Another way to address Graziella's problem is to simply not create
what is being referred to as Table 1. Instead, use a join when
displaying the results and use two separate insert statements within
the ZSQL method to deal with insertions. For example, in the query
ZSQL method Graziella could include something like:

SELECT t1.col1, t2.col1
FROM table1 t1, table2 t2
WHERE t1.key = t2.key

And in the insert ZSQL method, Graziella could write something like:

INSERT INTO table1 (col1, col2, ...) VALUES(<dtml-sqlvar Table1Value1
type=int>, ...)
<dtml-var sql_delimiter>
INSERT INTO table2 (col1, col2, ...) VALUES(<dtml-sqlvar Table2Value1
type=int>, ...)


...Michael



On 1/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Send Zope-DB mailing list submissions to
        zope-db@zope.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://mail.zope.org/mailman/listinfo/zope-db
or, via email, send a message with subject or body 'help' to
        [EMAIL PROTECTED]

You can reach the person managing the list at
        [EMAIL PROTECTED]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Zope-DB digest..."


Today's Topics:

   1. modifications on a query (Graziella Toutoungis)
   2. Re: modifications on a query (Andreas Jung)
   3. Re: modifications on a query (Maciej Wisniowski)
   4. Re: modifications on a query (Charlie Clark)
   5. RE : Re: [Zope-DB] modifications on a query (Graziella Toutoungis)
   6. Re: RE : Re: [Zope-DB] modifications on a query (Charlie Clark)
   7. Re: RE : Re: [Zope-DB] modifications on a query
      (Maciej Wisniowski)


----------------------------------------------------------------------

Message: 1
Date: Fri, 26 Jan 2007 07:37:25 +0000 (GMT)
From: Graziella Toutoungis <[EMAIL PROTECTED]>
Subject: [Zope-DB] modifications on a query
To: zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="iso-8859-1"



Hello,

I use zope2.9.4 with postgresql8.1, in my database i have some tables are the 
result  of a query on other tables.
exe: table1 is the result of table2 with table3

My
user can connect to the database and he can modify the  table1, this
modification should done on the orginals tables table2 and table3
 my
problem is how  i can  specify the origin of the column in table for
verifing that table2 and table3 may this modifications?

thanks for all suggetions.

            G.




Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses.






Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses.







Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses.









___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses
http://fr.answers.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mail.zope.org/pipermail/zope-db/attachments/20070126/e5900565/attachment-0001.htm

------------------------------

Message: 2
Date: Fri, 26 Jan 2007 08:48:31 +0100
From: Andreas Jung <[EMAIL PROTECTED]>
Subject: Re: [Zope-DB] modifications on a query
To: Graziella Toutoungis <[EMAIL PROTECTED]>, zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"



--On 26. Januar 2007 07:37:25 +0000 Graziella Toutoungis
<[EMAIL PROTECTED]> wrote:

>
>
> Hello,
>
> I use zope2.9.4 with postgresql8.1, in my database i have some tables are
> the result  of a query on other tables.  exe: table1 is the result of
> table2 with table3
>
> My
> user can connect to the database and he can modify the  table1, this
> modification should done on the orginals tables table2 and table3
>  my
> problem is how  i can  specify the origin of the column in table for
> verifing that table2 and table3 may this modifications?
>

Please rephrase your question and point out the Zope specific part of the
question.

-aj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : 
http://mail.zope.org/pipermail/zope-db/attachments/20070126/c8f6d41e/attachment-0001.bin

------------------------------

Message: 3
Date: Fri, 26 Jan 2007 09:05:50 +0100
From: Maciej Wisniowski <[EMAIL PROTECTED]>
Subject: Re: [Zope-DB] modifications on a query
To: Graziella Toutoungis <[EMAIL PROTECTED]>
Cc: zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1


> I use zope2.9.4 with postgresql8.1, in my database i have some tables
> are the result  of a query on other tables.
> exe: table1 is the result of table2 with table3
>
> My user can connect to the database and he can modify the  table1,
> this modification should done on the orginals tables table2 and table3
>  my  problem is how  i can  specify the origin of the column in table
> for verifing that table2 and table3 may this modifications?
>
> thanks for all suggetions.
Is table1 a view?
What does 'table2 with table3' mean?
If you have SQL statement like:

select col1, col2, col3 from ....

then you know where columns come from... don't you?

--
Maciej Wisniowski


------------------------------

Message: 4
Date: Fri, 26 Jan 2007 14:07:32 +0100
From: "Charlie Clark" <[EMAIL PROTECTED]>
Subject: Re: [Zope-DB] modifications on a query
To: "Graziella Toutoungis" <[EMAIL PROTECTED]>,   zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8

Am 26.01.2007, 08:37 Uhr, schrieb Graziella Toutoungis
<[EMAIL PROTECTED]>:

>
> Hello,
> I use zope2.9.4 with postgresql8.1, in my database i have some tables
> are the result  of a query on other tables.
> exe: table1 is the result of table2 with table3
> My
> user can connect to the database and he can modify the  table1, this
> modification should done on the orginals tables table2 and table3
>  my
> problem is how  i can  specify the origin of the column in table for
> verifing that table2 and table3 may this modifications?

I am not exactly sure what you wish to do: is table1 simply a view based
on a query of table2 and table3? It certainly sounds like it should be.
But I am not sure if you update views in PostgreSQL that the original
tables get updated.

You might wish to ask your question again in French as some of us will at
least understand it like that.

Anway if you wish to update tables based on the results of queries in Zope
you are probably best using a PythonScript to link the appropriate queries
if this is not directly possible in SQL.

ie.

results = context.SQL.someQuery()
for result in results:
     context.SQL.anotherQuery(result) # you probably wish to pass a
dictionary based on the first query in

Charlie



------------------------------

Message: 5
Date: Fri, 26 Jan 2007 14:17:03 +0100 (CET)
From: Graziella Toutoungis <[EMAIL PROTECTED]>
Subject: RE : Re: [Zope-DB] modifications on a query
To: Maciej Wisniowski <[EMAIL PROTECTED]>
Cc: zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=iso-8859-1

in my database i want to create a table1 who is the
result of a query on table2 and table3 like select
x2,y2,x3,y3 from table2 and table3...
-i want now to create the table1.
-evrey time the user try to insert into table1, i must
insert this data in the original table and verify the
possibility of the insertion.

my code now return a list of column name's like
['id', 'title','phon',...]
i want to create table1 from this list, i don't know
how i can do it, my code is:

 query ="SELECT id, name, value, shipping FROM
customer, invoice, orderinfo WHERE customer.id =
invoice.customer_id            AND
invoice.order_id=orderinfo.order_id;"

    print query

    curs.execute(query)

    names= [f[0] for f in curs.description]
    print 'names%s' %names
    tableColumn = []
    for name in names:
        tableColumn.append(name)


    value = []
    for row in curs.fetchall():
        for pair in zip(row):
            value.append(pair)
            print '%s' %pair
        print

    print value

    i = 0
    column=[]

    for x in tableColumn:
            test = tableColumn[i].strip()
            i += 1
            print test
            column.append(test)
    print column



#    createQuery = 'CREATE TABLE test_fetch
%s'%tableColumn
#    print createQuery

    curs.execute("DROP TABLE test_fetch")
#    curs.execute(createQuery)

i will integrate in zope this code to create a form in
order to give the users the capability to manage my
database.

any suggestions?

--- Maciej Wisniowski
<[EMAIL PROTECTED]> a écrit:

>
> > I use zope2.9.4 with postgresql8.1, in my database
> i have some tables
> > are the result  of a query on other tables.
> > exe: table1 is the result of table2 with table3
> >
> > My user can connect to the database and he can
> modify the  table1,
> > this modification should done on the orginals
> tables table2 and table3
> >  my  problem is how  i can  specify the origin of
> the column in table
> > for verifing that table2 and table3 may this
> modifications?
> >
> > thanks for all suggetions.
> Is table1 a view?
> What does 'table2 with table3' mean?
> If you have SQL statement like:
>
> select col1, col2, col3 from ....
>
> then you know where columns come from... don't you?
>
> --
> Maciej Wisniowski
>







___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses
http://fr.answers.yahoo.com


------------------------------

Message: 6
Date: Fri, 26 Jan 2007 14:23:24 +0100
From: "Charlie Clark" <[EMAIL PROTECTED]>
Subject: Re: RE : Re: [Zope-DB] modifications on a query
To: "Graziella Toutoungis" <[EMAIL PROTECTED]>,   "Maciej
        Wisniowski" <[EMAIL PROTECTED]>
Cc: zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8

Am 26.01.2007, 14:17 Uhr, schrieb Graziella Toutoungis
<[EMAIL PROTECTED]>:

>     curs.execute("DROP TABLE test_fetch")
> #    curs.execute(createQuery)
> i will integrate in zope this code to create a form in
> order to give the users the capability to manage my
> database.
> any suggestions?

Yes, you might want to look at existing products for managing
tables/queries in Zope. Otherwise you should consider creating a Zope file
system product and check that you can access the execute() method of the
DA. This is certainly possible for our mxOBDC Zope DA but I think the
ZpyscopgDA also supports it.

Charlie


------------------------------

Message: 7
Date: Fri, 26 Jan 2007 14:24:25 +0100
From: Maciej Wisniowski <[EMAIL PROTECTED]>
Subject: Re: RE : Re: [Zope-DB] modifications on a query
To: Graziella Toutoungis <[EMAIL PROTECTED]>
Cc: zope-db@zope.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1


> any suggestions?
Write a procedure in the database that
does this and just call this procedure from Zope.

--
Maciej Wisniowski


------------------------------

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


End of Zope-DB Digest, Vol 42, Issue 16
***************************************

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Reply via email to