"""Semantic recipes. Placeholders are identifiers/values, never teacher-written SQL."""

RECIPES = {
    'all': 'Show all rows from {table}.',
    'project': 'Show only {column} from {table}.',
    'eq': 'Show all rows from {table} where {category} equals {value}.',
    'project_eq': 'Show {column} from {table} where {category} is {value}.',
    'gt': 'Show rows from {table} with {numeric} greater than {number}.',
    'lt': 'Show rows from {table} with {numeric} less than {number}.',
    'gte': 'Show rows from {table} with {numeric} at least {number}.',
    'lte': 'Show rows from {table} with {numeric} at most {number}.',
    'between': 'Show rows from {table} with {numeric} between {number} and {upper}, inclusive.',
    'and': 'Show rows from {table} where {category} is {value} and {numeric} exceeds {number}.',
    'or': 'Show rows from {table} where {category} is either {value} or {other}.',
    'null': 'Show rows from {table} where {column} is null.',
    'not_null': 'Show rows from {table} where {column} is not null.',
    'count': 'How many rows are in {table}?',
    'count_eq': 'Count rows in {table} where {category} is {value}.',
    'sum': 'Calculate the total {numeric} in {table}.',
    'avg': 'Calculate the average {numeric} in {table}.',
    'max': 'What is the maximum {numeric} in {table}?',
    'min': 'What is the minimum {numeric} in {table}?',
    'distinct': 'List distinct values of {category} in {table}.',
    'sort_desc': 'Show all rows from {table} ordered by {numeric} from highest to lowest.',
    'sort_asc': 'Show all rows from {table} ordered by {numeric} from lowest to highest.',
    'top': 'Show the top {limit} rows from {table} by {numeric}, highest first.',
    'bottom': 'Show the bottom {limit} rows from {table} by {numeric}, lowest first.',
    'group_count': 'Count rows for each {category} in {table}.',
    'group_sum': 'Show total {numeric} for each {category} in {table}.',
    'having': 'Show {category} groups in {table} with more than {number} rows and their counts.',
    'date_after': 'Show rows in {table} with {date_column} on or after {date}.',
    'year': 'Show rows in {table} where the year of {date_column} is {year}.',
    'month': 'Show rows in {table} where the month of {date_column} is {month}.',
    'contains': 'Show rows in {table} whose {column} contains the literal text {value}, case-insensitively.',
    'join': 'Show {table}.{column} and {parent}.{label} by joining {table}.{foreign} to {parent}.id.',
    'join_filter': 'Show {table}.{column} for rows joined by {table}.{foreign} to {parent}.id where {parent}.{label} equals {value}.',
    'list_tables': 'List the tables in this database.',
    'describe': 'Show the columns and types of table {table}.',
    'missing_schema': 'I have not provided a database schema. Find the available tables before writing SQL for {table}.',
    'sql_error': 'The last query failed because a column was unknown. Inspect the schema of {table} before trying again.',
    'ambiguous': 'Show the best records in {table}.',
    'missing_value': 'Filter {table} by {category}, but I have not specified a value.',
    'write': 'Delete every row from {table}.',
    'weather': 'Get the weather in {city} using {unit}.',
    'search': 'Search the documentation for {query}.',
    'read_file': 'Read the file at {path}.',
    'ticket': 'Look up support ticket {ticket_id}.',
    'final': 'The database tool returned {count} rows. Tell me how many rows it returned.',
}

LANGUAGES = ['en', 'noisy_en', 'hi', 'hinglish']