Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-11 Thread Brian Sutherland
On Fri, Apr 11, 2008 at 05:07:56AM +0200, Andreas Jung wrote: --On 10. April 2008 21:29:43 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: What defines if something is the instance configuration? Isn't ZCML just another format of configuration file? I agree it's evil to hardcode database

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-11 Thread Andreas Jung
--On 11. April 2008 10:09:16 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: On Fri, Apr 11, 2008 at 05:07:56AM +0200, Andreas Jung wrote: --On 10. April 2008 21:29:43 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: What defines if something is the instance configuration? Isn't ZCML just

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-11 Thread Andreas Jung
--On 11. April 2008 08:36:43 +0100 Martin Aspeli [EMAIL PROTECTED] wrote: Martijn Faassen wrote: Andreas Jung wrote: --On 10. April 2008 19:10:49 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: Just adding my few requirements: - Integration into the component architecture in such a way

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-11 Thread Bernd Dorn
On 11.04.2008, at 10:09, Brian Sutherland wrote: Unfortunately, it doesn't seem an option, right now, to avoid using ZCML to setup database connections. So I'm not sure how you want to implement your ideas? +1 k, i didn't read the whole thread, but we (lovely systems) use zope.storm

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-11 Thread Stephan Richter
On Friday 11 April 2008, Bernd Dorn wrote: although it is a few lines of code to get db uris from somewhere else,   and this could also be application code if you use paster, you can stick options into your pater ini script. We are currently doing this for a setting in our app. Regards,

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-11 Thread Brian Sutherland
On Fri, Apr 11, 2008 at 01:21:45PM +0200, Andreas Jung wrote: Unfortunately, it doesn't seem an option, right now, to avoid using ZCML to setup database connections. So I'm not sure how you want to implement your ideas? I have no need for ideas to be implemented. We're using SA within in

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-10 Thread Brian Sutherland
On Wed, Apr 09, 2008 at 05:47:06PM +0200, Andreas Jung wrote: --On 9. April 2008 14:15:38 +0100 Laurence Rowe [EMAIL PROTECTED] wrote: @everyone: If we can all agree to use the same basic session and transaction management then we should probably push for it to be included as a sqlalchemy

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-10 Thread Andreas Jung
--On 10. April 2008 19:10:49 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: Just adding my few requirements: - Integration into the component architecture in such a way that I can specify the db connection parameters in ZCML and that database reflection still works. I

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-10 Thread Brian Sutherland
On Thu, Apr 10, 2008 at 07:31:54PM +0200, Andreas Jung wrote: --On 10. April 2008 19:10:49 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: Just adding my few requirements: - Integration into the component architecture in such a way that I can specify the db connection

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-10 Thread Brian Sutherland
On Thu, Apr 10, 2008 at 09:29:43PM +0200, Brian Sutherland wrote: On Thu, Apr 10, 2008 at 07:31:54PM +0200, Andreas Jung wrote: Please *NO* database specific configurations within ZCML. We're running applications in up three or four different environments and I don't want to maintain

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-10 Thread Kapil Thangavelu
On Thu, Apr 10, 2008 at 1:31 PM, Andreas Jung [EMAIL PROTECTED] wrote: --On 10. April 2008 19:10:49 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: Just adding my few requirements: - Integration into the component architecture in such a way that I can specify the db

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-10 Thread Andreas Jung
--On 10. April 2008 21:29:43 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: On Thu, Apr 10, 2008 at 07:31:54PM +0200, Andreas Jung wrote: --On 10. April 2008 19:10:49 +0200 Brian Sutherland [EMAIL PROTECTED] wrote: Just adding my few requirements: - Integration into the

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-09 Thread Andreas Jung
--On 9. April 2008 14:15:38 +0100 Laurence Rowe [EMAIL PROTECTED] wrote: @everyone: If we can all agree to use the same basic session and transaction management then we should probably push for it to be included as a sqlalchemy extension module. I would be happy with such a solution. As

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-09 Thread Kapil Thangavelu
On Wed, Apr 9, 2008 at 9:15 AM, Laurence Rowe [EMAIL PROTECTED] wrote: The transaction manager here: http://svn.plone.org/svn/collective/collective.lead/branches/elro-tpc/collective/lead/tx.py Has support for TPC and savepoints. It is tested and works. The only issue with sqlite is that

Re: [Zope-dev] Re: straighting out the SQLAlchemy integration mess

2008-04-09 Thread Andreas Jung
--On 10. April 2008 01:57:12 +0100 Martin Aspeli [EMAIL PROTECTED] wrote: Andreas Jung wrote: --On 9. April 2008 14:15:38 +0100 Laurence Rowe [EMAIL PROTECTED] wrote: @everyone: If we can all agree to use the same basic session and transaction management then we should probably push for