"""SQL query and params for getting transaction types that have sales."""

SQL_GET_TRANSACTIONTYPE = """
select distinct dtt.transactiontypeid, dtt.transactiontypeabbr,
  dtt.transactiontypedesc
from fact_sales fs
inner join dim_transactiontype dtt
  on dtt.transactiontypeid = fs.transactiontypeid
where {account_id_column} = {account_id}
and accountingperiodid between {min_period} and {max_period}
order by dtt.transactiontypedesc
"""

SNOWFLAKE_TRANSACTIONTYPE_PARAMS = {
    'account_id': ':account_id',
    'min_period': ':min_period',
    'max_period': ':max_period',
}