covert a table definition class from SQLAlchemy into vanilla MySQL

Question

I am trying to read in a database dump, but I must have the schema defined to do so.

Unfortunately (?), the schema was built using SQLAlchemy. The table definitions are implemented as such:

class Customer(Base):
    """Sqlalchemy model."""
    __tablename__ = "customer"

    id = Column(Integer, primary_key=True, autoincrement=False)

    name = Column('name', String(64), nullable=False)
    given_name = Column('given_name', String(32), nullable=True)
    family_name = Column('family_name', String(32), nullable=True)

etc etc.

Is there any way to easily convert this back into a MySQL table definition? I can't find anything that would do so. I would like to be able to do this in a scaleable manner, and not type it all by hand each time I have to do a database migration. I'm also suspecting that I'm not the first person to ever have tried this.

univerio · Accepted Answer · 2016-05-08 07:18:13Z

1

From the documentation:

from sqlalchemy.schema import CreateTable
print CreateTable(Customer.__table__).compile(engine)

answered May 8, 2016 at 7:18

univerio

20.7k3 gold badges73 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Monica Heddneck Over a year ago

Looks like it can't handle LONGTEXT type. :(

CompileError: (in table 'source', column 'html_source'): Compiler <sqlalchemy.sql.compiler.GenericTypeCompiler object at 0x7f8c1cf97cd0> can't render element of type <class 'sqlalchemy.dialects.mysql.base.LONGTEXT'>

univerio Over a year ago

@MonicaHeddneck It should. If you compile with your specific engine it should use a MySQL-specific compiler instead of GenericTypeCompiler, I believe.\

Monica Heddneck Over a year ago

Ah! from sqlalchemy import create_engine mysql_engine = create_engine('mysql://') from sqlalchemy.schema import CreateTable print CreateTable(Customer.__table__).compile(mysql_engine)

Collectives™ on Stack Overflow

covert a table definition class from SQLAlchemy into vanilla MySQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related