March 2001 - Zope - Zope lists

Re: [Zope] ZCatalog page...
by afterz＠zipmail.com 23 Mar '01

23 Mar '01

Ok, thanks. And where can I find it? Somebody has an example of formating date and time for bobobase_modification_time? Bye. --- In zope@y..., "Chris McDonough" <chrism@d...> wrote: Take a look in the help system under API Documentation for both ZCatalog and dtml-in. ----- Original Message ----- From: "After Dark" <afterz@z...> To: <zope@z...> Sent: Friday, March 23, 2001 10:02 AM Subject: [Zope] ZCatalog page... > > Hi, I`m developing a search for a site and I`m using > ZCatalog. > I made a basic search, but now I don`t know how to get the > number of rows resulted from the search, and how to make it > show the results by pages. > Is there a manual reference that show me all the functions > of ZCatalog, and/or a page/source that show me how to do all > that? > > I`d like something like zope.org`s search, but in there I > just got a piece of code, and didn`t helped much. > > Thanks. > > -- > --Ricardo Kohler > Costa > ________________________________________________ > Don't E-Mail, ZipMail! http://www.zipmail.com/ > > > _______________________________________________ > Zope maillist - Zope@z... > 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 ) > _______________________________________________ Zope maillist - Zope@z... 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 ) --- End forwarded message ---

1 0

Re: Mysql on Windows will not connect [SOLVED]
by Aaron Held 23 Mar '01

23 Mar '01

My mistake, the last email was incorrect. I downloaded MySQL-python-0.3.4.tar.gz but actually installed the windows version MySQL-python-0.3.3-win32-2.zip which is not supported by ZMySQLDA-2.0.5.tar.gz So I uninstalled ZMySQLDA-2.0.5 and installed ZMySQLDA-2.0.4.tar.gz I can query the database and everybody is happy. Thanks anyway, -Aaron ----- Original Message ----- From: "Aaron Held" <aaron(a)metrony.com> To: <zope(a)zope.org> Sent: Friday, March 23, 2001 12:02 PM Subject: Mysql on Windows will not connect > I am trying to setup a Z MySQL Database Connection to hit a local mysql server and keep getting errors. > > When I try to login with the following connection string: > > varex varex varex > > I get this error > Error Type: OperationalError > Error Value: (1045, "Access denied for user: 'varex@localhost' (Using password: YES)") > > If I try > > varex(a)10.4.4.78 varex varex > > I get this error > > Error Type: AttributeError > Error Value: server_capabilities > > I can login either way via the mysql command line. > > I can also use the python-mysql adapter from the pyton runtime that came with Zope > > D:\Python_Mysql\examples>d:\website\bin\python deirdre.py > Color number 1L is red > Color number 2L is blue > Color number 3L is yellow > > I do not know how to test teh Zope Mysql DA outside of Zope. > > Anyway I am running > Win98 > Zope 2.3.0 (from Zope-2.3.0-win32-x86.exe) > mysql on windows 3.23.28-gamma-debug > ZMySQLDA-2.0.5.tar.gz > MySQL-python-0.3.4.tar.gz > > Any pointers on what to do next? > > -Aaron > =================================================================== > As Isaac Newton would say now: > If I see further than others, it is because I stand on > the shoulders of giants too dumb to patent their discoveries. > (Gregory Palast, http://www.observer.co.uk/ ) > >

1 0

ZCatalog page...
by After Dark 23 Mar '01

23 Mar '01

Hi, I`m developing a search for a site and I`m using ZCatalog. I made a basic search, but now I don`t know how to get the number of rows resulted from the search, and how to make it show the results by pages. Is there a manual reference that show me all the functions of ZCatalog, and/or a page/source that show me how to do all that? I`d like something like zope.org`s search, but in there I just got a piece of code, and didn`t helped much. Thanks. -- --Ricardo Kohler Costa ________________________________________________ Don't E-Mail, ZipMail! http://www.zipmail.com/

2 1

Mysql on Windows will not connect
by Aaron Held 23 Mar '01

23 Mar '01

I am trying to setup a Z MySQL Database Connection to hit a local mysql server and keep getting errors. When I try to login with the following connection string: varex varex varex I get this error Error Type: OperationalError Error Value: (1045, "Access denied for user: 'varex@localhost' (Using password: YES)") If I try varex(a)10.4.4.78 varex varex I get this error Error Type: AttributeError Error Value: server_capabilities I can login either way via the mysql command line. I can also use the python-mysql adapter from the pyton runtime that came with Zope D:\Python_Mysql\examples>d:\website\bin\python deirdre.py Color number 1L is red Color number 2L is blue Color number 3L is yellow I do not know how to test teh Zope Mysql DA outside of Zope. Anyway I am running Win98 Zope 2.3.0 (from Zope-2.3.0-win32-x86.exe) mysql on windows 3.23.28-gamma-debug ZMySQLDA-2.0.5.tar.gz MySQL-python-0.3.4.tar.gz Any pointers on what to do next? -Aaron =================================================================== As Isaac Newton would say now: If I see further than others, it is because I stand on the shoulders of giants too dumb to patent their discoveries. (Gregory Palast, http://www.observer.co.uk/ )

1 0

Re: [Zope] CatalogAware & Catalog.
by Bak ＠ kedai 23 Mar '01

23 Mar '01

>Casey, thanks. That means it must always be "Catalog" if I want to use >CatalogAware? Therefore every time I search a new document it doesn't have to be. you can name your catalog anything, as long as you remember to reindex it properly check out http://www.zope.org/Members/kedai/BuildSimpleZClass it's not perfect, but it's there. comments welcome which inherit >CatalogAware as the base class, I will find this new item from searching? > > pattreeya. > >> >> CatalogAware looks for a ZCatalog named "Catalog" (with a capital "C"). >> Make sure the id of your ZCatalog is set to "Catalog" and it is >> acquirable by the CatalogAware objects. Therefore it needs to be at or >> above the CatalogAware objects in your Zope hierarchy. >> >> A caveat about CatalogAware, it only catalogs objects when the are >> created, deleted or moved. When you change their properties they are not >> automatically recataloged. To recatalog a CatalogAware object, call its >> reindex_object() method. > >_______________________________________________ >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 ) >

1 0

Re: [Zope] can't install PoPy
by Bak ＠ kedai 23 Mar '01

23 Mar '01

-----Original Message----- From: Damir Bartakovic <damir(a)stud.fbi.fh-darmstadt.de> To: zope(a)zope.org <zope(a)zope.org> Date: Friday, March 23, 2001 8:43 PM Subject: [Zope] can't install PoPy >on RedHat 7.0 >Postgres 7.0.2 in /usr/postgres (from the source .gz) >Zope 2.3.0 in /home/zope (from the source .gz) > >./configure --with-python=/home/zope/bin/python --with-postgres-libraries=/ u >sr/postgres/lib --with-post >gres-includes=/usr/postgres/include > when i installed PoPy on my rh 7, with postgres & postgresql-devel from rpm, i use with-libs=/usr/lib with-includes=/usr/include/pgsql >and some other combinations without effect. > >I am a bit confused, because I can't remember a problem on my previous >installation on RedHat 6.2. >Do I have to build the /usr/lib/python1.5/config/Makefile somehow? >why are the PostgreSQL Libraries not found? > >Any clues? >Thanks in advance! > > >_______________________________________________ >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 ) >

1 0

RE: [Zope] PythonScript editing time
by Mayers, Philip J 23 Mar '01

23 Mar '01

Urk. OK - My Zope installation had died, apparently. I started to get the PCGI process dying and those long timeouts I mentioned, so I just rebuilt Zope from scratch and exported/imported the application - it's all super-snappy now <sigh> Sorry for the false alarm - but it did seem to degrade without any external input, and a "Pack" attempt on the database failed with "I/O Error: 5". Hmm... Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Evan Simpson [mailto:evan@4-am.com] Sent: 23 March 2001 16:00 To: Mayers, Philip J; zope(a)zope.org Subject: Re: [Zope] PythonScript editing time From: "Mayers, Philip J" <p.mayers(a)ic.ac.uk> > I've got a large-ish pythonscript that does some pretty ugly stuff - the > application pattern requires it be a single script. Editing it (hitting > Change on the TTW interface) takes a long (10sec-ish) time. Is this > expected? Zope appears to peg the CPU at the same time... How largish, exactly? A big enough script could certainly take a while to apply restrictions to, but I have to admit that I haven't benchmarked Script compilation. Cheers, Evan @ digicool & 4-am

1 0

How slow should dtml-var be? (was: RE: [Zope] Problems with *BIG* SQL queries)
by Mayers, Philip J 23 Mar '01

23 Mar '01

As mentioned, I'm doing really big SQL queries which return a HTML report that's about 1Mb. The ZopeTime trick suggested by Alan helps a lot - the time spent really is on the Zope side, and happens even with the most minimal file - just a: <dtml-var "ZopeTime()"> <dtml-in QUERY> <dtml-var column1>,<dtml-var column2>,<dtml-var column3>,<dtml-var column4> </dtml-in> <dtml-var "ZopeTime()"> This takes about 4 minutes *on the server* - file return is quick. *Sigh*. This however: <dtml-var "ZopeTime()"> <dtml-in QUERY> </dtml-in> <dtml-var "ZopeTime()"> Takes about 30 seconds (which is reasonable): HTTP/1.1 200 OK Date: Wed, 21 Mar 2001 14:02:07 GMT Server: Apache/1.3.14 (Unix) (Red-Hat/Linux) X-Powered-By: Zope (www.zope.org) Python (www.python.org) Vary: Authorization Content-Length: 94 Connection: close Content-Type: text/plain 2001/03/21 14:02:07.2783 GMT 2001/03/21 14:02:46.6733 GMT I can only assume it's the namespace lookup in <dtml-var variable> - in fact, my calculations (9575 rows, 4 <dtml-var>s per row) make that 6ms per dtml-var, which isn't unreasonable. I guess I really do just have too much data... Using a PythonScript: print context.ZopeTime() for result in container.QUERY(): print "%s,%s,%s,%s" % (r.column1,r.column2,r.column3,r.column4) print context.ZopeTime() return printed ...doesn't seem to help Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

5 4

PythonScript editing time
by Mayers, Philip J 23 Mar '01

23 Mar '01

I've got a large-ish pythonscript that does some pretty ugly stuff - the application pattern requires it be a single script. Editing it (hitting Change on the TTW interface) takes a long (10sec-ish) time. Is this expected? Zope appears to peg the CPU at the same time... Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

2 1

Re: [Zope] Python console
by Karl Anderson 23 Mar '01

23 Mar '01

"Chris McDonough" <chrism(a)digicool.com> writes: > No magic. Same thing. Last I tried you needed to set some environment variables, modify according to your setup: os.environ['INSTANCE_HOME'] = '/u1/Portal/Devel/ZapCentral' # path to the top of the instance os.chdir('/u1/Portal/Devel/Zope-2_2-branch/lib/python') # lib/python dir in the server tree os.environ['ZEO_SERVER_PORT'] = '5802' import ZServer import Zope app = Zope.app() I remind myself of this at <http://www.zope.org/Members/karl/zeoConnectionReminder>. -- Karl Anderson karl(a)digicool.com

2 1