Package gluon :: Module dal :: Class SQLiteAdapter

[frames] | no frames]

Class SQLiteAdapter

    object --+        
             |        
ConnectionPool --+    
                 |    
       BaseAdapter --+
                     |
                    SQLiteAdapter

Known Subclasses:

Nested Classes

Inherited from BaseAdapter: __metaclass__

Instance Methods

EXTRACT(self, field, what)

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

_truncate(self, table, mode='') source code

lastrowid(self, table)

source code

REGEXP(self, first, second)
regular expression operator

source code

select(self, query, fields, attributes)
Simulate SELECT ...

source code

Inherited from BaseAdapter: ADD, AGGREGATE, ALLOW_NULL, AND, AS, BELONGS, CASE, CAST, COALESCE, COALESCE_ZERO, COMMA, CONCAT, CONTAINS, COUNT, DIV, ENDSWITH, EPOCH, EQ, GE, GT, ILIKE, INVERT, JOIN, LE, LEFT_JOIN, LENGTH, LIKE, LOWER, LT, MOD, MUL, NE, NOT, NOT_NULL, ON, OR, PRIMARY_KEY, RANDOM, RAW, REPLACE, STARTSWITH, SUB, SUBSTRING, UPPER, adapt, alias, build_parsemap, bulk_insert, close_connection, commit, commit_prepared, common_filter, concat_add, connector, constraint_name, count, create_sequence_and_triggers, create_table, delete, distributed_transaction_begin, 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, prepare, represent, represent_exceptions, rollback, rollback_prepared, rowslice, save_dbt, select_limitby, sequence_name, smart_adapt, sqlsafe_field, sqlsafe_table, table_alias, tables, trigger_name, truncate, update, varquote

Inherited from BaseAdapter (private): _count, _delete, _drop, _fetchall, _insert, _insert_empty, _select, _select_aux, _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

web2py_extract(lookup, s)

source code

web2py_regexp(expression, item)

source code

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables

drivers = ('sqlite2', 'sqlite3')

can_select_for_update = None
hash(x)

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

Inherited from ConnectionPool: POOLS, check_active_connection

Properties

Inherited from object: __class__

Method Details

EXTRACT(self, field, what)

Overrides: BaseAdapter.EXTRACT

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, after_connection=None)
(Constructor)

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

Overrides: object.__init__: (inherited documentation)

after_connection(self)

this it is supposed to be overloaded by adapters

Overrides: ConnectionPool.after_connection: (inherited documentation)

_truncate(self, table, mode=`''`)

Overrides: BaseAdapter._truncate

lastrowid(self, table)

Overrides: BaseAdapter.lastrowid

REGEXP(self, first, second)

regular expression operator

Overrides: BaseAdapter.REGEXP: (inherited documentation)

select(self, query, fields, attributes)

Simulate SELECT ... FOR UPDATE with BEGIN IMMEDIATE TRANSACTION. Note that the entire database, rather than one record, is locked (it will be locked eventually anyway by the following UPDATE).

Overrides: BaseAdapter.select