error when trying to insert data to sqlite3 table

Question

I am trying to run an sql function that inserts data into a table. I am following the example explained here but whenever i run the script no data is inserted into the table and neither does the script return the message. Here is the code: What can i be possibly be doing wrong?

from flask import render_template, flash, redirect, request
from app import app
from .forms import LoginForm
from .forms import RegistrationForm
import sqlite3 as sql

@app.route('/')
@app.route('/index')


@app.route('/registration', methods = ['GET','POST'])
def registration():
    form = RegistrationForm()

    if request.method == 'POST':
      try:
         card_id = request.form['card_id']
         pin = request.form['pin']
         account_id = request.form['account_id']


         with sql.connect("testDB.db") as con:
            cur = con.cursor()

            cur.execute("INSERT INTO atm_card (card_id,pin,account_id) VALUES (?,?,?,?)",(card_id,pin,account_id) )

            con.commit()
            msg = "Record successfully added"
      except:
         con.rollback()
         msg = "error in insert operation"

      finally:
         return render_template("index.html", msg=msg)
         con.close()

    else:
       return render_template("registration.html", form=form)

Tim Biegeleisen · Accepted Answer · 2017-05-29 05:26:10Z

1

One problem I see, possibly a typo or something else, is that you have four placeholders in the VALUES clause of your INSERT, but you seem to only intend to specify three columns. Change this:

cur.execute("INSERT INTO atm_card (card_id,pin,account_id) VALUES (?,?,?,?)",(card_id,pin,account_id) )

to this:

cur.execute("INSERT INTO atm_card (card_id,pin,account_id) VALUES (?,?,?)",(card_id,pin,account_id) )

answered May 29, 2017 at 5:26

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error when trying to insert data to sqlite3 table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related