sql INSERT in python (postgres, cursor, execute)

Question

I had no problem with SELECTing data in python from postgres database using cursor/execute. Just changed the sql to INSERT a row but nothing is inserted to DB. Can anyone let me know what should be modified? A little confused because everything is the same except for the sql statement.

<!-- language: python -->
@app.route("/addcontact")
def addcontact():

    # this connection/cursor setting showed no problem so far
    conn = pg.connect(conn_str)
    cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)

    sql = f"INSERT INTO jna (sid, phone, email) VALUES ('123','123','123')"
    cur.execute(sql) 
    return redirect("/contacts")

Could u please try: sql = f"INSERT INTO jna (\"sid\", \"phone\", \"email\") VALUES ('123','123','123') — Eray Balkanli, Nov 11 '18 at 16:14
@ErayBalkanli Thanks for the comment, but that didn't work either.. — PuffedRiceCrackers, Nov 11 '18 at 16:19
ok. Can you please try adding conn.commit() after the execute(sql) line? — Eray Balkanli, Nov 11 '18 at 16:21

score 2 · Answer 1 · answered Nov 11 '18 at 16:21

first look at your table setup and make sure your variables are named right in the right order, format and all that, if your not logging into the specific database on the sql server it won't know where the table is, you might need to send something like 'USE databasename' before you do your insert statement so your computer is in the right place in the server.

I might not be up to date with the language but is that 'f' supposed to be right before the quotes? if thats in ur code that'd probably throw an error unless it has a use im not aware of or its not relevant to the problem.

score 1 · Accepted Answer · answered Nov 11 '18 at 16:31

1

You have to commit your transaction by adding the line below after execute(sql)

conn.commit()

Ref: Using INSERT with a PostgreSQL Database using Python

answered Nov 11 '18 at 16:31

Eray Balkanli

7,752
11
48
82

sql INSERT in python (postgres, cursor, execute)

2 Answers2