Re: [sqlalchemy] Re: Can't connect to SQLite databases

2011-10-22 Thread Michael Bayer
what happens if you say: import sqlite3 import os sqlite3.connect(os.path.abspath("test.db")) ? thats essentially what SQLA 0.7 does in order to guard against os.chdir() changes as subsequent connections occur. On Oct 22, 2011, at 11:28 AM, jmsilva wrote: > On Oct 22, 2:18 pm, Michael Ba

[sqlalchemy] Re: Can't connect to SQLite databases

2011-10-22 Thread jmsilva
On Oct 22, 2:18 pm, Michael Bayer wrote: > strange.  what happens if you examine the "test.db" file more closely, is it > created with odd permissions (like not readable or something strange ?)   is > there a filesystem problem, can you reproduce this issue on any workstation > /environment ?  

Re: [sqlalchemy] Can't connect to SQLite databases

2011-10-22 Thread Michael Bayer
strange. what happens if you examine the "test.db" file more closely, is it created with odd permissions (like not readable or something strange ?) is there a filesystem problem, can you reproduce this issue on any workstation /environment ? the test case obviously works fine for me. The

[sqlalchemy] Can't connect to SQLite databases

2011-10-22 Thread João Silva
Hello everyone, I'm having a problem connecting to SQLite database files with SQLAlchemy. :memory: databases work just fine, but whenever I'm trying to access a file, the following happens: Python 2.7.2 (default, Jun 12 2011, 14:24:46) [MSC v.1500 64 bit (AMD64)] on win 32 Type "help", "co

Re: [sqlalchemy] Share uncommitted state between differing connections

2011-10-22 Thread Denis Krienbühl
2011/10/22 Michael Bayer : > A single object can only be linked to one Session at a time.  You can > transfer state to another while leaving the original unaffected using > Session.merge().  If the objects themselves are persistent (i.e. have an id) > and are clean (i.e have been flushed, no pe