Skip to main content

A library for rendering HTML tables and Excel files from SQLAlchemy models.

Project description

WebGrid
#######

.. image:: https://ci.appveyor.com/api/projects/status/6s1886gojqi9c8h6?svg=true
:target: https://ci.appveyor.com/project/level12/webgrid

.. image:: https://circleci.com/gh/level12/webgrid.svg?style=shield
:target: https://circleci.com/gh/level12/webgrid

.. image:: https://codecov.io/gh/level12/webgrid/branch/master/graph/badge.svg
  :target: https://codecov.io/gh/level12/webgrid

Introduction
---------------

WebGrid is a datagrid library for Flask and other Python web frameworks designed to work with
SQLAlchemy ORM entities.

Based on the configured grid, it will output an HTML table with sorting, filtering, and paging.

It also will export the grid to Excel.

For now, if you are interested in using it, you will need to see the source code and tests therein
for example usage.

Questions & Comments
---------------------

Please visit: http://groups.google.com/group/blazelibs

Running the Tests
----------------

Make sure to include the `--nologcapture` flag to nosetests or else you will get
failures when testing the logging features.

Current Status
---------------

Currently beta quality.


Changelog
---------

0.1.31 released 2016-11-03
==========================

- corrected DateTimeFilter processing to avoid "invalid date" messages

0.1.30 released 2016-10-28
==========================

- fixed problem with lambda default args being processed by the grid

0.1.29 released 2016-10-28
==========================

- allow default operation passed to filter to be a callable

0.1.28 released 2016-10-13
==========================

- fixed an additional regression in DateFilter and DateTimeFilter validation

0.1.27 released 2016-10-13
==========================

- corrected DateFilter and DateTimeFilter operations for empty, not empty, and between

0.1.26 released 2016-10-03
==========================

- update TextFilter to support case-insensitive operations for dialects like postgresql and sqlite

0.1.25 released 2016-09-12
==========================

- various bug fixes in DateTimeFilter
- introduce support for Arrow date objects in grid and date filters

0.1.24 released 2016-05-10
==========================

- enhanced options for subtotals to include sum, avg, strings, and SQLAlchemy expressions

0.1.23 released 2016-04-18
==========================

- change dependency to webhelpers2 from webhelpers
- update to support new python-dateutil, including fix of old parsing exception
- fix testing compatibility with Flask-SQLALchemy 2.1
- fix testing dependencies problem in setup
- support Python 3.4 and newer

0.1.22 released 2016-02-18
==========================

- fix potential warnings for SQLAlchemy when sorting by a label instead of an SA expression

0.1.21 released 2016-02-18
==========================

- bad release

0.1.20 released 2016-02-18
==========================

- errant release, identical to 0.1.19

0.1.19 released 2016-02-16
==========================

- fix edit/delete link display on large screens

0.1.18 released 2015-12-11
==========================

- fix bugs related to default operations using no-input date filters

0.1.17 released 2015-12-04
==========================

- add YesNoFilter and OptionsIntFilterBase helper
- fix compatibility with SQLAlchemy 1.0.9 for tests to pass
- add additional DateFilter operators

0.1.16 released 2015-10-15
==========================

- fixed problem with possible date/datetime filter overflows

0.1.15 released 2015-07-02
==========================

- add time column and filter

0.1.14 released 2015-05-11
==========================

- fix problem where empty strings passed to set as a non-required value 2 causes validation error

0.1.13 released 2015-02-12
==========================

- attempt to use column label for subtotaling if no SA expression is provided
- allow callers to specify default arguments to filters

0.1.12 released 2014-11-18
==========================

- allow filters to set additional html attributes on their table rows

0.1.11 released 2014-10-09
==========================

- fixed setup to include only webgrid in install, without the test apps

0.1.10 released 2014-10-02
==========================

- bug fix: hide_controls_box grid attribute used in rendering

0.1.9 released 2014-09-22
=========================

- bug fix: corrected default_op processing on TextFilter

0.1.8 released 2014-09-22
=========================

- enable default_op processing for all filter types

0.1.7 released 2014-09-18
=========================

- BC break: replaced MultiSelect widget with multipleSelect plugin.
Related JS and CSS must be included (available in webgrid static)
- included missing images referenced by webgrid CSS

0.1.6 released 2014-08-22
=========================

- updated filter tests to work with SA0.9
- refactoring related to subtotaling feature
- adjustments for SQLAlchemy 0.9+ (we now support 0.8+)
- workaround for dateutils parsing bug
- testing fixes
- completed dev requirements list
- fixed nose plugin bug, must not assume pathname case consistency (Windows)
- added BlazeWeb adapter
- xls_as_response now an adapter method, called by XLS renderer
- render_template now an optional adapter method, falls back to Jinja2 call

0.1.5 released 2014-05-20
=========================

- fix nose plugin setup to avoid warning message
- fix javascript bug related to sorting & newer jQuery libraries
- fix SA expression test to avoid boolean ambiguity
- avoid accidental unicode to text conversion in filters

0.1.4 released 2014-05-18
=========================

- fix string/unicode handling to avoid coercion of unicode to ascii

0.1.3 released 2014-05-18
=========================

- adjust the way the Flask blueprint is created and registered
- adjust route on blueprint so it has /static/... prefix for URL

0.1.0 - 0.1.2 released 2014-05-17
=================================

- initial release
- fix packaging issues (0.1.1)
- adjust init so xlwt not required if not used

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

WebGrid-0.1.31.tar.gz (78.0 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page