I encounter an error when using the SQLITE3 module

Question

I am attempting to use SQL in order to make a table currently I have created this

import sqlite3
conn = sqlite3.connect("Classes.db")
c = conn.cursor()
score = 5
name = ("Brad")
Class = 2
def tableCreate():
    c.execute("CREATE TABLE Class{}(ID INT, Name TEXT, Score (Out of 10) INT").format(Class)
def dataEntry():
    c.execute("INSERT INTO Class{} (Name, Score) VALUES (?,?)",
        (score,name)).format(Class)
    conn.commit()

When I run the tableCreate function it returns the error:

Traceback (most recent call last):
  File "<pyshell#0>", line 1, in <module>
    tableCreate()
c.execute("CREATE TABLE Class{}(ID INT, Name TEXT, Score (Out of 10)INT").format(Class)
sqlite3.OperationalError: unrecognized token: "{"

I would appreciate any help in resolving this error

pls do this : c = conn.cursor()

Oni1
– Oni1

2015-03-12 11:53:37 +00:00
Commented Mar 12, 2015 at 11:53 — Oni1
– Oni1, Commented Mar 12, 2015 at 11:53

Community · Accepted Answer · 2017-05-23 11:56:51Z

2

You should replace

c = conn.cursor

with

c = conn.cursor()

in order to do queries with the cursor object. All that c = conn.cursor allows you to do is create a database. If you're confused about the difference between a regular db cursor and one used for queries, this answer (and question) may help you make the distinction.

Edit:
For your second problem you have a parentheses issue, and the execute line should be enclosed properly, like this:

c.execute("CREATE TABLE Class{}(ID INT, Name TEXT, Score (Out of 10) INT".format(Class))

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Mar 12, 2015 at 11:54

HavelTheGreat

3,3862 gold badges18 silver badges35 bronze badges

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

4 Comments

Bradley Ridgway Over a year ago

After fixing this I now also receive a new error as shown above

HavelTheGreat Over a year ago

@BradleyRidgway Then instead of editing your question for your new error (commonly known as being a "help vampire") it would probably be in your best interest to maintain the current integrity of your question, investigate your new problem, and if you are completely incapable of solving it then posting another new question.

Bradley Ridgway Over a year ago

I don't see anything wrong with being a "Help Vampire" if that is ultimately the purpose of the site.

HavelTheGreat Over a year ago

@BradleyRidgway It really isn't the purpose of this site. I'm not here to debug your code, I'm here to help you figure out a specific issue with your code should you be incredibly stuck on it. Ultimately questions should provide value to other users that may come across them. If you edit your quesiton continuously with your "new error", all it does is confuse anyone who sees your question. For your information however, you have a brace issue, c.execute("CREATE TABLE Class{}(ID INT, Name TEXT, Score (Out of 10) INT".format(Class))

user1016274 · Accepted Answer · 2015-03-12 12:10:04Z

0

The format method is a method of the string object, i.e. you put the closing bracket too early:

c.execute("CREATE TABLE Class{}(ID INT, Name TEXT, Score (Out of 10) INT").format(Class)

should read

c.execute("CREATE TABLE Class{}(ID INT, Name TEXT, Score (Out of 10) INT".format(Class))

answered Mar 12, 2015 at 12:10

user1016274

4,2992 gold badges25 silver badges20 bronze badges

Collectives™ on Stack Overflow

I encounter an error when using the SQLITE3 module

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related