pythonGrid

Datagrid for Python Web Frameworks

pythongridstg

enable_export()

· ·

  • Parameter(s):
    • type: The only export type is CSV at the moment.
  • Description:
    • The export icon appears on the left side of the footer when enabled.

Example:

grid.enable_export()

The export requires PythonGridDbExport class that must be initiated inside export() function in route or controller. 

@app.route('/export', methods=['GET', 'POST'])
def export(): 
    exp = PythonGridDbExport('SELECT * FROM orders') 
    return exp.export()

set_col_width()

· ·

  • Parameters:
    • col_name: column name
    • width: width
  • Description:
    • Specify column width in pixels. The width should be an integer value.
  • Remark:
    •  pythonGrid will automatically resize the column width based on its content during page load. Users can also double-click a column divider to resize a column.

Example:

grid.set_col_width('comments', 600)

set_col_align()

· ·

  • Parameters:
    • col_name: column name
    • align: alignment direction: “left”, “center”, or “right”.
  • Description:
    • The horizontal alignment of text in a column. The default alignment value is left.

Example:

grid.set_col_align('status', 'center')

enable_pagecount()

· ·

  • Parameters:
    • page_count: boolean: true or false.
  • Description:
    • Enable page count in the pager. Default to true.
  • Remark:
    • Set to false to optimize performance for very large (e.g. millions) database table.

Example:

grid.enable_pagecount(True)

enable_rownumbers()

· ·

  • Parameters:
    • has_rownumbers: boolean value indicating whether row number is displayed.
  • Description:
    • Display row numbers before each row.

Example:

grid.enable_rownumbers(True)