def __init__(self): columns = [Column("filename",readonly=1), Column("title"), Column("rating",Column.Int), Column("virtual",Column.Boolean), Column("ID",Column.Primary,readonly=1), Column("format",readonly=1)] self.mainTable = MainTable(format="format", name="VideoInfo", columns=columns, primary="ID") columns = [Column("ID", Column.Primary,readonly=1), Column("name"), Column("hair"), Column("celeb",Column.Boolean), Column("type")] self.starTable = AuxiliaryTable(name="Stars", columns=columns, primary="ID", major="name") self.starLinkTable = LinkTable( name="StarVideo", auxTable=self.starTable, mainTable=self.mainTable) self.starTable.setLinkedTable(self.starLinkTable) self.tables = [self.mainTable, self.starTable, self.starLinkTable] Config.__init__(self)
def __init__(self): columns = [ Column("filename", readonly=1), Column("title"), Column("rating", Column.Int), Column("virtual", Column.Boolean), Column("ID", Column.Primary, readonly=1), Column("format", readonly=1) ] self.mainTable = MainTable(format="format", name="VideoInfo", columns=columns, primary="ID") columns = [ Column("ID", Column.Primary, readonly=1), Column("name"), Column("hair"), Column("celeb", Column.Boolean), Column("type") ] self.starTable = AuxiliaryTable(name="Stars", columns=columns, primary="ID", major="name") self.starLinkTable = LinkTable(name="StarVideo", auxTable=self.starTable, mainTable=self.mainTable) self.starTable.setLinkedTable(self.starLinkTable) self.tables = [self.mainTable, self.starTable, self.starLinkTable] Config.__init__(self)
def __init__(self): ########## MAIN ############################# columns = [ Column("filename", readonly=1), Column("photoset"), Column("ID", Column.Primary, readonly=1), Column("format", readonly=1) ] self.mainTable = MainTable(format="format", name="PictureInfo", columns=columns, primary="ID") ########## SUBJECT ############################# columns = [ Column("ID", Column.Primary, readonly=1), Column("name"), Column("hair"), Column("race") ] self.subjectTable = AuxiliaryTable(name="Subject", columns=columns, primary="ID", major="name") self.subjectLinkTable = LinkTable(name="SubjectPicture", auxTable=self.subjectTable, mainTable=self.mainTable) self.subjectTable.setLinkedTable(self.subjectLinkTable) ########## TAGS ############################# columns = [ Column("ID", Column.Primary, readonly=1), Column("description") ] self.tagTable = AuxiliaryTable(name="Tag", columns=columns, primary="ID", major="description") self.tagLinkTable = LinkTable(name="TagPicture", auxTable=self.tagTable, mainTable=self.mainTable) self.tagTable.setLinkedTable(self.tagLinkTable) ################################################ self.tables = [ self.mainTable, self.subjectTable, self.subjectLinkTable, self.tagTable, self.tagLinkTable ] Config.__init__(self)
def __init__(self): ########## MAIN ############################# columns = [Column("filename",readonly=1), Column("photoset"), Column("ID",Column.Primary,readonly=1), Column("format",readonly=1)] self.mainTable = MainTable(format="format", name="PictureInfo", columns=columns, primary="ID") ########## SUBJECT ############################# columns = [Column("ID", Column.Primary,readonly=1), Column("name"), Column("hair"), Column("race")] self.subjectTable = AuxiliaryTable(name="Subject", columns=columns, primary="ID", major="name") self.subjectLinkTable = LinkTable( name="SubjectPicture", auxTable=self.subjectTable, mainTable=self.mainTable) self.subjectTable.setLinkedTable(self.subjectLinkTable) ########## TAGS ############################# columns = [Column("ID", Column.Primary,readonly=1), Column("description")] self.tagTable = AuxiliaryTable(name="Tag", columns=columns, primary="ID", major="description") self.tagLinkTable = LinkTable( name="TagPicture", auxTable=self.tagTable, mainTable=self.mainTable) self.tagTable.setLinkedTable(self.tagLinkTable) ################################################ self.tables = [self.mainTable, self.subjectTable, self.subjectLinkTable, self.tagTable, self.tagLinkTable] Config.__init__(self)
def __init__(self): columns = [Column("title"), Column("artist"), Column("album"), Column("year"), Column("genre"), Column("track"), Column("format",readonly=1), Column("filename",readonly=1)] self.mainTable = MainTable(format="format", name="AudioInfo", columns=columns, primary="filename") self.tables = [self.mainTable] Config.__init__(self)
def __init__(self): columns = [ Column("title"), Column("artist"), Column("album"), Column("year"), Column("genre"), Column("track"), Column("format", readonly=1), Column("filename", readonly=1) ] self.mainTable = MainTable(format="format", name="AudioInfo", columns=columns, primary="filename") self.tables = [self.mainTable] Config.__init__(self)