Package conary :: Package dbstore :: Module mysql_drv :: Class Database
[hide private]
[frames] | no frames]

Class Database

source code

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]

cursor(self)

source code 
Overrides: base_drv.BaseDatabase.cursor

itercursor(self)

source code 
Overrides: base_drv.BaseDatabase.cursor

connect(self, **kwargs)

source code 
Overrides: base_drv.BaseDatabase.connect

alive(self)

source code 
Overrides: base_drv.BaseDatabase.alive

loadSchema(self, cu=None)

source code 
Overrides: base_drv.BaseDatabase.loadSchema

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

source code 
Overrides: base_drv.BaseDatabase.createTrigger

_dropIndexSql(self, table, name)

source code 
Overrides: base_drv.BaseDatabase._dropIndexSql

renameColumn(self, table, oldName, newName)

source code 
Overrides: base_drv.BaseDatabase.renameColumn

use(self, dbName)

source code 
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'}