[IronPython] MySQL and Iron Python

[Vernon Cole]

Harry:
  Which dbapi package are you running under sqlalchemy?
--
Vernon

On Thu, Jul 22, 2010 at 2:24 AM, Harry Percival <harry.percival at 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 <vernondcole at 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 <ian at 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 <ian at 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 <ian at 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 at lists.ironpython.com
> >>>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
> >>>
> >>>
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users at 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 at lists.ironpython.com
> >>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
> >>>
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at 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 at lists.ironpython.com
> >> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
> >>
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.ironpython.com
> > http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
> >
> >
> _______________________________________________
> Users mailing list
> Users at lists.ironpython.com
> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20100722/4d49906d/attachment.html>