- Zope - Zope lists

Creating a Database connection.
by Darren Carney 05 Jan '01

05 Jan '01

Dear Zope, I am very new to the Zope idea. I like what Zope is trying to do. But I am trying to set up an external SQL database connection. I have read the information thats on the Zope website. It has not made it any clearer about setting up a DA and making the connection. Thanks in advance for any help that you would be able to supply. King regards Darren

1 0

How to call ancestral method in ZClass method?
by Dirksen 05 Jan '01

05 Jan '01

I have a ZClass 'stuff' which is a subclass of DataSkin. 'stuff' overrides 'manage_delete' method, so as to do some extra clean-up jobs. After that, it will call its ancestor's 'manage_delete' method to wipe itself off. In java, you can do this by calling 'super.manage_delete()', but how to do it in zope? Dirksen __________________________________________________ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

2 1

Is it possible to install the Bug Collector Product in my Zope ???
by Frederic Quin 05 Jan '01

05 Jan '01

Hi all, I can't find the bug collector product to install it in my zope. Maybe it's not possible... If it is, please tell me where to download it. Frederic

2 1

Re: [ZOPE] ZBabel translation to Postgres
by Olaf Zanger 05 Jan '01

05 Jan '01

hi Andrew and others, > I get errors: > when i first want to view a page with the <dtml-babel src=uk dst=de> > test</dtml-babel> > > pg.error > error value: error: attribute 'phrases_phrase_id_seq' not found i changed the column name of the id from "phrase_id" to "id" and get still the same error message as above. so i figured that my bug is not in my changes but somewhere in the python code. do you have any help? thanks olaf > you need in postgresql (this is tested only from zope with zsql method, > since some other things don't work in the ZBabel Produkt with > postgresql): > > sqlGetPhrasesToUpdate: > > select distinct Phrases.* > > WHERE md5Hash not in > ( > select c.md5Hash > from Phrases as c, Phrases as d > where c.md5Hash = d.md5Hash and c.lang <> d.lang and c.lang='<dtml-var > srcLang>' > ) > and lang <>'<dtml-var srcLang>' > > sqlNewPhrase: > > insert into Phrases (phrase_id,lang,md5Hash,renderPath,renderText) > values ( > nextval('phrases_phrase_id_seq'), > <dtml-sqlvar lang type=nb>, > <dtml-sqlvar md5Hash type=nb>, > <dtml-sqlvar renderPath type=nb>, > <dtml-sqlvar renderText type=nb> > ) > > all other sqlFunctions seam to work (out of zope ZSQL method) > > i attache the ZBabel.sql for postgres. > the examples are handgenerated so the hashes are fake. > > TAKE CARE > until now this just fakes the ability of ZBabel on Postgres on a ZSQL > Method level for testing purposes. > > I get errors: > when i first want to view a page with the <dtml-babel src=uk dst=de> > test</dtml-babel> > > pg.error > error value: error: attribute 'phrases_phrase_id_seq' not found > > probably that helps anybody > > olaf > > > | What does the whole thing do anyway? > > > > Finds all the phrases that don't have a translation for the language > > selected. It's hard to find things that don't exist in databases without > > nested selects which MySQL did not have at the time. > > > > MySQL was chosen precisely because it is restricted, and is basically the > > lowest common denominator when it comes to SQL. > > > > I do recall however, that postgres only implements INNER and OUTER joins > > although I don't know the status of the JOIN stuff in postgres at this time. > > > > | Has anybody ported ZBabel already? > > > > Someone was going to send me patches for postgres, but, I never received > > them. > > > > I'll happily integrate patches, although, automatically selecting the > > right query based on database type will be required so that several releases > > aren't required. I don't think that that's a hard thing to achieve. > -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com -- Sent through GMX FreeMail - http://www.gmx.net

2 1

Re: [Zope] Core Session Tracking kudos & namespaces
by Bob Sidebotham 05 Jan '01

05 Jan '01

--- Chris McDonough <chrism(a)digicool.com> wrote: > I sympathize with the need to convert all your scripts over to use > sessioning from hidden form-field encoding and the like... I'd really > appreciate some input as to what kinds of problems you're trying to > solve with sessioning. I don't have any great number of scripts to convert. I've only been looking at zope for a few weeks. I DO have a significant application that handles a customer database, supplier ordering, inventory management and the like. This is currently written in Perl/cgi, and is way too slow and cumbersome. I'd like to move it into zope and at the same time make the database directly available to customers. In the current implementation of the application I maintain a lot of state at the server side--the server knows the page history, locally configured options, and the like. In that application I actually force you to use server-side navigation, since I load over the existing page every time you make a request (so there is only one page ever resident in the browser). I did this to make it impossible for the operator to use an old browser page (with stale form info). This is ugly and requires two round-trips for each request. I'm trying to figure out how to move this into zope, and to do this in the most natural way possible. So I'd like to give up mostly on the server-side navigation stuff. But I do want to do things like: if you go from a main page to a form, then if the form succeeds I'd like to return you directly to the main page (with no extra page fetch). If the form fails, it might go back to the main page, or include the error somewhere in the main page. Since the form is likely to be unrelated to the main page (just linked to from it), I need at least some server state to tell me where to return. I can also imagine doing side trips from forms--but that's harder, because then the side trip can't involve a link, otherwise you lose the information typed in (I "solved" this in my current implementation by wrapping *every* page in one big form and making all the links actually do submits, using a little javascript, but again that's something I'd rather avoid--I'd rather it was simple and relatively unsurprising). I'm unclear as to how I should really implement any of this. It almost seems like there is some sort of abstraction here that can be turned into a generic facility, but I haven't groked zope enough to figure out how that would be plugged in and what it would look like. So anyway, this was supposed to be an answer to your question, but it's really a thinly disguised attempt to get some design help on this. Is there another forum purely for design help with this sort of thing? How to fit a particular navigational abstraction into the zope framework? Thanks, Bob __________________________________________________ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

1 0

Industry customer lists
by Luis Botelho 05 Jan '01

05 Jan '01

This email is to request information on your company for our on line directory and introduce you to our company Repharm. Best Regards, Dianne Edwards Tel: 905-721-8456 Fax: 905-721-1471 email: repharm(a)home.com Repharm has the following installed customer databases and services available to increase your sales. ERP: BAAN JD Edwards Lawson Marcam Oracle Applications Peoplesoft QAD (Worldwide) SAP SSA Symix CRM: Clarify Pivotal Siebel SUPPLY CHAIN: I2 Manugistics Synquest HARDWARE: AS400 OS390 HP SUN DESKTOP APPLICATIONS: Corel Lotus Notes Microsoft COMMUNICATIONS: ASP's CLECS ISP's E-COMMERCE: .com Directory Software Directory Consultant Directory CFO List CIO List INDUSTRY SPECIFIC LISTS: Agriculture, Forestry and Fishing Communications Construction Finance, Insurance and Real Estate Manufacturing Mining Public Administration Retail Trade Services Transportation Utilities Wholesale Trade FRONT OFFICE SERVICES: We offer the following Front Office Services: a.. Fax Campaigns b.. Telemarketing c.. Direct Mail Customer Satisfaction Surveys

3 2

case insensitive search?
by Robin Becker 04 Jan '01

04 Jan '01

Is there an easy way to make the Find tab case insensitive. It seems like a very common need, but I see that FindSupport.py is calling string.find which makes it seem as though this is harder than it should be. -- Robin Becker

4 8

Re: [Zope] Zope eating CPU/RAM - how do I find the culprit?
by Oliver Bleutgen 04 Jan '01

04 Jan '01

> Oliver Bleutgen writes: > > Shouldn't tags for creating sql-statements in ZSQL > > (like dtml-sqltest) quote the variables by default in order > > to prevent unexpected conversions by the database? > Did you check, that standard SQL supports quoted > names? First, I meant double quotes (") not single one's ('), in case that wasn't clear. I know that for mysql, postgres, oracle there are column names which will surely break dtml-sqltest as it is implemented now. Either lowercase letters (oracle, as you also noted) or uppercase (the other two). I guess sql-keywords and special characters as column names - ok, not a very clever idea - will break sqltest on all of them. At least I didn't find a way to get it to work without patching zope. Searching the web I find various hints that many odbc,jdbc adapters and sql-db frontends use quoted names per default (psql). Unfortunately I don't want to pay to the ANSI-commitee for reading into the sql-standard, but I'm pretty sure every newer database supports that. > Even if it does, the proposed change will probably break > lots of existing code. Right, how about adding a argument like, let's say "sql_quote"? ;) Unfortunatly, I fear I'm have not enough knowledge in zope's internals to offer a clean patch. > I fear, in our projects, the fact that case does not matter > has been widely used. > We would have to change hundreds of SQL methods > after the proposed change. > For new projects, I would like to have it your way. > However, this will be difficult to achieve. I would like to see quoting as a standard, but you have a point. Maybe sql_quote is the way to go. cheers, oliver

1 0

Re: [Zope] Zope redirecting manage_workspace?!
by Dieter Maurer 04 Jan '01

04 Jan '01

Edmund Goppelt writes: > ... manage_workspace redirects ... It does this, if the current permissions does not allow the use of any of the available tabs. Are you sure, you set the permission mappings correctly? Dieter

1 0

Re: [Zope] Zope eating CPU/RAM - how do I find the culprit?
by Dieter Maurer 04 Jan '01

04 Jan '01

Oliver Bleutgen writes: > Shouldn't tags for creating sql-statements in ZSQL > (like dtml-sqltest) quote the variables by default in order > to prevent unexpected conversions by the database? Did you check, that standard SQL supports quoted names? Even if it does, the proposed change will probably break lots of existing code. I fear, in our projects, the fact that case does not matter has been widely used. We would have to change hundreds of SQL methods after the proposed change. For new projects, I would like to have it your way. However, this will be difficult to achieve. Dieter

1 0