PyQt + PygreSQL

[Neil Zanella]

Hello,

I am using the following with python:

The PyQt python bindings:

http://www.riverbankcomputing.co.uk/pyqt/

based on the Qt GUI Application Framework:

http://www.trolletch.com/

as well as the PyGreSQL python bindings:

http://www.pygresql.org/

based on the PostgreSQL database server:

http://www.postgresql.org/

I have the following question. When I instantiate QDataTable with C++
I must ensure that a database connection is open, and then have no
problems, otherwise I will get popup widgets with errors.

How can I properly set the default database connection and have
QDataTable find it using the combination of Python + PyQt + PyGreSQL?

Thanks,

Neil

[Grzegorz Dostatni]

I don't know how to set it up using pygresql, but you can do it using
qtsql module. Just make sure that qt was compiled with the postgresql
support.

If you need to use pygresql for some reason, you could always try to have
multiple connections to the database from you code (one through qtsql
module, another through qtsql). That will probably get very ugly very
quickly.

Greg
On 10 Aug 2004 13:43:05 -0700, Neil Zanella <nz******@cs.mu n.ca> wrote:

I have the following question. When I instantiate QDataTable with C++
I must ensure that a database connection is open, and then have no
problems, otherwise I will get popup widgets with errors.

How can I properly set the default database connection and have
QDataTable find it using the combination of Python + PyQt + PyGreSQL?

Thanks,

Neil

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[Neil Zanella]

Grzegorz Dostatni <do*******@yaho o.com> wrote in message news:<op******* *******@news.sr v.ualberta.ca>. ..

I don't know how to set it up using pygresql, but you can do it using
qtsql module. Just make sure that qt was compiled with the postgresql
support.
Thanks, I should have used the Python equivalent of QSqlDatabase::a ddDatabase()
to connect to PostgreSQL instead of using PyGreSQL. That way QDataTable can
find and use the database connection handle it knows about. After all, PyQt
knows nothing about PyGreSQL: as you just pointed out the two packages are
completely unrelated and independent of each other.
If you need to use pygresql for some reason, you could always try to have
multiple connections to the database from you code (one through qtsql
module, another through qtsql).

Exactly, but actually now that you pointed this out to me I don't think
I will need PyGreSQL since I'm already using the Qt database module.

Thanks,

Neil