Attempting to demonstrate issue #737

issue737.py

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

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, enum_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.enum_field = enum_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_v2'), 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 Model2(db.Model):
    def __init__(self, string_field=None, int_field=None, bool_field=None, model1=None):
        self.string_field = string_field
        self.int_field = int_field
        self.bool_field = bool_field
        self.model1 = model1

    id = db.Column(db.Integer, primary_key=True)
    string_field = db.Column(db.String)
    int_field = db.Column(db.Integer)
    bool_field = db.Column(db.Boolean)
    enum_field = db.Column(db.Enum('model2_v1', 'model2_v2'), nullable=True)

    # Relation
    model1_id = db.Column(db.Integer, db.ForeignKey(Model1.id))
    model1 = db.relationship(Model1, backref='model2')
        
class ModelAdmin(sqla.ModelView):
    can_edit = False
    can_delete = False
    can_create = False
    column_filters = ['datetime_field', 'date_field', 'test1', 'test2', 'test3', 'test4', 'bool_field', 'time_field', 'enum_field', 'int_field']

class Model2Admin(sqla.ModelView):
    can_edit = False
    can_delete = False
    can_create = False
    column_filters = ['model1', 'string_field']
    
admin = Admin(app, template_mode="bootstrap3")
admin.add_view(ModelAdmin(Model1, db.session))
admin.add_view(Model2Admin(Model2, 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))
    enum_obj1 = Model1('enum_obj1', enum_field='model1_v1')
    
    int_obj1 = Model1('int_obj1', int_field=5000)
    int_obj2 = Model1('int_obj2', int_field=9000)
    
    model2_obj1 = Model2('model2', model1=model1_obj3)
    model2_obj2 = Model2('model2', model1=model1_obj4)
        
    db.session.add_all([
        model_bool, model1_obj2, model1_obj3, model1_obj4, model1_obj5,
        date_obj1, time_obj1, datetime_obj1,
        enum_obj1, int_obj1, int_obj2, model2_obj1, model2_obj2
    ])
    db.session.commit()

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