Re: [Zope] Strategies for testing generated sql?
On 4/12/06, Paul Winkler <[EMAIL PROTECTED]> wrote: Functionally, we are missing some important testables:* we have no way to verify that these queries are syntactically correct sql.* we have no way to verify that these queries behave as expected against a sample data set.How do people test this sort of thing? Do you go whole-hog andfire up MySQL or whatever? Or use gadfly? sqlite? or what?Are there other tools I should know about? Sorry, It is taking a little more than I expected to prepare the sample. However, I can provide some idea on this topic. We do this using ZopeTestCase. Basically, we have a test database (postgresql, but it can be used for whatever transactional database). Each user has its own database, based on its username. The test does actual queries on the test database. At the end of each test (single test, not test suite), there is a rollback (if you're using a Z Database Adapter, this is done automatically by the transaction machinery). So, each single test runs with a "fresh" copy of the database. Regards Marco -- Icube Srlhttp://www.icube.it/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Strategies for testing generated sql?
Ok, here it is. It is a demo product, which has one class, GenerateInsert, which will generate an insert based on your parameters. I've also written a small test, which tries to show what I would do: test that given the proper parameters, it will generate the proper string. The case I'm showing is very simple, but it could be extended to other cases as well... Also, if you want to take a look at some tests in database environment, you could take a look at paflow (www.paflow.it) where there is quite a lot of tests... Regards MarcoOn 4/12/06, Paul Winkler <[EMAIL PROTECTED]> wrote: On Wed, Apr 12, 2006 at 06:51:18PM +0200, Marco Bizzarri wrote:> The problem is what you want to test. I'm not familiar with Zope 3,> therefore I'm talk on the base of ZSQLMethod.SQL.SQL from Zope 2.> > If I understand correctly, you've some high level construct which creates an> nvSQL instance.Correct.> Now, if you put yourself at the end of the line, what you> need to do is to parse the output of nvSQL, in order to see if the generated > SQL is correct.>> What you're doing therefore is to test whether nvSQL is able to generate> correctly the SQL. But I think this is not what you want to test. You could> safely assume that, given the proper input, nvSQL will generate the proper > output.>> Therefore, what you should test is that the generated nvSQL has the> appropriate characteristics.Exactly!I am also open to suggestions on what kind of characteristics I should be interested in. I have never written tests of generatedSQL before.> I will try to post a sample for Zope2, just to give an idea of what could be> done.That would be very helpful, thank you. --Paul Winklerhttp://www.slinkp.com___Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding! **(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )-- Icube Srlhttp://www.icube.it/ SimpleSQLTests.tar.gz Description: GNU Zip compressed data ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] TAL page whitespace removal
(Thu, Apr 13, 2006 at 12:00:08PM -0400) [EMAIL PROTECTED] wrote/schrieb/egrapse: > Date: Wed, 12 Apr 2006 19:03:29 +0100 > From: "Robert (Jamie) Munro" <[EMAIL PROTECTED]> ... > gzip will add enormous processing overhead to the server. Your server must be a C=64 or something. I'm running Zope on an Apple Powermac G3 B&W at 350Mhz -- not really an up-to-date powerhouse. Gzipping most of my COREBlog pages shows no noticeable difference in processor load - even on such a lame machine. I'm not even using apaches gzip-encoding module, but the Zope builtin stuff. Being able to get things faster to the clients frees load off the server, the payoff for gzipping content is mucho worth it in my experience. The next thing that paid off huge was implementing handling of If-Modified-Since headers. Bandwidth use for the Googlebot went down from from about 50MB per month to around 1MB. That helps getting processor load and disk load down too. Other search engines and even some "real" clients get 304's too. Regards, Sascha -- http://betabug.ch/blogs/ch-athens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] import & export error on.2.9.2 version of zope has been solved
On 4/14/06, shivayogi kumbar <[EMAIL PROTECTED]> wrote: > Is it because of the change in the version of ZODB, in zope2.7.3 they have > used the 3.2.4c version ZODB , and > in ZOPE2.9.2 used 3.6.0 version ZODB. No. > Sir "Lennart Regebro" has suggested me to copy and paste the data.fs file > from Zope2.7.3 where actully my application has developed.Please help me out That is the best way of upgrading, yes. Then you will have no import error. And you still no not include the whole traceback. It is impossible to say what is wrong unless you include the whole traceback. And stop calling the application "applictaion name" tell us what it is, people here might know the application. And, as I said before: This is most likely a problem with the application. Contact the application developer. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] How to update list from dtml?
Dear Zopistas, How to do in DTML something similar in python: foo[1] = 3.5 In DTML this does not work: Note, that I have list foo[,,,] already defined Many thanks, J. Lukesh ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] How to update list from dtml?
On 4/14/06, Jaroslav Lukesh <[EMAIL PROTECTED]> wrote: > Dear Zopistas, > > How to do in DTML something similar in python: > > foo[1] = 3.5 You call a python file that does it. Really, you don't want to start doing those things in DTML, it just gets very complicated very fast. -- Lennart Regebro, Nuxeo http://www.nuxeo.com/ CPS Content Management http://www.cps-project.org/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] How to update list from dtml?
Try: Jonathan - Original Message - From: "Jaroslav Lukesh" <[EMAIL PROTECTED]> To: Sent: Friday, April 14, 2006 10:22 AM Subject: [Zope] How to update list from dtml? Dear Zopistas, How to do in DTML something similar in python: foo[1] = 3.5 In DTML this does not work: Note, that I have list foo[,,,] already defined Many thanks, J. Lukesh ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Getting www.domain.com:8080/manage to go through Apache
HiI've got various virtual hosts running but am having a few issues getting the administration site on www.domain.com:8080/manage to go through Apache. I want to route this all through SSL. What I can get is the admin for the *individual site* but not all the sites listed under a Zope instance. I'm trying to use to put a request for www.domain.com/manage through to www.domain.com:8080/manage in Zope and then back out through port 443. I haven't set up the SSL certificates yet. Here's what I've got so far which isn't working quite as planned. Anyone achieved this at all? ThanksNameVirtualHost xx.x.xxx.xxx:80 ServerName www.domain.net RewriteEngine On RewriteRule ^/(.*) http://www.domain.co.uk:8080/manage/VirtualHostBase/https/www.domain.net:443/VirtualHostRoot/$1 [L,P] -- michael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] LocalFS under Zope2-7-7/windows
I all, I am migrating some apps to Zope2-7-7 under windows and the LocalFS product generate an error wen starting zope. The error at the end of the traceback is: File "C:\Programmi\Zope-2.7.7-final\lib\python\Signals\WinSignalHandler.py", line 227, in registerHandler hevent = win32event.CreateEvent(sa, 0, 0, event_name) TypeError: The object is not a PySECURITY_ATTRIBUTES object Any pointer on fixing this? Can someone plese confirm that LocalFS works fine under Unixes? Is there any other solution for serving files out from filesystem directories under Zope-2-7-7/win? TIA __peppo ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] How to update list from dtml?
> From: Jonathan [mailto:[EMAIL PROTECTED] > Try: > > I need to insert that at specific position, not append at end of the list. Thanks, JL. > - Original Message - > From: "Jaroslav Lukesh" <[EMAIL PROTECTED]> > > > > foo[1] = 3.5 > > > > In DTML this does not work: > > > > > > > > > > Note, that I have list foo[,,,] already defined ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] How to update list from dtml?
--On 14. April 2006 18:40:46 +0200 Jaroslav Lukesh <[EMAIL PROTECTED]> wrote: From: Jonathan [mailto:[EMAIL PROTECTED] Try: I need to insert that at specific position, not append at end of the list. A look at a basic Python tutorial documentation will tell you about the methods and ways to deal with Python lists. -aj -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376 E-Publishing, Python, Zope & Plone development, Consulting pgpkG35dVwfJn.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
No memory leak! (was: Re: [Zope] Memory Leak in Session Data Container)
Dieter Maurer wrote at 2006-4-11 22:14 +0200: >Andy Yates wrote at 2006-4-10 12:43 -0500: >> ... >>Fortunately, I have an easy way to reproduce the problem and even better >>I've found a work around. My hope is that the work around will lead >>somebody more familiar with the innards of Zope to where the problem is >>located. > >Congratulations! > >I will look into this within the next days (in Zope 2.8.1, however). I checked this: There is no memory leak related to session handling in Zope 2.8.1! > ... >The ZODB cache may keep your session objects (and thereby its >content) alive. Almost surely, this is what happened in Andy's test. Here is a description how I checked for the existence of a memory leak: I instrumented the pickles in "tempstorage.TemporaryStorage.TemporaryStorage" such that I can find out the number of pickles stored (similar to the reference counts in "Control_Panel/DebugInfo"). I performed a mass test, creating thousands of sessions (similar to Andy's test). The pickle number stored by "TemporaryStorage" grew as expected (as it stores the sessions). I forced all session objects maintained by "/temp_folder/session_data" to be discarded. Creating a single new session caused almost all "TemporaryStorage" pickles to be released. However, the ZODB caches still contained about 20.000 session objects. It was very surprising (and contrary to my previous message) that the storage flushed most of its pickles while references to them were still in the ZODB caches. This looks like a bug (but not a memory leak). I flushed the ZODB caches. I repeated the test and verified that the number of pickles remaining in "TemporaryStorage" does not increase. Results: * no memory leak! * maybe something that looks like a memory leak caused by the ZODB caches which may hold up to 20.000 (with standard configuration) no longer used objects A more senseful configuration can work around this. -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: zope 2.8.6 on Mac Intel
Hello Dieter, Thanks for your help, I have Zope 2.8.6 and Python 2.3.5 compiled with Fink. I also had the same problem with python 2.3.5 from Apple, which is known to lack some features, so you might be right with conflicting Python version. Under Unbutu, I used to compile Zope with python-devel package installed, but can't find it for os x. I'm going to try a few more python distro, like darwinport or macpython to see if it works. Manuel 2006/4/14, David H <[EMAIL PROTECTED]>: > Dieter Maurer wrote: > manuel spuhler wrote at 2006-4-12 21:40 +0200: > > > ... > File "/opt/Zope2.8/lib/python/ZODB/__init__.py", line 21, > in ? > from persistent import TimeStamp > File "/opt/Zope2.8/lib/python/persistent/__init__.py", > line 19, in ? > from cPersistence import Persistent, GHOST, UPTODATE, CHANGED, STICKY > ImportError: Inappropriate file type for dynamic loading > > Something is wrong with your "cPersistent.so" file. > > It should be a dynamically loaded shared object but somehow it is not. > > I cannot tell you why... > > > > Manuel, > > Last time I saw cPersistent.so mentioned as a problem it had to do with > conflicting python versions. No idea either, otherwise. > Did you mention your zope version *and* the python versions you are using? > (check your control panel) Didnt see the start of this thread. > > David > > > ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: zope 2.8.6 on Mac Intel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't see how a packaged Python that is possibly compiled with dubious options and split up along dubious lines into Python, Python- dev and Python-whatever is better than a self-compiled Python on OS X. The following document tells you how to do it: http://www.zope.org/Members/jens/docs/Document.2003-12-27.2431/view Self-compiling is not rocket science. jens On 14 Apr 2006, at 22:21, manuel spuhler wrote: Hello Dieter, Thanks for your help, I have Zope 2.8.6 and Python 2.3.5 compiled with Fink. I also had the same problem with python 2.3.5 from Apple, which is known to lack some features, so you might be right with conflicting Python version. Under Unbutu, I used to compile Zope with python-devel package installed, but can't find it for os x. I'm going to try a few more python distro, like darwinport or macpython to see if it works. Manuel 2006/4/14, David H <[EMAIL PROTECTED]>: Dieter Maurer wrote: manuel spuhler wrote at 2006-4-12 21:40 +0200: ... File "/opt/Zope2.8/lib/python/ZODB/__init__.py", line 21, in ? from persistent import TimeStamp File "/opt/Zope2.8/lib/python/persistent/__init__.py", line 19, in ? from cPersistence import Persistent, GHOST, UPTODATE, CHANGED, STICKY ImportError: Inappropriate file type for dynamic loading Something is wrong with your "cPersistent.so" file. It should be a dynamically loaded shared object but somehow it is not. I cannot tell you why... Manuel, Last time I saw cPersistent.so mentioned as a problem it had to do with conflicting python versions. No idea either, otherwise. Did you mention your zope version *and* the python versions you are using? (check your control panel) Didnt see the start of this thread. David -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (Darwin) iD8DBQFEQA4ZRAx5nvEhZLIRAuxjAJ4jAG6yti+W8hAIqfs6A1+//CybmACggGch PTs20xqyKq0mp0ImM5FhdEk= =cd3I -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: zope 2.8.6 on Mac Intel: Resolved
Hello David, sorry, I meant you before, but hey, hello too Dieter ;-) I finally manage to install and run Zope 2.8.6 on Mac Intel after installing the Universal package of python 2.4.3 for os x (http://www.python.org/download/releases/2.4.3/). Then I did the usual unix stuff: $./configure --with-python=/usr/local/bin/python --prefix=/opt/Zope2.8 && make &&make install $ /opt/Zope2.8/bin/mkzopeinstance.py Even if this Python version is not supported, I didn't notice (yet;-) any problem. As far as I know, it's the 1st Zope 2.8.6 and Plone 2.11 on Mac Intel and it's at least as fast as on Linux !!! Thank you all for your help and happy zoping! Manuel Zope Version (Zope 2.8.6-final, python 2.4.3, darwin) Python Version 2.4.3 (#1, Mar 30 2006, 11:02:16) [GCC 4.0.1 (Apple Computer, Inc. build 5250)] System Platform darwinope Version (Zope 2.8.6-final, python 2.4.3, darwin) Python Version 2.4.3 (#1, Mar 30 2006, 11:02:16) [GCC 4.0.1 (Apple Computer, Inc. build 5250)] System Platform darwin ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: zope 2.8.6 on Mac Intel
Thank you, I tried that already, but for some reasons, it did'nt work 2006/4/14, Jens Vagelpohl <[EMAIL PROTECTED]>: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I don't see how a packaged Python that is possibly compiled with > dubious options and split up along dubious lines into Python, Python- > dev and Python-whatever is better than a self-compiled Python on OS X. > > The following document tells you how to do it: > > http://www.zope.org/Members/jens/docs/Document.2003-12-27.2431/view > > Self-compiling is not rocket science. > > jens > > > On 14 Apr 2006, at 22:21, manuel spuhler wrote: > > > Hello Dieter, > > > > Thanks for your help, I have Zope 2.8.6 and Python 2.3.5 compiled with > > Fink. I also had the same problem with python 2.3.5 from Apple, which > > is known to lack some features, so you might be right with conflicting > > Python version. Under Unbutu, I used to compile Zope with python-devel > > package installed, but can't find it for os x. I'm going to try a few > > more python distro, like darwinport or macpython to see if it works. > > > > Manuel > > > > > > > > 2006/4/14, David H <[EMAIL PROTECTED]>: > >> Dieter Maurer wrote: > >> manuel spuhler wrote at 2006-4-12 21:40 +0200: > >> > >> > >> ... > >> File "/opt/Zope2.8/lib/python/ZODB/__init__.py", line 21, > >> in ? > >> from persistent import TimeStamp > >> File "/opt/Zope2.8/lib/python/persistent/__init__.py", > >> line 19, in ? > >> from cPersistence import Persistent, GHOST, UPTODATE, CHANGED, > >> STICKY > >> ImportError: Inappropriate file type for dynamic loading > >> > >> Something is wrong with your "cPersistent.so" file. > >> > >> It should be a dynamically loaded shared object but somehow it is > >> not. > >> > >> I cannot tell you why... > >> > >> > >> > >> Manuel, > >> > >> Last time I saw cPersistent.so mentioned as a problem it had to > >> do with > >> conflicting python versions. No idea either, otherwise. > >> Did you mention your zope version *and* the python versions you > >> are using? > >> (check your control panel) Didnt see the start of this thread. > >> > >> David > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.1 (Darwin) > > iD8DBQFEQA4ZRAx5nvEhZLIRAuxjAJ4jAG6yti+W8hAIqfs6A1+//CybmACggGch > PTs20xqyKq0mp0ImM5FhdEk= > =cd3I > -END PGP SIGNATURE- > ___ > Zope maillist - Zope@zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: zope 2.8.6 on Mac Intel
Hello David, sorry, I meant you before, but hey, hello too Dieter ;-) I think I broke the thread, sorry for reposting: I finally manage to install and run Zope 2.8.6 on Mac Intel after installing the Universal package of python 2.4.3 for os x (http://www.python.org/download/releases/2.4.3/). Then I did the usual unix stuff: $./configure --with-python=/usr/local/bin/python --prefix=/opt/Zope2.8 && make &&make install $ /opt/Zope2.8/bin/mkzopeinstance.py Even if this Python version is not supported, I didn't notice (yet;-) any problem. As far as I know, it's the 1st Zope 2.8.6 and Plone 2.11 on Mac Intel and it's at least as fast as on Linux !!! Thank you all for your help and happy zoping! Manuel Zope Version (Zope 2.8.6-final, python 2.4.3, darwin) Python Version 2.4.3 (#1, Mar 30 2006, 11:02:16) [GCC 4.0.1 (Apple Computer, Inc. build 5250)] System Platform darwinope Version (Zope 2.8.6-final, python 2.4.3, darwin) Python Version 2.4.3 (#1, Mar 30 2006, 11:02:16) [GCC 4.0.1 (Apple Computer, Inc. build 5250)] System Platform darwin ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
