Jeff Hardy's port of sqlite to c#: http://bytebucket.org/jdhardy/ironpython.sqlite/wiki/Home
On Thu, Jul 22, 2010 at 12:34 PM, Vernon Cole <vernondc...@gmail.com> wrote: > Harry: > Which dbapi package are you running under sqlalchemy? > -- > Vernon > > On Thu, Jul 22, 2010 at 2:24 AM, Harry Percival <harry.perci...@gmail.com> > wrote: >> >> Hi Ian, >> >> I've been having fun getting sqlalchemy ( http://www.sqlalchemy.org/ ) >> to work on IronPython for the last few months. >> >> If you want a richer API for querying databases, it's pretty good - >> although it's primarily designed as an ORM, so it's philosophy is more >> about definining your OO classes first and then choosing some of the >> to persist in a database, rather than reading from existing databases. >> Also, sqlalchemy is not supported on IPY and there are some bugs if >> you start to do anything really complicated. >> >> However, the core functionality works fine, and it will certainly give >> you field-name based access and, generally, a pleasant querying API. >> Ping me back if you need some help getting it to run, but in a >> nutshell: >> 1: download sqlalchemy >> 2: open download folder in cmd.exe >> 3: run "ipy setup.py install --no-compile" >> 4: sqlalchemy is now installed inside c:\program >> files\ironpython\lib\site-packages. >> 5; check it works: ipy, >>>import sqlalchemy >> 6: read the sqla manual! >> >> rgds, >> harry >> On Tue, Jul 20, 2010 at 10:47 PM, Vernon Cole <vernondc...@gmail.com> >> wrote: >> > Field name access is the next development step. The API calls for >> > position >> > (field number) access. Field name access is an extension. I personally >> > think >> > that it is the obvious thing to do, but the movers and shakers of the >> > database API don't see it the same way. My big goal is to add that >> > feature. >> > I implemented name access for (input) parameters in the last revision. >> > (paramstyle='named'). So for today, you must use column position to >> > read >> > the data. >> > -- >> > Vernon >> > >> > On Tue, Jul 20, 2010 at 1:12 PM, Ian Hobson <i...@ianhobson.co.uk> wrote: >> >> >> >> Thanks Vernon, >> >> >> >> With your help I now have some data! >> >> >> >> Now to find out if I can access it by field name and not just position. >> >> >> >> Thanks again >> >> >> >> Ian >> >> >> >> On 20/07/2010 19:32, Vernon Cole wrote: >> >> >> >> You need to supply a "Driver" for each dialect of SQL you use. The >> >> Microsoft drivers (SQL server and JET) ship with Windows, but you have >> >> to >> >> hunt for the others. For my testing, I use the "MySQL ODBC 5.1 Driver". >> >> You can find it at >> >> http://dev.mysql.com/downloads/connector/odbc/5.1.html >> >> >> >> Also, http://www.connectionstrings.com/ will shed more light on the >> >> black >> >> magic of creating a working connection string. >> >> -- >> >> Vernon >> >> >> >> On Tue, Jul 20, 2010 at 12:16 PM, Ian Hobson <i...@ianhobson.co.uk> >> >> wrote: >> >>> >> >>> ...Testing MySql login... >> >>> (-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider >> >>> for >> >>> ODBC Dr >> >>> ivers', u'[Microsoft][ODBC Driver Manager] Data source name not found >> >>> and >> >>> no def >> >>> ault driver specified', None, 0, -2147467259), None) >> >>> Unit tests for adodbapi version 2.3.0 >> >>> Default Date Converter is <adodbapi.pythonDateTimeConverter object at >> >>> 0x023D7610 >> >>> > >> >>> >> >>> >> >>> On 20/07/2010 19:05, Vernon Cole wrote: >> >>> >> >>> I use MySQL as one of the basic tests for adodbapi, so I can say that >> >>> it >> >>> works pretty well for me. >> >>> What obstacle do you hit? >> >>> -- >> >>> Vernon Cole >> >>> >> >>> On Tue, Jul 20, 2010 at 11:52 AM, Ian Hobson <i...@ianhobson.co.uk> >> >>> wrote: >> >>>> >> >>>> Hi all, >> >>>> >> >>>> How can I (a nube) read a MySQL database using Iron Python? (windows >> >>>> 7 >> >>>> and 2008 Server). >> >>>> >> >>>> Any method will do, so long as it works. :) >> >>>> >> >>>> I've tried adodbapi and mysqldb and mysqlconnector - and always hit >> >>>> an >> >>>> obstacle I can't get round. >> >>>> >> >>>> Regards >> >>>> >> >>>> Ian >> >>>> >> >>>> >> >>>> _______________________________________________ >> >>>> Users mailing list >> >>>> Users@lists.ironpython.com >> >>>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >> >>> >> >>> >> >>> _______________________________________________ >> >>> Users mailing list >> >>> Users@lists.ironpython.com >> >>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >> >>> >> >>> >> >>> No virus found in this incoming message. >> >>> Checked by AVG - www.avg.com >> >>> Version: 9.0.839 / Virus Database: 271.1.1/3017 - Release Date: >> >>> 07/20/10 >> >>> 07:36:00 >> >>> >> >>> >> >>> >> >>> _______________________________________________ >> >>> Users mailing list >> >>> Users@lists.ironpython.com >> >>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >> >>> >> >> >> >> >> >> _______________________________________________ >> >> Users mailing list >> >> Users@lists.ironpython.com >> >> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >> >> >> >> >> >> No virus found in this incoming message. >> >> Checked by AVG - www.avg.com >> >> Version: 9.0.839 / Virus Database: 271.1.1/3017 - Release Date: >> >> 07/20/10 >> >> 07:36:00 >> >> >> >> >> >> >> >> _______________________________________________ >> >> Users mailing list >> >> Users@lists.ironpython.com >> >> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >> >> >> > >> > >> > _______________________________________________ >> > Users mailing list >> > Users@lists.ironpython.com >> > http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >> > >> > >> _______________________________________________ >> Users mailing list >> Users@lists.ironpython.com >> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com > > > _______________________________________________ > Users mailing list > Users@lists.ironpython.com > http://lists.ironpython.com/listinfo.cgi/users-ironpython.com > > -- ------------------------------ Harry J.W. Percival ------------------------------ Italy Mobile: +39 389 095 8959 UK Mobile: +44 (0) 78877 02511 Skype: harry dot percival _______________________________________________ Users mailing list Users@lists.ironpython.com http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
