Home       Trees       Indices       Help   
web2py Web Framework
Package gluon :: Module dal :: Class PostgreSQLAdapter
[hide private]
[frames] | no frames]

Class PostgreSQLAdapter

source code

    object --+        
             |        
ConnectionPool --+    
                 |    
       BaseAdapter --+
                     |
                    PostgreSQLAdapter
Known Subclasses:
Nested Classes [hide private]

Inherited from BaseAdapter: __metaclass__

Instance Methods [hide private]
 
varquote(self, name) source code
 
adapt(self, obj) source code
 
sequence_name(self, table) source code
 
RANDOM(self) source code
 
ADD(self, first, second) source code
 
distributed_transaction_begin(self, key) source code
 
prepare(self, key) source code
 
commit_prepared(self, key) source code
 
rollback_prepared(self, key) source code
 
create_sequence_and_triggers(self, query, table, **args) source code
 
__init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY at 0x334cd70>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)
x.__init__(...) initializes x; see help(type(x)) for signature		 source code
 
after_connection(self)
this it is supposed to be overloaded by adapters		 source code
 
lastrowid(self, table=None) source code
 
try_json(self) source code
 
LIKE(self, first, second)
case sensitive like operator		 source code
 
ILIKE(self, first, second)
case in-sensitive like operator		 source code
 
REGEXP(self, first, second)
regular expression operator		 source code
 
STARTSWITH(self, first, second) source code
 
ENDSWITH(self, first, second) source code
 
ST_ASGEOJSON(self, first, second)
http://postgis.org/docs/ST_AsGeoJSON.html		 source code
 
ST_ASTEXT(self, first)
http://postgis.org/docs/ST_AsText.html		 source code
 
ST_X(self, first)
http://postgis.org/docs/ST_X.html		 source code
 
ST_Y(self, first)
http://postgis.org/docs/ST_Y.html		 source code
 
ST_CONTAINS(self, first, second)
http://postgis.org/docs/ST_Contains.html		 source code
 
ST_DISTANCE(self, first, second)
http://postgis.org/docs/ST_Distance.html		 source code
 
ST_EQUALS(self, first, second)
http://postgis.org/docs/ST_Equals.html		 source code
 
ST_INTERSECTS(self, first, second)
http://postgis.org/docs/ST_Intersects.html		 source code
 
ST_OVERLAPS(self, first, second)
http://postgis.org/docs/ST_Overlaps.html		 source code
 
ST_SIMPLIFY(self, first, second)
http://postgis.org/docs/ST_Simplify.html		 source code
 
ST_TOUCHES(self, first, second)
http://postgis.org/docs/ST_Touches.html		 source code
 
ST_WITHIN(self, first, second)
http://postgis.org/docs/ST_Within.html		 source code
 
ST_DWITHIN(self, first, (second, third))
http://postgis.org/docs/ST_DWithin.html		 source code
 
represent(self, obj, fieldtype) source code
 
_drop(self, table, mode='restrict') source code

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_list_integers, parse_list_references, parse_list_strings, 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 [hide private]

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables [hide private]
  drivers = ('psycopg2', 'pg8000')
  QUOTE_TEMPLATE = '"%s"'
  support_distributed_transaction = True
  types = {'big-id': 'BIGSERIAL PRIMARY KEY', 'big-reference': '...
  REGEX_URI = re.compile(r'^(?P<user>[^:@]+)(:(?P<password>[^@]*...

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 [hide private]

Inherited from object: __class__

Method Details [hide private]

varquote(self, name)

source code 
Overrides: BaseAdapter.varquote

adapt(self, obj)

source code 
Overrides: BaseAdapter.adapt

sequence_name(self, table)

source code 
Overrides: BaseAdapter.sequence_name

RANDOM(self)

source code 
Overrides: BaseAdapter.RANDOM

ADD(self, first, second)

source code 
Overrides: BaseAdapter.ADD

distributed_transaction_begin(self, key)

source code 
Overrides: BaseAdapter.distributed_transaction_begin

prepare(self, key)

source code 
Overrides: BaseAdapter.prepare

commit_prepared(self, key)

source code 
Overrides: BaseAdapter.commit_prepared

rollback_prepared(self, key)

source code 
Overrides: BaseAdapter.rollback_prepared

create_sequence_and_triggers(self, query, table, **args)

source code 
Overrides: BaseAdapter.create_sequence_and_triggers

__init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY at 0x334cd70>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)
(Constructor)

source code 

x.__init__(...) initializes x; see help(type(x)) for signature

Overrides: object.__init__
(inherited documentation)

after_connection(self)

source code 

this it is supposed to be overloaded by adapters

Overrides: ConnectionPool.after_connection
(inherited documentation)

lastrowid(self, table=None)

source code 
Overrides: BaseAdapter.lastrowid

LIKE(self, first, second)

source code 

case sensitive like operator

Overrides: BaseAdapter.LIKE
(inherited documentation)

ILIKE(self, first, second)

source code 

case in-sensitive like operator

Overrides: BaseAdapter.ILIKE
(inherited documentation)

REGEXP(self, first, second)

source code 

regular expression operator

Overrides: BaseAdapter.REGEXP
(inherited documentation)

STARTSWITH(self, first, second)

source code 
Overrides: BaseAdapter.STARTSWITH

ENDSWITH(self, first, second)

source code 
Overrides: BaseAdapter.ENDSWITH

represent(self, obj, fieldtype)

source code 
Overrides: BaseAdapter.represent

_drop(self, table, mode='restrict')

source code 
Overrides: BaseAdapter._drop

Class Variable Details [hide private]

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',
...

REGEX_URI

Value:
re.compile(r'^(?P<user>[^:@]+)(:(?P<password>[^@]*))?@(?P<host>[^:@]+)\
(:(?P<port>[0-9]+))?/(?P<db>[^\?]+)(\?sslmode=(?P<sslmode>.+))?$')

   Home       Trees       Indices       Help   
web2py Web Framework
Generated by Epydoc 3.0.1 on Sun Mar 16 02:36:13 2014 http://epydoc.sourceforge.net