python mysql callproc_python – pymysql callproc()似乎会影响后续选...

我有一个类似的问题(未提交)INSERT语句没有出现在数据库中. PyMySQL0.5fürPython3.2和MySQL Community Server 5.5.19.

我为我找到了解决方案：我使用executemany方法而不是使用execute()方法,在模块参考中解释

http://code.google.com/p/pymssql/wiki/PymssqlModuleReference

还有一个示例链接.

更新

不久之后,今天,我发现这还不是完整的解决方案.

python脚本末尾的exit()太快会使数据在数据库中丢失.

所以,我在关闭连接之前和exit()脚本之前添加了time.sleep(),最后出现了所有数据！

(我也转而使用myisam表)

import pymysql

conn = pymysql.connect(host='localhost', user='root', passwd='', db='mydb', charset='utf8')

conn.autocommit(True)

cur = conn.cursor()

# CREATE tables (SQL statements generated by MySQL workbench, and exported with Menu -> Database -> Forward Engineer)

cur.execute("""

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

DROP SCHEMA IF EXISTS `mydb` ;

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

USE `mydb` ;

# […]

SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

""")

# Fill lookup tables:

cur.executemany("insert into mydb.number(tagname,name,shortform) values (%s, %s, %s)", [('ЕД','singular','sg'), ('МН','plural','p')] )

cur.executemany("insert into mydb.person(tagname,name,shortform) values (%s, %s, %s)", [('1-Л','first','1st'), ('2-Л','second','2nd'), ('3-Л','third','3rd')] )

cur.executemany("insert into mydb.pos(tagname,name,shortform) values (%s, %s, %s)", [('S','noun','s'), ('A','adjective','a'), ('ADV','adverb','adv'), ('NUM','numeral','num'), ('PR','preposition','pr'), ('COM','composite','com'), ('CONJ','conjunction','conj'), ('PART','particle','part'), ('P','word-clause','p'), ('INTJ','interjection','intj'), ('NID','foreign-named-entity','nid'), ('V','verb','v')] )

#[…]

import time

time.sleep(3)

cur.close()

conn.close()

time.sleep(3)

exit()