def add_link_filters_filter(self, path, filters):
lnkstr = path
for _filter in filters:
try:
datamodel = SQLAModel(filters.get(_filter))
pk_name = datamodel.get_pk_name()
pk_value = getattr(filters.get(_filter), pk_name)
lnkstr = lnkstr + '&_flt_' + _filter + '=' + str(pk_value)
except:
pass
return lnkstr
class ProductView(ModelView):
datamodel = SQLAModel(Product)
list_columns = ['name','product_manufacturer', 'product_model']
add_columns = ['name','product_manufacturer', 'product_model']
edit_columns = ['name','product_manufacturer', 'product_model']
add_form_query_cascade = [('product_manufacturer', 'product_model',
SQLAModel(ProductModel, db.session),
['product_manufacturer',FA, 'product_manufacturer']
)]
edit_form_query_cascade = add_form_query_cascade
class Model2View(ModelView):
datamodel = SQLAModel(Model2)
list_columns = [
'field_integer', 'field_float', 'field_string', 'field_method'
]
edit_form_query_rel_fields = [
('group', SQLAModel(Model1, self.db.session),
[['field_string', FilterEqual, 'G2']])
]
add_form_query_rel_fields = [('group',
SQLAModel(Model1, self.db.session),
[['field_string', FilterEqual,
'G1']])]
class ContactModelView(ModelView):
datamodel = SQLAModel(Contact)
label_columns = {'group': 'Contacts Group'}
list_columns = ['name', 'personal_celphone', 'birthday', 'group']
list_template = 'list_contacts.html'
show_template = 'show_contacts.html'
base_order = ('name', 'asc')
show_fieldsets = [
('Summary', {'fields': ['name', 'gender', 'group']}),
(
'Personal Info',
{'fields': ['address', 'birthday', 'personal_phone', 'personal_celphone'], 'expanded': False}),
]
add_fieldsets = [
('Summary', {'fields': ['name', 'gender', 'group']}),
(
'Personal Info',
{'fields': ['address', 'birthday', 'personal_phone', 'personal_celphone'], 'expanded': False}),
]
edit_fieldsets = [
('Summary', {'fields': ['name', 'gender', 'group']}),
(
'Personal Info',
{'fields': ['address', 'birthday', 'personal_phone', 'personal_celphone'], 'expanded': False}),
]
class BenefitView(ModelView):
datamodel = SQLAModel(Benefit)
related_views = [EmployeeView]
add_columns = ['name']
edit_columns = ['name']
show_columns = ['name']
list_columns = ['name']
class ContactModelView(ModelView):
datamodel = SQLAModel(Contact)
list_columns = [
'name', 'personal_celphone', 'birthday', 'contact_group.name'
]
base_order = ('name', 'asc')
show_fieldsets = [
('Summary', {
'fields': ['name', 'gender', 'contact_group']
}),
('Personal Info', {
'fields':
['address', 'birthday', 'personal_phone', 'personal_celphone'],
'expanded':
False
}),
]
add_fieldsets = [
('Summary', {
'fields': ['name', 'gender', 'contact_group']
}),
('Personal Info', {
'fields':
['address', 'birthday', 'personal_phone', 'personal_celphone'],
'expanded':
False
}),
]
edit_fieldsets = [
('Summary', {
'fields': ['name', 'gender', 'contact_group']
}),
('Personal Info', {
'fields':
['address', 'birthday', 'personal_phone', 'personal_celphone'],
'expanded':
False
}),
]