OK. I found the problem, but it's not exactly what I'd expect.
Apparently, to take a path from the root for an sqlite file you need
*four* slashes.
sqlite:////tmp/foo.db
It's nice being able to do relative paths (something that SQLObject's
URIs don't let you do), but 4 slashes just seems excessive :)
On 6/29/06, Kevin Dangoor <[EMAIL PROTECTED]> wrote:
> I'm having some trouble making a new sqlite database. I can create
> in-memory databases just fine, but I can't seem to create one on disk.
> I am certain that I have permissions to the file i'm trying to create.
>
> Unfortunately, the error and the code don't give me anything to work
> with for troubleshooting. The failure occurs in a lambda, and I have
> no way of knowing what the options were (short of modifying sqlalchemy
> itself).
>
> I just installed the latest versions of pysqlite (2.3.1) and sqlite (3.3.6)
>
> >>> from sqlalchemy import *
> >>> e = create_engine("sqlite:///tmp/hithere.db")
> >>> e.connect()
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> File
> "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/engine/base.py",
> line 470, in connect
> File
> "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/engine/base.py",
> line 177, in __init__
> File
> "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/engine/base.py",
> line 493, in raw_connection
> File
> "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/engine/default.py",
> line 34, in get_connection
> File "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/pool.py",
> line 85, in connect
> File "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/pool.py",
> line 135, in __init__
> File "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/pool.py",
> line 110, in get
> File "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/pool.py",
> line 204, in do_get
> File
> "build/bdist.darwin-8.6.0-Power_Macintosh/egg/sqlalchemy/engine/default.py",
> line 27, in <lambda>
> pysqlite2.dbapi2.OperationalError: unable to open database file
> >>> e = create_engine("sqlite:///:memory:")
> >>> e.connect()
> <sqlalchemy.engine.base.Connection object at 0x555450>
>
--
Kevin Dangoor
TurboGears / Zesty News
email: [EMAIL PROTECTED]
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
