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
