Revision: 27972
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at June 28, 2010 19:24 by MartinJanda
Initial Code
Once the database is defined as such, performing insert can be performed like this:
# Insert an entry into table 'mytable'
sequence_id = db.insert('mytable', firstname="Bob",lastname="Smith",joindate=web.SQLLiteral("NOW()"))
The insert statement takes the following keyword arguments:
tablename seqname
_test
**values
tablename
The name of the table in your database to which you would like to add data to.
seqname
An optional argument, the default value is None. Set seqname to the ID if it's not the default, or to False.
_test
The _test variable lets you see the SQL produced by the statement:
results = db.select('mytable', offset=10, _test=True)
><sql: 'SELECT * FROM mytable OFFSET 10'>
**values
A set of named arguments that represent the fields in your table. If values are not given, the database may create default values or issue a warning.
Initial URL
http://webpy.org/cookbook/insert
Initial Description
Initial Title
web.py db insert
Initial Tags
python
Initial Language
Python