Features

Generated fab pages look as shown below:

1. Multi-page: apps incude 1 page per table

2. Multi-table: pages include related_views for each related child table, and join in parent data

3. Favorite field first: first-displayed field is “name”, or contains “name” (configurable)

4. Predictive joins: favorite field of each parent is shown (product name - not product id)

5. Ids last: such boring fields are not shown on lists, and at the end on other pages

Background:

Flask Application Builder (FAB) provides a rapid means for building web pages for database apps, based on Python, Flask and sqlalchemy. Use the Quick Start Guide (link above) to create the application shown above in 10 minutes.

Recall that creating the views.py file can be tedious. This utility generates the views.py file from the models.py file, to save time and reduce learning curve.

Usage:

First, create a fab project (e.g., see the Quick Start Guide).

Then, generate the views.py file like this:

cd <project>  # fab directory containing the config.py file
pip install fab-quick-start
fab-quick-start run

Copy the console output to your views.py file, and run fab / flask app:

export FLASK_APP=app
flask run

Parameters

The simple run command will request 2 parameters, and output to the console. You can specify parameters and output via command line arguments, like this:

fab-quick-start run --favorites="name description" --non_favorites="id" > app/views.py

where:

• favorites: words() used to find “favorite fields”. Fields named with these words, or containing these words, are placed at the start of lists and show pages. Your values might reflect your language, and your database naming conventions.

• non_favorites: name(s) used to find fields to be place at the end of list / show pages.

• the > pipes the output to a file (which is overwritten).

Depends on:

• Flask-AppBuilder

More information:

The FAB Quick Start github for more information, and explore the code.

Acknowledgements

Many thanks to

• Daniel Vaz Gaspar, the creator of FAB, for his help and guidance

• Katrina Huber-Juma, for Python help and final review

• Tyler Band, for early testing

Change Log

Initial Version

0.9.8 - Fix duplicate view class generation