Package trac :: Package db :: Module mysql_backend :: Class MySQLConnection

Class MySQLConnection

            object --+    
                     |    
    api.ConnectionBase --+
                         |
            object --+   |
                     |   |
util.ConnectionWrapper --+
                         |
                        MySQLConnection

Connection wrapper for MySQL.

Nested Classes
Inherited from `api.ConnectionBase`: `__metaclass__`

Instance Methods

__init__(self, path, log, user=None, password=None, host=None, port=None, params={})
x.__init__(...) initializes x; see help(type(x)) for signature source code

cursor(self)

source code

rollback(self)

source code

close(self)

source code

cast(self, column, type)
Returns a clause casting column as type. source code

concat(self, *args)
Returns a clause concatenating the sequence args. source code

drop_column(self, table, column)
Drops the column from table. source code

drop_table(self, table)
Drops the table. source code

get_column_names(self, table)
Returns the list of the column names in table. source code

get_last_id(self, cursor, table, column='id')
Returns the current value of the primary key sequence for table. source code

get_table_names(self)
Returns a list of the table names.

source code

like(self)
Returns a case-insensitive LIKE clause. source code

like_escape(self, text)
Returns text escaped for use in a LIKE clause. source code

reset_tables(self)
Deletes all data from the tables and resets autoincrement indexes.

source code

prefix_match(self)
Return a case sensitive prefix-matching operator.

source code

prefix_match_value(self, prefix)
Return a value for case sensitive prefix-matching operator.

source code

quote(self, identifier)
Return the quoted identifier.

source code

update_sequence(self, cursor, table, column='id')
Updates the current value of the primary key sequence for table. source code

Inherited from util.ConnectionWrapper: __call__, __getattr__, check_select, execute, executemany

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

Class Variables
	poolable = `True`
	__abstractmethods__ = `frozenset([])`

Properties

Inherited from util.ConnectionWrapper: cnx, log, readonly

Inherited from object: __class__

Method Details

Class MySQLConnection

__init__(self, path, log, user=None, password=None, host=None, port=None, params={}) (Constructor)

cast(self, column, type)

concat(self, *args)

drop_column(self, table, column)

drop_table(self, table)

get_column_names(self, table)

get_last_id(self, cursor, table, column='id')

get_table_names(self)

like(self)

like_escape(self, text)

reset_tables(self)

prefix_match(self)

prefix_match_value(self, prefix)

quote(self, identifier)

update_sequence(self, cursor, table, column='id')

init(self, path, log, user=None, password=None, host=None, port=None, params=`{}`)
(Constructor)

get_last_id(self, cursor, table, column=`'id'`)

update_sequence(self, cursor, table, column=`'id'`)