From: Ingo L. <in...@fa...> - 2002-06-03 16:40:59
Attachments:
pgdb.patch
mk.patch
|
Hi, attached is a patch against MiddleKit to provide preliminary support for PostgreSQL. We are using the patch locally, it seems to work just fine. Its a bit unpolished but, well,... here it is :-) Known issues: - sample data not supported - requires a patch against the PostgreSQL python bindings (only 7.2+ supported) The reason that a patch against the PostgreSQL python bindings is required is that MiddleKit makes uses of a database-assigned ID for newly inserted database objects. It retrieves this through a MySQL-specific server function. Postgres has an equivalent in the 'C' glue for its binding but this equivalent is not exposed by the python-part of the driver. (its called 'lastoid'). The second reason is that we put mxDateTime support into the python part of the Postgres driver so that some assumptions MiddleKit makes about the type of the returned data of datetime columns hold. I suppose there is a way to do that little bit of processing in the MiddleKit patch directly and if anyone can point me in the right direction there, I would truly appreciate it. any and all feedback very welcome! Ingo |
From: <dru...@re...> - 2002-06-03 17:39:35
|
Good stuff! On Mon, 3 Jun 2002, Ingo Luetkebohle wrote: > Hi, > > attached is a patch against MiddleKit to provide preliminary support > for PostgreSQL. We are using the patch locally, it seems to work > just fine. Its a bit unpolished but, well,... here it is :-) > > Known issues: > - sample data not supported > - requires a patch against the PostgreSQL python bindings > (only 7.2+ supported) > > The reason that a patch against the PostgreSQL python bindings is required > is that MiddleKit makes uses of a database-assigned ID for newly > inserted database objects. It retrieves this through a MySQL-specific > server function. Postgres has an equivalent in the 'C' glue for its > binding but this equivalent is not exposed by the python-part of the driver. > (its called 'lastoid'). > > The second reason is that we put mxDateTime support into the python > part of the Postgres driver so that some assumptions MiddleKit makes > about the type of the returned data of datetime columns hold. I suppose > there is a way to do that little bit of processing in the MiddleKit patch > directly and if anyone can point me in the right direction there, I would > truly appreciate it. > > any and all feedback very welcome! > > Ingo > |
From: Federico Di G. <fo...@in...> - 2002-06-03 21:21:42
|
Il lun, 2002-06-03 alle 18:36, Ingo Luetkebohle ha scritto: > The reason that a patch against the PostgreSQL python bindings is require= d > is that MiddleKit makes uses of a database-assigned ID for newly > inserted database objects. It retrieves this through a MySQL-specific > server function. Postgres has an equivalent in the 'C' glue for its > binding but this equivalent is not exposed by the python-part of the driv= er. > (its called 'lastoid'). then just use psycopg, that has a lastoid() mothod on cursors. :) > The second reason is that we put mxDateTime support into the python > part of the Postgres driver so that some assumptions MiddleKit makes > about the type of the returned data of datetime columns hold. I suppose=20 > there is a way to do that little bit of processing in the MiddleKit patch= =20 > directly and if anyone can point me in the right direction there, I would= =20 > truly appreciate it. psycopg has support for custom (pythonic) typecast objects from postgres to python. i don't have the time to work on middlekit at now, but why don't you try this adapter. some people say it is better than the builtin one. (ok, ok, i am clearly partial on it...) --=20 Federico Di Gregorio Debian GNU/Linux Developer & Italian Press Contact fo...@de... INIT.D Developer fo...@in... Those who do not study Lisp are doomed to reimplement it. Poorly. -- from Karl M. Hegbloom .signature |
From: Chuck E. <Chu...@ya...> - 2002-06-09 10:28:12
|
On Monday 03 June 2002 09:36 am, Ingo Luetkebohle wrote: > Hi, > > attached is a patch against MiddleKit to provide preliminary support > for PostgreSQL. We are using the patch locally, it seems to work > just fine. Its a bit unpolished but, well,... here it is :-) Were you able to run the MiddleKit test suite by any chance? > cd Webware/MiddleKit/Tests > python Test.py > r (The reason I redirect to 'r' is that any exceptions go to stderr and will therefore show up (or not)). I have an old MK/Postgres patch lying about. I guess I have the task of reviewing both patches and merging them in. :-O :-) -Chuck |
From: <dru...@re...> - 2002-06-09 20:59:38
|
Hi, I noticed that great example of a TaskKit page generator in the documentation. I looked in the admin section and I didn't see a viewer there. Is there talk about adding Admin plug ins? For the previous example, when WebWare was installed, it would notice that there was a TaskKit. When it noticed that, it would install a link to the TaskKit Admin Module under the Admin context. Then the user could see what tasks were running fairly easily. It would be kind of neat to do this. Is anybody working on this? Dru |
From: <dru...@re...> - 2002-06-09 21:10:51
|
BTW, also, what is the best way to get some code to run when a context is started up? I need to reload the TaskKit schedule. Dru |
From: Chuck E. <Chu...@ya...> - 2002-06-10 06:36:29
|
On Sunday 09 June 2002 01:59 pm, dru...@re... wrote: > Hi, > > I noticed that great example of a TaskKit page generator in > the documentation. I looked in the admin section and I > didn't see a viewer there. > > Is there talk about adding Admin plug ins? > > For the previous example, when WebWare was installed, it would > notice that there was a TaskKit. When it noticed that, it would > install a link to the TaskKit Admin Module under the Admin context. > Then the user could see what tasks were running fairly easily. > > It would be kind of neat to do this. Is anybody working on this? I was planning something exactly like this, but only implemented it for the examples, not the admin. Have at it if you like! -Chuck |
From: Tom S. <tom...@we...> - 2002-06-10 21:05:06
|
Chuck Esterbrook wrote: > On Sunday 09 June 2002 01:59 pm, dru...@re... wrote: > >>Hi, >> >>I noticed that great example of a TaskKit page generator in >>the documentation. I looked in the admin section and I >>didn't see a viewer there. >> >>Is there talk about adding Admin plug ins? >> >>For the previous example, when WebWare was installed, it would >>notice that there was a TaskKit. When it noticed that, it would >>install a link to the TaskKit Admin Module under the Admin context. >>Then the user could see what tasks were running fairly easily. >> >>It would be kind of neat to do this. Is anybody working on this? would be nice. What I was planing, was a persistency framework for the task list, but it should be generic with different plugins (flat file, database, ZODB,.), so you can restart the appserver with the old tasks (if necessary). Got stuck somehow.... > > I was planning something exactly like this, but only implemented it for > the examples, not the admin. Have at it if you like! would be nice so have some more examples and a Tasklist Admin interface.. -- Tom Schwaller tsc...@gn... http://www.python.de |
From: <dru...@re...> - 2002-06-10 21:10:14
|
Well, I'll see what I can produce this week. Thanks for the updates.. Dru |
From: Chuck E. <ChuckEsterbrook@StockAlerts.com> - 2002-07-08 10:14:57
|
On Thursday 04 July 2002 02:11 am, Ingo Luetkebohle wrote: > btw, is someone still working on the MiddleKit? Most of the comments > are from a while ago. I'm just asking because, well, some of the > code is a bit confusing and the general approach for supporting > multiple databases seems a bit complicated to me, so I'm wondering > wether anyone is working on that? Please dont't see these comments > as an attack, MiddleKit is very usefull to us and I'm hoping it will > continue to be developed. Ingo, I've just barely skimmed your message. I'm swamped on a project right now. Yes, MK still gets developed, but I haven't needed too many changes to it for awhile now. My last improvements were optimizations that made is substantially faster that earlier versions. I certainly use it on a regular basis! Regarding the test suite, I invoked the scripts separately on purpose so each one will have a "fresh environment" to run on. That way I can be sure that test failures are the result of earlier test cases gone amuk. I believe there is a webware-discuss question on MK I need to get to as well. Hopefully I'll have more time later in the week to look all this over! -Chuck |
From: SourceForge.net <no...@so...> - 2003-01-15 21:56:08
|
Patches item #564478, was opened at 2002-06-04 13:14 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=304866&aid=564478&group_id=4866 Category: MiddleKit Group: None Status: Open Resolution: None Priority: 5 Submitted By: ingo (netd) >Assigned to: Nobody/Anonymous (nobody) Summary: PostgreSQL support for MiddleKit Initial Comment: Adds PostgreSQL support to MiddleKit (from Webware 0.7). Needs attached PostgreSQL patch, which applies against 7.2+. Sample data not supported, yet. Feedback very welcome! ---------------------------------------------------------------------- >Comment By: Geoff Talvola (gtalvola) Date: 2003-01-15 16:58 Message: Logged In: YES user_id=88162 I'm unassigning this from myself since I don't use either PostgreSQL or MiddleKit. Perhaps Chuck or someone else can review and check this in. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=304866&aid=564478&group_id=4866 |
From: SourceForge.net <no...@so...> - 2003-03-06 18:08:26
|
Patches item #564478, was opened at 2002-06-04 13:14 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=304866&aid=564478&group_id=4866 Category: MiddleKit Group: None Status: Open Resolution: None Priority: 5 Submitted By: ingo (netd) Assigned to: Nobody/Anonymous (nobody) Summary: PostgreSQL support for MiddleKit Initial Comment: Adds PostgreSQL support to MiddleKit (from Webware 0.7). Needs attached PostgreSQL patch, which applies against 7.2+. Sample data not supported, yet. Feedback very welcome! ---------------------------------------------------------------------- >Comment By: Geoff Talvola (gtalvola) Date: 2003-03-06 13:19 Message: Logged In: YES user_id=88162 I've applied the MiddleKit patches to Webware CVS. Does anyone know if the patch to the PostgreSQL-python bindings is still needed? ---------------------------------------------------------------------- Comment By: Geoff Talvola (gtalvola) Date: 2003-01-15 16:58 Message: Logged In: YES user_id=88162 I'm unassigning this from myself since I don't use either PostgreSQL or MiddleKit. Perhaps Chuck or someone else can review and check this in. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=304866&aid=564478&group_id=4866 |
From: SourceForge.net <no...@so...> - 2004-12-31 17:41:24
|
Patches item #564478, was opened at 2002-06-04 12:14 Message generated for change (Comment added) made by jdhildeb You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=304866&aid=564478&group_id=4866 Category: MiddleKit Group: None >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: ingo (netd) Assigned to: Nobody/Anonymous (nobody) Summary: PostgreSQL support for MiddleKit Initial Comment: Adds PostgreSQL support to MiddleKit (from Webware 0.7). Needs attached PostgreSQL patch, which applies against 7.2+. Sample data not supported, yet. Feedback very welcome! ---------------------------------------------------------------------- >Comment By: Jason Hildebrand (jdhildeb) Date: 2004-12-31 11:41 Message: Logged In: YES user_id=173690 Thanks for your patch, which has unfortunately received no attention in over two years. In the meantime full PostgreSQL support has been added to MiddleKit (making this patch obselete) so I'm closing this bug. ---------------------------------------------------------------------- Comment By: Geoff Talvola (gtalvola) Date: 2003-03-06 12:19 Message: Logged In: YES user_id=88162 I've applied the MiddleKit patches to Webware CVS. Does anyone know if the patch to the PostgreSQL-python bindings is still needed? ---------------------------------------------------------------------- Comment By: Geoff Talvola (gtalvola) Date: 2003-01-15 15:58 Message: Logged In: YES user_id=88162 I'm unassigning this from myself since I don't use either PostgreSQL or MiddleKit. Perhaps Chuck or someone else can review and check this in. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=304866&aid=564478&group_id=4866 |