Exemple #1
0
    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)
Exemple #2
0
    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)
Exemple #3
0
    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)
Exemple #4
0
    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)
Exemple #5
0
 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)
Exemple #6
0
    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)