sqlglot.dialects.doris
1from __future__ import annotations 2 3from sqlglot.dialects.mysql import MySQL 4from sqlglot.generators.doris import DorisGenerator 5from sqlglot.parsers.doris import DorisParser 6 7 8class Doris(MySQL): 9 DATE_FORMAT = "'yyyy-MM-dd'" 10 DATEINT_FORMAT = "'yyyyMMdd'" 11 TIME_FORMAT = "'yyyy-MM-dd HH:mm:ss'" 12 13 Parser = DorisParser 14 15 Generator = DorisGenerator
9class Doris(MySQL): 10 DATE_FORMAT = "'yyyy-MM-dd'" 11 DATEINT_FORMAT = "'yyyyMMdd'" 12 TIME_FORMAT = "'yyyy-MM-dd HH:mm:ss'" 13 14 Parser = DorisParser 15 16 Generator = DorisGenerator
Parser =
<class 'sqlglot.parsers.doris.DorisParser'>
Generator =
<class 'sqlglot.generators.doris.DorisGenerator'>
VALID_INTERVAL_UNITS: set[str] =
{'MICROSECS', 'MINUTES', 'YEAR', 'YEAR_MONTH', 'WY', 'DAYOFMONTH', 'DOW', 'MONTH', 'MICROSECOND', 'TIMEZONE_MINUTE', 'EPOCH_MICROSECONDS', 'MINUTE', 'DAYOFWEEK_ISO', 'TZH', 'Y', 'DW', 'WEEK', 'MM', 'DAYOFWEEK', 'QUARTER', 'MSEC', 'NSEC', 'M', 'USECS', 'NANOSECS', 'WEEKDAY', 'DW_ISO', 'MONTHS', 'D', 'MINS', 'DY', 'DAYOFYEAR', 'WK', 'HH', 'MS', 'TIMEZONE_HOUR', 'MIL', 'S', 'YYYY', 'DECADES', 'MON', 'NANOSECOND', 'WEEKOFYEAR', 'HOUR', 'TZM', 'MILLENNIUM', 'SECONDS', 'DOW_ISO', 'DAY OF WEEK', 'USECOND', 'H', 'MILLISECON', 'QTRS', 'MINUTE_MICROSECOND', 'HOUR_SECOND', 'MILLISECS', 'DOY', 'DAY_MINUTE', 'SECOND', 'EPOCH_MILLISECOND', 'HRS', 'DEC', 'EPOCH_SECONDS', 'YYY', 'YY', 'YRS', 'MSECONDS', 'SEC', 'USEC', 'MILLISECOND', 'HOURS', 'DAY OF YEAR', 'MILLISEC', 'C', 'MSECOND', 'WEEKDAY_ISO', 'EPOCH_NANOSECOND', 'NANOSEC', 'SECS', 'CENTURY', 'MILS', 'US', 'DAY_HOUR', 'WEEKOFYEAR_ISO', 'WEEKOFYEARISO', 'QUARTERS', 'YR', 'EPOCH', 'EPOCH_MILLISECONDS', 'MONS', 'MILLISECONDS', 'HOUR_MICROSECOND', 'DAY_MICROSECOND', 'HOUR_MINUTE', 'MICROSECONDS', 'MI', 'WEEK_ISO', 'MIN', 'MILLENIA', 'WOY', 'CENTS', 'DAY_SECOND', 'EPOCH_MICROSECOND', 'DAYS', 'MSECS', 'CENT', 'MINUTE_SECOND', 'W', 'MICROSEC', 'HR', 'NS', 'DD', 'EPOCH_NANOSECONDS', 'DECADE', 'NSECONDS', 'DAY', 'SECOND_MICROSECOND', 'DECS', 'DAYOFWEEKISO', 'USECONDS', 'YEARS', 'NSECOND', 'CENTURIES', 'WEEKISO', 'QTR', 'Q', 'EPOCH_SECOND'}
UNESCAPED_SEQUENCES: dict[str, str] =
{'\\a': '\x07', '\\b': '\x08', '\\f': '\x0c', '\\n': '\n', '\\r': '\r', '\\t': '\t', '\\v': '\x0b', '\\\\': '\\'}
Mapping of an escaped sequence (\n) to its unescaped version (
).
STRINGS_SUPPORT_ESCAPED_SEQUENCES: bool =
True
Whether string literals support escape sequences (e.g. \n). Set by the metaclass based on the tokenizer's STRING_ESCAPES.
BYTE_STRINGS_SUPPORT_ESCAPED_SEQUENCES: bool =
True
Whether byte string literals support escape sequences. Set by the metaclass based on the tokenizer's BYTE_STRING_ESCAPES.
parser_class =
<class 'sqlglot.parsers.doris.DorisParser'>
generator_class =
<class 'sqlglot.generators.doris.DorisGenerator'>
TIME_TRIE: dict =
{'%': {'M': {0: True}, 'c': {0: True}, 'e': {0: True}, 'h': {0: True}, 'i': {0: True}, 's': {0: True}, 'u': {0: True}, 'k': {0: True}, 'l': {0: True}, 'r': {0: True}, 'T': {0: True}, 'W': {0: True}, 'x': {0: True}}}
FORMAT_TRIE: dict =
{'%': {'M': {0: True}, 'c': {0: True}, 'e': {0: True}, 'h': {0: True}, 'i': {0: True}, 's': {0: True}, 'u': {0: True}, 'k': {0: True}, 'l': {0: True}, 'r': {0: True}, 'T': {0: True}, 'W': {0: True}, 'x': {0: True}}}
INVERSE_TIME_MAPPING: dict[str, str] =
{'%B': '%M', '%-m': '%c', '%-d': '%e', '%I': '%h', '%M': '%i', '%S': '%s', '%W': '%u', '%-H': '%k', '%-I': '%l', '%I:%M:%S %p': '%r', '%H:%M:%S': '%T', '%A': '%W', '%G': '%x', '%mstrict': '%m', '%dstrict': '%d', '%Hstrict': '%H', '%Istrict': '%h', '%Mstrict': '%i', '%Sstrict': '%s'}
INVERSE_TIME_TRIE: dict =
{'%': {'B': {0: True}, '-': {'m': {0: True}, 'd': {0: True}, 'H': {0: True}, 'I': {0: True}}, 'I': {0: True, ':': {'%': {'M': {':': {'%': {'S': {' ': {'%': {'p': {0: True}}}}}}}}}, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'M': {0: True, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'S': {0: True, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'W': {0: True}, 'H': {':': {'%': {'M': {':': {'%': {'S': {0: True}}}}}}, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'A': {0: True}, 'G': {0: True}, 'm': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'd': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}}}
INVERSE_FORMAT_MAPPING: dict[str, str] =
{'%mstrict': '%m', '%dstrict': '%d', '%Hstrict': '%H', '%Istrict': '%I', '%Mstrict': '%M', '%Sstrict': '%S'}
INVERSE_FORMAT_TRIE: dict =
{'%': {'m': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'd': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'H': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'I': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'M': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'S': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}}}
ESCAPED_SEQUENCES: dict[str, str] =
{'\x07': '\\a', '\x08': '\\b', '\x0c': '\\f', '\n': '\\n', '\r': '\\r', '\t': '\\t', '\x0b': '\\v', '\\': '\\\\'}