"""Constants for snowflake."""

SNOWFLAKE_ORCHARD_DATABASE = 'ORCHARD_APP_REPORTING_V2'
SNOWFLAKE_ART_RELATIONS_SCHEMA = 'ART_RELATIONS_PROD_ART_RELATIONS'
# snowflake query parameters
PHYSICAL_DISTRIBUTION_FORMATS = (
    '67', '68', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78',
    '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90',
    '91', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103',
    '104', '105', '106', '107', '108', '109', '110', '111', '112', '113',
    '114', '115', '116', '117', '118', '119', '120', '121', '122', '123',
    '124', '125', '126', '127', '128', '129', '130', '131', '132', '133',
    '134', '135', '136', '137', '138', '139', '140', '141', '142', '143',
    '144', '145', '146', '147', '148', '149', '150', '151', '152'
)

ELIGIBLE_PRODUCTS_ORDER_BY = {
    # will have to include each of these in select query for sort to work
    'release_id': 'r.release_id',
    'sale_start_date': 'r.sale_start_date',

}
ELIGIBLE_PRODUCTS_TAKEDOWN_ORDER_BY = {
    # will have to include each of these in select query for sort to work
    'release_id': 'release_id',
    'sale_start_date': 'sale_start_date',

}
ORDER_DIR = ('asc', 'desc')