Package conary :: Package dbstore :: Module mysql_drv :: Class Database

Class Database

base_drv.BaseDatabase --+
                        |
                       Database

Nested Classes

[hide private]

cursorClass

iterCursorClass

sequenceClass

Instance Methods

[hide private]

_setCharSet(self, cu)

source code

_getMaxPacketSize(self, cu)

source code

cursor(self)

source code

itercursor(self)

source code

connect(self, **kwargs)

source code

alive(self)

source code

loadSchema(self, cu=None)

source code

createTrigger(self, table, column, onAction, pinned=None)

source code

_dropIndexSql(self, table, name)

source code

renameColumn(self, table, oldName, newName)

source code

use(self, dbName)
Connects to a new database using the same login credentials and database host.

source code

analyze(self, table='') source code

dropForeignKey(self, table, column=None, name=None)

source code

setAutoIncrement(self, table, column, value)

source code

Inherited from base_drv.BaseDatabase: __del__, __init__, addForeignKey, bulkload, close, closed, commit, createIndex, dropColumn, dropIndex, dropTrigger, getVersion, reopen, rollback, sequence, setVersion, shell, transaction

Inherited from base_drv.BaseDatabase (private): _connectData

Class Variables

[hide private]

alive_check = 'select version(), current_date()'

basic_transaction = 'begin'

driver = 'mysql'

MaxPacket = 1048576

keywords = {'MEDIUMBLOB': 'MEDIUMBLOB', 'BLOB': 'BLOB', 'STRIN...

tempTableStorage = {}

Inherited from base_drv.BaseDatabase: functions, sequences, tables, tempTables, triggers, version, views

Method Details

[hide private]

Connects to a new database using the same login credentials and database host. On sqlite, this emulates a straight new connect()

Overrides: base_drv.BaseDatabase.use: (inherited documentation)

analyze(self, table=`''`)

source code

Overrides: base_drv.BaseDatabase.analyze

dropForeignKey(self, table, column=None, name=None)

source code

Overrides: base_drv.BaseDatabase.dropForeignKey

setAutoIncrement(self, table, column, value)

source code

Overrides: base_drv.BaseDatabase.setAutoIncrement

Class Variable Details

[hide private]

keywords

Value:

{'MEDIUMBLOB': 'MEDIUMBLOB', 'BLOB': 'BLOB', 'STRING': 'VARCHAR(767)',
 'PATHTYPE': 'VARBINARY(767)', 'CREATEVIEW': "CREATE DEFINER='root'@'l
ocalhost' SQL SECURITY INVOKER VIEW", 'STRAIGHTJOIN': 'STRAIGHT_JOIN',
 'PRIMARYKEY': 'INTEGER PRIMARY KEY AUTO_INCREMENT', 'TABLEOPTS': 'DEF
AULT CHARACTER SET latin1 COLLATE latin1_bin'}

Class Database

cursor(self)

itercursor(self)

connect(self, **kwargs)

alive(self)

loadSchema(self, cu=None)

createTrigger(self, table, column, onAction, pinned=None)

_dropIndexSql(self, table, name)

renameColumn(self, table, oldName, newName)

use(self, dbName)

analyze(self, table='')

dropForeignKey(self, table, column=None, name=None)

setAutoIncrement(self, table, column, value)

keywords

analyze(self, table=`''`)