Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Jeff Hardy
On Fri, May 9, 2014 at 2:54 PM, Doug Blank wrote: > Agreed. But maybe there is a way to still use the Mono.Data.Sqlite code > base? Perhaps add in more functionality (wouldn't be exposed by ADO), > accessible via a intermediate API. It seems a waste to have two low-level > interfaces to sqlite3...

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Doug Blank
On Fri, May 9, 2014 at 8:59 AM, Jeff Hardy wrote: > On Fri, May 9, 2014 at 12:01 PM, Doug Blank wrote: > > On Fri, May 9, 2014 at 4:42 AM, Jeff Hardy wrote: > >> > >> On Thu, May 8, 2014 at 5:32 PM, Doug Blank > wrote: > >> > Just getting back to attempting to use sqlite3 on computers other th

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Slide
Ah, I guess it would help if I actually went and looked at what was being used :-) On Fri, May 9, 2014 at 6:48 AM, Jeff Hardy wrote: > On Fri, May 9, 2014 at 2:41 PM, Slide wrote: > > Would it be useful to pick up something like this: > > https://code.google.com/p/csharp-sqlite/ ? > > That's w

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Jeff Hardy
On Fri, May 9, 2014 at 2:41 PM, Slide wrote: > Would it be useful to pick up something like this: > https://code.google.com/p/csharp-sqlite/ ? That's what it already uses. :) It's no longer maintained, doesn't work on non-Windows platforms, and is perpetually behind the actual SQLite releases. It

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Slide
Would it be useful to pick up something like this: https://code.google.com/p/csharp-sqlite/ ? On Fri, May 9, 2014 at 5:59 AM, Jeff Hardy wrote: > On Fri, May 9, 2014 at 12:01 PM, Doug Blank wrote: > > On Fri, May 9, 2014 at 4:42 AM, Jeff Hardy wrote: > >> > >> On Thu, May 8, 2014 at 5:32 PM,

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Jeff Hardy
On Fri, May 9, 2014 at 12:01 PM, Doug Blank wrote: > On Fri, May 9, 2014 at 4:42 AM, Jeff Hardy wrote: >> >> On Thu, May 8, 2014 at 5:32 PM, Doug Blank wrote: >> > Just getting back to attempting to use sqlite3 on computers other than >> > Windows, and it looks like this C# library has other pro

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Doug Blank
On Fri, May 9, 2014 at 4:42 AM, Jeff Hardy wrote: > On Thu, May 8, 2014 at 5:32 PM, Doug Blank wrote: > > Just getting back to attempting to use sqlite3 on computers other than > > Windows, and it looks like this C# library has other problems on other > OSes. > > > > The first issue is that it a

Re: [Ironpython-users] IronPython SQLite interface

2014-05-09 Thread Jeff Hardy
On Thu, May 8, 2014 at 5:32 PM, Doug Blank wrote: > Just getting back to attempting to use sqlite3 on computers other than > Windows, and it looks like this C# library has other problems on other OSes. > > The first issue is that it appears that all activity must happen in the same > thread (conne

Re: [Ironpython-users] IronPython SQLite interface

2014-05-08 Thread Doug Blank
Just getting back to attempting to use sqlite3 on computers other than Windows, and it looks like this C# library has other problems on other OSes. The first issue is that it appears that all activity must happen in the same thread (connection, cursor, execution). That can mitigated against if tha

Re: [Ironpython-users] IronPython SQLite interface

2014-02-11 Thread Ivan Pozdeev
> Issue #173 with patch: > https://github.com/IronLanguages/main/issues/173 > That works for me! I just removed the removal of the slash. I don't > know what that will do for Windows users that had a path that started with > "/". > We distribute our own DLLs, so no rush for a new release.

Re: [Ironpython-users] IronPython SQLite interface

2014-02-11 Thread Doug Blank
Issue #173 with patch: https://github.com/IronLanguages/main/issues/173 That works for me! I just removed the removal of the slash. I don't know what that will do for Windows users that had a path that started with "/". We distribute our own DLLs, so no rush for a new release. Thanks! -Doug

Re: [Ironpython-users] IronPython SQLite interface

2014-02-11 Thread Jeff Hardy
On Mon, Feb 10, 2014 at 10:15 PM, Slide 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 throu

Re: [Ironpython-users] IronPython SQLite interface

2014-02-10 Thread Slide
That seems a little odd. Perhaps Jeff can shed some light on it, I think he wrote the SQLite adaptation layer. On Mon, Feb 10, 2014 at 3:14 PM, Doug Blank 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 (6

Re: [Ironpython-users] IronPython SQLite interface

2014-02-10 Thread Doug Blank
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") >>> -Doug On Mon, Feb 10,

Re: [Ironpython-users] IronPython SQLite interface

2014-02-10 Thread Doug Blank
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 wrote: > > On

Re: [Ironpython-users] IronPython SQLite interface

2014-02-10 Thread Doug Blank
On Mon, Feb 10, 2014 at 8:47 AM, Slide 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 >

Re: [Ironpython-users] IronPython SQLite interface

2014-02-10 Thread Slide
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? On Fri, Feb 7, 2014 at 6:

Re: [Ironpython-users] IronPython SQLite interface

2014-02-07 Thread Doug Blank
On Fri, Feb 7, 2014 at 7:47 AM, Slide wrote: > Do you get a specific error message? > Sorry, yes: Traceback (most recent call last): File "", line 1, in _sqlite3.OperationalError: unable to open database file Does this work for you? I get this error running latest ipy.exe (Mono 2.10, Ubuntu

Re: [Ironpython-users] IronPython SQLite interface

2014-02-07 Thread Slide
Do you get a specific error message? On Fri, Feb 7, 2014 at 5:37 AM, Doug Blank 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 > sql