This repository was archived by the owner on Jan 28, 2021. It is now read-only.
This repository was archived by the owner on Jan 28, 2021. It is now read-only.
Possible error in SHOW CREATE TABLE #594
Closed
Description
SQLAlchemy says this:
/Users/erizocosmico/Library/Python/2.7/lib/python/site-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: u'`ref_name` TEXT NOT NULL,'
util.warn("Unknown schema content: %r" % line)
/Users/erizocosmico/Library/Python/2.7/lib/python/site-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: u'`commit_hash` TEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'
util.warn("Unknown schema content: %r" % line)
Traceback (most recent call last):
File "foo.py", line 7, in <module>
repo_df = pd.read_sql_table("refs", con=conn)
File "/Users/erizocosmico/Library/Python/2.7/lib/python/site-packages/pandas/io/sql.py", line 242, in read_sql_table
raise ValueError("Table %s not found" % table_name)
ValueError: Table refs not found
It's possible we have some kind of error in our SHOW CREATE TABLE
implementation.
Reproduction case:
import pandas as pd
import sqlalchemy
engine = sqlalchemy.create_engine('mysql+pymysql://[email protected]:3306/gitbase')
with engine.connect() as conn:
repo_df = pd.read_sql_table("refs", con=conn)