title: sqlite3 and python :sqlite3.OperationalError:
body: <blockquote>
    <p>table named excercise</p>
  </blockquote>
  
  <pre><code>CODB_cursor.execute(""" CREATE TABLE excercise (
                      distance INTEGER
                      timeOfRun INTEGER
                      avgHR INTEGER
                      dayOfExcercise timestamp
                      )""")
  
  callOnDB.commit()
  
  </code></pre>
  
  <blockquote>
    <p>function that inserts values to the table named excercise</p>
  </blockquote>
  
  <pre><code>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})
  
  </code></pre>
  
  <blockquote>
    <blockquote>
      <p>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 </p>
    </blockquote>
  </blockquote>
  
  <pre><code>exc_1 = Excercise(4, 120, 154, datetime.datetime.now())
  insert_excercise(exc_1)
  </code></pre>
  
  <p>i keep on getting :::sqlite3.OperationalError: table excercise has 1 columns but 4 values were supplied:::</p>
  
  <p>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)</p>