ansaurus

Question

How do I get around not being able to parse a table name into a python sqlite query?

Answer 1

+1 A:

Right. You can not use parameter substitution to specify the table. So instead you must do string manipulation:

c.execute("SELECT * FROM {t} ".format(t=tablename))

unutbu 2010-10-28 15:42:26

Answer 2

+1 A:

I don't know if this is a python3 thing but it seems easiest to just do this:

c.execute("SELECT * FROM %s "% tablename)

Joshkunz 2010-10-28 16:35:13

No it is a sqlite thing, and it is pretty typical for most db interfaces. Query parameters are usually just for plugging in in place of literal values, in INSERT or WHERE clauses, not for table or column references.

Paul McGuire 2010-10-28 19:14:33

By python3 I means I'm using python version 3. I specidfied because the syntax is a little different from version 2.

Higbasa 2010-10-29 00:31:47

Paul is right though, which is why i'm looking for an alternate course of action. so far all I have come up with is a nested if statment each with its own sqlite query.

Higbasa 2010-10-29 00:33:42

The problem I have with this however is I wanted my app to be more dynamic and allow me to continue adding databases without having to modify the python code every time. Any insight would be appreciated.

Higbasa 2010-10-29 00:35:03

add more tables, not databases :s

Higbasa 2010-10-29 00:37:22

Answer 3

A:

Blockquote * Right. You can not use parameter substitution to specify the table. So instead you must do string manipulation: c.execute("SELECT * FROM {t} ".format(t=tablename))* Blockquote

Thanks unutbu, this is just what I needed.

Higbasa 2010-10-29 05:00:11

You might want to accept his answer by clicking the check underneath it. That way he'll get the credit.

Joshkunz 2010-10-29 06:51:09

ansaurus

tags:

views:

answers:

How do I get around not being able to parse a table name into a python sqlite query?

related questions