Package web2py :: Package gluon :: Module sql :: Class MySQLAdapter
[hide private]
[frames] | no frames]

Class MySQLAdapter

source code

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

Instance Methods [hide private]
 
RANDOM(self) source code
 
SUBSTRING(self, field, parameters) source code
 
_drop(self, table, mode) 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=1, db_codec='UTF-8', credential_decoder=<function <lambda> at 0x12212a8>)
x.__init__(...) initializes x; see x.__class__.__doc__ for signature
source code
 
lastrowid(self, table) source code

Inherited from BaseAdapter: ADD, AGGREGATE, AND, AS, BELONGS, COMMA, CONTAINS, DIV, ENDSWITH, EQ, EXTRACT, GE, GT, INVERT, LE, LEFT_JOIN, LIKE, LOWER, LT, MUL, NE, NOT, NOT_NULL, ON, OR, PRIMARY_KEY, STARTSWITH, SUB, UPPER, alias, bulk_insert, commit, constraint_name, count, create_sequence_and_triggers, create_table, delete, drop, execute, expand, file_close, file_delete, file_exists, file_open, get_table, insert, integrity_error_class, log_execute, migrate_table, parse, represent, represent_exceptions, rollback, rowslice, select, select_limitby, sequence_name, tables, trigger_name, truncate, update

Inherited from BaseAdapter (private): _count, _delete, _insert, _select, _truncate, _update

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

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables [hide private]
  commit_on_alter_table = True
  support_distributed_transaction = True
  types = {'blob': 'LONGBLOB', 'boolean': 'CHAR(1)', 'date': 'DA...

Inherited from BaseAdapter: uploads_in_blob

Inherited from ConnectionPool: pools

Properties [hide private]

Inherited from object: __class__

Method Details [hide private]

RANDOM(self)

source code 
Overrides: BaseAdapter.RANDOM

SUBSTRING(self, field, parameters)

source code 
Overrides: BaseAdapter.SUBSTRING

_drop(self, table, mode)

source code 
Overrides: BaseAdapter._drop

distributed_transaction_begin(self, key)

source code 
Overrides: BaseAdapter.distributed_transaction_begin

prepare(self, key)

source code 
Overrides: BaseAdapter.prepare

commit_prepared(self, ley)

source code 
Overrides: BaseAdapter.commit_prepared

rollback_prepared(self, key)

source code 
Overrides: BaseAdapter.rollback_prepared

concat_add(self, table)

source code 
Overrides: BaseAdapter.concat_add

__init__(self, db, uri, pool_size=0, folder=1, db_codec='UTF-8', credential_decoder=<function <lambda> at 0x12212a8>)
(Constructor)

source code 
x.__init__(...) initializes x; see x.__class__.__doc__ for signature
Overrides: BaseAdapter.__init__

lastrowid(self, table)

source code 
Overrides: BaseAdapter.lastrowid

Class Variable Details [hide private]

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