DB insert with no values doesn't work with mysql about webpy HOT 6 CLOSED

Found a workaround when there is an auto-incrementing column in the table. Instead of just insert('table') you do:

my_id = db.insert('table', id=web.db.SQLLiteral('NULL'))

This works in MySQL and SQLite.

from webpy.

What SQL does that result in?

from webpy.

In [8]: db.insert('table', id=web.db.SQLLiteral('NULL'), _test=True)
Out[8]: <sql: 'INSERT INTO table (id) VALUES (NULL)'>

Obviously this will only work if the id column has been set to something like id integer primary key auto_increment (mysql) or id integer primary key (sqlite).

from webpy.

Yeah, don't think we want to count on that. I think just crashing is safer if the SQL engine doesn't support default values.

from webpy.

Uhm. MySQL does support default values, it just uses a different syntax:
INSERT INTO tbl_name () VALUES();

I was just searching for a solution that would work for both Sqlite and MySQL. Maybe the MySQL specific subclass in web.py could honor the MySQL syntax.

from webpy.

Thanks :)

from webpy.