Package web2py :: Package gluon :: Module dal2 :: Class MySQLAdapter

[frames] | no frames]

Class MySQLAdapter

    object --+        
             |        
ConnectionPool --+    
                 |    
       BaseAdapter --+
                     |
                    MySQLAdapter

Instance Methods

RANDOM(self)

source code

SUBSTRING(self, field, parameters)

source code

DROP(self, table, mode)

source code

support_distributed_transaction(self)

source code

distributed_transaction_begin(self, key)

source code

prepare(self, key)

source code

commit_prepared(self, ley)

source code

rollback_prepared(self, key)

source code

concat_add(self, table)

source code

__init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8')
x.__init__(...) initializes x; see x.__class__.__doc__ for signature source code

commit_on_alter_table(self)

source code

lastrowid(self, tablename)

source code

Inherited from BaseAdapter: ADD, AGGREGATE, AND, BELONGS, COMMA, COUNT, DELETE, DESC, DIV, EQ, EXTRACT, GE, GT, INSERT, LE, LEFT_JOIN, LIKE, LOWER, LT, MUL, NE, NOT, NOT_NULL, ON, OR, PRIMARY_KEY, SELECT, SELECT_LIMITBY, SUB, TRUNCATE, UPDATE, UPPER, VERBATIM, alias, commit, contraint_name, count, create_sequence_and_triggers, execute, expand, integrity_error_class, log_execute, parse, represent, represent_exceptions, rollback, rowslice, select, tables

Inherited from ConnectionPool: find_or_make_work_folder, pool_connection

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

Static Methods

Inherited from ConnectionPool: close_all_instances, set_thread_folder

Class Variables

types = {'blob': 'LONGBLOB', 'boolean': 'CHAR(1)', 'date': 'DA...

Inherited from ConnectionPool (private): _connection_pools, _folders, _instances

Properties

Inherited from object: __class__

Method Details

RANDOM(self)

Overrides: BaseAdapter.RANDOM

SUBSTRING(self, field, parameters)

Overrides: BaseAdapter.SUBSTRING

DROP(self, table, mode)

Overrides: BaseAdapter.DROP

support_distributed_transaction(self)

Overrides: BaseAdapter.support_distributed_transaction

distributed_transaction_begin(self, key)

Overrides: BaseAdapter.distributed_transaction_begin

prepare(self, key)

Overrides: BaseAdapter.prepare

commit_prepared(self, ley)

Overrides: BaseAdapter.commit_prepared

rollback_prepared(self, key)

Overrides: BaseAdapter.rollback_prepared

concat_add(self, table)

Overrides: BaseAdapter.concat_add

init(self, db, uri, pool_size=0, folder=None, db_codec=`'UTF-8'`)
(Constructor)

x.__init__(...) initializes x; see x.__class__.__doc__ for signature

Overrides: object.__init__: (inherited documentation)

commit_on_alter_table(self)

Overrides: BaseAdapter.commit_on_alter_table

lastrowid(self, tablename)

Overrides: BaseAdapter.lastrowid

Class Variable Details

types

Value:

{'blob': 'LONGBLOB',
 'boolean': 'CHAR(1)',
 'date': 'DATE',
 'datetime': 'DATETIME',
 'decimal': 'NUMERIC(%(precision)s,%(scale)s)',
 'double': 'DOUBLE',
 'id': 'INT AUTO_INCREMENT NOT NULL',
 'integer': 'INT',
...