Module Import alias ImportFrom alias alias ClassDef bases NameLoad body Expr Str Assign NameStore Str Assign NameStore Str Assign NameStore Dict Str Str Str Str Str Str Str Str Str Str Str Str Str Str Assign NameStore Num Assign NameStore ListLoad TupleLoad Str Str Str TupleLoad Str Str Str TupleLoad Str Str Str TupleLoad Str Str Num TupleLoad Str Str Str TupleLoad Str Str Str TupleLoad Str Str Str FunctionDef arguments args NameParam defaults body Expr Str Return Call AttributeLoad Call AttributeLoad NameLoad attr NameLoad attr Str Str decorator_list FunctionDef arguments args NameParam defaults body Expr Str TryExcept body Expr Call AttributeLoad NameLoad attr NameLoad handlers ExceptHandler body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Pass decorator_list FunctionDef arguments args NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad AugAssignAdd NameStore Str Return Call AttributeLoad NameLoad attr Str Str decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Return Call AttributeLoad NameLoad attr Str Str decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Assign NameStore CompareNotEq Call NameLoad ListComp NameLoad comprehension NameStore AttributeLoad AttributeLoad NameLoad attr attr CompareEq SubscriptLoad SubscriptLoad SubscriptLoad NameLoad Index Num Index Num Slice Num Str Num If BoolOpAnd CompareEq ListLoad AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr ListLoad NameLoad Str Num UnaryOpNot AttributeLoad AttributeLoad NameLoad attr attr UnaryOpNot NameLoad BoolOpOr UnaryOpNot Call NameLoad AttributeLoad NameLoad attr Str UnaryOpNot AttributeLoad AttributeLoad NameLoad attr attr body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore BinOpAdd BinOpAdd BinOpAdd BinOpAdd BinOpAdd BinOpAdd Str Call AttributeLoad NameLoad attr Str NameLoad Str Call AttributeLoad NameLoad attr Str Str Str TryExcept body Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Str handlers ExceptHandler body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Return Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad If Call NameLoad NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr Str Str Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str If UnaryOpNot Call NameLoad NameLoad Str body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Str Assign AttributeStore NameLoad attr Call NameLoad For TupleStore NameStore NameStore AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr TupleLoad Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Return CompareIn TupleLoad Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str If CompareEq NameLoad Str body TryExcept body If CompareEq Call NameLoad NameLoad Num body Return Str orelse If CompareEq Call NameLoad NameLoad Num body Return Str handlers ExceptHandler body Pass Return Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Import alias identifier Expr Call AttributeLoad NameLoad attr Return Call AttributeLoad NameLoad attr keyword SubscriptLoad AttributeLoad NameLoad attr Index Str keyword Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index Str keyword SubscriptLoad AttributeLoad NameLoad attr Index Str keyword SubscriptLoad AttributeLoad NameLoad attr Index Str keyword SubscriptLoad AttributeLoad NameLoad attr Index Str decorator_list decorator_list
N/A N/A os retriever.lib.models Engine no_cleanup engine N/A Engine N/A N/A Engine instance for PostgreSQL. N/A name PostgreSQL N/A abbreviation postgres N/A datatypes N/A auto int bigint double decimal char bool serial integer bigint double precision decimal varchar boolean N/A max_int 2147483647 N/A required_opts N/A N/A user Enter your PostgreSQL username postgres N/A password Enter your password N/A host Enter your PostgreSQL host localhost N/A port Enter your PostgreSQL port 5432 N/A database Enter your PostgreSQL database name postgres N/A database_name Format of schema name {db} N/A table_name Format of table name {db}.{table} create_db_statement N/A N/A self N/A N/A N/A In PostgreSQL, the equivalent of a SQL database is a schema. N/A N/A N/A N/A N/A Engine create_db_statement self replace DATABASE SCHEMA N/A create_db N/A N/A self N/A N/A N/A Creates the database N/A N/A N/A N/A N/A Engine create_db self N/A N/A N/A N/A N/A N/A N/A self connection rollback N/A N/A create_table N/A N/A self N/A N/A N/A PostgreSQL needs to commit operations individually. N/A N/A N/A Engine create_table self N/A N/A N/A N/A self connection commit N/A drop_statement N/A N/A self objecttype objectname N/A N/A N/A In PostgreSQL, the equivalent of a SQL database is a schema. N/A statement N/A N/A Engine drop_statement self objecttype objectname N/A statement  CASCADE; N/A N/A N/A statement replace  DATABASE   SCHEMA  N/A escape_single_quotes N/A N/A self value N/A N/A N/A Escapes single quotes in the value N/A N/A N/A value replace ' '' N/A insert_data_from_file N/A N/A self filename N/A N/A N/A Use PostgreSQL's "COPY FROM" statement to perform a bulk insert. N/A N/A N/A self get_cursor N/A ct N/A N/A len N/A True N/A c N/A N/A self table columns N/A N/A N/A N/A c N/A 1 N/A 0 N/A 3 ct- 0 N/A N/A N/A N/A N/A N/A N/A self table cleanup function N/A N/A self table delimiter N/A N/A self table header_rows N/A no_cleanup , 1 N/A N/A N/A self table fixed_width N/A ct N/A N/A N/A hasattr N/A self table do_not_bulk_insert N/A N/A N/A self table do_not_bulk_insert N/A N/A columns N/A N/A N/A self table get_insert_columns N/A filename N/A N/A N/A os path abspath filename N/A statement N/A N/A N/A N/A N/A N/A 
COPY  N/A N/A self table_name  ( columns )
FROM ' N/A N/A filename replace \ \\ '
WITH DELIMITER ','
CSV HEADER N/A N/A N/A N/A N/A self execute BEGIN N/A N/A N/A self execute statement N/A N/A N/A self execute COMMIT N/A N/A N/A N/A N/A N/A N/A self connection rollback N/A N/A N/A Engine insert_data_from_file self filename N/A N/A N/A N/A Engine insert_data_from_file self filename N/A insert_statement N/A N/A self values N/A N/A N/A Returns a SQL statement to insert a set of values N/A statement N/A N/A Engine insert_statement self values N/A N/A isinstance statement basestring N/A N/A statement N/A N/A statement decode utf-8 ignore N/A statement N/A table_exists N/A N/A self dbname tablename N/A N/A N/A Checks to see if the given table exists N/A N/A N/A hasattr self existing_table_names N/A N/A N/A N/A N/A self cursor execute SELECT schemaname, tablename FROM pg_tables WHERE schemaname NOT LIKE 'pg_%'; N/A N/A self existing_table_names N/A set N/A N/A schema table N/A self cursor N/A N/A N/A N/A N/A self existing_table_names add N/A N/A N/A schema lower N/A N/A table lower N/A N/A N/A N/A N/A dbname lower N/A N/A tablename lower N/A self existing_table_names N/A format_insert_value N/A N/A self value datatype N/A N/A N/A Formats a value for an insert statement N/A N/A datatype bool N/A N/A N/A N/A N/A N/A int value 1 N/A N/A TRUE N/A N/A N/A N/A int value 0 N/A N/A FALSE N/A N/A N/A N/A N/A N/A N/A Engine format_insert_value self value datatype N/A get_connection N/A N/A self N/A N/A N/A Gets the db connection. N/A psycopg2 dbapi N/A N/A N/A self get_input N/A N/A N/A dbapi connect host N/A N/A self opts N/A host port N/A int N/A N/A self opts N/A port user N/A N/A self opts N/A user password N/A N/A self opts N/A password database N/A N/A self opts N/A database N/A N/A