- Zope - Zope lists

database design question
by Arkaitz 04 May '01

04 May '01

Hi all, I am starting to design a web app, which will have a database consisting of 5000 to 10000 restaurants, which could potentially grow, but not much more. I'm a newbye to Zope,and initially my idea was to keep all the data in a MySQL DB, and access it from Zope. I need to do some very flexible queries and searches on the DB, and I've found that Z SQL Methods get quite awkward easily. I am thinking now about a pure-Zope (ZOBD) solution. I have thought about using a ZClass for each restaurant and keeping them organized in directories with the next hierarchy: County/City/Restaurant Is this a reasonable idea at all to do? I can write Python, and would like to avoid DTML for non-presentation tasks as much as possible. Also, I would need to be able to do queries of the style "give me restaurants that sell chinese food anywhere in this region/city". I appreciate any recommendation or resource that can help me make a good decision. TIA, Arkaitz.

3 3

\'s in ZSQL methods with Postgresql
by Mayers, Philip J 04 May '01

04 May '01

This: update tb1 set cl1=<dtml-sqlvar val1 type=nb>,who=<dtml-sqlvar "REQUEST.AUTHENTICATED_USER">,time=now() Called with: sqlmethod(val1='\') Fails with: Error Type: ProgrammingError Error Value: ERROR: parser: parse error at or near "loginname" update tb1 set cl1='\',who='loginname',time=now() Clearly the \ needs to be escaped. Is this Postgres specific? If so, why isn't the DA (ZPsycopg) quoting it? Running Zope 2.3.2 Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

3 2

Question about cache management
by Oliver Bleutgen 04 May '01

04 May '01

Hi zopistas, I'm currently trying to tune a site for production use. Now I'm thinking about how to best implement caching. My problem is that esp. the first two levels of the site are dynamically created from pulling together summary information from zclasses further down, and these "summary" pages all come from one index_html via acqusition. i.e. root folder index_html content folder content_folder_1 some zclasses content2_folder_2 some zclasses ..etc... So using bobobase_modification_time for the http-header isn't optimal I guess. Has anybody found a nice strategy to cleverly handle this kind of situation? Another question: Does anybody know how the RAM Cache Manager decides to purge an object? Is that just done by setting the "cleanup intervall" Btw: While doing testing I compared the RAM Cache Manager to apache's mod_proxy and to no cache at all. I got (on a PII 350 +64Meg) no cache: approx. 8 hits/sec Ram Cache: approx.: 50 hits/sec Apache+proxy approx: 500 hits/sec I know the reasons, but I found it nonetheless interesting. cheers, oliver

2 1

Zope as Portal Server
by dave＠kovach.com 04 May '01

04 May '01

Hi - Was researching something for work and was curious if anyone had any thoughts as to how ZOPE could be used as a PORTAL SERVER? Portals being all the craze(!) in the enterprise-land - seems as if ZOPE or even cooler a "vertical" version of ZOPE geared towards specifically the needs of deploying and maintaining an Enterprise portal... Any thoughts on the topic? or on the topic of ZOPE in the enterprise? or on the topic of Vertical versions of the ZOPE application? Sincerely, David Kovach dave(a)kovach.com _____________________________________________________ Get your name as your email and web site address. http://www.NetIdentity.com. Be somebody online.

3 2

OO vs Relational Databases
by Lee Hunter 04 May '01

04 May '01

Interesting article on Slashdot this morning http://slashdot.org/features/01/05/03/1434242.shtml Looks at the pros and cons of usinng an OO database (the Zope model) versus rdbms. Cheers Lee Hunter _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

Zope book error or version difference?
by Dennis Nichols 04 May '01

04 May '01

Zope Book .pdf fetched today says on page 258 >ObjectManager Constructor > >manage_addDocument(id, title) > >Add a DTML Document to the current ObjectManager But when I call manage_addDocument from DTML using in Zope 2.2.2, it actually adds a DTML Method (!) However, manage_addDTMLDocument(id, title) does add a DTML Document. Could be a change between 2.2.2 and 2.3.x or it could be an error in the book, in which case I thought I should point it out. Or maybe I should've skipped the beer with dinner. -- Dennis Nichols nichols(a)tradingconnections.com

2 1

Sorting mod.time with dtml-in?
by Kai Hofmann 04 May '01

04 May '01

I thought that I could simply sort by modification time withe the following: <dtml-in expr="subdir.objectValues()" sort="bobo_modification_time"> but as it seems I am to stupid to understand Zope/Python, because this does not work :( Any hints? Thanks Kai -- Institut für Seeverkehrswirtschaft und Logistik http://www.isl.org/ Dipl.-Inform. Kai Hofmann mailto:hofmann@isl.org Universitaetsallee GW1 Block A phone:+49 421 22096-83 D-28359 Bremen fax:+49 421 22096-55

3 6

Re: Product Creation and Permission]
by Jason Joy 04 May '01

04 May '01

I also found this interesting. In a regular vanilla DTML document, if you put this in: <dtml-var "REQUEST['AUTHENTICATED_USER']"> You'll get something like this back: jj However, in method B of my Product, when it goes to the index_html for the product, and I put in the above, I get this back: Site Error An error was encountered while publishing this resource. exceptions.TypeError Sorry, a site error occurred. Traceback (innermost last): File /usr/local/Zope-2.3.2/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/Zope-2.3.2/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.2/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /usr/local/Zope-2.3.2/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: index_html) File /usr/local/Zope-2.3.2/lib/python/App/special_dtml.py, line 127, in __call__ (Object: index_html) File /usr/local/Zope-2.3.2/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__ (Object: index_html) File /usr/local/Zope-2.3.2/lib/python/DocumentTemplate/DT_Util.py, line 334, in eval (Object: REQUEST['AUTHENTICATED_USER']) (Info: REQUEST) File <string>, line 0, in ? File /usr/local/Zope-2.3.2/lib/python/DocumentTemplate/DT_Util.py, line 161, in careful_getitem TypeError: sequence index must be integer Which I think is directly related to what I am experiencing with getting the manage_main. Jason > The other thing I now notice is that you are mixing the old security > model with __ac_permissions__ with the new one "classSecurityInfo". > > This is likely confusing Zope. Drop the __ac_permissions__ stuff. > > -- > | Casey Duncan > | Kaivo, Inc. > | cduncan(a)kaivo.com > `------------------> > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1

2 1

Session scoped variables
by Tommy Johnson 04 May '01

04 May '01

Ok, now I have another question. How do you maintain state within Zope? I'm particularly interested in session scoped variables. Currently I'm trying to learn Zope by building an e-commerce application, and in all other languages, (ASP, ColdFusion, etc...) you have session scope available to you in order to track individual users, their individual shopping carts, customer info, etc. I haven't been able to find anything yet for Zope. It isn't something like SESSION.(whatever) is it? Also, does anyone know of a place that may have working examples of things of this nature. I'm thinking of publishing something like that (trials, discoveries, obstacles, how I solved them, and the like) after I complete this application. If I had something like that, it would benefit me greatly, so if there isn't anything out there ... Thanks in advance, Tommy _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com

3 2

SybaseDAv2
by Mike Thompson 04 May '01

04 May '01

Hello, We are using the Zope - Sybase DA (SybaseDAv2) to interface multiple application servers to a Sybase 11.9.2 backend server. Both are running Redhat 6.2. Periodically, the database connection is being lost on one or more of the application servers. When this happens, the DA database connection cannot be re-established until zope is restarted. Any requests made give the error '<method> is not connected to a database'. Access is no problem with the isql client from the same machine. It seems to me that the DA is getting into a state where it is blocking db requests for some reason. Has anyone else seen this type of behavior? Is there a fix or workaround? Thanks in advance, Mike Thompson Hilgraeve Inc.

1 0