def append_oneObject(self, objekt): ctype = objekt.idcol.type coltype = ColumnType(ctype.type, ctype.width) col = Column(objekt.idcol.name, coltype) col.set_fk(objekt.maintable.name) self.maintable.columns.append(col) self._maincols[col.name] = col
def append_manyObject(self, objekt, tablename=None): if tablename is None: tablename = '%s%s' % (self.type, objekt.type) coltype = ColumnType(type='int') maincol = Column(self.idcol.name, coltype) maincol.set_fk(self.maintable.name) rcol = Column(objekt.idcol.name, coltype) rcol.set_fk(objekt.maintable.name) self._hasManyTables[objekt.type] = Table(tablename, [maincol, rcol])
def append_manyfield(self, name, type, tablename, reftable): coltype = ColumnType(type='int') maincol = Column(self.idcol.name, coltype) maincol.set_fk(self.maintable.name) maincol.constraint.pk = True rcol = Column(name, coltype) rcol.set_fk(reftable) rcol.constraint.pk = True self._hasManyTables[type] = Table(tablename, [maincol, rcol])
def __init__(self, colname): Column.__init__(self, colname, NUM) self.constraint.pk = True self.constraint.unique = True self.constraint.null = False self.constraint.auto = True