def addLabel(cursor, experiment_label_id, instance_id, final_label, family,
iteration_number, method, annotation):
types = ['INT UNSIGNED', 'INT UNSIGNED', 'VARCHAR(200)']
types += ['VARCHAR(200)', 'INT', 'VARCHAR(200)', 'BIT(1)']
label_info = [
experiment_label_id, instance_id, final_label, family,
iteration_number, method, annotation
]
mysql_tools.insertRowIntoTable(cursor, 'Labels', label_info, types)
def createDbLine(self):
if self.iteration_number == 1:
types = ['INT UNSIGNED', 'INT UNSIGNED', 'BIT(1)']
values = [self.experiment.experiment_id, self.iteration_number, False]
mysql_tools.insertRowIntoTable(self.experiment.cursor, 'InteractiveExperiments',
values, types)
else:
query = 'UPDATE InteractiveExperiments '
query += 'SET current_iter = ' + str(self.iteration_number) + ', '
query += 'annotations = 0 '
query += 'WHERE id = ' + str(self.experiment.experiment_id) + ';'
self.experiment.cursor.execute(query)
self.experiment.db.commit()
def addExperimentDB(self):
## Get the experiment_label id
self.cursor.execute('SELECT id FROM ExperimentsLabels \
WHERE label = %s', (self.experiment_label,))
experiment_label_id = self.cursor.fetchone()
if experiment_label_id is not None:
self.experiment_label_id = experiment_label_id[0]
else:
self.experiment_label_id = experiment_db_tools.addExperimentLabel(
self.cursor,
self.experiment_label)
types = ['INT UNSIGNED', 'VARCHAR(200)', 'VARCHAR(1000)',
'INT UNSIGNED', 'INT UNSIGNED']
values = [0, self.kind, self.experiment_name,
self.experiment_label_id, self.parent]
mysql_tools.insertRowIntoTable(self.cursor, 'Experiments',
values, types)
self.experiment_id = mysql_tools.getLastInsertedId(self.cursor)
def addExperimentLabel(cursor, experiment_label):
types = ['INT UNSIGNED', 'VARCHAR(1000)']
values = [0, experiment_label]
mysql_tools.insertRowIntoTable(cursor, 'ExperimentsLabels', values, types)
experiment_label_id = mysql_tools.getLastInsertedId(cursor)
return experiment_label_id