Mysql and Python 3.8 about dataset HOT 7 OPEN

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

from dataset.

Wrong button, good morning :)

from dataset.

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.

from dataset.

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.

from dataset.

The only thing we're passing in there is schema, which is None as a default. This should be possible:

https://docs.sqlalchemy.org/en/14/core/reflection.html#sqlalchemy.engine.reflection.Inspector.get_table_names

Can you try and remove the self.schema from /home/dataset/venv/lib/python3.8/site-packages/dataset/database.py:184?

from dataset.

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

from dataset.

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.

from dataset.