sqlite3 and python :sqlite3.OperationalError:

Question

table named excercise

CODB_cursor.execute(""" CREATE TABLE excercise (
                    distance INTEGER
                    timeOfRun INTEGER
                    avgHR INTEGER
                    dayOfExcercise timestamp
                    )""")

callOnDB.commit()

function that inserts values to the table named excercise

def insert_excercise(exc):
    with callOnDB:
        CODB_cursor.execute("INSERT INTO excercise VALUES(:distance,:timeOfRun,:avgHR,:dayOfExcercise)",
                            {'distance':exc.distance,'timeOfRun':exc.timeOfRun,
                            'avgHR':exc.avgHR,'dayOfExcercise':exc.dayOfExcercise})

in a different file named excercise there is a class named Excercise with self, distance, timeOfRun, avgHR, dayOfExcercise. exc_1 is passed to insert_excercise function

exc_1 = Excercise(4, 120, 154, datetime.datetime.now())
insert_excercise(exc_1)

i keep on getting :::sqlite3.OperationalError: table excercise has 1 columns but 4 values were supplied:::

i don't know why , i have 4 columns named (distance, timeOfRun, avgHR, dayOfExcercise) i have import sqlite3, import datetime, and from excercise import Excercise (this refers to the other file that has the class excercise)

DinoCoderSaurus · Accepted Answer · 2020-04-19 20:43:01Z

1

This is creating one column!

CREATE TABLE excercise (
                    distance INTEGER
                    timeOfRun INTEGER
                    avgHR INTEGER
                    dayOfExcercise timestamp
                    )

Syntax requires a , between column definitions eg (col1 TYPE, col2 TYPE, col3 TYPE....)

answered Apr 19, 2020 at 20:43

DinoCoderSaurus

6,5402 gold badges12 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

sqlite3 and python :sqlite3.OperationalError:

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related