pythonGrid

Datagrid for Python Web Frameworks

installation

Creating the Sample Database

· ·

Find the sample database in folder sampledb. Run the sample SQL script Using your favorite Postgres or MySQL client (more database supports are coming).

For Postgres, PgAdmin is an excellent GUI client. For MySQL, you cannot go wrong with the hand dandy MySQL Workbench.

Steps to create the sample database:

  1. Create a new database named sampledb
  2. Run the sample SQL script for the database of your choice.

Installation

· ·

To install pythonGrid, a couple of quick start options are available:

git clone https://github.com/pycr/pythongrid.git

Folder Structure

Within the download you will see something like this:

├── LICENSE
├── README.md
├── app
│   ├── __init__.py
│   ├── data.py
│   ├── grid.py
│   ├── routes.py
│   ├── static
│   └── templates
│       ├── 404.html
│       ├── base.html
│       ├── grid.html
│       └── index.html
├── sample
│   ├── sampledb_postgres.sql
│   ├── sampledb_mysql.sql
├── config.py
├── index.py
└── requirements.txt

pythonGrid current has two main files in grid.py and data.py in app folder.

  • grid.py is the main Python class that is responsible for creating the datagrid table. It relies on jqGrid, a popular jQuery datagrid plugin, to render grids in the browser.
  • data.py is a Python class that returns the data via AJAX to populate the grid from a database.
  • static contains all of the client side Javascript and CSS files used for rendering