Re: [Zope-dev] buildbot for ZTK released packages (linux 32)
Tres Seaver wrote: > I don't know yet -- I planned to look at the failure more closely, and > figure out something that would work with the newer mechanize. Just for your information, what we're doing is using wsgi_intercept, which hooks into zope.testbrowser, which uses mechanize. But I think we actually need more tests for it in zope.app.wsgi. Anyway, let me know if you need any help on this. Regards, Martijn ___ Zope-Dev maillist - Zope-Dev@zope.org https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] buildbot for ZTK released packages (linux 32)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martijn Faassen wrote: > Tres Seaver wrote: > >>> python 2.5 and 2.6 : >>> - zope.app.wsgi >> I plan to work on fixing this failure, which is due to moving the >> zope.testbrowser pin from 3.8.2 to 3,9.1. > > How are you going to fix it? I'm asking because we depend on > zope.app.wsgi for the browser testing of Grok now, at least on a branch. I don't know yet -- I planned to look at the failure more closely, and figure out something that would work with the newer mechanize. Tres. - -- === Tres Seaver +1 540-429-0999 tsea...@palladion.com Palladion Software "Excellence by Design"http://palladion.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkv0DTUACgkQ+gerLs4ltQ6rUgCePwYHmyagITfQ380VNoPzg6D4 L2oAmwQIxeajJwf17DudE0H8RND9mgxB =/Z10 -END PGP SIGNATURE- ___ Zope-Dev maillist - Zope-Dev@zope.org https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] buildbot for ZTK released packages (linux 32)
Tres Seaver wrote: >> python 2.5 and 2.6 : >> - zope.app.wsgi > > I plan to work on fixing this failure, which is due to moving the > zope.testbrowser pin from 3.8.2 to 3,9.1. How are you going to fix it? I'm asking because we depend on zope.app.wsgi for the browser testing of Grok now, at least on a branch. Regards, Martijn ___ Zope-Dev maillist - Zope-Dev@zope.org https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Problem in Fetching values from the ZSQL method
Hi Charlie,
Let me thank you first for the help.
SELECT
SecID
,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos
,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos
FROM Txntemp
WHERE Txntemp.fileImportID = < dtml-sqlvar seqID type="int" >
GROUP BY SecID
Could you please explain how to make use of the src__=True parameter and
where can we view exactly what SQL is being sent to the database.
Please clarify in details.
Charlie Clark-6 wrote:
>
> Am 19.05.2010, 09:48 Uhr, schrieb joseph_ig :
>
>> Hi all,
>
> Hiya Joseph,
>
> zope-db is a better list for this discussion.
>
>> I have written a ZSQL method named ('getSummaryValue') for fetching the
>> summary result from a table. Please see the following query.
>> SELECT
>> SecID
>> ,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos
>> ,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos
>> FROM Txntemp
>> WHERE Txntemp.fileImportID =
>> GROUP BY SecID
>
>> This ZSQL method takes a single parameter "seqID" of type "int"
>> This ZSQL method script is called within a Python_script as follows
>> context.getSummaryValue(seqID = SequenceID)
>
>> the "SequenceID" is passed in as a request variable to the python
>> script. I
>> have two sites one testing and another Live.
>
>> In testing site the script does return value for the sequenceID passed
>> into it as a request variable.
>
>> But while running in Live environment it doesn't return any value for
>> the sequenceID passed into it as a request variable.
>> But when the sequeneceID is hardcoded into the python script it does
>> return
>> the details in LIVE.
>
> I don't see seqID being used in the statement.
>
> You can debug the call by passing in the src__=True parameter. This will
> allow you to see exactly what SQL is being sent to the database.
>
>> Please help to resolve the issue. All help are really appreciated. Its
>> really critical Please help.
>
> Charlie
> --
> Charlie Clark
> Managing Director
> Clark Consulting & Research
> German Office
> Helmholtzstr. 20
> Düsseldorf
> D- 40215
> Tel: +49-211-600-3657
> Mobile: +49-178-782-6226
> ___
> Zope-Dev maillist - Zope-Dev@zope.org
> https://mail.zope.org/mailman/listinfo/zope-dev
> ** No cross posts or HTML encoding! **
> (Related lists -
> https://mail.zope.org/mailman/listinfo/zope-announce
> https://mail.zope.org/mailman/listinfo/zope )
>
>
--
View this message in context:
http://old.nabble.com/Problem-in-Fetching-values-from-the-ZSQL-method-tp28605115p28609879.html
Sent from the Zope - Dev mailing list archive at Nabble.com.
___
Zope-Dev maillist - Zope-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
https://mail.zope.org/mailman/listinfo/zope-announce
https://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] buildbot for ZTK released packages (linux 32)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christophe Combelles wrote: > It's live again. This one tests only released packages: Great! That should induce us to stay on the ball about making releases for 'fixcommitted' bugs. > http://buildbot.afpy.org/ztk1.0/waterfall > > Failures : > > python2.4 : zope > - zope.browserpage > - zope.viewlet > - zope.contentprovider > - zope.defferedimport > - zope.app.wsgi > > python 2.5 and 2.6 : > - zope.app.wsgi I plan to work on fixing this failure, which is due to moving the zope.testbrowser pin from 3.8.2 to 3,9.1. > python2.7b2 : > - zope.testing > - zope.formlib > - zope.proxy > - zope.exceptions > - zope.app.publisher > - zope.app.wsgi Tres. - -- === Tres Seaver +1 540-429-0999 tsea...@palladion.com Palladion Software "Excellence by Design"http://palladion.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkvz9NYACgkQ+gerLs4ltQ4wkgCfWYpnYHT4mkwWUIwRF4l7h12U 6M0An1a1jvDDbz08yxyL2ZZr3SkroM/k =PeYS -END PGP SIGNATURE- ___ Zope-Dev maillist - Zope-Dev@zope.org https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Problem in Fetching values from the ZSQL method
Am 19.05.2010, 09:48 Uhr, schrieb joseph_ig :
> Hi all,
Hiya Joseph,
zope-db is a better list for this discussion.
> I have written a ZSQL method named ('getSummaryValue') for fetching the
> summary result from a table. Please see the following query.
> SELECT
> SecID
> ,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos
> ,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos
> FROM Txntemp
> WHERE Txntemp.fileImportID =
> GROUP BY SecID
> This ZSQL method takes a single parameter "seqID" of type "int"
> This ZSQL method script is called within a Python_script as follows
> context.getSummaryValue(seqID = SequenceID)
> the "SequenceID" is passed in as a request variable to the python
> script. I
> have two sites one testing and another Live.
> In testing site the script does return value for the sequenceID passed
> into it as a request variable.
> But while running in Live environment it doesn't return any value for
> the sequenceID passed into it as a request variable.
> But when the sequeneceID is hardcoded into the python script it does
> return
> the details in LIVE.
I don't see seqID being used in the statement.
You can debug the call by passing in the src__=True parameter. This will
allow you to see exactly what SQL is being sent to the database.
> Please help to resolve the issue. All help are really appreciated. Its
> really critical Please help.
Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-600-3657
Mobile: +49-178-782-6226
___
Zope-Dev maillist - Zope-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
https://mail.zope.org/mailman/listinfo/zope-announce
https://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] Zope Tests: 12 OK, 8 Failed
Summary of messages to the zope-tests list. Period Tue May 18 12:00:00 2010 UTC to Wed May 19 12:00:00 2010 UTC. There were 20 messages: 6 from Zope Tests, 13 from ccomb at free.fr, 1 from ct at gocept.com. Test failures - Subject: FAILED : ZTK 1.0 / Python2.6.4 Linux 32bit From: ccomb at free.fr Date: Tue May 18 20:38:43 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014491.html Subject: FAILED: Repository policy check found errors in 583 projects From: ct at gocept.com Date: Tue May 18 21:18:57 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014492.html Subject: FAILED : ZTK 1.0dev / Python2.4.6 Linux 32bit From: ccomb at free.fr Date: Tue May 18 23:26:39 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014503.html Subject: FAILED : ZTK 1.0dev / Python2.5.2 Linux 32bit From: ccomb at free.fr Date: Tue May 18 23:27:06 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014504.html Subject: FAILED : ZTK 1.0dev / Python2.6.4 Linux 32bit From: ccomb at free.fr Date: Tue May 18 23:27:23 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014505.html Subject: FAILED : ZTK 1.0 / Python2.6.4 Linux 32bit From: ccomb at free.fr Date: Wed May 19 01:44:14 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014508.html Subject: FAILED : ZTK 1.0 / Python2.4.6 Linux 32bit From: ccomb at free.fr Date: Wed May 19 01:45:31 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014509.html Subject: FAILED : ZTK 1.0 / Python2.5.2 Linux 32bit From: ccomb at free.fr Date: Wed May 19 01:46:57 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014510.html Tests passed OK --- Subject: OK : Zope-2.10 Python-2.4.6 : Linux From: Zope Tests Date: Tue May 18 21:29:22 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014493.html Subject: OK : Zope-2.11 Python-2.4.6 : Linux From: Zope Tests Date: Tue May 18 21:31:22 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014494.html Subject: OK : Zope-2.12 Python-2.6.5 : Linux From: Zope Tests Date: Tue May 18 21:33:22 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014495.html Subject: OK : Zope-2.12-alltests Python-2.6.5 : Linux From: Zope Tests Date: Tue May 18 21:35:22 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014496.html Subject: OK : Zope-trunk Python-2.6.5 : Linux From: Zope Tests Date: Tue May 18 21:37:23 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014497.html Subject: OK : Zope-trunk-alltests Python-2.6.5 : Linux From: Zope Tests Date: Tue May 18 21:39:23 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014498.html Subject: OK : BlueBream template / Python2.5.2 32bit linux From: ccomb at free.fr Date: Tue May 18 22:00:53 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014499.html Subject: OK : BlueBream template / Python2.6.4 32bit linux From: ccomb at free.fr Date: Tue May 18 22:00:56 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014500.html Subject: OK : BlueBream template / Python2.4.6 32bit linux From: ccomb at free.fr Date: Tue May 18 22:00:58 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014502.html Subject: OK : BlueBream template / Python2.7b2 32bit linux From: ccomb at free.fr Date: Tue May 18 22:00:58 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014501.html Subject: OK : Zope 3.4.1 KGS / Python2.4.6 32bit linux From: ccomb at free.fr Date: Wed May 19 00:22:37 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014506.html Subject: OK : Zope 3.4.1 KGS / Python2.5.2 32bit linux From: ccomb at free.fr Date: Wed May 19 00:45:22 EDT 2010 URL: http://mail.zope.org/pipermail/zope-tests/2010-May/014507.html ___ Zope-Dev maillist - Zope-Dev@zope.org https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] buildbot for ZTK released packages (linux 32)
It's live again. This one tests only released packages: http://buildbot.afpy.org/ztk1.0/waterfall Failures : python2.4 : zope - zope.browserpage - zope.viewlet - zope.contentprovider - zope.defferedimport - zope.app.wsgi python 2.5 and 2.6 : - zope.app.wsgi python2.7b2 : - zope.testing - zope.formlib - zope.proxy - zope.exceptions - zope.app.publisher - zope.app.wsgi ___ Zope-Dev maillist - Zope-Dev@zope.org https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] Problem in Fetching values from the ZSQL method
Hi all,
I have written a ZSQL method named ('getSummaryValue') for fetching the
summary result from a table. Please see the following query.
SELECT
SecID
,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos
,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos
FROM Txntemp
WHERE Txntemp.fileImportID =
GROUP BY SecID
This ZSQL method takes a single parameter "seqID" of type "int"
This ZSQL method script is called within a Python_script as follows
context.getSummaryValue(seqID = SequenceID)
the "SequenceID" is passed in as a request variable to the python script. I
have two sites one testing and another Live.
In testing site the script does return value for the sequenceID passed into
it as a request variable.
But while running in Live environment it doesn't return any value for the
sequenceID passed into it as a request variable.
But when the sequeneceID is hardcoded into the python script it does return
the details in LIVE .
Please help to resolve the issue. All help are really appreciated. Its
really critical Please help.
--
View this message in context:
http://old.nabble.com/Problem-in-Fetching-values-from-the-ZSQL-method-tp28605115p28605115.html
Sent from the Zope - Dev mailing list archive at Nabble.com.
___
Zope-Dev maillist - Zope-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
https://mail.zope.org/mailman/listinfo/zope-announce
https://mail.zope.org/mailman/listinfo/zope )
