Using sqlacodegen #
Setup mysql, create user ants ###
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> CREATE USER ‘ants'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON angir.* TO 'ants'@'localhost' WITH GRANT OPTION;
Import schema from a mwb file ###
Open the mwb file in MySQLWorkbench and export the schema as angir.sql.
Replace default_schema with angir.
shell> mysql -u ants
mysql> create database angir;
mysql> use angir;
mysql> source path/to/angir.sql;
Install sqlacodegen, oursql###
pip install sqlacodegen
pip install oursql
Make models code from the created schema ###
sqlacodegen mysql+oursql://ants:some_pass@localhost/angir > generated_models.py
Recommended Posts