本文整理匯總了Python中pymysql.cursors.SSCursor方法的典型用法代碼示例。如果您正苦於以下問題：Python cursors.SSCursor方法的具體用法？Python cursors.SSCursor怎麽用？Python cursors.SSCursor使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類pymysql.cursors的用法示例。
在下文中一共展示了cursors.SSCursor方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Python代碼示例。
示例1: test_unbuffered_load_file
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import SSCursor [as 別名]
def test_unbuffered_load_file(self):
"""Test unbuffered load local infile with a valid file"""
conn = self.connections[0]
c = conn.cursor(cursors.SSCursor)
c.execute("CREATE TABLE test_load_local (a INTEGER, b INTEGER)")
filename = os.path.join(os.path.dirname(os.path.realpath(__file__)),
'data',
'load_local_data.txt')
try:
c.execute(
("LOAD DATA LOCAL INFILE '{0}' INTO TABLE " +
"test_load_local FIELDS TERMINATED BY ','").format(filename)
)
c.execute("SELECT COUNT(*) FROM test_load_local")
self.assertEqual(22749, c.fetchone()[0])
finally:
c.close()
conn.close()
conn.connect()
c = conn.cursor()
c.execute("DROP TABLE test_load_local") 示例2: test_issue_491
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import SSCursor [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() 示例3: test_unbuffered_load_file
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import SSCursor [as 別名]
def test_unbuffered_load_file(self):
"""Test unbuffered load local infile with a valid file"""
conn = self.connect()
c = conn.cursor(cursors.SSCursor)
c.execute("CREATE TABLE test_load_local (a INTEGER, b INTEGER)")
filename = os.path.join(os.path.dirname(os.path.realpath(__file__)),
'data',
'load_local_data.txt')
try:
c.execute(
("LOAD DATA LOCAL INFILE '{0}' INTO TABLE " +
"test_load_local FIELDS TERMINATED BY ','").format(filename)
)
c.execute("SELECT COUNT(*) FROM test_load_local")
self.assertEqual(22749, c.fetchone()[0])
finally:
c.close()
conn.close()
conn.connect()
c = conn.cursor()
c.execute("DROP TABLE test_load_local") 示例4: __init__
# 需要導入模塊: from pymysql import cursors [as 別名]
# 或者: from pymysql.cursors import SSCursor [as 別名]
def __init__(self, stream=False, **kw): # MySQLdb.cursors.SSCursor 流式遊標
if stream == True:
self._connect = pymysql.connect(cursorclass = cursors.SSCursor, **kw)
else:
self._connect = pymysql.connect(**kw)