On 18/04/2006, at 14:39, Nikolai Prokoschenko wrote: > I'm having a curious problem with TurboGears on Windows (I've snatched > the newest alpha). I've created my model and have done "tg-admin sql > create". An appropriate "file.db" (SQLite) has been created with a > right schema. However, if I try to create a first SQLObject like in > the > Wiki20 tutorial, it is created normally, but the file is not updated. > Instead, a new file named "file.db-journal" is created, which > presumably caches or journals all the changes. Needless to say, the > data is not available either through TG or through sqlite3 on the > command line.
You might need to commit the transaction: (in tg-admin shell) hub.commit() Transactions in the shell are not automatically committed (so you can do tests without altering the real data if necessary). > I've also had some problems deleting the database when I > tried to start over - Windows has told me the file is in use by > another > process. This is normal if using sqlite. AFAIK, sqlite holds a lock on the db when used so no concurrent processes can access it. This should be no problem if using postgresql, mysql or any other "real" database ;) HTH Alberto --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears -~----------~----~----~----~------~----~------~--~---
