Hi:
I'm newbie in sqlalchemy. I'm in trouble. the code is:
db = create_engine('sqlite:///test.db')
db.echo = True
metadata = BoundMetaData(db)
flight = Table('test',metadata, ....) # ... means columns
result = select([flight.c.flight_id, flight.c.name]).execute()
# ... read record from result
flight.update(flight.c.flight_id == bindparam('id')).execute({'id':5,
'name':'ok'})
It happens error after run. the error message is:
[ERROR]: SQLError: (OperationalError) database table is locked "UPDATE test SET
name=? WHERE test.flight_id = ?" [0, 5]
Could anyone else tell me why?
Thanks
--tocer
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
