Package gluon :: Module dal :: Class NewPostgreSQLAdapter

[frames] | no frames]

Class NewPostgreSQLAdapter

    object --+            
             |            
ConnectionPool --+        
                 |        
       BaseAdapter --+    
                     |    
     PostgreSQLAdapter --+
                         |
                        NewPostgreSQLAdapter

Nested Classes

Inherited from BaseAdapter: __metaclass__

Instance Methods

parse_list_integers(self, value, field_type)

source code

parse_list_references(self, value, field_type)

source code

parse_list_strings(self, value, field_type)

source code

represent(self, obj, fieldtype)

source code

Inherited from PostgreSQLAdapter: ADD, ENDSWITH, ILIKE, LIKE, RANDOM, REGEXP, STARTSWITH, ST_ASGEOJSON, ST_ASTEXT, ST_CONTAINS, ST_DISTANCE, ST_DWITHIN, ST_EQUALS, ST_INTERSECTS, ST_OVERLAPS, ST_SIMPLIFY, ST_TOUCHES, ST_WITHIN, ST_X, ST_Y, __init__, adapt, after_connection, commit_prepared, create_sequence_and_triggers, distributed_transaction_begin, lastrowid, prepare, rollback_prepared, sequence_name, try_json, varquote

Inherited from PostgreSQLAdapter (private): _drop

Inherited from BaseAdapter: AGGREGATE, ALLOW_NULL, AND, AS, BELONGS, CASE, CAST, COALESCE, COALESCE_ZERO, COMMA, CONCAT, CONTAINS, COUNT, DIV, EPOCH, EQ, EXTRACT, GE, GT, INVERT, JOIN, LE, LEFT_JOIN, LENGTH, LOWER, LT, MOD, MUL, NE, NOT, NOT_NULL, ON, OR, PRIMARY_KEY, RAW, REPLACE, SUB, SUBSTRING, UPPER, alias, build_parsemap, bulk_insert, close_connection, commit, common_filter, concat_add, connector, constraint_name, count, create_table, delete, drop, execute, expand, expand_all, file_close, file_delete, file_exists, file_open, find_driver, get_table, id_query, insert, isOperationalError, isProgrammingError, is_numerical_type, log, log_execute, migrate_table, parse, parse_blob, parse_boolean, parse_date, parse_datetime, parse_decimal, parse_double, parse_id, parse_integer, parse_json, parse_reference, parse_time, parse_value, represent_exceptions, rollback, rowslice, save_dbt, select, select_limitby, smart_adapt, sqlsafe_field, sqlsafe_table, table_alias, tables, trigger_name, truncate, update

Inherited from BaseAdapter (private): _count, _delete, _fetchall, _insert, _insert_empty, _select, _select_aux, _truncate, _update

Inherited from ConnectionPool: after_connection_hook, close, find_or_make_work_folder, reconnect

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __str__, __subclasshook__

Static Methods

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables

drivers = 'psycopg2', 'pg8000'

types = {'big-id': 'BIGSERIAL PRIMARY KEY', 'big-reference': '...

Inherited from PostgreSQLAdapter: QUOTE_TEMPLATE, REGEX_URI, support_distributed_transaction

Inherited from BaseAdapter: FALSE, TRUE, T_SEP, can_select_for_update, commit_on_alter_table, connection, dbpath, driver, driver_name, folder, native_json, uploads_in_blob

Inherited from ConnectionPool: POOLS, check_active_connection

Properties

Inherited from object: __class__

Method Details

parse_list_integers(self, value, field_type)

Overrides: BaseAdapter.parse_list_integers

parse_list_references(self, value, field_type)

Overrides: BaseAdapter.parse_list_references

parse_list_strings(self, value, field_type)

Overrides: BaseAdapter.parse_list_strings

represent(self, obj, fieldtype)

Overrides: BaseAdapter.represent

Class Variable Details

types

Value:

{'big-id': 'BIGSERIAL PRIMARY KEY',
 'big-reference': 'BIGINT REFERENCES %(foreign_key)s ON DELETE %(on_de
lete_action)s',
 'bigint': 'BIGINT',
 'blob': 'BYTEA',
 'boolean': 'CHAR(1)',
 'date': 'DATE',
 'datetime': 'TIMESTAMP',
...