flask_app.py

from flask import Flask
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.script import Manager
from flask.ext.migrate import Migrate, MigrateCommand


flask_app = Flask(__name__)
flask_app.secret_key = 'fhdjksfh7h38h3489fh3489fh3489hf938h'

# app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://ipostolaki@localhost/Books'
flask_app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///books.db'
flask_app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

db = SQLAlchemy(flask_app)
migrate = Migrate(flask_app, db)

manager = Manager(flask_app)
manager.add_command('db', MigrateCommand)


@flask_app.route('/')
def index():
    return 'This flask app will be used to view simulation data stored in the database'


#### ORM Storage Models

class StoredBook(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80))

    owner_id = db.Column(db.Integer, db.ForeignKey('stored_user.id'))
    holder_id = db.Column(db.Integer, db.ForeignKey('stored_user.id'))


class StoredUser(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True)
    own_books = db.relationship(StoredBook, backref='owner', lazy='dynamic', foreign_keys=[StoredBook.owner_id])
    holded_books = db.relationship(StoredBook, backref='holder', lazy='dynamic', foreign_keys=[StoredBook.holder_id])


if __name__ == '__main__':
    manager.run()