Hi !
I've been looking into the documentation but could not find it.
What is the proper way to insert a DEFAULT keywork in the tuples of the
VALUES clause in an INSERT statement ? As in
CREATE TABLE number (
i INTEGER,
letters STRING,
roman STRING DEFAULT '',
) ;
INSERT INTO number (c1, c2, c3) VALUES (1, 'one', 'I'), (1000000, 'one
million', DEFAULT) ; -- NOTE THE DEFAULT HERE
(yes this example is silly)
The best I came up with, is using the `literal_column('DEFAULT', type_=...)`
construct.
I wondered if there is a better way, cause I was worried about the keyword
possibly getting quoted at some point, though I am not 100% sure that could
happen.
Thanks in advance !
Regards,
Nicolas.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/9c133c97-a5c6-4863-8f40-d8174949f4d7%40googlegroups.com.
