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
