def empty_db(connector, clean_box):
# delete from tools_chromosome, tools_eachobservation, tools_uploadmd5
operator = mc.Operator(connector)
for t in clean_box:
operator.clean_table(t)
operator.terminate()
def cleandb_except(connector, exception_box, exceptions):
# delete from table where exceptions won't be deleted.
operator = mc.Operator(connector)
for t in exception_box:
if exceptions != '':
operator.clean_table(t, {'md5': ['!=', exceptions]})
else:
operator.clean_table(t)
print('Exception drop Success in ', t)
operator.terminate()
def cleanup_once(login_file_name, logfile):
connector = mc.Connector(login_file_name)
operator = mc.Operator(connector)
timenow = datetime.datetime.now()
md5s = operator.autoclean(timenow)
with open(logfile, 'a') as f:
f.write("{}: Performing routine cleanup work --------".format(timenow))
f.write('\n')
for i in md5s:
path = '/home/circ/circDraw/cirDraw/media/md5_data/' + str(i)
delete_file_outputlog(path, logfile)
def drop_db(connector):
try:
# drop table tools_chromosome, tools_eachobservation, tools_uploadmd5
operator = mc.Operator(connector)
drop_box = [
'tools_chromosome', 'tools_eachobservation', 'tools_uploadmd5'
]
for t in drop_box:
operator.drop_table(t)
operator.terminate()
return True
except Exception as e:
print("Failed: drop_db in resetdb.py failed...")
print("Error: ", e)
return False
def delete_row(connector):
try:
# delete some lines from table
operator = mc.Operator(connector)
table_name = 'django_migrations'
conditions = {'app': 'tools'}
# table_name = 'tools_uploadmd5'
# conditions = {'MD5': 'dcf1208e1926aab1af379cedec7f254c'}
operator.clean_table(table_name, conditions)
operator.terminate()
return True
except Exception as e:
print("Failed: delete_row in resetdb.py failed...")
print("Error: ", e)
return False