#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)
#Table creation from connector import DBHandler import sys import timing dbh = DBHandler() table = """CREATE TABLE `{0}` ( `db_ref` varchar(100) NOT NULL, `query_id` varchar(100) NOT NULL, `query_len` int(11) NOT NULL, `hit_id` varchar(400) NOT NULL, `hit_def` varchar(400) NOT NULL, `hit_lenght` int(11) NOT NULL, `e_value` double NOT NULL, `coverage` double NOT NULL, `covovere_value` double NOT NULL, `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';"""