def createLabelsTable(cursor):
fields = ['experiment_label_id', 'instance_id']
fields += ['label', 'family']
fields += ['iteration', 'method', 'annotation']
types = ['INT UNSIGNED', 'INT UNSIGNED', 'VARCHAR(200)']
types += ['VARCHAR(200)', 'INT UNSIGNED', 'VARCHAR(200)', 'BIT(1)']
mysql_tools.createTableFromFields(cursor, 'Labels', fields, types,
['experiment_label_id', 'instance_id'])
def createExperimentsLabelsTable(cursor):
fields = ['id', 'label']
types = ['INT UNSIGNED', 'VARCHAR(1000)']
mysql_tools.createTableFromFields(cursor,
'ExperimentsLabels',
fields,
types, ['id'],
auto_increment=True)
def createExperimentsTable(cursor):
fields = ['id', 'kind', 'name', 'label_id', 'parent']
types = [
'INT UNSIGNED', 'VARCHAR(200)', 'VARCHAR(1000)', 'INT UNSIGNED',
'INT UNSIGNED'
]
mysql_tools.createTableFromFields(cursor,
'Experiments',
fields,
types, ['id'],
auto_increment=True)
def loadIdents(self):
idents_file = dir_tools.getDatasetDirectory(
self.project, self.dataset) + 'idents.csv'
fields = ['instance_id', 'ident', 'row_number']
types = [
'INT', 'VARCHAR(200) CHARACTER SET utf8',
'INT NOT NULL AUTO_INCREMENT'
]
mysql_tools.createTableFromFields(self.cursor, 'Idents', fields, types,
['row_number', 'instance_id'])
mysql_tools.loadCsvFile(self.cursor, idents_file, 'Idents',
['row_number'])
def createInteractiveExperimentsTable(cursor):
fields = ['id', 'current_iter', 'annotations']
types = ['INT UNSIGNED', 'INT UNSIGNED', 'BIT(1)']
mysql_tools.createTableFromFields(cursor, 'InteractiveExperiments', fields,
types, ['id'])