Using parameters in a CREATE TABLE ... (column DEFAULT ?) clause, in Python sqlite3 db-api

Question

I want to use python to execute a CREATE STATEMENT clause, specifying default values for certain columns using parameter substitution with ? (so that I can safely specify defaults from python types).

It doesn't appear to work, although it works fine when I use parametric statements in a select or similar statement. For example:

As expected:

>>> list(sqlite3.connect('sensemap.sql3').cursor().execute('select ?', (101,)))
[(101,)]

Unexpected:

>>> sqlite3.connect('sensemap.sql3').cursor().execute('create table mytable (mycolumn default ?)', (101,))
Traceback (most recent call last):
  File "<console>", line 1, in <module>
OperationalError: near "?": syntax error

Why is that? Is what I'm attempting possible?

CL. · Accepted Answer · 2014-04-14 09:12:21Z

1

The original SQL statements of all your schema objects are stored in the database (try SELECT sql FROM sqlite_master). With such a simple text value, it is not possible to remember parameter values, so parameters are not allowed in CREATE xxx statements.

answered Apr 14, 2014 at 9:12

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Using parameters in a CREATE TABLE ... (column DEFAULT ?) clause, in Python sqlite3 db-api

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