I try to run the use case of this project, this is my code:
`
import os
from sqlalchemy import create_engine
os.environ['CLASSPATH'] = "./postgresql-42.2.18.jar"
def connect(user, password, db, ip='127.0.0.1:5432'):
url = 'jdbcapi+pgjdbc://{}:{}@{}/{}'
url = url.format(user, password, ip, db)
con = create_engine(url)
return con
if name == 'main':
conn = connect('postgres', '123456', 'test')
execute = conn.execute("select * from admin")
print(execute)
`
And the following is the error I encountered:
What's wrong with this?
I try to run the use case of this project, this is my code:
`
import os
from sqlalchemy import create_engine
os.environ['CLASSPATH'] = "./postgresql-42.2.18.jar"
def connect(user, password, db, ip='127.0.0.1:5432'):
url = 'jdbcapi+pgjdbc://{}:{}@{}/{}'
url = url.format(user, password, ip, db)
con = create_engine(url)
return con
if name == 'main':
conn = connect('postgres', '123456', 'test')
execute = conn.execute("select * from admin")
print(execute)
`
And the following is the error I encountered:
What's wrong with this?