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 0x31433f0>¶
-
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 0x313eb20>¶
-
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 0x3143140>¶
-
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 0x3141e50>¶
-
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 0x307a2f0>¶
-
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 0x3076b00>¶
-
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')¶
-