from flask import Flask
from flask.ext.admin import Admin
from flask.ext.admin.contrib import sqlamodel

from sqlalchemy import create_engine, Column, Integer, Unicode
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session, sessionmaker

Base = declarative_base()


class User(Base):
    __tablename__ = 'user'

    id = Column(Integer, primary_key=True)
    name = Column(Unicode(64))


# Create application
app = Flask(__name__)
app.config['SECRET_KEY'] = '123456790'

# Create SQLA session
engine = create_engine('sqlite:///dummy.sqlite')
Base.metadata.create_all(engine)
session = scoped_session(sessionmaker(bind=engine))

# Flask initialization here
admin = Admin(app)

# Pass a session object here. You might want to store it elsewhere.
admin.add_view(sqlamodel.ModelView(User, session))

# Start app
app.debug = True
app.run()