Now i installed zope2 2.13.7 and just added products.zsqlmethods in
buildout.cfg and also added entry as products.sqlmethods = 2.13.3 in
versions.cfg.
Then run the buildout and mkzopeinstance.
After instance is created, checked to add new zsql method.
But still there is no option to add it.
Also
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/27/2011 12:49 PM, c k wrote:
Now i installed zope2 2.13.7 and just added products.zsqlmethods in
buildout.cfg and also added entry as products.sqlmethods = 2.13.3 in
versions.cfg.
Then run the buildout and mkzopeinstance.
After instance is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/27/2011 02:39 PM, Tres Seaver wrote:
On 06/27/2011 12:49 PM, c k wrote:
Now i installed zope2 2.13.7 and just added products.zsqlmethods in
buildout.cfg and also added entry as products.sqlmethods = 2.13.3 in
versions.cfg.
Then run the
Hello all,
I am trying to install zsql methods in zope 2.13. After many retries i am
able to install it using buildout. Now it is not shown in the add listbox to
add new zsql methods. What is going wrong? Normally when it is installed
using buildout, it should be available in the listbox to add
Now i installed zope2 2.13.7 and just added products.zsqlmethods in
buildout.cfg and also added entry as products.sqlmethods = 2.13.3 in
versions.cfg.
Then run the buildout and mkzopeinstance.
After instance is created, checked to add new zsql method.
But still there is no option to add it.
Also
harshad behere wrote:
Dear list,
While inserting data into one of the oracle table's CLOB column using
zsql via python script, we observed that zope process (running in debug
mode) is getting terminated/killed if length of text data = 4094 with
message on command prompt
Input string too
Dear list,
While inserting data into one of the oracle table's CLOB column using
zsql via python script, we observed that zope process (running in debug
mode) is getting terminated/killed if length of text data = 4094 with
message on command prompt
Input string too long, limit 4096
Whereas
harshad behere wrote:
Dear list,
While inserting data into one of the oracle table's CLOB column using
zsql via python script, we observed that zope process (running in debug
mode) is getting terminated/killed if length of text data = 4094 with
message on command prompt
Input string too
harshad behere wrote:
Dear list,
While inserting data into one of the oracle table's CLOB column using
zsql via python script, we observed that zope process (running in debug
mode) is getting terminated/killed if length of text data = 4094 with
message on command prompt
Input string too
Maciej Wisniowski wrote:
It works something like this::
(...)
If in the folder 'sql/Userstuff' you have a file called
'select_users.sql' you will the be able to just run:
# select users:
print SQLUser.select_users()
# same but first printed the final SQL used
print
I've developed a little module that makes it really easy to plug in .sql
files into a python product class as ZSQLMethods. It's extremely easy to
use and doesn't require any CMF or ZODB stuff. It also has support for
memcache for those of you with slow db queries that you need to repeat.
It
It works something like this::
(...)
If in the folder 'sql/Userstuff' you have a file called
'select_users.sql' you will the be able to just run:
# select users:
print SQLUser.select_users()
# same but first printed the final SQL used
print SQLUser.select_users(debug__=True)
# save
Hi there,
I am implementing a tool to handle userdata that is stored in a MySQL db.
The underlaying logic of the stored procedures used to maintain the db
content
dictate that I have to control the transactions myself.
I understand that there is a way to handle transaction controll in the
ZMySQL
robert rottermann schrieb:
Hi there,
I am implementing a tool to handle userdata that is stored in a MySQL db.
The underlaying logic of the stored procedures used to maintain the db
content
dictate that I have to control the transactions myself.
Can you elaborate on that? I dont see a reason
Are you sure it doesn't do it out of the box?
I know it does for ZPsycopgDA which is the Postgresq Zope database adapter.
With that one I don't have to come near handling the SQL transactions.
What Zope commits and rollsback is done for SQL too automatically.
robert rottermann wrote:
Hi
robert rottermann wrote at 2007-1-10 09:00 +0100:
...
I am implementing a tool to handle userdata that is stored in a MySQL db.
The underlaying logic of the stored procedures used to maintain the db
content
dictate that I have to control the transactions myself.
If you know what you do, then you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
I am implementing a tool to handle userdata that is stored in a MySQL
db. The underlaying logic of the stored procedures used to maintain the
db content dictate that I have to control the transactions myself.
I understand that there is a
Am 10.01.2007, 13:00 Uhr, schrieb robert rottermann [EMAIL PROTECTED]:
I understand that there is a way to handle transaction control in the
ZMySQL methods. However I find no documentation at all on how to use it.
This is incorrect. ZSQL methods are called within Zope transactions so you
thanks charlie,
so that means, that the _commit and _abort methods are only for zope's
transaction controll.
Yes, and with good reason.
But I think that if you know what your'e doing you may
use them althought it may be tricky. It is better to
try external method like Charlie suggested for
In a PostgreSQL DB I have a Numeric data type with a precision of two
decimal places. If I have 1.33 in as the result from my query, it's
everything is good. However, if I have 1.30 it reduces the precision
to one decimal place and I get 1.3. Not so good when dealing with
currency ( I don't
Maciej Wisniowski schrieb:
In a PostgreSQL DB I have a Numeric data type with a precision of two
decimal places. If I have 1.33 in as the result from my query, it's
everything is good. However, if I have 1.30 it reduces the precision
to one decimal place and I get 1.3. Not so good when dealing
Hi:
In a PostgreSQL DB I have a Numeric data type with a precision of two
decimal places. If I have 1.33 in as the result from my query, it's
everything is good. However, if I have 1.30 it reduces the precision
to one decimal place and I get 1.3. Not so good when dealing with
currency ( I don't
At Tuesday 24/10/2006 01:05, Jason C. Leach wrote:
In a PostgreSQL DB I have a Numeric data type with a precision of two
decimal places. If I have 1.33 in as the result from my query, it's
everything is good. However, if I have 1.30 it reduces the precision
to one decimal place and I get 1.3.
Jason C. Leach wrote:
Hi:
In a PostgreSQL DB I have a Numeric data type with a precision of two
decimal places. If I have 1.33 in as the result from my query, it's
everything is good. However, if I have 1.30 it reduces the precision
to one decimal place and I get 1.3. Not so good when dealing
Aloha,
I think so, for the moment anyhow!
Thanks all,
John S.
Cliff Ford wrote:
Comment on Peter's suggestion: I am no expert on these things, but it is
my understanding that for MySQL LAST_INSERT_ID() fetches the last
autoincrement value made by the current insert, so the outcome is not
This is how it works for MySQL:
insert into org (org_name, org_phone) values ('x', 'y')
dtml-var sql_delimiter
select LAST_INSERT_ID() as org_id
You have to have the select LAST_INSERT_ID call in the same query as the
insert, and you have to have the sql_delimiter.
I assume you know that the
What if you have 1,000,000 requests/sec?
What if between the INSERT and the LAST_INSERT_ID() another INSERT is made?
I use PostgreSQL and with postgres you can always ask the sequence what
the next id is going to be. It goes something like this::
next_id = context.GetNextId()[0].next_id
Peter Bengtsson wrote:
What if you have 1,000,000 requests/sec?
What if between the INSERT and the LAST_INSERT_ID() another INSERT is made?
I use PostgreSQL and with postgres you can always ask the sequence what
the next id is going to be. It goes something like this::
next_id =
Aloha,
Is this even easier solution only for postgreSQL, or is it for MySQL?
I am going to have to start working with integrating MySQL into
zope-based stuff soon so I'm trying to get a head start... :-)
thanks,
John S.
Tino Wildenhain wrote:
Peter Bengtsson wrote:
What if you have
Comment on Peter's suggestion: I am no expert on these things, but it is
my understanding that for MySQL LAST_INSERT_ID() fetches the last
autoincrement value made by the current insert, so the outcome is not
affected by virtually simultaneous requests. And I don't think MySQL
accepts a value
New to python/Zope, old-timer on PHP
I'm using MySQL and a ZSQL method to insert data into the database. ex:
insert into org (org_name, org_phone) values ('x', 'y')
What I'm trying to figure out is that org_id (also part of the org
table, but not specified in the sql statement) is an
=
',rstat.data_dictionary()print 'rstat.dictionaries=
',rstat.dictionaries()
hth
Jonathan
- Original Message -
From:
Benjamin
Menking
To: zope@zope.org
Sent: Monday, July 17, 2006 1:01 PM
Subject: [Zope] ZSQL Method
Question
New to python/Zope, old-timer
Alle 18:42, lunedì 19 dicembre 2005, hai scritto:
Pier Luigi Fiorini wrote:
Hello,
I'm developing a Zope application that uses a PostgreSQL connection and
several ZSQL objects.
People should log in using a Postgres user and ZSQL object should be
executed by the user that's logged in.
Pier Luigi Fiorini wrote:
Alle 18:42, lunedì 19 dicembre 2005, hai scritto:
Pier Luigi Fiorini wrote:
Hello,
I'm developing a Zope application that uses a PostgreSQL connection and
several ZSQL objects.
People should log in using a Postgres user and ZSQL object should be
executed by the user
Hello,
I'm developing a Zope application that uses a PostgreSQL connection and
several ZSQL objects.
People should log in using a Postgres user and ZSQL object should be executed
by the user that's logged in. Multiple people can be logged at the same time.
Unfortunately it is not possible
Pier Luigi Fiorini schrieb:
Hello,
I'm developing a Zope application that uses a PostgreSQL connection and
several ZSQL objects.
People should log in using a Postgres user and ZSQL object should be executed
by the user that's logged in. Multiple people can be logged at the same time.
On Mon, Dec 19, 2005 at 03:39:51PM +0100, Tino Wildenhain wrote:
Pier Luigi Fiorini schrieb:
Hello,
I'm developing a Zope application that uses a PostgreSQL connection and
several ZSQL objects.
People should log in using a Postgres user and ZSQL object should be
executed by the user that's
--On 19. Dezember 2005 15:32:46 +0100 Pier Luigi Fiorini
[EMAIL PROTECTED] wrote:
Hello,
I'm developing a Zope application that uses a PostgreSQL connection and
several ZSQL objects.
People should log in using a Postgres user and ZSQL object should be
executed by the user that's logged in.
Am Montag, den 19.12.2005, 15:43 +0100 schrieb Reinoud van Leeuwen:
The postgresql commandline tool psql has a command /user to change the
details of the current connection. Wouldn't it be easier to use a command
like that at the beginning of each database request?
Well this \connect
Ed Colmar wrote:
Will the database be queried for all results, and only have 20
displayed, or will the database just return the 20 that are needed?
The database will get hammered every time ;-)
There was a thread between myself and Charlie from eGenix on the zope-db
list earlier this
Do ZSQL methods communicate with the dtml-in call and understand the
size attribute?
for example, in this dtml-in statement:
dtml-in SQL_get_large_list size=20 start=query_start
/dtml-in
Will the database be queried for all results, and only have 20
displayed, or will the database just return
Ed Colmar wrote:
Do ZSQL methods communicate with the dtml-in call and understand the
size attribute?
for example, in this dtml-in statement:
dtml-in SQL_get_large_list size=20 start=query_start
/dtml-in
Will the database be queried for all results, and only have 20
displayed, or will the
Am Donnerstag, den 08.12.2005, 13:46 -0800 schrieb Ed Colmar:
Do ZSQL methods communicate with the dtml-in call and understand the
size attribute?
Not really.
for example, in this dtml-in statement:
dtml-in SQL_get_large_list size=20 start=query_start
/dtml-in
Will the database be
Hi
I have been using ZSQLMethods object some with some without pluggable
brains. I have come across a problem where the results of the sql query are not
refreshed even thought the database is updated. I have noticed that the problem
only occurs to those ZSQLMethods that have pluggable
Green things,
Am I missing something, or should I just simply not be using ZSQL methods in
my ZClass? If I try to add one, I get an error about there not being a DB
connection object (which makes sense) and won't let me add the object.
I was planning on making the constructor find all
Has anybody selectively used SELECT INTO with zope/postgres?
Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86)
Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3]
System Platform: linux2
ZPyGreSQLDA-0-0-3
I'm trying something like:
SELECT DISTINCT
song,
Has anybody selectively used SELECT INTO with zope/postgres?
Make that succesfully.
Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86)
Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3]
System Platform: linux2
ZPyGreSQLDA-0-0-3
I'm trying something
+---[ Steve Drees ]--
| Has anybody selectively used SELECT INTO with zope/postgres?
It's probably dying because there can only be ONE SELECT clause in a
ZSQL Method. The SELECT ... INTO will be triggering a false positive.
--
Totally Holistic Enterprises Internet|
Centre for Computing Services|
| Imperial College |
+--+
-Original Message-
From: Mayers, Philip J [mailto:[EMAIL PROTECTED]]
Sent: 18 January 2001 22:37
To: '[EMAIL PROTECTED]'
Subject: [Zope] ZSQL, Python methods and XMLRPC
I've three questions
I've three questions (but I'm making progress!):
1) In 2.2.5, how can I call a ZSQL method from a Python Method - I'm passing
the method in as a parameter, and the furthest I get says "__call__ not
defined".
Do PythonScripts obivate the need for this? I assume I can just do this:
for record in
Ok, here's the situation.
I create a folderish object. I insert some info into the postgresql
database related to this folderish object. I create a ZPopy database
connection within this folderish object. All of this is done through a
python method.
If I do a query using this new database
Yellow ppl,
I think everybody already had this problem...
Suppose you have a DB connection in /root/subfolder/DB_conn
then you build lots of zsql objects from that point down...
then you move the DB connection object up to the root.
result: all ZSQL's have to be changed to assume the DB_conn
Wednesday, November 08, 2000 4:00 AM
Subject: [Zope] ZSQL is killing me...
Yellow ppl,
I think everybody already had this problem...
Suppose you have a DB connection in /root/subfolder/DB_conn
then you build lots of zsql objects from that point down...
then you move the DB connection object
Hi!
I'm trying to emulate an outter join in a Z SQL, but Zope crashes every
time I try the query.
The query is defined as:
-*-*-
parameters: username
query definition:
select codigo, nome, 'T' as select
from cad_exportacao
where codigo in (
select codigo
from user_codigo
Cesar A. K. Grossmann wrote:
Hi!
I'm trying to emulate an outter join in a Z SQL, but Zope crashes every
time I try the query.
...
What is wrong? What I can do to get the job done (I need to fill an
multiselect with 'codigo', 'nome' from 'cad_exportacao', and if exists
any 'codigo' for
I'm not sure why this should *crash* zope, but you can do it with a much
simpler query and a little DTML coding. The following should work
(UNTESTED):
It cannot help me.
I have two tables. One called cad_exportacao, and the other is called
user_codigo. The table user_codigo maps every
, November 02, 2000 12:08 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope] ZSql Strange Error
I'm not sure why this should *crash* zope, but you can do it with a much
simpler query and a little DTML coding. The following should work
(UNTESTED):
It cannot help me.
I have
Casey Duncan wrote:
Duh, maybe I should learn to read.
:-)
Let me know if this is any better,
It worked! Thanks.
[]s
--
César A. K. Grossmann
http://members.xoom.com/ckant/
___
Zope maillist - [EMAIL PROTECTED]
Hi all
Can someone please tell me what is going on here?
I have an query that selects data into a temp table.
It then deletes some stuff from the temp table
Then is deletes some more stuff
Then i select the remaining records and drop the table
The problem is that when i try to select the
Hi,
I'm trying to perform a simple MySQL lookup based on the
AUTHENTICATED_USER. When I test the ZSQL method from the management
interface, everything works fine. However, when I try to call the method
from a DTML document, [it] returns nothing.
Is this a namespace issue? I'm stumped and hoping
I'm pretty sure that all variables have to be passed in explicitly
with SQLMethods. Namespaces are not passed in.
Try specifying username as an argument in the ZSQLMethods edit form
and pass it in like this:
dtml-in expr=
"lookup_by_username(username=REQUEST.AUTHENTICATED_USER.getUserName()"
sigh /
Thanks. It was a syntax issue. I think I tried every single variation on
passing variables to the method except that one. Sorry for the bother,
folks... :-)
On 18 Oct 2000, Jon Prettyman wrote:
I'm pretty sure that all variables have to be passed in explicitly
with SQLMethods.
meter list for this SQL method as well,
though it may not need to be...
Steve
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jon
Prettyman
Sent: Thursday, 19 October 2000 8:18
To: [EMAIL PROTECTED]
Subject: Re: [Zope] ZSQL Method AUTHENTICATED_USER
I'm p
I have a table with lots of data in my Gadfly database. I would like to add
a couple of new columns to that table. Is it at all possible to add columns
to existing table or do I have to create a new table all together?
Regards,
George
___
Zope
I have a table with lots of data in my Gadfly database. I would like to add
a couple of new columns to that table. Is it at all possible to add columns
to existing table or do I have to create a new table all together?
Nope,
ALTER TABLE TABLE_NAME ADD COLUMN_NAME FORMAT_TYPE
i think should
Greetings,
I have a lot of past experience with tuning and timing on Oracle (quite
simple), but I seem to have hit a hurdle with timing my sql statements in
MySQL. Getting these timings are _incredibly_ important to finding
bottlenecks in a web site's performance...
Now, first, is it possible
I'm answering myself because I found a solution to my problem, and I
wanted to share the results with the list, in case someone is struggling
to try to do the same thing...
The problem with mysql (go easy, we're not talking about the fact that
mysql is primitive and overall does not match up to
The Oracle8i recordset I'm retrieving includes a few columns which
are NUMBER(10,0) format which are milliseconds. I would like to
divide each by 1000 and use the ROUND function to return a result
with one decimal place, e.g. ROUND(column1/1000, 1).
This works as expected in SQL*Plus. It
Tom Deprez writes:
... nested Z SQL method call ...
I do not understand fully, what you want to do.
But the following FAQ may also be your problem:
Z SQL methods do *NOT* use the DTML namespace
for parameters.
You must either pass the parameters explicitly:
Dear all,
I'm a happy Zope user (in a private environment), experienced in
client-server application development but still quite green regarding to
Zope. I'm trying to figure out how I can use database locking using ZSQL
and MySQL. What is the case? I would like to implement a multi-user update
Hi,
I use an ZSQLMethod to query a database. In the result report I try to
insert the results of another ZSQLMethod per each record of the first
result report. The problem is that the first record shows the correct
result of the second result, but that the following records all show the
second
Hello,
I get a trailng "L" on smallint variables from ZSQL/MySQL on 2.1.4 (prod
server) but not on 2.1.6 (developt server).
I do remember a post some times ago about that, BUT i can't find it
again on the archives despite my (weak ?) efforts..
Any info/tip would be great as the production 2.1.4
Hi,
I have installed Openticket an the
appropiate database .. when I now
go into Openticket and select the
"sqlGenTicketId" - ZSQL-method for
testing the database-connection I get:
Error, exceptions.KeyError: unhandled
SQL used:
select max(ticket_id)+1 as new_ticket_id from tickets
In the
Hi,
I have a text file object containing data I want to use to update a MySQL
table.
I can get the data using the LocalFS object product and the howto from
jfarr, but I don't know how to use ZSQL method and DTML method to inject
this data in the table.
Any help would be appreciated.
Regards,
Andreas writes:
ZSQLMethod's "advanced" property 'Maximum number of rows retrieved'
makes no sense to me.
It prevents stupid queries to kill Zope.
Assume, such a query returns 100.000.000 records.
This probably will let Zope require several GB memory.
As I know so far there is no way to
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andreas
Sent: Saturday, June 10, 2000 1:59 AM
To: Umesh Soni
Cc: Phill Hugo; [EMAIL PROTECTED]
Subject: Re: [Zope] ZSQL method broken on 2.1.6
(using zope 2.1.6 with ZMySQLDA-2.0.0a1
Umesh Soni wrote:
(using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
Hi there,
I had this ZSQL method (simplified for clarity) working on 2.1.4
select id, nickname from bboard
where id=50
order by id desc
limit 30
Remove either the limit 30 or the LIMIT 1000 Advanced
Umesh Soni wrote:
(using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
Hi there,
I had this ZSQL method (simplified for clarity) working on 2.1.4
select id, nickname from bboard
where id=50
order by id desc
limit 30
Remove either the limit 30 or the LIMIT
Umesh Soni wrote:
Umesh Soni wrote:
(using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
Hi there,
I had this ZSQL method (simplified for clarity) working on 2.1.4
select id, nickname from bboard
where id=50
order by id desc
limit 30
Remove either
newid
/dtml-in
___
Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andy
Sent: Wednesday, May 17, 2000 7:45 PM
To: [EMAIL PROTECTED]
Subject: [Zope] ZSQL-Methods: last inserted id
PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
// Jonathan Park
// Sent: Thursday, May 18, 2000 1:35 PM
// To: [EMAIL PROTECTED]
// Subject: [Zope] zsql method??/
//
//
// Hello everyone!
//
// I have a dtml method that calls in the sql method like this
//dtml-in sql method
// the result I
81 matches
Mail list logo