How to "format" column names and types into python sqlite3?

Question

I have a function that I want to use when mass creating tables.
This is the function:

def make_tables(tablenames: list, cursor: sql.Cursor, parameters, connection: sql.Connection):
    for i in tablenames:
        cursor.execute(f"CREATE TABLE IF NOT EXISTS '{scrub(i)}' ('{parameters}')")
    connection.commit()

My parameters variable is parameters = 'name text, id integer' what it does, is create a table with one column, called 'name text, id integer' and type unknown.
The solutions from here: Python sqlite3, create table columns from a list with help of .format don't work. I will have different names and types as input, and the number of columns will vary.
What ways are there to solving this problem?

Don't put quotes around {parameters}. That's making it a single string, not parsing it as separate parameters. — Barmar
– Barmar, Commented Nov 3, 2020 at 0:44
I voted to close this question as a simple typo, it's not worth answering. — Barmar
– Barmar, Commented Nov 3, 2020 at 0:51

Barmar · Accepted Answer · 2020-11-03 00:56:54Z

1

Don't put quotes around {parameters}, that turns it into a single parameter definition.

        cursor.execute(f"CREATE TABLE IF NOT EXISTS '{scrub(i)}' ({parameters})")

answered Nov 3, 2020 at 0:56

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

How to "format" column names and types into python sqlite3?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related