sqlite3 python generate tables

Question

I am trying to generate tables based off the paramaters of a function. To generate the table I thought of passing a string of what I wanted to be executed as the following function:

conn = sqlite3.connect('tutorial.db')

c = conn.cursor()

def create_table(name, unix, datestamp, keyword, value):

    command = "CREATE TABLE IF NOT EXISTS " + name + "(" + unix + " REAL, " + datestamp + " TEXT, " + keyword + " TEXT, " + value + " REAL)"

    c.execute('CREATE TABLE' + command)

However when I run the command:

create_table('new','boy','girl','joy','joe')

I get error: Traceback (most recent call last): File "C:\Users\David\Documents\learn_sql_\learn_sql.py", line 22, in create_table('new','boy','girl','joy','joe') File "C:\Users\David\Documents\learn_sql_\learn_sql.py", line 12, in create_table c.execute('CREATE TABLE' + command) sqlite3.OperationalError: near "TABLECREATE": syntax error

Thoughts?

Thanks

Replace temporarily your "c.execute" with "print" to see what you are sending to Sqlite. — Michael Butscher
– Michael Butscher, Commented Nov 28, 2019 at 2:44

GiovaniSalazar · Accepted Answer · 2019-11-28 02:54:01Z

0

try with this :

import sqlite3

conn = sqlite3.connect('tutorial.db')

c = conn.cursor()

def create_table(name, unix, datestamp, keyword, value):

    #c.execute('CREATE TABLE' + command)
    cmd = "CREATE TABLE IF NOT EXISTS %s(%s real,%s text,%s text,%s real)" % (name,unix,datestamp,keyword,value)
    print(cmd)
    c.execute(cmd)

create_table('new','boy','girl','joy','joe')

answered Nov 28, 2019 at 2:54

GiovaniSalazar

2,1042 gold badges11 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

sqlite3 python generate tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related