[IronPython] MySQL and Iron Python

[Harry Percival]

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 <vernondcole at 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.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
>
>
> _______________________________________________
> Users mailing list
> Users at 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