Skip to content

Instantly share code, notes, and snippets.

@pawl
Last active August 29, 2015 14:12
Show Gist options
  • Select an option

  • Save pawl/ec6c51d1a10ffa75bac3 to your computer and use it in GitHub Desktop.

Select an option

Save pawl/ec6c51d1a10ffa75bac3 to your computer and use it in GitHub Desktop.
Attempting to implement new column_editable_list in flask-admin
from datetime import date, datetime, time
from flask import Flask, request
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.admin.contrib import sqla
from flask.ext.admin import expose, Admin, AdminIndexView
app = Flask(__name__)
app.config['DATABASE_FILE'] = 'sample_db.sqlite'
app.config['SECRET_KEY'] = 'secret'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + app.config['DATABASE_FILE']
db = SQLAlchemy(app)
class Model1(db.Model):
def __init__(self, test1=None, test2=None, test3=None, test4=None,
bool_field=False, date_field=None, time_field=None, datetime_field=None,
int_field=None):
self.test1 = test1
self.test2 = test2
self.test3 = test3
self.test4 = test4
self.bool_field = bool_field
self.date_field = date_field
self.time_field = time_field
self.datetime_field = datetime_field
self.int_field = int_field
id = db.Column(db.Integer, primary_key=True)
test1 = db.Column(db.String(20))
test2 = db.Column(db.Unicode(20))
test3 = db.Column(db.Text)
test4 = db.Column(db.UnicodeText)
bool_field = db.Column(db.Boolean)
enum_field = db.Column(db.Enum('model1_v1', 'model1_v1'), nullable=True)
int_field = db.Column(db.Integer)
date_field = db.Column(db.Date)
time_field = db.Column(db.Time)
datetime_field = db.Column(db.DateTime)
class ModelAdmin(sqla.ModelView):
column_filters = ['datetime_field', 'date_field', 'test1', 'test2', 'test3', 'test4', 'bool_field', 'time_field', 'int_field']
column_editable_list = ['test1']
admin = Admin(app, template_mode="bootstrap3")
admin.add_view(ModelAdmin(Model1, db.session))
def build_sample_db():
db.drop_all()
db.create_all()
model_bool = Model1('model_bool', bool_field=True)
model1_obj2 = Model1('model1_obj2',)
model1_obj3 = Model1('model1_obj3', test2=u"blah")
model1_obj4 = Model1('model1_obj4', test3="blah")
model1_obj5 = Model1('model1_obj5', test4=u"blah")
date_obj1 = Model1('date_obj1', date_field=date(2014,11,17))
time_obj1 = Model1('time_obj1', time_field=time(11,10,9))
datetime_obj1 = Model1('datetime_obj1', datetime_field=datetime(2014,4,3,1,9,0))
int_obj1 = Model1('int_obj1', int_field=5000)
int_obj2 = Model1('int_obj2', int_field=9000)
db.session.add_all([
model_bool, model1_obj2, model1_obj3, model1_obj4, model1_obj5,
date_obj1, time_obj1, datetime_obj1, int_obj1, int_obj2
])
db.session.commit()
if __name__ == '__main__':
build_sample_db()
app.run(host="0.0.0.0", port=5001, debug=True)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment