easy_sql.sql_processor.backend.sql_dialect.postgres
Module Contents
Classes
- class easy_sql.sql_processor.backend.sql_dialect.postgres.PgSqlDialect(sql_expr)
Bases:
digraph inheritancec9b9c5befa { bgcolor=transparent; rankdir=LR; size="8.0, 12.0"; "PgSqlDialect" [URL="#easy_sql.sql_processor.backend.sql_dialect.postgres.PgSqlDialect",fillcolor=white,fontname="Vera Sans, DejaVu Sans, Liberation Sans, Arial, Helvetica, sans",fontsize=10,height=0.25,shape=box,style="setlinewidth(0.5),filled",target="_top"]; "SqlDialect" -> "PgSqlDialect" [arrowsize=0.5,style="setlinewidth(0.5)"]; "SqlDialect" [URL="../index.html#easy_sql.sql_processor.backend.sql_dialect.SqlDialect",fillcolor=white,fontname="Vera Sans, DejaVu Sans, Liberation Sans, Arial, Helvetica, sans",fontsize=10,height=0.25,shape=box,style="setlinewidth(0.5),filled",target="_top"]; }easy_sql.sql_processor.backend.sql_dialect.SqlDialect
- Parameters
sql_expr (SqlExpr) –
- create_partition_automatically(self)
- create_partition_sql(self, target_table_name, partitions, if_not_exists=False)
- Parameters
target_table_name (str) –
partitions (List[easy_sql.sql_processor.backend.base.Partition]) –
if_not_exists (bool) –
- Return type
- create_partitions_with_data_sqls(self, source_table_name, target_table_name, col_names, partitions)
- Parameters
source_table_name (str) –
target_table_name (str) –
col_names (List[str]) –
partitions (List[List[easy_sql.sql_processor.backend.base.Partition]]) –
- create_table_like_sql(self, target_table_name, source_table_name, partitions)
- Parameters
target_table_name (str) –
source_table_name (str) –
partitions (List[easy_sql.sql_processor.backend.base.Partition]) –
- Return type
- create_table_sql(self, table_name, select_sql)
- create_table_with_partitions_sql(self, table_name, cols, partitions)
- Parameters
table_name (str) –
cols (List[Dict]) –
partitions (List[easy_sql.sql_processor.backend.base.Partition]) –
- create_temp_table_schema_like_target_schema(self)
- create_view_sql(self, table_name, select_sql)
- delete_partition_sql(self, table_name, partitions)
- Parameters
partitions (List[easy_sql.sql_processor.backend.base.Partition]) –
- Return type
- extract_partition_cols(self, native_partitions_sql_result)
- Parameters
native_partitions_sql_result (sqlalchemy.engine.ResultProxy) –
- Return type
List[str]
- insert_data_sql(self, table_name, col_names_expr, select_sql, partitions)
- Parameters
table_name (str) –
col_names_expr (str) –
select_sql (str) –
partitions (List[easy_sql.sql_processor.backend.base.Partition]) –
- move_data_sql(self, target_table, temp_table, partitions)
- Parameters
target_table (str) –
temp_table (str) –
partitions (List[easy_sql.sql_processor.backend.base.Partition]) –
- Return type
List[str]
- native_partitions_sql(self, table_name)
- rename_table_sql(self, from_table, to_table)
- rename_view_sql(self, from_table, to_table)
- support_static_partition(self)