Although I won't be able to devote much time to providing RDBMS
support for Mindwrapper right now, I've decide to investigate it
further. My questions for this group are these:
1. Since I don't want to put myself in a position of writing
adapters for a lot of different database systems, what would be the
minimum interface requirements?
2. Would support for http://python.org/peps/pep-0249.html (Python
Database API Specification v2.0) with a mapping from the
object-tree to tables be sufficient?
3. Would Gadfly or PySQLite be a reasonable target for testing?
Thanks.
···
=====
Donnal Walter
Arkansas Children's Hospital
You can find code with a basic ORMapper in the wxPython properties distribution CVS (wxoo.table.*), it's minimally functional with MySQL and PostgreSQL. I don't have enough time to work on finishing this, and am thinking I'll eventually switch to using APE as the ORMapper. (I'm also thinking that, realistically, this stuff just doesn't belong in wxoo (after all, OO != relational most of the time), so if I do wind up working any more on it, I'd rather it was as part of another project).
You'll find code for introspecting a RDBMS' structure, and code for mapping that to wxoo data-types and property editors. That's about the state of the code at the moment, but it might wind up being helpful in some way.
There are a considerable number of other ORM projects out there, BTW. Most deal with only 2 or 3 RDBMS systems at most.
Enjoy,
Mike
Donnal Walter wrote:
···
Although I won't be able to devote much time to providing RDBMS
support for Mindwrapper right now, I've decide to investigate it
further. My questions for this group are these:
1. Since I don't want to put myself in a position of writing
adapters for a lot of different database systems, what would be the
minimum interface requirements?
2. Would support for PEP 249 – Python Database API Specification v2.0 | peps.python.org (Python
Database API Specification v2.0) with a mapping from the
object-tree to tables be sufficient?
3. Would Gadfly or PySQLite be a reasonable target for testing?
Thanks.
=====
Donnal Walter
Arkansas Children's Hospital
---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org
--
_______________________________________
Mike C. Fletcher
Designer, VR Plumber, Coder
http://members.rogers.com/mcfletch/
Hi Donnal,
Not sure if this is fits exactly with what you're doing, but check out the
"GNU Enterprise" project.
http://www.gnuenterprise.org/project/what.html
They're building an "information systems builder" using Python/wxPython. =)
Basically they want to make a cross-platform, Access-like form builder and
reporting tool, that plugs into most any database. They have different
components, but the "Common" component is what you may be most interested
in. It's the backend for all their tools, and it provides a wrapper around
the various database implementations and provides some interesting functions
like XML import/export. They've got ODBC support and explicit support for a
number of free databases, like MySQL, PostgreSQL, and Firebird.
I haven't thoroughly evaluated this tool, but in my tests, it worked just
fine with MySQL as a backend.
Kevin
···
----- Original Message -----
From: "Donnal Walter" <donnalcwalter@yahoo.com>
To: <wxpython-users@lists.wxwindows.org>
Sent: Monday, April 07, 2003 7:40 AM
Subject: [wxPython-users] [OT] Relational support for Mindwrapper
Although I won't be able to devote much time to providing RDBMS
support for Mindwrapper right now, I've decide to investigate it
further. My questions for this group are these:
1. Since I don't want to put myself in a position of writing
adapters for a lot of different database systems, what would be the
minimum interface requirements?
2. Would support for PEP 249 – Python Database API Specification v2.0 | peps.python.org (Python
Database API Specification v2.0) with a mapping from the
object-tree to tables be sufficient?
3. Would Gadfly or PySQLite be a reasonable target for testing?
Thanks.
=====
Donnal Walter
Arkansas Children's Hospital
---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org
Donnal:
I'm glad to hear it! My opinions:
1. Since I don't want to put myself in a position of writing
adapters for a lot of different database systems, what would
be the minimum interface requirements?
See question 2
2. Would support for PEP 249 – Python Database API Specification v2.0 | peps.python.org
(Python Database API Specification v2.0) with a mapping from
the object-tree to tables be sufficient?
I think so. I tend to use MySQLDb, which is a DB-API interface for MySQL. From
what I've seen there are DB-API 2.o interfaces to most if not all the popular
databases. For example, if Mindwrapper could interface with MySQLDb's DB-API
presentation I'd be in pretty good shape. I think. The hardest part may be
handling the SQL to filter query results from the database on some criteria
selected in the GUI, or presenting a view of the data which represents two or
more joined tables. Just thinking aloud here, hope it's helpful ...
3. Would Gadfly or PySQLite be a reasonable target for testing?
I've not used either one, but I've investigated both and I think either would
probably do. Maybe someone can give a better answer on this ...
···
Thanks.
=====
Donnal Walter
Arkansas Children's Hospital
---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail:
wxPython-users-help@lists.wxwindows.org