mt.sql.mysql
Useful modules for accessing MySQL
Functions
list_views(): Lists all views of a given database.rename_table(): Renames a table of a schema.list_columns_ext(): Lists all columns of a given table of a given schema.list_columns(): Lists all columns of a given table of a given schema.rename_column(): Renames a column of a table.drop_column(): Drops a column of a table.
- mt.sql.mysql.list_views(db_name, engine)
Lists all views of a given database.
- Parameters:
db_name (str) – a valid dtabase name returned from show_databases()
engine (sqlalchemy.engine.Engine) – an sqlalchemy connection engine created by function create_engine()
- Returns:
out – list of all view names
- Return type:
list
- mt.sql.mysql.rename_table(old_table_name, new_table_name, engine, schema=None)
Renames a table of a schema.
- Parameters:
old_table_name (str) – old table name
new_table_name (str) – new table name
engine (sqlalchemy.engine.Engine) – an sqlalchemy connection engine created by function create_engine()
schema (str or None) – schema name
- mt.sql.mysql.list_columns_ext(table_name, engine, schema=None)
Lists all columns of a given table of a given schema.
- Parameters:
schema (str or None) – a valid schema name returned from list_schemas()
table_name (str) – a valid table name returned from list_tables()
engine (sqlalchemy.engine.Engine) – an sqlalchemy connection engine created by function create_engine()
schema – schema name
- Returns:
out – a table of details of the columns
- Return type:
pandas.DataFrame
- mt.sql.mysql.list_columns(table_name, engine, schema=None)
Lists all columns of a given table of a given schema.
- Parameters:
table_name (str) – a valid table name returned from list_tables()
engine (sqlalchemy.engine.Engine) – an sqlalchemy connection engine created by function create_engine()
schema (str or None) – schema name
- Returns:
out
- Return type:
list of all column names
- mt.sql.mysql.rename_column(table_name, old_column_name, new_column_name, engine, schema=None)
Renames a column of a table.
- Parameters:
table_name (str) – table name
old_column_name (str) – old column name
new_column_name (str) – new column name
engine (sqlalchemy.engine.Engine) – an sqlalchemy connection engine created by function create_engine()
schema (str or None) – schema name
- mt.sql.mysql.drop_column(table_name, column_name, engine, schema=None)
Drops a column of a table.
- Parameters:
table_name (str) – table name
column_name (str) – column name
engine (sqlalchemy.engine.Engine) – an sqlalchemy connection engine created by function create_engine()
schema (str or None) – schema name