it means some other process has already opened the database file (and
probably opened a transaction).
On Nov 14, 2006, at 4:40 AM, tocer wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
