I need help creating tables with Sqlite3

[Rius2]

I wish to make a function that creates tables from a tablename list i provide

import sqlite3


def creat_tables():
    conn = sqlite3.connect('listatest.db')
    c = conn.cursor()
    
    tablelist = ('unu','doi','trei')

    for tablename in tablelist:

        create = 'CREATE TABLE IF NOT EXISTS ' + tablename + ' (numar_par INTEGER PRIMARY KEY, echipa1 TEXT UNIQUE, scor1 TEXT, scor2 TEXT, echipa2 TEXT, '
        'cota FLOAT, miza INT, stare INT)'
        c.execute(create)

I get this error

Error:
"C:\Program Files\Python36\python.exe" "D:/pariuri/python/teste sqlite/TutorialSqlite.py"
Traceback (most recent call last):
  File "D:/pariuri/python/teste sqlite/TutorialSqlite.py", line 6, in <module>
    creat_tables()
  File "D:\pariuri\python\teste sqlite\create_tables.py", line 17, in creat_tables
    c.execute(create)
sqlite3.OperationalError: near " ": syntax error

Process finished with exit code 1

[nilamo]

Does it fail for the first table, or the second?
Have you tried adding a semicolon to the end of the statement, to let sqlite know it's the end of the statement?  I don't know a lot about sqlite, but it could just be batching all the execute statements together, and actually executing them at the same time when the transaction commits (... which might be when the cursor falls out of scope).

Add a call to print with the sql statement just before calling execute, so we can see if it fails the first time around, or the second.

[buran]

Note that your SQL statement is divided on two lines -12 and 13. You have ' at the end of line 12 and rest is orphan string on line 13

[Rius2]

Note that your SQL statement is divided on two lines -12 and 13. You have ' at the end of line 12 and rest is orphan string on line 13

I did put a print in front of execute as nimalo suggested, and made line 12 and 13 in one line, and this did the job, which is interesting as that is how Pycharm is formating a line that is too long if i just copy/paste it into the interpreter.

Thanks you.