etcdb.sqlparser package

Submodules

etcdb.sqlparser.etcdb_lexer module

etcdb.sqlparser.etcdb_lexer.t_STRING(t)

[_a-zA-Z0-9]*[_a-zA-Z]+[_a-zA-Z0-9]*

etcdb.sqlparser.etcdb_lexer.t_begin_quoted(t)

‘

etcdb.sqlparser.etcdb_lexer.t_error(t)

etcdb.sqlparser.etcdb_lexer.t_quoted_STRING_VALUE(t)

[- :.a-zA-Z0-9$/+=_@]+

etcdb.sqlparser.etcdb_lexer.t_quoted_end(t)

‘

etcdb.sqlparser.etcdb_lexer.t_quoted_error(t)

etcdb.sqlparser.parser module

class etcdb.sqlparser.parser.SQLParser

Bases: object

parse(*args, **kwargs)

exception etcdb.sqlparser.parser.SQLParserError

Bases: exceptions.Exception

All SQL parsing errors

etcdb.sqlparser.parser.p_AUTO_INCREMENT(p)

opt_column_def_options : AUTO_INCREMENT

etcdb.sqlparser.parser.p_DEFAULT_CLAUSE(p)

opt_column_def_options : DEFAULT value

etcdb.sqlparser.parser.p_NOT_NULL(p)

opt_column_def_options : NOT NULL

etcdb.sqlparser.parser.p_NULL(p)

opt_column_def_options : NULL

etcdb.sqlparser.parser.p_PRIMARY_KEY(p)

opt_column_def_options : PRIMARY KEY

etcdb.sqlparser.parser.p_UNIQUE(p)

opt_column_def_options : UNIQUE

etcdb.sqlparser.parser.p_bit_expr(p)

bit_expr : simple_expr

etcdb.sqlparser.parser.p_boolean_primary_comparison(p)

boolean_primary : boolean_primary comparison_operator predicate

etcdb.sqlparser.parser.p_boolean_primary_is_not_null(p)

boolean_primary : boolean_primary IS NOT NULL

etcdb.sqlparser.parser.p_boolean_primary_is_null(p)

boolean_primary : boolean_primary IS NULL

etcdb.sqlparser.parser.p_boolean_primary_predicate(p)

boolean_primary : predicate

etcdb.sqlparser.parser.p_col_expr(p)

col_expr : identifier ‘=’ expr

etcdb.sqlparser.parser.p_col_expr_list(p)

col_expr_list : col_expr_list ‘,’ col_expr

etcdb.sqlparser.parser.p_col_expr_list_one(p)

col_expr_list : col_expr

etcdb.sqlparser.parser.p_column_definition(p)

column_definition : data_type opt_column_def_options_list

etcdb.sqlparser.parser.p_commit_statement(p)

commit_statement : COMMIT

etcdb.sqlparser.parser.p_comparison_operator(p)

comparison_operator : ‘=’ | GREATER_OR_EQ | ‘>’ | LESS_OR_EQ | ‘<’ | N_EQ

etcdb.sqlparser.parser.p_create_database_statement(p)

create_database_statement : CREATE DATABASE identifier

etcdb.sqlparser.parser.p_create_definition(p)

create_definition : identifier column_definition

etcdb.sqlparser.parser.p_create_definition_list_many(p)

create_definition_list : create_definition_list ‘,’ create_definition

etcdb.sqlparser.parser.p_create_definition_list_one(p)

create_definition_list : create_definition

etcdb.sqlparser.parser.p_create_table_statement(p)

create_table_statement : CREATE TABLE identifier ‘(‘ create_definition_list ‘)’

etcdb.sqlparser.parser.p_data_type(p)

data_type : INTEGER opt_UNSIGNED | VARCHAR ‘(‘ NUMBER ‘)’ | DATETIME | DATETIME ‘(‘ NUMBER ‘)’ | INT opt_UNSIGNED | LONGTEXT | SMALLINT opt_UNSIGNED | TINYINT | BOOL

etcdb.sqlparser.parser.p_delete_statement(p)

delete_statement : DELETE FROM identifier opt_WHERE

etcdb.sqlparser.parser.p_desc_table_statement(p)

desc_table_statement : DESC identifier

etcdb.sqlparser.parser.p_drop_database_statement(p)

drop_database_statement : DROP DATABASE identifier

etcdb.sqlparser.parser.p_drop_table_statement(p)

drop_table_statement : DROP TABLE identifier opt_IF_EXISTS

etcdb.sqlparser.parser.p_error(t)

etcdb.sqlparser.parser.p_expr_AND(p)

expr : expr AND expr

etcdb.sqlparser.parser.p_expr_NOT(p)

expr : NOT expr %prec UNOT

etcdb.sqlparser.parser.p_expr_OR(p)

expr : expr OR expr

etcdb.sqlparser.parser.p_expr_bool_primary(p)

expr : boolean_primary

etcdb.sqlparser.parser.p_fieldlist_many(p)

fieldlist : fieldlist ‘,’ identifier

etcdb.sqlparser.parser.p_fieldlist_one(p)

fieldlist : identifier

etcdb.sqlparser.parser.p_function_call_count_star(p)

function_call : COUNT ‘(‘ ‘*’ ‘)’

etcdb.sqlparser.parser.p_function_call_version(p)

function_call : VERSION ‘(‘ ‘)’

etcdb.sqlparser.parser.p_identifier(p)

identifier : STRING

etcdb.sqlparser.parser.p_identifier_escaped(p)

identifier : ‘`’ STRING ‘`’

etcdb.sqlparser.parser.p_insert_statement(p)

insert_statement : INSERT INTO identifier opt_fieldlist VALUES ‘(‘ values_list ‘)’ opt_USE_LOCK

etcdb.sqlparser.parser.p_list_expr(p)

list_expr : list_expr ‘,’ expr

etcdb.sqlparser.parser.p_list_expr_one(p)

list_expr : expr

etcdb.sqlparser.parser.p_literal(p)

literal : q_STRING | NUMBER | STRING_VALUE

etcdb.sqlparser.parser.p_opt_FULL(p)

opt_FULL : FULL

etcdb.sqlparser.parser.p_opt_FULL_empty(p)

opt_FULL :

etcdb.sqlparser.parser.p_opt_LIMIT(p)

opt_LIMIT : LIMIT NUMBER

etcdb.sqlparser.parser.p_opt_LIMIT_empty(p)

opt_LIMIT :

etcdb.sqlparser.parser.p_opt_ORDER_BY_empty(p)

opt_ORDER_BY :

etcdb.sqlparser.parser.p_opt_ORDER_BY_extended(p)

opt_ORDER_BY : ORDER BY identifier ‘.’ identifier opt_ORDER_DIRECTION

etcdb.sqlparser.parser.p_opt_ORDER_BY_simple(p)

opt_ORDER_BY : ORDER BY identifier opt_ORDER_DIRECTION

etcdb.sqlparser.parser.p_opt_ORDER_DIRECTION(p)

opt_ORDER_DIRECTION : ASC | DESC

etcdb.sqlparser.parser.p_opt_ORDER_DIRECTION_empty(p)

opt_ORDER_DIRECTION :

etcdb.sqlparser.parser.p_opt_UNSIGNED(p)

opt_UNSIGNED : | UNSIGNED

etcdb.sqlparser.parser.p_opt_USE_LOCK(p)

opt_USE_LOCK : USE LOCK STRING_VALUE

etcdb.sqlparser.parser.p_opt_USE_LOCK_empty(p)

opt_USE_LOCK :

etcdb.sqlparser.parser.p_opt_WHERE(p)

opt_WHERE : WHERE expr

etcdb.sqlparser.parser.p_opt_WHERE_empty(p)

opt_WHERE :

etcdb.sqlparser.parser.p_opt_after(p)

opt_AFTER : AFTER NUMBER

etcdb.sqlparser.parser.p_opt_after_empty(p)

opt_AFTER :

etcdb.sqlparser.parser.p_opt_column_def_options_list(p)

opt_column_def_options_list : opt_column_def_options opt_column_def_options_list

etcdb.sqlparser.parser.p_opt_column_def_options_list_empty(p)

opt_column_def_options_list :

etcdb.sqlparser.parser.p_opt_fieldlist(p)

opt_fieldlist : ‘(‘ fieldlist ‘)’

etcdb.sqlparser.parser.p_opt_fieldlist_empty(p)

opt_fieldlist :

etcdb.sqlparser.parser.p_opt_from(p)

opt_FROM : FROM table_reference

etcdb.sqlparser.parser.p_opt_from_empty(p)

opt_FROM :

etcdb.sqlparser.parser.p_opt_if_exists(p)

opt_IF_EXISTS : IF EXISTS

etcdb.sqlparser.parser.p_opt_if_exists_empty(p)

opt_IF_EXISTS :

etcdb.sqlparser.parser.p_predicate(p)

predicate : bit_expr

etcdb.sqlparser.parser.p_predicate_in(p)

predicate : bit_expr IN ‘(‘ list_expr ‘)’

etcdb.sqlparser.parser.p_q_STRING(p)

q_STRING : “’” STRING “’”

etcdb.sqlparser.parser.p_q_STRING_EMPTY(p)

q_STRING :

etcdb.sqlparser.parser.p_select_alias(p)

select_alias : AS identifier

etcdb.sqlparser.parser.p_select_alias_empty(p)

select_alias :

etcdb.sqlparser.parser.p_select_item(p)

select_item : select_item2 select_alias

etcdb.sqlparser.parser.p_select_item2(p)

select_item2 : table_wild | expr

etcdb.sqlparser.parser.p_select_item_list(p)

select_item_list : select_item_list ‘,’ select_item

etcdb.sqlparser.parser.p_select_item_list_select_item(p)

select_item_list : select_item

etcdb.sqlparser.parser.p_select_item_list_star(p)

select_item_list : ‘*’

etcdb.sqlparser.parser.p_select_statement(p)

select_statement : SELECT select_item_list opt_FROM opt_WHERE opt_ORDER_BY opt_LIMIT

etcdb.sqlparser.parser.p_set_names_statement(p)

set_names_statement : SET NAMES STRING

etcdb.sqlparser.parser.p_set_statement(p)

set_statement : set_autocommit_statement | set_names_statement

etcdb.sqlparser.parser.p_set_statement_autocommit(p)

set_autocommit_statement : SET AUTOCOMMIT ‘=’ NUMBER

etcdb.sqlparser.parser.p_show_databases_statement(p)

show_databases_statement : SHOW DATABASES

etcdb.sqlparser.parser.p_show_tables_statement(p)

show_tables_statement : SHOW opt_FULL TABLES

etcdb.sqlparser.parser.p_simple_expr_function_call(p)

simple_expr : function_call

etcdb.sqlparser.parser.p_simple_expr_identifier(p)

simple_expr : identifier

etcdb.sqlparser.parser.p_simple_expr_identifier_full(p)

simple_expr : identifier ‘.’ identifier

etcdb.sqlparser.parser.p_simple_expr_literal(p)

simple_expr : literal

etcdb.sqlparser.parser.p_simple_expr_parent(p)

simple_expr : ‘(‘ expr ‘)’

etcdb.sqlparser.parser.p_simple_expr_variable(p)

simple_expr : variable

etcdb.sqlparser.parser.p_statement(p)

statement : select_statement | show_tables_statement | create_table_statement | create_database_statement | show_databases_statement | use_database_statement | commit_statement | set_statement | insert_statement | delete_statement | drop_database_statement | drop_table_statement | desc_table_statement | update_table_statement | wait_statement

etcdb.sqlparser.parser.p_table_reference(p)

table_reference : identifier

etcdb.sqlparser.parser.p_table_reference_w_database(p)

table_reference : identifier ‘.’ identifier

etcdb.sqlparser.parser.p_table_wild(p)

table_wild : identifier ‘.’ ‘*’

etcdb.sqlparser.parser.p_update_table_statement(p)

update_table_statement : UPDATE identifier SET col_expr_list opt_WHERE opt_USE_LOCK

etcdb.sqlparser.parser.p_use_database_statement(p)

use_database_statement : USE identifier

etcdb.sqlparser.parser.p_value(p)

value : q_STRING | NUMBER | STRING_VALUE

etcdb.sqlparser.parser.p_values_list_many(p)

values_list : values_list ‘,’ value

etcdb.sqlparser.parser.p_values_list_one(p)

values_list : value

etcdb.sqlparser.parser.p_variable(p)

variable : ‘@’ ‘@’ STRING

etcdb.sqlparser.parser.p_wait_statement(p)

wait_statement : WAIT select_item_list FROM identifier opt_WHERE opt_AFTER

etcdb.sqlparser.parsetab module

etcdb.sqlparser.sql_tree module

class etcdb.sqlparser.sql_tree.SQLTree

Bases: object

reset()

Module contents