July 2000 - Zope - Zope lists

Re: [Zope] upgrade to 2.2 and zsql methods problems
by J�lio Dinis Silva 17 Jul '00

17 Jul '00

I have the exact same problem. Júlio >From: "Erik Myllymaki" <erik(a)pacific-shores.com> >To: <zope(a)zope.org> >Subject: [Zope] upgrade to 2.2 and zsql methods problems >Date: Sun, 16 Jul 2000 22:34:28 -0700 > >Hello, > >I just upgraded to 2.2 from 2.1.6 on a WinNT machine. Things went well, >except my zsql methods won't run from the site. I can manage and test them >from the management pages, but if I call them from the site I get an >*unauthorized* error. This happens even wen I log in as superuser or the >owner of that zsqlmethod object. I have tried to recreate some of the >queries from scratch and applying new ownership and wide open permissions, >but this doesn't seem to work either. > >Zope is running as a service and I am using the ODBC adapter to connect to >MSSQL Server. As I say, the queries all un as expected from the management >test screens. > >Any ideas? > >Thanks, > >Erik Myllymaki >erik(a)pacific-shores.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 Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Re: [Zope] Long Data Type
by Dieter Maurer 17 Jul '00

17 Jul '00

Ronnie Sengupta writes: > Can anybody who has succesfully managed to insert text data (greater than 2k > or 4k) into Oracle 8i 8.1.6 with DCOracle version 1.3.1 please explain how > it is to be done. > > I have seen several other posts in this mailing list. But nothing fruitful. > > The same goes for Stored Procedures. Can't get them to work either. > > I am a web developer for a site called www.zdnetindia.com. We are using Zope > with Mysql. Planning on Migrating to Oracle. DCOracle currently does not support LOB's (neither CLOB's nor BLOB's). DC is looking for funders to upgrade DCOracle to use the Oracle 8 OCI interface. Currently, the Oracle 7 OCI interface is used mainly with a few 8 extensions. Dieter

2 1

suggestions for what to run in front of ZEO'ed zopes for failover?
by Roman Milner 17 Jul '00

17 Jul '00

I'm wondering if anyone can suggest something good to run in front of 2 zopes talking to a zeo server - for failover and load balancing. I have been using a tool called 'balance' which works really well - but for failover it only works if the socket to one of the zope servers doesn't connect. We occasionally have a situation where the socket will still answer but the zope server hanges and never returns an answer. So, I'm looking for something with configurable timeouts on responses. Does any one know of anything like that? Thanks, ^Roman

3 2

CalendarTag fix for Zope 2.2
by Tres Seaver 17 Jul '00

17 Jul '00

Here is a small patch to make the lovely calendar tag play nice with DT_Util.namespace() in Zope 2.2: $ diff -c lib/python/Products/Calendar/CalendarTag.py \ lib/python/Products/Calendar/CalendarTag.py.org *** lib/python/Products/Calendar/CalendarTag.py Sun Jul 16 21:39:27 2000 --- lib/python/Products/Calendar/CalendarTag.py.org Sun Jul 16 21:41:40 2000 *************** *** 248,254 **** __call__ = render def render_day_(self, md, date, firstday): ! ns = namespace(md, date = date, mode = self.mode, firstday = firstday, --- 248,254 ---- __call__ = render def render_day_(self, md, date, firstday): ! ns = namespace(self, date = date, mode = self.mode, firstday = firstday, namespace() now insists that its self argument be an InstanceDict, which caused it to barf. -- ========================================================= Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

3 2

Re: [Zope] ZCatalog
by Chris McDonough 17 Jul '00

17 Jul '00

Jonathan, Please respond to the list as well as to me so others can benefit. What's happening here is that your catalog is named "s". I should have noticed this the first time around. But I didn't. The bit you want is: <a href="<dtml-var "s.getpath(data_record_id_)">"> <dtml-var title> Whether you use "raw" or "title" depends on what you want to see. If you want to see the "raw" DTML that makes up the object that gets referenced in the catalog as a link, use "raw". If you want to see the title as a link, use "title". If your catalog isn't named "s", and the DTML is actually wrong where it says "<dtml-in s size=50 start=query_start>", change "s" to whatever the catalog is named. What Zope is doing: 1. Iterating over the catalog in batches of fifty responses in the line that says: <dtml-in s size=50 start=query_start> 2. Doing some stuff at the beginning of the batch (all the "if sequence-start" stuff) 3. Showing results, if any with a link (the bit you're adding) 4. Doing some stuff at the end of a batch (all the "if sequence-end" stuff) 5. Showing a meaningful message if there were no results. Jonathan Desp wrote: > > yes, so I quess: > > <a href="<dtml-var "catalog.getpath(data_record_id_)">"> > <dtml-var title> > > will become: > > <a href="<dtml-var "catalog.getpath(data_record_id_)">"> > <dtml-var raw> > > then I did it, > > here I tryed my search: > > http://www.atomasoft.com/gosearch > > and it's not working. > > All is great with my source or I need to shutdown zope if I want to see the > result working.. ? > > Do you know if there is any other changing to do? > > here is my new source again: > > <dtml-var standard_html_header> > <dtml-in s size=50 start=query_start> > <dtml-if sequence-start> > > <dtml-if previous-sequence> > > <a href="<dtml-var URL><dtml-var sequence-query > >query_start=<dtml-var > previous-sequence-start-number>"> > (Previous <dtml-var previous-sequence-size> results) > </a> > > </dtml-if previous-sequence> > > <table border> > <tr> > <th>Raw</th> > </tr> > > </dtml-if sequence-start> > > <tr> > <td><a href="<dtml-var "catalog.getpath(data_record_id_)">"><dtml-var > raw></a></td> > </tr> > > <dtml-if sequence-end> > > </table> > <dtml-if next-sequence> > > <a href="<dtml-var URL><dtml-var sequence-query > >query_start=<dtml-var > next-sequence-start-number>"> > (Next <dtml-var next-sequence-size> results) > </a> > > </dtml-if next-sequence> > </dtml-if sequence-end> > > <dtml-else> > > There was no data matching this <dtml-var title_or_id> query. > > </dtml-in> > > <dtml-var standard_html_footer>

2 2

Re: [Zope] Newbie: Build Object Names
by Dieter Maurer 17 Jul '00

17 Jul '00

Terry Babbey writes: > I find I am really struggling trying to learn the syntax and variables for > the various commands. Would an understanding of Python help me to understand > the Zope > commands better and is there good documentation for Python that does not > expect the reader to have a large background knowledge? I do not think that an understanding of Python will help you much with DTML (of cause, it would not harm but help, but not too much). In DTML, you only have to do with Python expressions: you see them enclosed in "...". Python expressions are a small part of Python (which is small by itself!). You have: the usual arithmetic operators: +, -, *, /, % strings: enclosed in '...', '''...''' or "...", """...""" (the two latter forms will not work in DTML!) lists: [], [1,2,3], ['a','b','c','d'] with methods "append(element)" and "insert(where,element)" (and some more) tuples: (), (1,), (1,2,3,), ('a','b') with '+' as concatenation and [i] for subscription dictionaries: {}, { 1: 'a'}, { 'a' : 'AAA', 'b' : 'BBB',} i.e. sets of key/value pairs. They support "[key]" for subscription. They have methods "update(dict)" and "clear()", "get(key,default=None)". functions: called by "function(argumentlist)", e.g. "int('0')", "sql_method(user='dieter',city='St. Ingbert') Arguments can be positional or keyword. Arguments can have default values and then be omitted in function calls. instances (of classes): with the infix '.' operator for attribute/method access: e.g. "[].append(1)", "[].insert(0,'a')", "object.id". Functions of instances are called methods. They have as implicit (on call) first argument the object they belong to. exceptions: raised with "raise" and catched with try: protected code except: exception handling uncaught exceptions produce the tracebacks you sometimes see in Zope error pages. Strings, lists, and tuples together are called sequences. They are '+' as concatenation, '*' as repetition and '[i]' as subscription. You can use the infix operator 'in' to test for containment. The "len" function can be used to determine the number of elements. Like all object oriented systems, Python relies heavily on object classes and extension modules. They are much more voluminous and complex than Python itself. One such framework (set of intertwined modules and classes) is Zope. It, itself, is far more complex than the complete Python. Especially, its namespace handling and the powerfull acquisition adds significantly to the complexity. If you need them, you must get aquainted with the methods of the various Zope objects (folders, images, DTML methods, DTML documents, ...), too. The namespace object "_" provides much of the interface to Python. Look at its documentation in the DTML guide. In general, you do not need all arguements of DTML tags or Zope objects. You should have a rough feeling, what is there and go into details when you need it. Dieter

1 0

Re: [Zope] DTML?
by Dieter Maurer 17 Jul '00

17 Jul '00

R. David Murray writes: > On Tue, 11 Jul 2000, Chris Withers wrote: > > Tino Wildenhain wrote: > > > I want that too. When we are over it, how about replacing (or at least > > > aliasing) > > > these - variables to _ ? sequence-item, sequence-index etc. comes to > > > mind. > > > > IF you've got a patch that will do this, please mail it to me and stick > > it in the collector... > > Note that DC has in the (recent) past expressed reluctence to do > this. I don't understand why. Something about namespace pollution? I understand the namespace problem. However, a prefix "dtml_" (or something similar) may be a better solution than using letters not allowed in Python names. Dieter

1 0

Re: [Zope-dev] SQL-Methods
by Dieter Maurer 17 Jul '00

17 Jul '00

Andre Schubert writes: > i ave a problem, i do some sql-queries in my python product and would > return the results like the ZSQLMethods. > How do i have to return the data and field names from my python product > to an dtml document so that i can work with it like ZMYSQL. "dtml-in" expects its argument to behave like a sequence of objects. It makes the current object's attributes available for direct access. Z SQL Methods use the class "Shared.DC.ZRDB.Results.Results" for results which in turn uses a subclass of "Shared.DC.ZRDB.Record" to wrap the rows. Look at the code in "Shared/DC/ZRDB" on how to use them. Dieter

1 0

MetaPublisher DB - was linuxworld article
by Mark Pratt 17 Jul '00

17 Jul '00

hi, Gijs Reulen wrote: > Has anyone at Digital Creations yet taken a look at > Beehive's MetaPublisher ? I think that is the way to go > for the short term (Studio being long term) ! Nice > looking browser interface, combining data and > databases, wizards, etc. before people get confused when gijs is referring to "databases" in the above statement he`s referring to a MetaPublisher version which he and a few other brave members of the MetaPublisher mailinglist are currently testing. this version gives users a choice whether to store data in the ZODB or in an external relational DB. this version will come with a few other goodies --- but we prefer to keep some things a surprise. regards, mark -------------------------------------------------------------- mark pratt (managing director) mark(a)beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

3 5

Re: [Zope] DTML Problem (from the newbie "hair ripper" category)
by Dieter Maurer 17 Jul '00

17 Jul '00

Darin Lee writes: > Here is the proverbial rub. If I want to *test* for the presence of > "navigation_name" so I can print "title_or_id" if it's not defined, Zope > simply skips the "navigation_name" property. It's like it always evaluates > to false! > <dtml-in "objectValues(['Category'])"> > <dtml-with sequence-item> > <dtml-if "hasProperty('navigation_name')"> > <dtml-var navigation_name> > <dtml-else> > <dtml-var title_or_id> > </dtml-if> > </dtml-with> > </dtml-in> > > Doesn't work! I do not yet know the method "hasProperty". As a short term work around, you may try directly: <dtml-if navigation_name> <dtml-var navigation_name> <dtml-else> <dtml-var title_or_id> </dtml-if> This may acquire "navigation_name". Thus, you may restrict namespace lookup with: <dtml-with sequence-item only> <-- code above--> </dtml-with> Dieter

1 0