def CreateDummyDB():
db = SqliteDatabase('/tmp/dummy.sqlite', 'w')
db.CreateTable(
'tecan_readings',
'exp_id TEXT, plate TEXT, reading_label TEXT, row INT, col INT, time INT, measurement REAL',
drop_if_exists=False)
db.CreateTable('tecan_labels',
'exp_id TEXT, plate INT, row INT, col INT, label TEXT',
drop_if_exists=False)
db.CreateTable(
'tecan_plates',
'exp_id TEXT, plate INT, description TEXT, owner TEXT, project TEXT',
drop_if_exists=False)
db.CreateTable('tecan_experiments',
'exp_id TEXT, serial_number TEXT, desciption TEXT',
drop_if_exists=False)
db.CreateTable('tecan_scripts',
'exp_id TEXT, script BLOB',
drop_if_exists=False)
return db
