I have an issue converting a .py to .exe using pyinstaller .
The program below works perfectly as a .py, but everything i tried to convert it to .exe with pyinstaller or auto-py-to-exe it gives an .exe file that produces absolutly no result.
pyinstaller runs an produces an exe file without error, but the exe file gives no result.
No errors are raised while creating the exe
The program through an SQL request is supposed to print a list of email comming from a postgresql base.
I ran the .py in spider and in cmd : everything is ok. i tried runing the exe in cmd, no errors but again : no results
Here is the .py :
import psycopg2
try:
# connect to PostgreSQL
conn = psycopg2.connect(
dbname="xxxx",
user="xxxx",
password="xxxx",
host="postgresql-xxxx-xxxx.xxxx.xxxx",
port="xxxx" # port par défaut PostgreSQL
)
# create cursor for SQL commands
cursor = conn.cursor()
# run selection
cursor.execute("SELECT email FROM membre")
# get results
rows = cursor.fetchall()
# print results
for row in rows:
print(row)
except Exception as e:
print(f"Une erreur est survenue : {e}")
finally:
# close cursor ant conn.
if cursor:
cursor.close()
if conn:
conn.close()
here is the code for convertion (i tried with a lot of hide-import, but nothing changes):
pyinstaller --onefile --hidden-import=psycopg2 --hidden-import=psycopg2._psycopg --hidden-import=psycopg2.extensions --hidden-import=psycopg2.extras --hidden-import=sqlalchemy.dialects.postgresql --hidden-import=sqlalchemy.dialects.postgresql.psycopg2 creation_userform_sans_sql.py
i tried to add hidden-imports (a lot !) also tried onefile or not... also tried auto-py-to-exe
finaly i found another postgres module that works when converted to .exe : pg8000
for the moment everything works in .exe as in .py.