问题描述
我正在使用以下方法尝试将记录插入到 postgresql 数据库表中,但它不起作用.我没有收到任何错误,但表中没有记录.我需要提交还是什么?我正在使用通过 Bitnami djangostack 安装的 postgresql 数据库.
I'm using the following to try and insert a record into a postgresql database table, but it's not working. I don't get any errors, but there are no records in the table. Do I need a commit or something? I'm using the postgresql database that was installed with the Bitnami djangostack install.
import psycopg2 try: conn = psycopg2.connect("dbname='djangostack' user='bitnami' host='localhost' password='password'") except: print "Cannot connect to db" cur = conn.cursor() try: cur.execute("""insert into cnet values ('r', 's', 'e', 'c', 'w', 's', 'i', 'd', 't')""") except: print "Cannot insert"
推荐答案
如果不想每条记录都提交到数据库,可以添加以下行:
If don't want to have to commit each entry to the database, you can add the following line:
conn.autocommit = True
所以你得到的代码是:
import psycopg2 try: conn = psycopg2.connect("dbname='djangostack' user='bitnami' host='localhost' password='password'") conn.autocommit = True except: print "Cannot connect to db" cur = conn.cursor() try: cur.execute("""insert into cnet values ('r', 's', 'e', 'c', 'w', 's', 'i', 'd', 't')""") except: print "Cannot insert"