Edit on GitHub

sqlglot.dialects.tableau

View Source

 1from __future__ import annotations
 2
 3from sqlglot import tokens
 4from sqlglot.dialects.dialect import Dialect
 5from sqlglot.generators.tableau import TableauGenerator
 6from sqlglot.parsers.tableau import TableauParser
 7
 8
 9class Tableau(Dialect):
10    LOG_BASE_FIRST = False
11
12    class Tokenizer(tokens.Tokenizer):
13        IDENTIFIERS = [("[", "]")]
14        QUOTES = ["'", '"']
15
16    Generator = TableauGenerator
17
18    Parser = TableauParser

class Tableau(sqlglot.dialects.dialect.Dialect): View Source

10class Tableau(Dialect):
11    LOG_BASE_FIRST = False
12
13    class Tokenizer(tokens.Tokenizer):
14        IDENTIFIERS = [("[", "]")]
15        QUOTES = ["'", '"']
16
17    Generator = TableauGenerator
18
19    Parser = TableauParser

LOG_BASE_FIRST: bool | None = False

Whether the base comes first in the LOG function. Possible values: True, False, None (two arguments are not supported by LOG)

Generator = <class 'sqlglot.generators.tableau.TableauGenerator'>

Parser = <class 'sqlglot.parsers.tableau.TableauParser'>

SUPPORTS_COLUMN_JOIN_MARKS = False

Whether the old-style outer join (+) syntax is supported.

STRINGS_SUPPORT_ESCAPED_SEQUENCES: bool = False

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 = False

Whether byte string literals support escape sequences. Set by the metaclass based on the tokenizer's BYTE_STRING_ESCAPES.

INITCAP_SUPPORTS_CUSTOM_DELIMITERS = False

tokenizer_class = <class 'Tableau.Tokenizer'>

jsonpath_tokenizer_class = <class 'sqlglot.dialects.dialect.JSONPathTokenizer'>

parser_class = <class 'sqlglot.parsers.tableau.TableauParser'>

generator_class = <class 'sqlglot.generators.tableau.TableauGenerator'>

TIME_TRIE: dict = {}

FORMAT_TRIE: dict = {}

INVERSE_TIME_MAPPING: dict[str, str] = {}

INVERSE_TIME_TRIE: dict = {}

INVERSE_FORMAT_MAPPING: dict[str, str] = {}

INVERSE_FORMAT_TRIE: dict = {}

INVERSE_CREATABLE_KIND_MAPPING: dict[str, str] = {}

ESCAPED_SEQUENCES: dict[str, str] = {}

QUOTE_START = "'"

QUOTE_END = "'"

IDENTIFIER_START = '['

IDENTIFIER_END = ']'

VALID_INTERVAL_UNITS: set[str] = {'DAYOFYEAR', 'H', 'MICROSEC', 'NSECONDS', 'S', 'MONTHS', 'DEC', 'EPOCH_SECOND', 'WEEKOFYEAR', 'CENTS', 'DW', 'QUARTERS', 'WEEKDAY_ISO', 'DECADE', 'NANOSEC', 'CENTURY', 'EPOCH', 'MSECS', 'M', 'DAYOFWEEK', 'WEEKDAY', 'CENTURIES', 'MILS', 'MI', 'DAYOFWEEKISO', 'MONTH', 'HOURS', 'DOW_ISO', 'WEEK_ISO', 'SEC', 'NSECOND', 'DAY', 'HH', 'MSEC', 'EPOCH_MICROSECONDS', 'CENT', 'DAYOFWEEK_ISO', 'YYY', 'YEAR', 'USECOND', 'C', 'EPOCH_SECONDS', 'YR', 'MIN', 'NSEC', 'WY', 'USECS', 'WEEKOFYEAR_ISO', 'DAY OF YEAR', 'YEARS', 'NANOSECOND', 'QTR', 'DOW', 'WEEKISO', 'EPOCH_MICROSECOND', 'DY', 'MILLISEC', 'MM', 'W', 'WEEK', 'SECONDS', 'NANOSECS', 'MILLISECON', 'SECOND', 'USECONDS', 'D', 'US', 'EPOCH_NANOSECONDS', 'Y', 'NS', 'EPOCH_NANOSECOND', 'YYYY', 'DW_ISO', 'DAYOFMONTH', 'QUARTER', 'MON', 'Q', 'MIL', 'MONS', 'WOY', 'WEEKOFYEARISO', 'MINUTE', 'YY', 'USEC', 'YRS', 'MILLISECONDS', 'MILLENNIUM', 'TIMEZONE_MINUTE', 'HR', 'HOUR', 'MICROSECONDS', 'EPOCH_MILLISECONDS', 'MILLISECOND', 'MILLISECS', 'MINS', 'MSECOND', 'WK', 'MSECONDS', 'DD', 'TIMEZONE_HOUR', 'TZM', 'MICROSECOND', 'MINUTES', 'DECS', 'QTRS', 'MS', 'TZH', 'MICROSECS', 'EPOCH_MILLISECOND', 'DECADES', 'HRS', 'DAY OF WEEK', 'SECS', 'DAYS', 'DOY', 'MILLENIA'}

BIT_START: str | None = None

BIT_END: str | None = None

HEX_START: str | None = None

HEX_END: str | None = None

BYTE_START: str | None = None

BYTE_END: str | None = None

UNICODE_START: str | None = None

UNICODE_END: str | None = None

class Tableau.Tokenizer(sqlglot.tokens.Tokenizer): View Source

13    class Tokenizer(tokens.Tokenizer):
14        IDENTIFIERS = [("[", "]")]
15        QUOTES = ["'", '"']

IDENTIFIERS = [('[', ']')]

QUOTES = ["'", '"']

BYTE_STRING_ESCAPES: ClassVar[list[str]] = ["'"]

Inherited Members

sqlglot.tokens.Tokenizer: Tokenizer; SINGLE_TOKENS; BIT_STRINGS; BYTE_STRINGS; HEX_STRINGS; RAW_STRINGS; HEREDOC_STRINGS; UNICODE_STRINGS; STRING_ESCAPES; VAR_SINGLE_TOKENS; ESCAPE_FOLLOW_CHARS; IDENTIFIER_ESCAPES; HEREDOC_TAG_IS_IDENTIFIER; HEREDOC_STRING_ALTERNATIVE; STRING_ESCAPES_ALLOWED_IN_RAW_STRINGS; NESTED_COMMENTS; HINT_START; TOKENS_PRECEDING_HINT; KEYWORDS; COMMANDS; COMMAND_PREFIX_TOKENS; NUMERIC_LITERALS; NUMBERS_CAN_HAVE_DECIMALS; COMMENTS; dialect; tokenize; sql; size; tokens