I have a database table shown below: db=DAL("sqlite://storage.sqlite")
db.define_table('content', Field('author'), Field('time', 'datetime', update=request.now), Field('text', 'text'), Field('picture', readable=False), Question is, how do I connect to the database via a script, and what is the syntax for inserting data into a web2py database table via a script? I want to know this because I'll be looping through a list and inserting data from the list to the database as I loop through... --