예제 #1
0
  `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);
예제 #2
0
파일: testing.py 프로젝트: Nazkter/Mafa_Web
#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)
예제 #3
0
파일: testing.py 프로젝트: BioinfUD/NGSpre
#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)
예제 #4
0
파일: cmddmon.py 프로젝트: Nazkter/Mafa_Web
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}
예제 #5
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);