Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't transform *gz files to postgresql #15

Open
Merzouk-Ilyes opened this issue Mar 15, 2023 · 3 comments
Open

Can't transform *gz files to postgresql #15

Merzouk-Ilyes opened this issue Mar 15, 2023 · 3 comments

Comments

@Merzouk-Ilyes
Copy link

Traceback (most recent call last):
File "/Library/Frameworks/Python.framework/Versions/3.9/bin/imdbpy2sql.py", line 505, in
conn = setConnection(URI, DB_TABLES)
File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/imdb/parser/sql/alchemyadapter.py", line 455, in setConnection
engine = create_engine(uri, **params)
File "", line 2, in create_engine
File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/util/deprecations.py", line 277, in warned
return fn(*args, **kwargs) # type: ignore[no-any-return]
File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 693, in create_engine
raise TypeError(
TypeError: Invalid argument(s) 'encoding' sent to create_engine(), using configuration PGDialect_psycopg2/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

@Merzouk-Ilyes
Copy link
Author

I'm trying to load the *gz files to postgresql database but i'm getting this error which is related to encoding !

@Bouncner
Copy link
Contributor

Related? #14

@Merzouk-Ilyes
Copy link
Author

@Bouncner no i have a problem in the last step ( although this issue #14 still exists but i got the imdbpy2sql.py somewhere else) , the problem is in loading the GZ files to postgresql DB.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants