Skip to main content

A useful simple to use tool to turn your sql query into a beautiful report html table

Project description

This is easy to use tool for generating html table from sql query.

the package contains only one function named "generateFromSql" with 8 arguments :

  • session : SQLAlchemy session
  • title : the title of the report that will be shown on top of table
  • sqltext : the sql query
  • footerCols : a list of columns name that you want to have Sum of values on footer . Example : ['amount','price']
  • direction (default = "ltr") : indicates direction of the report page. "ltr"- Left to Right , "rtl" - Right to Left
  • font (default = "Tahoma") : font of title and table contents
  • totalText (default = "Total") : title of footer row that will be the put below the first column.
  • rowIndex (default = False) : indicates whether the table should have index column or not.
  • headerRowColor (default = '#eeeeee') : the header (title) row background color.
  • evenRowColor (default = '#ffffff') : the even rows background color.
  • oddRowColor (default = '#ffffff') : the odd rows background color.

usage :

Installation

To install flask_sqlalchemy using pip type:

pip install flask-sqlalchemy-report

Usage :

from flask_sqlalchemy_report import Reporter 

@app.route('/listOfPersons', methods=['GET'])
def listOfPersons():
  reportTitle = "Employee List"
  sqlQuery = "SELECT FirstName as 'First Name', LastName as 'Last Name', phone as 'Phone Number', salary as 'Salary' FROM persons"
  columnsToBeSummarized = ['Salary']
  fontName = "Arial"
  headerRowBackgroundColor = '#ffeeee'
  evenRowsBackgroundColor = '#ffeeff'
  oddRowsBackgroundColor = '#ffffff'
  return Reporter.generateFromSql(db.session, reportTitle, sqlQuery, columnsToBeSummarized, 
                                  "ltr", fontName, "Total Salary", True,
                                  headerRowBackgroundColor, evenRowsBackgroundColor, oddRowsBackgroundColor
                                  )

Read More

Project details


Download files

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

Source Distribution

flask_sqlalchemy_report-0.2.2.tar.gz (3.2 kB view hashes)

Uploaded source

Built Distribution

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page