Error when inserting rows into SQLite with Python

Question

Getting an error when trying to insert a row into SQLite table from Python.

The relevant code;

sql = '''INSERT INTO scr(scr=?, close_date=?, vendor=?, application=?, dev=?, tester=?, release=?)''', (issueId, closeDate, vendor, application, assignedDev, assignedTester, enterpriseRelease)
try:
    cursor.execute(sql)
    db.commit()
except Exception, err:
    print("\nFailed to insert row into table scr:\n" + str(sql))
    print(Exception, err)

and the error returned:

Failed to insert row into table scr:
('INSERT INTO scr(scr=?, close_date=?, vendor=?, application=?, dev=?, tester=?, release=?)', ('236500', '0', 'Database', 'Starbase Deleted', 'john.doe', 'jane.doe', 'None'))
(<type 'exceptions.Exception'>, ValueError('operation parameter must be str or unicode',))

Medhat Gayed · Accepted Answer · 2014-06-03 20:10:11Z

2

Your sql statement is not right, try this:

sql = '''INSERT INTO scr(scr, close_date, vendor, application, dev, tester, release) VALUES (?, ?, ?, ?, ?, ?, ?)'''
params = (issueId, closeDate, vendor, application, assignedDev, assignedTester, enterpriseRelease)

try:
    cursor.execute(sql, params)
    db.commit()
except Exception as err:
    print("\nFailed to insert row into table scr:\n" + str(sql))
    print(Exception, err)

answered Jun 3, 2014 at 20:10

Medhat Gayed

2,84324 silver badges13 bronze badges

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

1 Comment

Radamand Over a year ago

result after making changes:

Failed to insert row into table scr: ('INSERT INTO scr(scr, close_date, vendor, application, dev, tester, release)',) (<type 'exceptions.Exception'>, ValueError('operation parameter must be str or unicode',))

Collectives™ on Stack Overflow

Error when inserting rows into SQLite with Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related