Mailing List Archive: form-controllerPythonScript-ZSQL

form-controllerPythonScript-ZSQL

javi80mix at gmail

Mar 7, 2007, 1:35 AM

Post #1 of 7 (4496 views)

Hello everyone:
i´m doing a form where i get email and one ask. when I check that
email is valid, I do Controller Python Script where i want to create:
- DB conecction
- ZSQL method to modify DB
- get user session
and after i call a zpt, it tell me that all it´s ok

DB conection:

db_system_type = REQUEST.get('db_system_type', 'mysql')

from Products.ZMySQLDA import DA

DA.manage_addZMySQLConnection(self, db_conn_id, '',
REQUEST.get('db_conn_str', 'zforum@localhost zforum zforum'))

zsql:
how to do it????

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

Re: form-controllerPythonScript-ZSQL [ In reply to ]

charlie at egenix

Mar 7, 2007, 1:37 AM

Post #2 of 7 (4354 views)

Am 07.03.2007, 10:35 Uhr, schrieb javi lopez <javi80mix@gmail.com>:

> Hello everyone:
> iÂ´m doing a form where i get email and one ask. when I check that
> email is valid, I do Controller Python Script where i want to create:

Why do you need a DB connection per user? You can't do this in a
PythonScript. You will need to use an ExternalMethod or a Product but I
would guess you need to rethink your application.

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

Re: form-controllerPythonScript-ZSQL [ In reply to ]

maciej.wisniowski at coig

Mar 7, 2007, 1:42 AM

Post #3 of 7 (4344 views)

> zsql:
> how to do it????
Have you read 'Relational database connectivity' chapter of Zope Book?

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

Re: form-controllerPythonScript-ZSQL [ In reply to ]

javi80mix at gmail

Mar 7, 2007, 1:48 AM

Post #4 of 7 (4344 views)

All that is a little part of a Product, but i need check that´s ok ,
when I fill in the form , email and ask are stored in my DB with zsql
method, i need user to stored in DB too.
how could do it??
thanks

2007/3/7, Charlie Clark <charlie@egenix.com>:
> Am 07.03.2007, 10:35 Uhr, schrieb javi lopez <javi80mix@gmail.com>:
>
> > Hello everyone:
> > i´m doing a form where i get email and one ask. when I check that
> > email is valid, I do Controller Python Script where i want to create:
>
> Why do you need a DB connection per user? You can't do this in a
> PythonScript. You will need to use an ExternalMethod or a Product but I
> would guess you need to rethink your application.
>
> Charlie
>
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: form-controllerPythonScript-ZSQL [ In reply to ]

charlie at egenix

Mar 7, 2007, 1:54 AM

Post #5 of 7 (4334 views)

Am 07.03.2007, 10:48 Uhr, schrieb javi lopez <javi80mix@gmail.com>:

> All that is a little part of a Product, but i need check thatÂ´s ok ,
> when I fill in the form , email and ask are stored in my DB with zsql
> method, i need user to stored in DB too.
> how could do it??

I am sorry but I do not understand exactly what you want to do. Getting
connections on a per user basis doesn't seem to me to make a lot of sense
when using an application server like Zope. Generally you just need to get
hold of an existing connection object and ask it to do the SQL for you.

Good luck

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

Re: form-controllerPythonScript-ZSQL [ In reply to ]

javi80mix at gmail

Mar 7, 2007, 2:39 AM

Post #6 of 7 (4358 views)

My product is like a faq, i have a search engine, it search a
ask-answer in my portal, but if there isn´t result, i fill in a form,
it store email and ask of the user on my DB and when my admin knows
the answer, he answered to the user.
I have the product, but I don´t know how to do this part(form-store DB
with zsql method) inside my product
Any help???
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: form-controllerPythonScript-ZSQL [ In reply to ]

charlie at egenix

Mar 7, 2007, 2:53 AM

Post #7 of 7 (4351 views)

Am 07.03.2007, 11:39 Uhr, schrieb javi lopez <javi80mix@gmail.com>:

> My product is like a faq, i have a search engine, it search a
> ask-answer in my portal, but if there isnÂ´t result, i fill in a form,
> it store email and ask of the user on my DB and when my admin knows
> the answer, he answered to the user.
> I have the product, but I donÂ´t know how to do this part(form-store DB
> with zsql method) inside my product
> Any help???

from Products.ZSQLMethods.SQL import SQL

will let you handle SQL within a Product that you can then pass to your
connection object.

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