def get_db(self): db = DAL('sqlite://%s' % self.db_filename, folder=self.db_directory) # An artifact set is a specific set of artifacts # ex: a folder of images to be scanned db.define_table('artifact_sets', Field('name', 'string'), Field('parent', 'reference artifact_sets')) # An artifact is an individual image in the Gado's queue # artifact name is a concatenation of set.name and set_incrementor # the set_incrementer is an incrementer for a particular set # the first object in the queue has an incrementer of 1 # the last object has a set_incrementer of N (for N objects in the stack) db.define_table( 'artifacts', Field('artifact_set', db.artifact_sets), # foreign key Field('set_incrementer', 'integer'), Field('name', 'string')) # An image is a picture # this could be a scan of the front or a snapshot of the back db.define_table( 'images', Field('artifact', db.artifacts), Field('path', 'string'), Field('front', 'boolean'), # is this a picture of the front? Field('name', 'string')) return db
def get_db(self): db = DAL('sqlite://%s' % self.db_filename, folder = self.db_directory) # An artifact set is a specific set of artifacts # ex: a folder of images to be scanned db.define_table('artifact_sets', Field('name', 'string'), Field('parent', 'reference artifact_sets')) # An artifact is an individual image in the Gado's queue # artifact name is a concatenation of set.name and set_incrementor # the set_incrementer is an incrementer for a particular set # the first object in the queue has an incrementer of 1 # the last object has a set_incrementer of N (for N objects in the stack) db.define_table('artifacts', Field('artifact_set', db.artifact_sets), # foreign key Field('set_incrementer', 'integer'), Field('name', 'string')) # An image is a picture # this could be a scan of the front or a snapshot of the back db.define_table('images', Field('artifact', db.artifacts), Field('path', 'string'), Field('front', 'boolean'), # is this a picture of the front? Field('name', 'string')) return db
def get_db(self): db = DAL("sqlite://%s" % self.db_filename, folder=self.db_directory) # An artifact set is a specific set of artifacts # ex: a folder of images to be scanned db.define_table("artifact_sets", Field("name", "string"), Field("parent", "reference artifact_sets")) # An artifact is an individual image in the Gado's queue # artifact name is a concatenation of set.name and set_incrementor # the set_incrementer is an incrementer for a particular set # the first object in the queue has an incrementer of 1 # the last object has a set_incrementer of N (for N objects in the stack) db.define_table( "artifacts", Field("artifact_set", db.artifact_sets), # foreign key Field("set_incrementer", "integer"), Field("name", "string"), ) # An image is a picture # this could be a scan of the front or a snapshot of the back db.define_table( "images", Field("artifact", db.artifacts), Field("path", "string"), Field("front", "boolean"), # is this a picture of the front? Field("name", "string"), ) return db