[Python]Use Flask-Admin with PostgreSQL

This code recipe gives you an idea of how to use Flask-Admin with postgresql database.

from flask import Flask
from flask.ext.admin import Admin
from flask.ext.admin import BaseView
from flask.ext.admin import expose
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.admin.contrib.sqla import ModelView


app = Flask(__name__)

app.config['SECRET_KEY'] = '123456790'
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:postgres123@localhost/scrapy'

db = SQLAlchemy(app)


admin = Admin(app)

class MyView(BaseView):
    @expose('/')
    def index(self):
        return self.render('index.html')

class Cars(db.Model):
    
    can_create = False
    
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(64))
    price = db.Column(db.String(64))
    
admin.add_view(MyView(name='Hello'))
admin.add_view(ModelView(Cars, db.session))

if __name__ == '__main__':
    app.run(host='0.0.0.0',port=8080,debug=True)
    


posted @ 2017-06-08 13:32  cxchanpin  阅读(722)  评论(0编辑  收藏  举报