Open ddofborg opened 2 years ago
Hmmm I'm not sure what's happening there. Can you share the list of table names in the given database? One of them might contain only special characters and get normalized to None
...
Wrong button, good morning :)
It's a clean install of MySQL v8 on Ubuntu, only default databases and tables. I do see a utf8mb4
encoding of the tables. Could that be it?
PS. Maybe it's good to update the docs and remove MySQLDB from there.
If it helps, I can add the print
somewhere to see the value before normalisation. Just let me know where normalisation happens, and I will print
before that.
The only thing we're passing in there is schema
, which is None
as a default. This should be possible:
Can you try and remove the self.schema
from /home/dataset/venv/lib/python3.8/site-packages/dataset/database.py:184?
You mean from:
@property
def tables(self):
"""Get a listing of all tables that exist in the database."""
return self.inspect.get_table_names(schema=self.schema)
to:
@property
def tables(self):
"""Get a listing of all tables that exist in the database."""
return self.inspect.get_table_names()
Same thing...
Hmmm I really don't understand how this is caused by dataset
. Have you checked the upstream bug tracker at sqlalchemy to see if the issue is documented there? I don't have MySQL set up to test so it's a bit hard to debug/replicate.
I am trying to use dataset with MySQL 8.
I noticed
MySQLDB
is not really supported on Python3 and I found mysqlclient, which replacesMySQLDB
for Python 3.When I run the following:
I get:
I get this error for basically all commands. Any ideas what this could be?