pydal.adapters package¶
Submodules¶
pydal.adapters.base module¶
-
class
pydal.adapters.base.
BaseAdapter
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, after_connection=None)[source]¶ Bases:
pydal.connection.ConnectionPool
-
close_connection
(*args, **kwargs)¶
-
dbengine
= 'None'¶
-
drivers
= ()¶
-
iterparse
(sql, fields, colnames, blob_decode=True, cacheable=False)[source]¶ Iterator to parse one row at a time. It doen’t support the old style virtual fields
-
support_distributed_transaction
= False¶
-
types
¶
-
uploads_in_blob
= False¶
-
-
class
pydal.adapters.base.
NoSQLAdapter
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, after_connection=None)[source]¶ Bases:
pydal.adapters.base.BaseAdapter
-
can_select_for_update
= False¶
-
drop
(*args, **kwargs)¶
-
-
class
pydal.adapters.base.
NullAdapter
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, after_connection=None)[source]¶
-
class
pydal.adapters.base.
SQLAdapter
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.BaseAdapter
-
can_select_for_update
= True¶
-
commit
(*args, **kwargs)¶
-
commit_on_alter_table
= False¶
-
commit_prepared
(*args, **kwargs)¶
-
drop
(*args, **kwargs)¶
-
execute
(*args, **kwargs)¶
-
execution_handlers
= []¶
-
prepare
(*args, **kwargs)¶
-
rollback
(*args, **kwargs)¶
-
rollback_prepared
(*args, **kwargs)¶
-
pydal.adapters.couchdb module¶
-
class
pydal.adapters.couchdb.
CouchDB
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, after_connection=None)[source]¶ Bases:
pydal.adapters.base.NoSQLAdapter
-
dbengine
= 'couchdb'¶
-
drivers
= ('couchdb',)¶
-
uploads_in_blob
= True¶
-
pydal.adapters.cubrid module¶
pydal.adapters.db2 module¶
-
class
pydal.adapters.db2.
DB2
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
dbengine
= 'db2'¶
-
execute
(*args, **kwargs)¶
-
-
class
pydal.adapters.db2.
DB2IBM
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.db2.DB2
-
drivers
= ('ibm_db_dbi',)¶
-
pydal.adapters.firebird module¶
-
class
pydal.adapters.firebird.
FireBird
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
REGEX_URI
= <_sre.SRE_Pattern object at 0x133b990>¶
-
commit_on_alter_table
= True¶
-
dbengine
= 'firebird'¶
-
drivers
= ('kinterbasdb', 'firebirdsql', 'fdb', 'pyodbc')¶
-
support_distributed_transaction
= True¶
-
-
class
pydal.adapters.firebird.
FireBirdEmbedded
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.firebird.FireBird
-
REGEX_URI
= <_sre.SRE_Pattern object at 0x1337aa0>¶
-
pydal.adapters.google_adapters module¶
Adapter for GAE
pydal.adapters.imap module¶
pydal.adapters.informix module¶
-
class
pydal.adapters.informix.
Informix
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
dbengine
= 'informix'¶
-
drivers
= ('informixdb',)¶
-
execute
(*args, **kwargs)¶
-
pydal.adapters.ingres module¶
-
class
pydal.adapters.ingres.
Ingres
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
dbengine
= 'ingres'¶
-
drivers
= ('pyodbc',)¶
-
-
class
pydal.adapters.ingres.
IngresUnicode
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.ingres.Ingres
pydal.adapters.mongo module¶
-
class
pydal.adapters.mongo.
Expansion
(adapter, crud, query, fields=(), tablename=None, groupby=None, distinct=False, having=None)[source]¶ Bases:
object
Class to encapsulate a pydal expression and track the parse expansion and its results.
Two different MongoDB mechanisms are targeted here. If the query is sufficiently simple, then simple queries are generated. The bulk of the complexity here is however to support more complex queries that are targeted to the MongoDB Aggregation Pipeline.
This class supports four operations: ‘count’, ‘select’, ‘update’ and ‘delete’.
Behavior varies somewhat for each operation type. However building each pipeline stage is shared where the behavior is the same (or similar) for the different operations.
In general an attempt is made to build the query without using the pipeline, and if that fails then the query is rebuilt with the pipeline.
- QUERY constructed in _build_pipeline_query():
- $project : used to calculate expressions if needed $match: filters out records
- FIELDS constructed in _expand_fields():
- FIELDS:COUNT
- $group : filter for distinct if needed $group: count the records remaining
- FIELDS:SELECT
- $group : implement aggregations if needed $project: implement expressions (etc) for select
- FIELDS:UPDATE
- $project: implement expressions (etc) for update
- HAVING constructed in _add_having():
- $project : used to calculate expressions $match: filters out records $project : used to filter out previous expression fields
-
dialect
¶
-
class
pydal.adapters.mongo.
Mongo
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, after_connection=None)[source]¶ Bases:
pydal.adapters.base.NoSQLAdapter
-
dbengine
= 'mongodb'¶
-
drivers
= ('pymongo',)¶
-
insert
(table, fields, safe=None)[source]¶ Safe determines whether a asynchronous request is done or a synchronous action is done For safety, we use by default synchronous requests
-
pydal.adapters.mssql module¶
-
class
pydal.adapters.mssql.
MSSQL
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
REGEX_ARGPATTERN
= <_sre.SRE_Pattern object>¶
-
REGEX_DSN
= <_sre.SRE_Pattern object>¶
-
REGEX_URI
= <_sre.SRE_Pattern object at 0x136cb40>¶
-
dbengine
= 'mssql'¶
-
drivers
= ('pyodbc',)¶
-
-
class
pydal.adapters.mssql.
MSSQL1
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQL
,pydal.adapters.mssql.Slicer
-
class
pydal.adapters.mssql.
MSSQL1N
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQLN
,pydal.adapters.mssql.Slicer
-
class
pydal.adapters.mssql.
MSSQL3
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQL
-
class
pydal.adapters.mssql.
MSSQL3N
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQLN
-
class
pydal.adapters.mssql.
MSSQL4
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQL
-
class
pydal.adapters.mssql.
MSSQL4N
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQLN
-
class
pydal.adapters.mssql.
MSSQLN
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQL
-
execute
(*args, **kwargs)¶
-
-
class
pydal.adapters.mssql.
Sybase
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQL1
-
dbengine
= 'sybase'¶
-
-
class
pydal.adapters.mssql.
Vertica
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.mssql.MSSQL1
pydal.adapters.mysql module¶
-
class
pydal.adapters.mysql.
Cubrid
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.mysql.MySQL
-
dbengine
= 'cubrid'¶
-
drivers
= ('cubriddb',)¶
-
-
class
pydal.adapters.mysql.
MySQL
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
REGEX_URI
= <_sre.SRE_Pattern object at 0x13e4310>¶
-
commit_on_alter_table
= True¶
-
commit_prepared
(*args, **kwargs)¶
-
dbengine
= 'mysql'¶
-
drivers
= ('MySQLdb', 'pymysql', 'mysqlconnector')¶
-
prepare
(*args, **kwargs)¶
-
rollback_prepared
(*args, **kwargs)¶
-
support_distributed_transaction
= True¶
-
pydal.adapters.oracle module¶
pydal.adapters.postgres module¶
-
class
pydal.adapters.postgres.
JDBCPostgre
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.Postgre
-
REGEX_URI
= <_sre.SRE_Pattern object at 0x136cf00>¶
-
drivers
= ('zxJDBC',)¶
-
-
class
pydal.adapters.postgres.
Postgre
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
REGEX_URI
= <_sre.SRE_Pattern object at 0x1364120>¶
-
commit_prepared
(*args, **kwargs)¶
-
dbengine
= 'postgres'¶
-
drivers
= ('psycopg2', 'pg8000')¶
-
prepare
(*args, **kwargs)¶
-
rollback_prepared
(*args, **kwargs)¶
-
support_distributed_transaction
= True¶
-
-
class
pydal.adapters.postgres.
PostgreBoolean
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶
-
class
pydal.adapters.postgres.
PostgreMeta
[source]¶ Bases:
pydal.adapters.AdapterMeta
-
class
pydal.adapters.postgres.
PostgreNew
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶
-
class
pydal.adapters.postgres.
PostgrePG8000
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.Postgre
-
drivers
= ('pg8000',)¶
-
execute
(*args, **kwargs)¶
-
-
class
pydal.adapters.postgres.
PostgrePG8000Boolean
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.PostgrePG8000New
,pydal.adapters.postgres.PostgreBoolean
-
class
pydal.adapters.postgres.
PostgrePG8000New
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.PostgrePG8000
,pydal.adapters.postgres.PostgreNew
-
class
pydal.adapters.postgres.
PostgrePsyco
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.Postgre
-
drivers
= ('psycopg2',)¶
-
-
class
pydal.adapters.postgres.
PostgrePsycoBoolean
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.PostgrePsycoNew
,pydal.adapters.postgres.PostgreBoolean
-
class
pydal.adapters.postgres.
PostgrePsycoNew
(db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY>, driver_args={}, adapter_args={}, do_connect=True, srid=4326, after_connection=None)[source]¶ Bases:
pydal.adapters.postgres.PostgrePsyco
,pydal.adapters.postgres.PostgreNew
pydal.adapters.sapdb module¶
pydal.adapters.sqlite module¶
-
class
pydal.adapters.sqlite.
JDBCSQLite
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.sqlite.SQLite
-
drivers
= ('zxJDBC_sqlite',)¶
-
-
class
pydal.adapters.sqlite.
SQLite
(*args, **kwargs)[source]¶ Bases:
pydal.adapters.base.SQLAdapter
-
dbengine
= 'sqlite'¶
-
drivers
= ('sqlite2', 'sqlite3')¶
-