def __init__(self, logger = None, dbi = None, params = None): """ _init_ Call the base class's constructor and create all necessary tables, constraints and inserts. """ CreateAgentBase.__init__(self, logger, dbi, params) self.create["01wm_components"] = \ """CREATE TABLE wm_components ( id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, pid INTEGER NOT NULL, update_threshold INTEGER NOT NULL, PRIMARY KEY (id), UNIQUE (name))""" for tableName in self.sequenceTables: seqname = '%s_SEQ' % tableName self.create["%s%s" % (self.seqStartNum, seqname)] = """ CREATE SEQUENCE %s start with 1 increment by 1 nomaxvalue cache 100""" % seqname triggerName = '%s_TRG' % tableName self.create["%s%s" % (self.seqStartNum, triggerName)] = """ CREATE TRIGGER %s BEFORE INSERT ON %s REFERENCING NEW AS newRow FOR EACH ROW BEGIN SELECT %s.nextval INTO :newRow.id FROM dual; END; """ % (triggerName, tableName, seqname)
def __init__(self, logger=None, dbi=None, params=None): """ _init_ Call the base class's constructor and create all necessary tables, constraints and inserts. """ CreateAgentBase.__init__(self, logger, dbi, params) self.create["01wm_components"] = \ """CREATE TABLE wm_components ( id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, pid INTEGER NOT NULL, update_threshold INTEGER NOT NULL, PRIMARY KEY (id), UNIQUE (name))""" for tableName in self.sequenceTables: seqname = '%s_SEQ' % tableName self.create["%s%s" % (self.seqStartNum, seqname)] = """ CREATE SEQUENCE %s start with 1 increment by 1 nomaxvalue cache 100""" % seqname triggerName = '%s_TRG' % tableName self.create["%s%s" % (self.seqStartNum, triggerName)] = """ CREATE TRIGGER %s BEFORE INSERT ON %s REFERENCING NEW AS newRow FOR EACH ROW BEGIN SELECT %s.nextval INTO :newRow.id FROM dual; END; """ % (triggerName, tableName, seqname)
def __init__(self, logger=None, dbi=None, params=None): """ _init_ Call the base class's constructor and create all necessary tables, constraints and inserts. """ CreateAgentBase.__init__(self, logger, dbi, params)
def __init__(self, logger = None, dbi = None, params = None): """ _init_ Call the base class's constructor and create all necessary tables, constraints and inserts. """ CreateAgentBase.__init__(self, logger, dbi, params)
def execute(self, conn = None, transaction = None): for i in self.create.keys(): self.create[i] = self.create[i] + " ENGINE=InnoDB" self.create[i] = self.create[i].replace('INTEGER', 'INT(11)') return CreateAgentBase.execute(self, conn, transaction)
def __init__(self, logger=None, dbi=None, params=None): """ _init_ Call the base class's constructor and create all necessary tables, constraints and inserts. """ CreateAgentBase.__init__(self, logger, dbi, params) self.create["02wm_workers"] = \ """CREATE TABLE wm_workers ( component_id INTEGER NOT NULL REFERENCES wm_components(id), name VARCHAR(255) NOT NULL, last_updated INTEGER NOT NULL, state VARCHAR(255), pid INTEGER, last_error INTEGER, error_message VARCHAR(1000), UNIQUE (component_id, name))""" # constraints added in table definition self.constraints.clear()
def __init__(self, logger = None, dbi = None, params = None): """ _init_ Call the base class's constructor and create all necessary tables, constraints and inserts. """ CreateAgentBase.__init__(self, logger, dbi, params) self.create["02wm_workers"] = \ """CREATE TABLE wm_workers ( component_id INTEGER NOT NULL REFERENCES wm_components(id), name VARCHAR(255) NOT NULL, last_updated INTEGER NOT NULL, state VARCHAR(255), pid INTEGER, last_error INTEGER, error_message VARCHAR(1000), UNIQUE (component_id, name))""" # constraints added in table definition self.constraints.clear()
def execute(self, conn=None, transaction=None): for i in self.create.keys(): self.create[i] = self.create[i].replace('AUTO_INCREMENT', 'AUTOINCREMENT') return CreateAgentBase.execute(self, conn, transaction)
def execute(self, conn=None, transaction=None): for i in self.create.keys(): self.create[i] += " ENGINE=InnoDB ROW_FORMAT=DYNAMIC" self.create[i] = self.create[i].replace('INTEGER', 'INT(11)') return CreateAgentBase.execute(self, conn, transaction)
def execute(self, conn = None, transaction = None): for i in self.create.keys(): self.create[i] = self.create[i].replace('AUTO_INCREMENT', 'AUTOINCREMENT') return CreateAgentBase.execute(self, conn, transaction)