Created
November 4, 2014 08:52
-
-
Save remirobert/0b10fd63a7f0cadd024e to your computer and use it in GitHub Desktop.
Create database with sqlalchemy for flask web app
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!flask/bin/python | |
from migrate.versioning import api | |
from flask import Flask | |
from flask.ext.sqlalchemy import SQLAlchemy | |
import os.path | |
basedir = os.path.abspath(os.path.dirname(__file__)) | |
app = Flask(__name__) | |
db = SQLAlchemy(app) | |
SQLALCHEMY_DATABASE_URI = 'sqlite:///' + os.path.join(basedir, 'app.db') | |
SQLALCHEMY_MIGRATE_REPO = os.path.join(basedir, 'db_repository') | |
db.create_all() | |
if not os.path.exists(SQLALCHEMY_MIGRATE_REPO): | |
api.create(SQLALCHEMY_MIGRATE_REPO, 'database repository') | |
api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO) | |
else: | |
api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, api.version(SQLALCHEMY_MIGRATE_REPO)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment