[Ironpython-users] IronPython SQLite interface

[Doug Blank]

On Mon, Feb 10, 2014 at 8:47 AM, Slide <slide.o.mix at gmail.com> 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 <doug.blank at gmail.com> wrote:
>
>>
>> On Fri, Feb 7, 2014 at 7:47 AM, Slide <slide.o.mix at gmail.com> 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 <doug.blank at gmail.com> 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
>>>> Ironpython-users at python.org
>>>> https://mail.python.org/mailman/listinfo/ironpython-users
>>>>
>>>>
>>>
>>>
>>> --
>>> Website: http://earl-of-code.com
>>>
>>
>>
>
>
> --
> Website: http://earl-of-code.com
>
> _______________________________________________
> Ironpython-users mailing list
> Ironpython-users at python.org
> https://mail.python.org/mailman/listinfo/ironpython-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20140210/71dbcc08/attachment.html>