Re: Database issues when adding GUI

On Mon, 7 Jun 2021, Adrian Klaver wrote:

> What Philip is suggesting is to use Python only simple script to connect to 
> database and retrieve from table. Something like:
>
> import psycopg2
>
> con = psycopg2.connect(<connection_str>)
> cur = con.cursor()
> cur.execute('select * from activitytypes')
> rs = cur.fetchall()
> print(rs)

Adrian,

>>> con = psycopg2.connect(bustrac)
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
NameError: name 'bustrac' is not defined

That's because there's a problem with connecting to the database. See my
reply to Rob's message.

Thanks,

Rich