Sqlite3 & Python creating tables

Question

I'm trying to use the scrapy pipeline to store its data in a sqlite3 database here is the little part that trows a OperationalError: near "Transaction": syntax error

def createResidentialTable(self):
    self.cur.execute("""CREATE TABLE IF NOT EXISTS Residential
        (Id INT PRIMARY KEY NOT NULL, Transaction TEXT, Location TEXT, Price REAL)""")

My debugging so far, if i remove the Transaction TEXT & Location TEXT & Price Real from the creating tables my spider runs again. So i'm assuming there is something wrong with my listing of the tables.

Have looked trough some code examples and the official sqlite3 documentation and they list it as followed :

Create table

c.execute('''CREATE TABLE stocks
             (date text, trans text, symbol text, qty real, price real)''')

Any thoughts or suggestions?

z3ntu · Accepted Answer · 2016-07-31 10:31:34Z

1

Transaction is a reserved keyword which you are not allowed to use as an identifier. Just use something other than Transaction as an identifier.

answered Jul 31, 2016 at 10:31

z3ntu

1907 silver badges20 bronze badges

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

1 Comment

Kevin G Over a year ago

Thank you this has been haunting me for a few days now :)

Collectives™ on Stack Overflow

Sqlite3 & Python creating tables

Create table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Create table

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related