Hello,
I am trying to insert rows into a sqlite database, and am getting the
error: SQL logic error or missing database. This only happens with
inserts, not selects, which are working fine.
I am not sure how to debug this one. The insert command I have is:
web.insert('comments',who=user._id_,
comment=comment,
filename=pic.filename,
family_id=pic.family_id,
person_id=pic.person_id,
created=datetime.now(),
picture=pic._id_)
where all of the data is correct, and of the correct type, as far as
I can tell. I am loading the database with:
web.config.db_parameters = dict(dbn='sqlite',
db='family_database.db')
right before the web.run() command. for what its worth, the
standalone code below works. I know that it is finding the database,
because the selects right before then are working. Is there
something I am missing?
thanks,
Brian Blais
from datetime import date,datetime
import sys
import web
if __name__ == "__main__":
web.connect(dbn='sqlite', db='family_database.db')
commentsdb = web.select('comments')
comments=[x for x in commentsdb]
print "comments: ",comments
userdb = web.select('users')
users=[x for x in userdb]
print "users: ",users
sys.stdout.flush()
web.insert('comments',who=1,
comment='this is a test',
filename='filename here',
family_id=0,
person_id=0,
created=datetime.now(),
picture=1)
commentsdb = web.select('comments')
comments=[x for x in commentsdb]
print comments
sys.stdout.flush()
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
