Re: Database issues when adding GUI

On 6/7/21 9:00 AM, Rich Shepard wrote:
> 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

No this is because you did not use an actual connection string e.g:

psycopg2.connect("host=salmo user=rshepard dbname=bustrac")

Instead you used an undefined variable bustrac per the error message:

  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
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com