Re: [Zope-dev] Using Java-Script with DTML
If you don't mind the complication, you can use the xml-rpc Java Applet (I can't remember where it comes from) and the Javascript hooks that it provides to make xml-rpc calls from javscript to Zope. >> Original Message << On 6/29/00, 10:14:06 AM, Hung Jung Lu <[EMAIL PROTECTED]> wrote regarding Re: [Zope-dev] Using Java-Script with DTML: > --- In [EMAIL PROTECTED], Thomas Weholt <[EMAIL PROTECTED]> wrote: > > >not work, of course. How I can I pass argument thru Javascript to the > >sqlMethod ?? ---> > > alert (text); > >} > > > > > I think I know what you are talking about. But you have to really > keep your mind straight about one thing: DTML runs with the CPU > on the server side, JavaScript runs with the CPU on the client side. > In other words, by the time you are running Javascript, you > CAN'T access your database records. > I have done a lot of things in displaying dynamic pull-down menus. > E.g: you choose a state from one pull down menu, and the content > of another pulldown menu is automatically changed to the list of > cities within that particular state. When you click on a state, > you CAN'T query your database for the list of its cities. It's > too late, your code is already running on the client side. So > what should you do? What you should do is to pre-generate > JavaScript arrays, storing the names of all the cities for all > the states. > That being said, there is one more caveat. When you pre-render > your database records into JavaScript arrays, you have to be > careful about quoting. I don't know whether there are any string > format quoting in DTML suitable for rendering into JavaScript > (the comes to mind, but I am not > sure it works outside ZSQL methods), I ended up implementing my > own external method to quote Python strings into JavaScript strings. > If you still don't understand what I mean, consider a python string > 'He said, "no".' > stored in your DTML variable mystring, that is, something like: > > and you pre-render it into JavaScript code > x = ""; > It won't work. Because if you look at the source of your JavaScript, > you will see: > x = "He said, "no"."; > regards, > Hung Jung > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Product Data Storage
Just my $0.02 worth... If you can at all avoid it, I think you should find a way to store it in the ZODB. Maybe a Configuration product that would allow you to create arbitrary configuration information and still be able to access it without making filesystem calls. Think about DC's Zope on a CD demo. Not that you really need to do that sort of thing, but it's really not going to work if you have to write stuff to the filesystem. Actually, an XML Docment somewhere at root level should give you the kind of flexibility you're looking for. Lot's of people are using XML files for conf these days (they're all jumping... don't you want to...) That being said, I totally agree that if you need to store something in a file, put it in Zope/var. I, for one, have my Zope application code on partition along with other apps, and the data, like Data.fs on another. I typically don't expect the apps partition to grow very much, or very often, In fact, only when I install something. So it would be quite shocking to have that space filling unexpectedly. But, as always, the choice is completely up to you. Monty >> Original Message << On 6/30/00, 3:27:42 PM, Dan "L." Pierson <[EMAIL PROTECTED]> wrote regarding [Zope-dev] Product Data Storage: > Andy Dawkins writes: > > I have decided AGAINST searching the ZODB for instances of ZMailIn because > > that is just too scary, hideously inefficient and I don't want to go there. > > Instead I thought of keeping an up-to-date list of where all the current > > instances where held. My original idea was to get the ZMailIn product to > > write a file in to the /lib/python/Products/ZMailIn directory, which > > shouldn't cause any problems that I can see. > ... snip ... > > So my question is this: > > What are peoples opinions on storing shared product data? Where should it > > be placed? Should this ability be added to Zope as a standard? > Shared data should go in zope/var, or a subdirectory of that. > Zope/lib should be considered read-only by running products unless > explicitly changed by the user. As you have correctly pointed out, > lots of machines share Zope installations for multiple servers. > A standard interface for Python code to get a private subdirectory of > var might well be useful. > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Fwd: [Zope-PTK] Area based roles?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 7/4/00, 12:45:29 PM, Monty Taylor <[EMAIL PROTECTED]> wrote regarding [Zope-PTK] Area based roles?: > Hi all. I've got an idea of something I'm trying to implement, and I'm > wondering if the concept is of use to anyone else. > I've got an Intranet up in PTK. (What a shock, as I'm posting here. :) ) > I'm slowly getting people to use it for internal collaboration, et al. > But the main things people are wanting to do are internal to their own > department, with some overlap. So you've got: > +PTKRoot > | > +-Members > | +-John > | +-Sue > | > +-Marketing > +-Technology > Say John is in Technology and Sue is in Marketing. What I want is for > John to have Contributor rights in the context of Technology, and Sue in > Marketing, i.e. John adds a News Item and Publishes it. It shows up in > Technology but not Marketing. > I thought about creating a Technolgy Item ("Release Notes") and a > Marketing one ("Press Release") and then just having a catalog search on > the meta-type of each in the appropriate folder's index_html and give > them all Contributor. But that strikes me as unclean. It would be nice to > have anyone be able to create a Press Release or Release Notes, but only > have them published in their department's context, and merely pending in > others. > Am I making any sense at all? Does anyone see either a need for doing > this or a way to do it? If it requires changes to PTK core, would anyone > be interested in those, or should I throw them in my pile of dirty little > secrets that no one should really know exist? > Thanks, > Monty > ___ > Zope-PTK maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-ptk > See http://www.zope.org/Products/PTK/Tracker for bug reports and feature requests ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Re: [Zope-PTK] Roles, Groups, Security and Group Membership
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 7/4/00, 1:22:04 PM, Chris Withers <[EMAIL PROTECTED]> wrote regarding [Zope-PTK] Roles, Groups, Security and Group Membership: > Monty Taylor wrote: > > Am I making any sense at all? Does anyone see either a need for doing > > this or a way to do it? If it requires changes to PTK core, would anyone > > be interested in those, or should I throw them in my pile of dirty little > > secrets that no one should really know exist? > You're making perfect sense and I think it's a Zope problem partly, and > also a PTK problem. Good point. I think as ZEO becomes more prevelant and Zope wants to compete in the realm of big systems, group based interaction could serve to iron some things out. > The Zope problem is that Zope security has no idea about Groups. > As in Users/Members exist > There may have roles > They may also be members of Groups. > Groups may also be members of Groups. > Groups may also have roles associated with THEM. > Other major security systems I can think of (LDAP, Unix, NT, Notes) all > have this concept but Zope does not :( > Should this part of the discussion be moved to zope-dev? Probably so. I've forwarded the original email there and I'm sending this one to zope-dev. Any comments from the zope-dev world? Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] ZEO Replication/Cache
I just installed an instance of ZEO Storage Server with a client on the same machine and a client on a different machine. So far, it seems to work reasonably well, with one exception. None of the changes I've made on one client seem to propagate to the other client unless I restart the other client. This can't be the intended modus operendi. Have I missed something obvious, or is the proactive notification from server to client not implemented yet? Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Overriding a method in an instance.
It seems to me that the problem here is in appearance. Although it seems that you're aquiring an index_html or searchResults in those cases, they are actually instantiated in scope just like anything else you'd add inside that particular object, you just can't see them. So you have two choices. Sub-class Tracker or Squishdot and override that way. OR Make a folder that contains the overridden methods and call things through the context of that folder. In the case of what it seems you want to do I'd say sub-classing is going to be your real answer. Hope that helps... Monty >> Original Message << On 7/10/00, 4:11:08 PM, Chris Withers <[EMAIL PROTECTED]> wrote regarding [Zope-dev] Overriding a method in an instance.: > Hi, > I guess this should be a feature request for the collector but I thought > I'd see what other people thought first... > I'd really like to be able to override methods in an instance of an > object. Examples I can think of are Squishdot and the Tracker. > In Squishdot, or any ZCatalog for that matter, it'd be great to override > searchResults to return what I want, formatted how I want. > In Tracker, the same could be said for index_html. > These may be bad examples, but hopefully you see what I mean... > Anyway, if you do try to override, you get a 'This id is already in use' > error. How do you get around it and how should this problem be solved? > cheers, > Chris > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZSQL Question
Let me preface this by saying: this is an untested guess. I don't have Access around anywhere to play with. But, my guess would be that since you're connecting using ODBC, you'll have to use standard SQL wildcards instead of Microsoft extensions. So try select * from SomeTable where SomeField like '%project%' Monty >> Original Message << On 7/12/00, 6:51:31 AM, Daniel Sashko <[EMAIL PROTECTED]> wrote regarding [Zope-dev] ZSQL Question: > Hello, is there a way in Zope to search on the pattern of the field in > the database?? > for example:: > through ZODBC using ZSQL connected to ACCESS database I have a query that > goes like this: > select * from SomeTable where (SomeField Like '*project*') > If I run this SQL in ACCESS directly it returns all the records where the > field SomeField has the word "project" anywhere in the text... but when I > run it through the ZSQL I get nothing in return. > Is there another key word to be used with ZSQL or is it just imposible to > query on the patterns > What's weird, the ZSQL does not choke on the "Like" word... it just says > that there was no data matching the query... > any one has any ideas? > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] MySQL Transaction Support
We were talking about this a while back and I believe came to a consensus about having two different ZMySQL adapters, one for transactions, one for not. However, since each table can have a different type, this might not bode too well for someone that needs a connection to draw from one table with BDB and one without. If you look at the output of the mysqldump utility, using --opt, it shows both server version and table type. I think we should be able to add a function to _mysql.c that would expose that information on a per-table basis. We could then make the call as to whether the sever supports transactions or not. A question would be, what should the commit/rollback mechanism decide to do when the transaction deals with tables of both types. I would suggest a default behavior of not allowing transactions in a mixed type situation, with a way to set an overriding option to allow the rollbackable table to be rolled back and leave the other as is. Hopefully the application designed wouldn't cause that kind of insanity, but hey, if they want to, they'll find a way. Does anyone have any thoughts on this approach? Baring any blaring negative comments, I'll start working on knocking up something like this. Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Re: MySQL Transaction Support
Good point. It still irks me to have two DA's though. It gets confusing enough with the three different DA's running around now, much less if one of them actually had two valid versions. What if we had two classes like you said, but then in the manage_addForm had a checkbox for Transactions enabled, which would determine which Class got instantiated? Any good reasons why that shouldn't work? Monty Andy Dustman wrote: > > On Tue, 1 Aug 2000, Monty Taylor wrote: > > > A question would be, what should the commit/rollback mechanism decide to > > do when the transaction deals with tables of both types. > > It should raise ProgrammingError, "You're screwed". > > If you need transactional capabilities, then you just can't mix > transactional and non-transactional tables in MySQL. This is also why I > think there need to be two Zope DAs for MySQL: Non-transactional and > transactional, the latter being a simple subclass of the former with TM > support mixed-in. The choice of whether or not to be transactional should > be made by the application designer; it's too complicated to make at > run-time (i.e. for each query). Even if you can use the API to find the > table type, you stil have to figure out what tables are used by the query, > and that requires parsing SQL. > > -- > andy dustman | programmer/analyst | comstar.net, inc. > telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d > "Therefore, sweet knights, if you may doubt your strength or courage, > come no further, for death awaits you all, with nasty, big, pointy teeth!" ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZOracle LOB Questions
Is anyone working on fixing DCOracle? I'll have someone look into if no one else is, but I'd prefer to spend the energy elsewhere if it's already being addressed. (The LOB support would be nice for me as well.) "Matthew T. Kromer" wrote: > > Alexander Schad wrote: > > > > > Alex, Oracle 8i broke DCOracle's support for LOBs; DCOracle primarily > > > uses OCI 7 (Oracle 7) calls, and Oracle 8i enforces a restriction that > > > OCI 8 objects cannot be used in the context of an OCI 7 statement. > > > > > > You can use Oracle 8.0 for this, the restriction isn't enforced until > > > Oracle 8.1. > > > > > > > Hello! > > thank you for your answer. but does that mean that i can only use LOBS > > with Oracle 8.0 ? > > i'm confused. i need to use LOBs. if i use oracle 8.1 can i use LOBS and > > if yes which Databse adapter do i need? > > If your database adapter is 8.0 you can probably use LOBs, if > the adapter is 8.1 you probably can't. I never mix and match > adatpters vs. databases, though, so your mileage my vary. By > this I mean, you could use 8.0 libraries to access an 8.1 > database via SQL*NET. I *think* the error is actually being > raised at the library level, not the server itself. > > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] [Zope] App isolation
I'm fairly sure there's already a Zope COM interface, and I know Zope can do xml-rpc. And SOAP support is coming. So I would suggest building it as an XMLRPC or SOAP server, and then use the Zope client functionality already there to connect to it. I wouldn't do COM because I'm an Open Source bigot. Monty Jacques Exelrud wrote: > > Not sure if this list is the best place to put such question but here it > is... > I need to develop what would be a product if only Zope was the target. > As it´s not I was thinking what could I do to not need to build such app > twice: > I came to 2 options both involving building a server of some kind and > using Python to connect to this server. > > 1st > Build the app as a COM server (the target OS is Windows) and using > Python support build an interface to this COM server as a Zope > product > > 2nd > Build the app as a XMLRPC server and using Python support build an > interface to this XMLRPC server > > The second options is better because I´m not attached to any platform > but, as I said, that´s not an issue right now. > > Good options would be having a JVM running "inside" Zope so that jave > objects could be accessed by it or SOAP Zope support beeing ready... > > Any sugestions on any of those or a 3rd option ? > > Thanks in advance, > Jacques > > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Shared Libraries and Persistent Objects
Hey guys, I've got a question about how Zope deals with shared libraries. Say I have a 2Meg shared library that I've generated with SWIG. (I know it's big, but for sake of argument) Say then that I create a Python Class that imports this library and provides a front-end for each of its exported methods. Then, I instantiate this class 2000 times within a Zope instance. My question is, the library code is loaded into memory once, right? That seems to be what should happen, but I want to make sure before I start selling people here on SWIGing a few utilities and bundling them into one of our Zope objects instead of doing fork/execs to call an executable. I'm not shifting the burden from loading time to storage size, am I? Thanks, Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] ZSQL Methods from Python?
Hey, is there any doco about using ZSQL Methods from Python Products? Also, does anyone know of any work done to extend ZSQL Methods to allow stored-procedure calls? I know I can do an Oracle Procedure call from DCOracle that returns a cursor, but I'd love to combine that with the caching/pluggable brains of ZSQL Methods. Is there anything out there on this or am I going to have to roll my own? Thanks, Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZSQL Methods from Python?
Jim Fulton wrote: > Monty Taylor wrote: > > > Also, does anyone know of any work done to extend ZSQL Methods to allow > > stored-procedure calls? > > No, but I'd love to see someone tackle it. The semantics > of stored procedures varies so widely accross databases, that > I doubt that it would be easiliy generalizable. I think, at > least for starters, a form of stored procedure support for > Oracle would make alot of sense. > > > I know I can do an Oracle Procedure call from > > DCOracle that returns a cursor, but I'd love to combine that with the > > caching/pluggable brains of ZSQL Methods. Is there anything out there on > > this or am I going to have to roll my own? > > I think you'd have to roll your own. If you want to > do something reusable that other people could use, I'd be > happy to provide whatever advice and support I can. > I think I'd like to talk to you about this. We're about to work on transitioning a web-based product to Zope, and we use Store Procedures exclusively. I'd love to have the extra ZSQL goo instead of having to wrap the code at such an individual level. Maybe we can stick someone on the task. But I'm sure we'll need a guiding hand or two. All of this assumes I can get past the basic problem that follows... > > Note that one of the things I like about Oracle's stored procedures > is that they allow me to avoid screwing with cursors in the common case > that I'm getting one row of data. I can just get the data I need through > a straight function call. The DCOracleStorage uses stored procedures > almost exclusively. > > I've been looking through that code (we've started using DCOracleStorage on the backend.) For some reason, though, I can't get the stored procedure stuff to work like you do. Check out the following: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SQL> desc pgm140_api; PROCEDURE SELECT_TARGETS Argument Name TypeIn/Out Default? -- --- -- PP_NAMEVARCHAR2IN PP_RESULT REF CURSOR IN/OUT RECORD IN/OUT AMSM_IDNUMBER(12) IN/OUT NAME VARCHAR2(80)IN/OUT PROCEDURE SELECT_TECHNOLOGIES Argument Name TypeIn/Out Default? -- --- -- PP_CATEGORYVARCHAR2IN PP_RESULT REF CURSOR IN/OUT RECORD IN/OUT ET_ID NUMBER(12) IN/OUT NAME VARCHAR2(80)IN/OUT * Then from python, with the same connection string, I do: Python 1.5.2 (#1, Feb 14 2000, 18:27:27) [GCC 2.95.1 19990816 (release)] on sunos5 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> import DCOracle.oci_ >>> conn=DCOracle.Connect('') >>> pgm140_api=getattr(conn.procedures,'pgm140_api') >>> sql_select_targets=getattr(pgm140_api, 'select_targets') Traceback (innermost last): File "", line 1, in ? File "/apps/zope/lib/python/Products/ZOracleDA/DCOracle/ociProc.py", line 324, in __getattr__ oci.error: no usable procedure named pgm140_api.select_targets I've tried using all caps on one or both as well to no avail. Any thoughts? Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] MySQL : help !
I can send you one, but if building it is giving you lots of problems, you may have larger problems, and the _mysql I send may not really help. Building should be sort-of straight forward. What version of ZMysqlDA are you using? What version of Mysql? What errors are you getting? [EMAIL PROTECTED] wrote: > I need the binarie file named _msql > does anybody got it (for any Linux)? > Because I can't build this file : I've got too many errors > > Thanks in advance > Jérôme DIEBOLD > > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] ZMySQLDA transaction issues.
We were chatting a while back about how to handle the MySQL issue of support/non-support for transactions, with the dominant suggestion at the time being two DAs. I just got done talking with Michael Widenius (Monty of MySQL fame) and he offered to add a warning on rollback if the table doesn't support transactions. So what I'm going to do is this, unless anyone can raise a beefy suggestion. 1) Actually get off my ass and incorporate all of adustman's MySQLdb changes into my ZMySQLDA. :) 2) Make transactions un-supported until the release of MySQL that contains the warning. Since the 3.23 line is pre-release, there shouldn't be any issues with people using a version of MySQL that supports transactions but not being able to upgrade to one that ZMySQLDA supports (you should never be that tied to a pre-release version of anything.) 3) For all MySQL versions that we don't 'officially' support as having transactions, throw an exception if a rollback is attempted. 4) Include a config option to turn off the exceptions. I believe we should be able to keep a simple, and single, ZMySQLDA this way. But please, shoot holes in the plan for me. Thanks, Monty ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )