本文整理匯總了Python中pymysql.cursors.Cursor方法的典型用法代碼示例。如果您正苦於以下問題：Python cursors.Cursor方法的具體用法？Python cursors.Cursor怎麽用？Python cursors.Cursor使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類pymysql.cursors的用法示例。
在下文中一共展示了cursors.Cursor方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Python代碼示例。
示例1: test_issue_491
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import Cursor [as 別名]
def test_issue_491(self):
""" Test warning propagation """
conn = pymysql.connect(charset="utf8", **self.databases[0])
with warnings.catch_warnings():
# Ignore all warnings other than pymysql generated ones
warnings.simplefilter("ignore")
warnings.simplefilter("error", category=pymysql.Warning)
# verify for both buffered and unbuffered cursor types
for cursor_class in (cursors.Cursor, cursors.SSCursor):
c = conn.cursor(cursor_class)
try:
c.execute("SELECT CAST('124b' AS SIGNED)")
c.fetchall()
except pymysql.Warning as e:
# Warnings should have errorcode and string message, just like exceptions
self.assertEqual(len(e.args), 2)
self.assertEqual(e.args[0], 1292)
self.assertTrue(isinstance(e.args[1], text_type))
else:
self.fail("Should raise Warning")
finally:
c.close() 示例2: get_xref_protein_gene_rel
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import Cursor [as 別名]
def get_xref_protein_gene_rel(cursor: Cursor, protein: str,
database: str, config: dict, taxon: str) -> str:
select_database(cursor, database)
find_gene_query = \
config['queries']['protein2xref'].format("{}.{}".format(taxon, protein))
cursor.execute(find_gene_query)
query_res = cursor.fetchall()
if len(query_res) > 1:
logger.warn("Ambiguous protein to gene "
"mapping for {} {}".format(protein, query_res))
gene = None
elif len(query_res) == 0:
logger.warn("No mapping for {}".format(protein))
gene = None
else:
gene = query_res[0][1]
return gene 示例3: select_database
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import Cursor [as 別名]
def select_database(cursor: Cursor, database: str) -> None:
query = "USE {};".format(database)
cursor.execute(query) 示例4: get_deprecated_protein_gene_rel
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import Cursor [as 別名]
def get_deprecated_protein_gene_rel(cursor: Cursor, protein: str,
database: str, config: dict) -> str:
select_database(cursor, database)
find_db_query = config['queries']['id_mapping'].format(protein)
cursor.execute(find_db_query)
old_db = cursor.fetchall()
try:
select_database(cursor, old_db[0][0])
except pymysql.err.InternalError:
return ''
except IndexError:
return ''
find_gene_query = config['queries']['protein2gene'].format(protein)
try:
cursor.execute(find_gene_query)
except pymysql.err.ProgrammingError:
find_gene_query = config['queries']['p2g_two'].format(protein)
cursor.execute(find_gene_query)
query_res = cursor.fetchall()
if len(query_res) > 1:
raise ValueError("Ambiguous protein to gene "
"mapping for {} {}".format(protein, query_res))
elif len(query_res) == 0:
raise ValueError("No mapping for protein {}".format(protein))
return query_res[0][0]