Form Handler Filtering data with ease

Gramex 1.21 has a powerful handler called FormHandler. This makes it easy to render data. You can stop writing FunctionHandler to do this.

Read data from files

You can just point to a CSV, XLSX or HDF file.

handler: FormHandler
kwargs:
  url: $YAMLPATH/flags.csv

The result looks like this

Perform calculations

If you want to return data after performing calculations, add a function:

handler: FormHandler
kwargs:
  url: $YAMLPATH/flags.csv
  function: mymodule.myfunction(data)

This uses the results of mymodule.myfunction(data) instead of data.

Read data from databases

Just change the URL from the file to an SQLAlchemy URL. You need to specify a table. You can optionally add a query.

    url: 'mysql+pymysql://$USER:$PASS@server/db'
    table: sales
    query: 'SELECT * FROM sales ORDER BY date DESC'

    url: 'mssql+pyodbc://$USER:$PASS@dsn'
    table: sales
    query: 'SELECT TOP 1000 * FROM sales'

    url: 'sqlite:///D:/path/to/file.db'
    table: sales

Filter with ease

?Continent=Europe shows rows where Continent = Europe ?Continent!=Europe - where Continent is NOT Europe ?Name~=United - where name contains “United”

… and many more filter operations.

Choose your format

You can return the data as HTML, CSV, JSON, or XLSX. Formatted XLSX (with conditional formatting, etc) will be available in the next release of Gramex.

You should be able to replace most of your FunctionHandlers with FormHandler. Please reach out to the CTO team if you have questions.