`alig_identy` float NOT NULL,
`gi_id` varchar(3000) NOT NULL,
`ref_seq_ac` varchar(1000) NOT NULL,
`ref_seq_def` varchar(1000) NOT NULL,
`go_ids` varchar(3000) NOT NULL,
`go_terms` varchar(12000) NOT NULL,
`go_ontology` varchar(100) NOT NULL,
`uniprot_ac` varchar(50) NOT NULL,
`uniprot_def` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Tabla con los campos definitivos';"""
#query = table.format('morrongo')
#print query
#dbh.executeSQL(query);
timing.start()
result = dbh.executeSQL('select * from Diploria_datos limit 0,250000')
countd = dbh.executeSQL('select count(*) as count from Diploria_datos')
print countd[0]['count']
slices = countd[0]['count']/250000
print slices
timing.finish()
print "Took: "+str(timing.seconds())+" seconds to complete"
sconds_t = timing.seconds()*slices
print "Estimate to complete all records: "+str(sconds_t/60)+' minutes'
#print result
#print sys.getsizeof(result)/1000
#print len(result);
#name = "headlines.c2_up.clean.ok"
#sp = name.split('.')
#print sp[0]+'.'+sp[1]
import sys
from connector import DBHandler
import time
import os
args = sys.argv
inputFilename = args[1]
script = open(inputFilename, 'r')
lines = script.readlines()
qlen = len(lines)
print 'Lines:' + str(qlen)
a = DBHandler()
i = 0
for line in lines:
i = i + 1
print i, " Lines processed \r",
sys.stdout.flush()
a.executeSQL(line)
print ""
print "Finished!"
script.close()
os.remove(inputFilename)
#name = "headlines.c2_up.clean.ok"
#sp = name.split('.')
#print sp[0]+'.'+sp[1]
import sys
from connector import DBHandler
import time
import os
args = sys.argv
inputFilename = args[1]
script = open(inputFilename,'r')
lines = script.readlines();
qlen = len(lines)
print 'Lines:'+str(qlen)
a = DBHandler()
i = 0
for line in lines:
i = i + 1
print i," Lines processed \r",
sys.stdout.flush()
a.executeSQL(line)
print ""
print "Finished!"
script.close()
os.remove(inputFilename)
print 'Locating!'
import sys
from connector import DBHandler
import time
import os
import smtplib
a = DBHandler()
def execute(command):
os.system(command)
while(True):
time.sleep(1)
result = a.executeSQL("select * from commands where state='new'")
for command in result:
cmd = command['command']
query = "UPDATE commands SET state='running' WHERE id={0}".format(command['id'])
a.executeSQL(query)
print "############# NEW COMMAND ############"
print "new command: {0} is now running".format(cmd)
print "______________________________________"
execute(command['command'])
query2 = "UPDATE commands SET state='finishd' WHERE id={0}".format(command['id'])
a.executeSQL(query2)
print "state updated to 'finished'"
sender = '*****@*****.**'
receivers = [command['email']]
message = """
Here is a link to your process output: http://200.69.103.29:21050/mafa2/outputs/{0}
`alig_score` float NOT NULL,
`alig_bitscore` float NOT NULL,
`alig_identy` float NOT NULL,
`gi_id` varchar(3000) NOT NULL,
`ref_seq_ac` varchar(1000) NOT NULL,
`ref_seq_def` varchar(1000) NOT NULL,
`go_ids` varchar(3000) NOT NULL,
`go_terms` varchar(12000) NOT NULL,
`go_ontology` varchar(100) NOT NULL,
`uniprot_ac` varchar(50) NOT NULL,
`uniprot_def` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Tabla con los campos definitivos';"""
#query = table.format('morrongo')
#print query
#dbh.executeSQL(query);
timing.start()
result = dbh.executeSQL('select * from Diploria_datos limit 0,250000')
countd = dbh.executeSQL('select count(*) as count from Diploria_datos')
print countd[0]['count']
slices = countd[0]['count'] / 250000
print slices
timing.finish()
print "Took: " + str(timing.seconds()) + " seconds to complete"
sconds_t = timing.seconds() * slices
print "Estimate to complete all records: " + str(sconds_t / 60) + ' minutes'
#print result
#print sys.getsizeof(result)/1000
#print len(result);
