Python MySqlConn.insert_one_by_sql примеры использования

Пример #1

Файл: PubmedProcessor.py Проект: wangtingbang/biss_py

def save_to_db(vo):
	'''
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| pmid             | varchar(16) | YES  |     | NULL    |       |
| pubdate          | datetime    | YES  |     | NULL    |       |
| iso_abbreviation | text        | YES  |     | NULL    |       |
| medline_pgn      | text        | YES  |     | NULL    |       |
| article_title    | text        | YES  |     | NULL    |       |
| authors          | text        | YES  |     | NULL    |       |
| abstracts        | text        | YES  |     | NULL    |       |
| pub_types        | text        | YES  |     | NULL    |       |
| mesh_items       | text        | YES  |     | NULL    |       |
| substances       | text        | YES  |     | NULL    |       |
| link_out         | text        | YES  |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
	'''

	sql = 'insert into biss_pubmed values (\'' + vo.getId() + '\', \'' + vo.getPd() + '\', \'' + vo.getIa() + '\', \'' + vo.getMp() + '\', \'' + vo.getAt() + '\', \'' + vo.getAth() + '\', \'' + vo.getAbs() + '\', \'' + vo.getPt() + '\', \'' + vo.getMi() + '\', \'' + vo.getSb() + '\', \'' + vo.getLo() + '\');'
	f_open = open( './logs/pubmed_sql.sql', 'a')
	f_open.write(sql + '\n')
	print 'Now inserting data into database...'
	print 'SQL:\n', sql
	try:
		res = MySqlConn.insert_one_by_sql(sql)
		print '\tData inserted into database...'
	except MySQLdb.DataError:
		print '\tData error, cannot save data...'
	return

Пример #2

Файл: CloneProcessor.py Проект: wangtingbang/biss_py

def save_to_db(vo):
	'''
+--------------+---------------+------+-----+---------+-------+
| Field        | Type          | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+-------+
| cid          | varchar(16)   | YES  |     | NULL    |       |
| lib_name     | varchar(128)  | YES  |     | NULL    |       |
| lib_abbr     | varchar(16)   | YES  |     | NULL    |       |
| organism     | varchar(32)   | YES  |     | NULL    |       |
| destributors | varchar(1024) | YES  |     | NULL    |       |
| vetor_type   | varchar(16)   | YES  |     | NULL    |       |
| clones_db    | varchar(64)   | YES  |     | NULL    |       |
| end_seq_cdb  | int(11)       | YES  |     | NULL    |       |
| isrt_seq_cdb | int(11)       | YES  |     | NULL    |       |
| c_end_seq    | int(11)       | YES  |     | NULL    |       |
+--------------+---------------+------+-----+---------+-------+
	'''

	sql = 'insert into biss_clone values (\'' + vo.getId() + '\', \'' + vo.getLn() + '\', \'' + vo.getLa() + '\', \'' + vo.getOrg() + '\', \'' + vo.getDstr() + '\', \'' + vo.getVt() + '\', \'' + vo.getCdb() + '\', \'' + vo.getEsc() + '\', \'' + vo.getIsc() + '\', \'' + vo.getCes() + '\');'
	f_open = open( './logs/clone_sql.sql', 'a')
	f_open.write(sql + '\n')
	print 'Now inserting data into database...'
	print 'SQL:\n', sql
	try:
		res = MySqlConn.insert_one_by_sql(sql)
		print '\tData inserted into database...'
	except MySQLdb.DataError:
		print '\tData error, cannot save data...'
	return

Пример #3

Файл: NucCoreProcessor.py Проект: wangtingbang/biss_py

def save_to_db(vo):
	'''
+------------+---------------+------+-----+---------+-------+
| Field      | Type          | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+-------+
| nrsid      | varchar(32)   | YES  |     | NULL    |       |
| locus      | varchar(256)  | YES  |     | NULL    |       |
| definition | varchar(256)  | YES  |     | NULL    |       |
| accession  | varchar(128)  | YES  |     | NULL    |       |
| version    | varchar(128)  | YES  |     | NULL    |       |
| dblink     | varchar(128)  | YES  |     | NULL    |       |
| keyword    | varchar(32)   | YES  |     | NULL    |       |
| source     | varchar(32)   | YES  |     | NULL    |       |
| organism   | varchar(512)  | YES  |     | NULL    |       |
| comments   | varchar(1024) | YES  |     | NULL    |       |
| contig     | varchar(128)  | YES  |     | NULL    |       |
+------------+---------------+------+-----+---------+-------+
	'''

	sql = 'insert into biss_nuccore values (\'' + vo.getId() + '\', \'' + vo.getLocus() + '\', \'' + vo.getDef() + '\', \'' + vo.getAcc() + '\', \'' + vo.getVer() + '\', \'' + vo.getDbl() + '\', \'' + vo.getKw() + '\', \'' + vo.getSrc() + '\', \'' + vo.getOrg() + '\', \'' + vo.getCmt() + '\', \'' + vo.getCtg() + '\');'
	f_open = open( './logs/nuccore_sql.sql', 'a')
	f_open.write(sql)
	print 'Now inserting data into database...'
	try:
		res = MySqlConn.insert_one_by_sql(sql)
		print '\tData inserted into database...'
	except MySQLdb.DataError:
		print '\tData error, cannot save data...'
	return

Пример #4

Файл: ProteinProcessor.py Проект: wangtingbang/biss_py

def save_ref_to_db(vo):
	'''
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| protein_id  | varchar(16)  | YES  |     | NULL    |       |
| residues_no | int(11)      | YES  |     | NULL    |       |
| authors     | varchar(128) | YES  |     | NULL    |       |
| title       | varchar(256) | YES  |     | NULL    |       |
| journal     | varchar(256) | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
	'''
	sql = 'insert into biss_protein_reference values (\'' + vo.getPid() + '\', \'' + vo.getRno() + '\', \'' + vo.getAth() + '\', \'' + vo.getTtl() + '\', \'' + vo.getJur() + '\');'
	f_open = open( './logs/protein_sql.sql', 'a')
	f_open.write(sql)
	print 'Now inserting data into database...\n\t\SQL:\n', sql
	res = MySqlConn.insert_one_by_sql(sql)
	print '\tData inserted into database...'
	return

Пример #5

Файл: ProteinProcessor.py Проект: wangtingbang/biss_py

def save_to_db(vo):
	'''
|item_id          | varchar(16)  | NO   | PRI |         |       |
| locus            | text         | YES  |     | NULL    |       |
| definition       | text         | YES  |     | NULL    |       |
| accession        | varchar(16)  | YES  |     | NULL    |       |
| keywords         | varchar(16)  | YES  |     | NULL    |       |
| version          | varchar(32)  | YES  |     | NULL    |       |
| dbsource         | varchar(32)  | YES  |     | NULL    |       |
| source           | varchar(256) | YES  |     | NULL    |       |
| organism         | text         | YES  |     | NULL    |       |
| comment          | text         | YES  |     | NULL    |       |
| features         | varchar(32)  | YES  |     | NULL    |       |
| features_source  | text         | YES  |     | NULL    |       |
| features_protein | text         | YES  |     | NULL    |       |
| features_cds     | text         | YES  |     | NULL    |       |
| origin      
	
	'''
	'''
	sql = 'insert into biss_protein values (' + vo.getId() + '\', \'' 
		+ vo.getLocus() + '\', \''
		+ vo.getDef() + '\', \'' 
		+ vo.getAcc() + '\', \'' 
		+ vo.getKw() + '\', \'' 
		+ vo.getVer() + '\', \'' 
		+ vo.getDbs() + '\', \'' 
		+ '' + '\', \'' 
		+ vo.getOrg() + '\', \'' 
		+ vo.getCmt() + '\', \'' 
		+ '' + '\', \'' 
		+ '' + '\', \'' 
		+ '' + '\', \'' 
		+ '' + '\', \''	
		+ vo.getOri() + '\');'
	'''
	sql = 'insert into biss_protein values (\'' + vo.getId() + '\', \'' + vo.getLocus() + '\', \'' + vo.getDef() + '\', \'' + vo.getAcc() + '\', \'' + vo.getKw() + '\', \'' + vo.getVer() + '\', \'' + vo.getDbs() + '\', \'' + '' + '\', \'' + vo.getOrg() + '\', \'' + vo.getCmt() + '\', \'' + vo.getFtr() + '\', \'' + vo.getFtrs() + '\', \'' + vo.getFtrp() + '\', \'' + vo.getFtrc() + '\', \'' + vo.getOri() + '\');'
	f_open = open( './logs/protein_sql.sql', 'a')
	f_open.write(sql)
	print 'Now inserting data into database...'
	res = MySqlConn.insert_one_by_sql(sql)
	print '\tData inserted into database...'
	return

Пример #6

Файл: PubmedProcessor.py Проект: wangtingbang/biss_py

def save_ref_to_db(vo):
	'''
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| protein_id  | varchar(16)  | YES  |     | NULL    |       |
| residues_no | int(11)      | YES  |     | NULL    |       |
| authors     | varchar(128) | YES  |     | NULL    |       |
| title       | varchar(256) | YES  |     | NULL    |       |
| journal     | varchar(256) | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
	'''
	sql = 'insert into biss_nuc_ref values (\'' + vo.getNid() + '\', \'' + vo.getRno() + '\', \'' + vo.getAth() + '\', \'' + vo.getTtl() + '\', \'' + vo.getJur() + '\');'
	f_open = open( './logs/clo_ref.sql', 'w')
	f_open.write(sql)
	print 'Now inserting data into database...'
	try:
		print 'SQL:\n',sql
		res = MySqlConn.insert_one_by_sql(sql)
		print '\tData inserted into database...'
	except MySQLdb.DataError:
		print '\tData error, cannot save data...'
	return