Starting Alembic migration to Google App Engine

Question

I have a Flask application that uses SQLAlchemy (Flask-SQLAlchemy) and Alembic (Flask-Migrate). The application runs on Google App Engine. I want to use Google Cloud SQL.

On my machine, I run python manage.py db upgrade to run my migrations against my local database. Since GAE does not allow arbitrary shell commands, how do I migrate to it?

Answer 1

• IP Local Computer White List: https://console.cloud.google.com/sql/instances/INSTANCENAME/access-control/authorization?project=PROJECTNAME
• Create user: https://console.cloud.google.com/sql/instances/INSTANCENAME/access-control/users?project=PROJECTNAME
• Assign an external IP address to the instance: https://console.cloud.google.com/sql/instances/INSTANCENAME/access-control/ip?project=PROJECTNAME
• Use the following SQLAlchemy connection URI: SQLALCHEMY_DATABASE_URI = 'mysql://user: pw@ip :3306/DBNAME'
• Remember to free up the IP address later as you pay for every hour that it has not used.

Answer 2

You can use the white IP address of your local computer for the Google Cloud SQL instance, then run the script on your local machine.

Answer 3

This is just code that you can run, so you can create an admin endpoint from which you can upgrade:

 @app.route('/admin/dbupgrade') def dbupgrade(): from flask_migrate import upgrade, Migrate migrate = Migrate(app, db) upgrade(directory=migrate.directory) return 'migrated' 

(Dropwizard, for example, is great for admin stuff like this through tasks )