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)
__author__ = 'matt'
#! /usr/bin/python
from ConfigBase import Config
import os
import inspect
import logging
config = Config()
config['db_connection_string'] = 'mysql://*****:*****@localhost'
# load local config overrides
# these can be passed in env variables
if 'TEST_CONFIG' in os.environ:
configModule = 'config.' + os.environ['TEST_CONFIG']
print 'Using', configModule
localConfig = __import__(configModule)
config.update(getattr(localConfig, os.environ['TEST_CONFIG']).config)
