"""SQL queries."""

ALL_FIELDS = '*'
ASSET_ID_FIELD = 'asset_id'

# Query for getting a batch of records
#
IODA_DATA = """
SELECT {} FROM public.ioda_assets_csv_export_report
ORDER BY asset_id
OFFSET %(offset)s
LIMIT %(limit)s
"""


# Query for getting total number of records to be saved to CSV
#
COUNT = """
SELECT
 COUNT(asset_id) AS asset_count
  FROM public.ioda_assets_csv_export_report
"""