OPSI.Backend.SQL module

Basic SQL backend.

This backend is a general SQL implementation undependend from concrete databases and their implementation.

copyright:uib GmbH <info@uib.de> author:Jan Schneider <j.schneider@uib.de> author:Erol Ueluekmen <e.ueluekmen@uib.de> author:Niko Wenselowski <n.wenselowski@uib.de> license:GNU Affero General Public License version 3

class OPSI.Backend.SQL.SQL(**kwargs)

Bases: object

ALTER_TABLE_CHANGE_SUPPORTED = True

AUTOINCREMENT = 'AUTO_INCREMENT'

ESCAPED_APOSTROPHE = "\\'"

ESCAPED_ASTERISK = '\\*'

ESCAPED_BACKSLASH = '\\\\'

ESCAPED_PERCENT = '\\%'

ESCAPED_UNDERSCORE = '\\_'

close(conn, cursor)

connect()

delete(table, where)

doCommit = True

escapeApostrophe(string)

escapeAsterisk(string)

escapeBackslash(string)

escapePercent(string)

escapeUnderscore(string)

execute(query, conn=None, cursor=None)

getRow(query)

getSet(query)

getTableCreationOptions(table)

getTables()

insert(table, valueHash)

query(query, conn=None, cursor=None)

update(table, where, valueHash, updateWhereNone=False)

class OPSI.Backend.SQL.SQLBackend(**kwargs)

Bases: OPSI.Backend.Backend.ConfigDataBackend

auditHardwareOnHost_deleteObjects(auditHardwareOnHosts)

auditHardwareOnHost_getHashes(attributes=[], **filter)

auditHardwareOnHost_getObjects(attributes=[], **filter)

auditHardwareOnHost_insertObject(auditHardwareOnHost)

auditHardwareOnHost_updateObject(auditHardwareOnHost)

auditHardware_deleteObjects(auditHardwares)

auditHardware_getHashes(attributes=[], **filter)

auditHardware_getObjects(attributes=[], **filter)

auditHardware_insertObject(auditHardware)

auditHardware_updateObject(auditHardware)

auditSoftwareOnClient_deleteObjects(auditSoftwareOnClients)

auditSoftwareOnClient_getHashes(attributes=[], **filter)

auditSoftwareOnClient_getObjects(attributes=[], **filter)

auditSoftwareOnClient_insertObject(auditSoftwareOnClient)

auditSoftwareOnClient_updateObject(auditSoftwareOnClient)

auditSoftwareToLicensePool_deleteObjects(auditSoftwareToLicensePools)

auditSoftwareToLicensePool_getHashes(attributes=[], **filter)

auditSoftwareToLicensePool_getObjects(attributes=[], **filter)

auditSoftwareToLicensePool_insertObject(auditSoftwareToLicensePool)

auditSoftwareToLicensePool_updateObject(auditSoftwareToLicensePool)

auditSoftware_deleteObjects(auditSoftwares)

auditSoftware_getHashes(attributes=[], **filter)

auditSoftware_getObjects(attributes=[], **filter)

auditSoftware_insertObject(auditSoftware)

auditSoftware_updateObject(auditSoftware)

backend_createBase()

backend_deleteBase()

backend_exit()

bootConfiguration_deleteObjects(bootConfigurations)

bootConfiguration_getObjects(attributes=[], **filter)

bootConfiguration_insertObject(bootConfiguration)

bootConfiguration_updateObject(bootConfiguration)

configState_deleteObjects(configStates)

configState_getObjects(attributes=[], **filter)

configState_insertObject(configState)

configState_updateObject(configState)

config_deleteObjects(configs)

config_getObjects(attributes=[], **filter)

config_insertObject(config)

config_updateObject(config)

getData(query)

getRawData(query)

group_deleteObjects(groups)

group_getObjects(attributes=[], **filter)

group_insertObject(group)

group_updateObject(group)

host_deleteObjects(hosts)

host_getObjects(attributes=[], **filter)

host_insertObject(host)

host_updateObject(host)

licenseContract_deleteObjects(licenseContracts)

licenseContract_getObjects(attributes=[], **filter)

licenseContract_insertObject(licenseContract)

licenseContract_updateObject(licenseContract)

licenseOnClient_deleteObjects(licenseOnClients)

licenseOnClient_getObjects(attributes=[], **filter)

licenseOnClient_insertObject(licenseOnClient)

licenseOnClient_updateObject(licenseOnClient)

licensePool_deleteObjects(licensePools)

licensePool_getObjects(attributes=[], **filter)

licensePool_insertObject(licensePool)

licensePool_updateObject(licensePool)

objectToGroup_deleteObjects(objectToGroups)

objectToGroup_getObjects(attributes=[], **filter)

objectToGroup_insertObject(objectToGroup)

objectToGroup_updateObject(objectToGroup)

productDependency_deleteObjects(productDependencies)

productDependency_getObjects(attributes=[], **filter)

productDependency_insertObject(productDependency)

productDependency_updateObject(productDependency)

productOnClient_deleteObjects(productOnClients)

productOnClient_getObjects(attributes=[], **filter)

productOnClient_insertObject(productOnClient)

productOnClient_updateObject(productOnClient)

productOnDepot_deleteObjects(productOnDepots)

productOnDepot_getObjects(attributes=[], **filter)

productOnDepot_insertObject(productOnDepot)

productOnDepot_updateObject(productOnDepot)

productPropertyState_deleteObjects(productPropertyStates)

productPropertyState_getObjects(attributes=[], **filter)

productPropertyState_insertObject(productPropertyState)

productPropertyState_updateObject(productPropertyState)

productProperty_deleteObjects(productProperties)

productProperty_getObjects(attributes=[], **filter)

productProperty_insertObject(productProperty)

productProperty_updateObject(productProperty)

product_deleteObjects(products)

product_getObjects(attributes=[], **filter)

product_insertObject(product)

product_updateObject(product)

softwareLicenseToLicensePool_deleteObjects(softwareLicenseToLicensePools)

softwareLicenseToLicensePool_getObjects(attributes=[], **filter)

softwareLicenseToLicensePool_insertObject(softwareLicenseToLicensePool)

softwareLicenseToLicensePool_updateObject(softwareLicenseToLicensePool)

softwareLicense_deleteObjects(softwareLicenses)

softwareLicense_getObjects(attributes=[], **filter)

softwareLicense_insertObject(softwareLicense)

softwareLicense_updateObject(softwareLicense)

class OPSI.Backend.SQL.SQLBackendObjectModificationTracker(**kwargs)

Bases: OPSI.Backend.Backend.BackendModificationListener

clearModifications(objectClass=None, sinceDate=0)

getModifications(sinceDate=0)

objectInserted(backend, obj)

objectUpdated(backend, obj)

objectsDeleted(backend, objs)

OPSI.Backend.SQL.onlyAllowSelect(query)

OPSI.Backend.SQL.timeQuery(*args, **kwds)