conary.dbstore.base_drv.BaseDatabase

Class BaseDatabase

Instance Methods

[hide private]

__init__(self, db)

source code

__del__(self)

source code

_connectData(self, names=['user', 'password', 'host', 'port', 'database']) source code

connect(self, **kwargs)

source code

reopen(self)
Returns True if the database backend was reopened or a reconnection was required

source code

close(self)

source code

alive(self)

source code

closed(self)

source code

cursor(self)

source code

itercursor(self)

source code

sequence(self, name)

source code

analyze(self, table='') source code

commit(self)

source code

transaction(self, name=None)
start transaction [ named point ]

source code

rollback(self, name=None)
rollback [ to transaction point ]

source code

createTrigger(self, table, when, onAction, sql)

source code

dropTrigger(self, table, onAction)

source code

createIndex(self, table, name, columns, unique=False, check=True)

source code

_dropIndexSql(self, table, name)

source code

dropIndex(self, table, name, check=True)

source code

dropColumn(self, table, name)

source code

renameColumn(self, table, oldName, newName)

source code

loadSchema(self)

source code

getVersion(self)

source code

setVersion(self, version)

source code

shell(self)

source code

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

source code

bulkload(self, tableName, rows, columnNames, start_transaction=True)

source code

addForeignKey(self, table, column, refTable, refColumn, cascade=False, name=None)

source code

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

source code

setAutoIncrement(self, table, column, value)

source code

Class Variables

[hide private]

alive_check = 'select 1 where 1 = 1'

basic_transaction = 'begin transaction'

driver = 'base'

keywords = {'MEDIUMBLOB': 'BLOB', 'STRING': 'STRING', 'PATHTYP...

tables = None

views = None

tempTables = None

functions = None

sequences = None

triggers = None

version = 0

use(self, dbName, **kwargs)

source code

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

Class Variable Details

[hide private]

keywords

Value:

{'MEDIUMBLOB': 'BLOB', 'STRING': 'STRING', 'PATHTYPE': 'STRING', 'CREA
TEVIEW': 'CREATE VIEW', 'STRAIGHTJOIN': '', 'TABLEOPTS': '', 'PRIMARYK
EY': 'INTEGER PRIMARY KEY', 'BLOB': 'BLOB'}