On Mon, Feb 10, 2014 at 10:15 PM, Slide <[email protected]> wrote: > That seems a little odd. Perhaps Jeff can shed some light on it, I think he > wrote the SQLite adaptation layer.
I did, but the funny code is part of the C#-sqlite library, which is a port of the C library to C#. (if you're feeling brave, dig through the code. It's ... interesting.) It looks like the author just assumed Windows-ish systems in all cases, and Doug has to go and break everything by trying to run it on Unix. :( I have no idea what that code is trying to do (context: https://github.com/IronLanguages/main/blob/master/Languages/IronPython/IronPython.SQLite/c%23sqlite/os_win_c.cs#L2646); it might be some vestigial part of SQLite that's not needed. Since // seems OK I'm assuming that's the case. Doug, can you open an issue? And in the meantime, is using // an acceptable workaround? - Jeff > > > On Mon, Feb 10, 2014 at 3:14 PM, Doug Blank <[email protected]> wrote: >> >> That must be the issue, as "//home/dblank/name.db" works: >> >> $ ipy.exe >> IronPython 2.9.9a0 DEBUG (2.9.0.0) on Mono 4.0.30319.1 (64-bit) >> Type "help", "copyright", "credits" or "license" for more information. >> >>> import sqlite3 >> >>> sqlite3.connect("//home/dblank/test.db") >> <Connection object at 0x000000000000002B> >> >>> >> >> -Doug >> >> >> >> On Mon, Feb 10, 2014 at 5:12 PM, Doug Blank <[email protected]> wrote: >>> >>> After more testing, it appears that it only fails when the path begins >>> with a slash "/". >>> >>> I see: >>> >>> ./c#sqlite/os_win_c.cs: if ( zConverted.StartsWith( "/" ) && >>> !zConverted.StartsWith( "//" >>> >>> I'll try a couple of more things... >>> >>> -Doug >>> >>> >>> On Mon, Feb 10, 2014 at 9:19 AM, Doug Blank <[email protected]> wrote: >>>> >>>> >>>> On Mon, Feb 10, 2014 at 8:47 AM, Slide <[email protected]> wrote: >>>>> >>>>> All the connect call does is this: >>>>> >>>>> int rc = Sqlite3.sqlite3_open(database, out this.db); >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> if(rc != Sqlite3.SQLITE_OK) >>>>> throw GetSqliteError(this.db, null); >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Which makes me thing that sqlite3_open is returning an error code. What >>>>> happens if you do the same in CPython? >>>> >>>> >>>> No error, creates a file of length 0, and works: >>>> >>>> $ python >>>> Python 2.7.5+ (default, Sep 19 2013, 13:48:49) >>>> [GCC 4.8.1] on linux2 >>>> Type "help", "copyright", "credits" or "license" for more information. >>>> >>> import sqlite3 >>>> >>> sqlite3.connect("/home/dblank/test.db") >>>> <sqlite3.Connection object at 0x7fc3c21b6118> >>>> >>> >>>> >>>> $ ls -al /home/dblank/test.db >>>> -rw-r--r-- 1 dblank dblank 0 Feb 10 09:15 /home/dblank/test.db >>>> >>>> -Doug >>>> >>>> >>>>> >>>>> >>>>> >>>>> On Fri, Feb 7, 2014 at 6:01 AM, Doug Blank <[email protected]> >>>>> wrote: >>>>>> >>>>>> >>>>>> On Fri, Feb 7, 2014 at 7:47 AM, Slide <[email protected]> wrote: >>>>>>> >>>>>>> Do you get a specific error message? >>>>>> >>>>>> >>>>>> Sorry, yes: >>>>>> >>>>>> Traceback (most recent call last): >>>>>> File "<string>", line 1, in <module> >>>>>> _sqlite3.OperationalError: unable to open database file >>>>>> >>>>>> Does this work for you? I get this error running latest ipy.exe (Mono >>>>>> 2.10, Ubuntu 13.10) and IronPython in Calico. >>>>>> >>>>>> -Doug >>>>>> >>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Fri, Feb 7, 2014 at 5:37 AM, Doug Blank <[email protected]> >>>>>>> wrote: >>>>>>>> >>>>>>>> Just recently discovered the sqlite3 port for IronPython, but having >>>>>>>> some basic trouble: >>>>>>>> >>>>>>>> This works fine: >>>>>>>> >>>>>>>> import sqlite3 >>>>>>>> sqlite3.connect("test.db") >>>>>>>> >>>>>>>> but this doesn't: >>>>>>>> >>>>>>>> import sqlite3 >>>>>>>> sqlite3.connect("/home/dblank/test.db") >>>>>>>> >>>>>>>> Any ideas? >>>>>>>> >>>>>>>> -Doug >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Ironpython-users mailing list >>>>>>>> [email protected] >>>>>>>> https://mail.python.org/mailman/listinfo/ironpython-users >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Website: http://earl-of-code.com >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Website: http://earl-of-code.com >>>>> >>>>> _______________________________________________ >>>>> Ironpython-users mailing list >>>>> [email protected] >>>>> https://mail.python.org/mailman/listinfo/ironpython-users >>>>> >>>> >>> >> > > > > -- > Website: http://earl-of-code.com > > _______________________________________________ > Ironpython-users mailing list > [email protected] > https://mail.python.org/mailman/listinfo/ironpython-users > _______________________________________________ Ironpython-users mailing list [email protected] https://mail.python.org/mailman/listinfo/ironpython-users
