Metadata-Version: 2.1
Name: agatereports
Version: 0.0.1
Summary: python report generator engine to process JasperReports jrxml file.
Home-page: https://github.com/ozawa-hi/agatereports
Author: Hitoshi Ozawa
Author-email: ozawa_h@gmail.com
License: BSD license (see LICENSE for details), Copyright (c) 2019, Hitoshi Ozawa
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: BSD License
Classifier: Topic :: Office/Business
Classifier: Topic :: Printing
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Topic :: Text Processing :: Markup
Classifier: Topic :: Utilities
Classifier: Programming Language :: Python :: 3.6
Requires-Dist: reportlab (>=3.4.0)
Requires-Dist: mysql-connector-python (>=8.0)
Requires-Dist: psycopg2-binary (<2.8,>=2.7)

AgateReports

Pure Python engine to generate reports from JasperReports jrxml file.
==============================================================================

Introduction
------------
AgateReports is a pure Python tool to generate reports without extensive coding.
It currently relies on Jaspersoft Studio `<https://sourceforge.net/projects/jasperstudio/>`_ to graphically position reporting elements on a report layout.

.. image:: ./docs/img/overview.png
    :width: 832px
    :align: center
    :height: 292px
    :alt: overview

This package aims to be a solution to following users:

- Python developers who want to create a report using GUI tool.
- Users who want to modify existing reports without programming.

Differences with JasperReports
------------------------------
- AgateReports use different components than JasperReports and there are minor differences. AgateReports components are based on modules such as ReportLab that are available in Python
- AgateReports ia able to use .ttc fonts
- Additional components available in Python are added. Currently, jrxml file must manually be edited to use these components. Furthermore, since JasperReports do not support these components, edited jrxml file can no longer be edited with Jaspersoft Studio. There is a plan to fork Jaspersoft Studio to support Python language syntax and these components.

Current Restrictions
--------------------
- AgateReports is still in initial development phase and does not provide all of JasperReports features.
- Patterns, format, and Java classes specified in jrxml file need to be changed to Python equivalent.
  For example, "Current Date" needs to be converted from "new java.util.Date()" to "datatime.datetime.now()"
- Currently, only MySQL, Postgresql, and csv file are supported as a datasource
- Performance is slow for large data source.


Requirements
------------
Python3.6 or above
ReportLab
Pillow
MySQL Connector/Python
psycopg2

Installation
----------------
AgateReports requires Pillow. If Pillow is not already installed, please install it with the following command.
::

    pip install Pillow

AgateReports can be installed by the following command:
::

    pip install agatereports


Getting Started
----------------
Please refer to the following github project for full documentation.
https://github.com/ozawa-hi/agatereports

`demos directory <https://github.com/ozawa-hi/agatereports/tree/master/demos/README.rst>`_ contains samples of jrxml files and Python scripts on how to use AgateReports.

Usage Sample
---------------
.. code-block:: python

    from agatereports.adapters import MysqlAdapter
    from agatereports.basic_report import BasicReport

    import logging
    logger = logging.getLogger(__name__)


    def datasource_mysql_sample():
        """
        MySQL data source sample.

        WARNING: Before running this sample, schema 'agatereports' must be create and populated.
        Run scripts in directory 'agatereports/tests/database/mysql' to create and populated database tables.

        CAUTION: Edit values of 'host' and 'port' to those in your environment.
         """
        logger.info('running datasource mysql sample')
        jrxml_filename = '../demos/jrxml/datasource_mysql.jrxml'  # input jrxml filename
        output_filename = '../demos/output/datasource_mysql.pdf'  # output pdf filename

        # MySQL datasource
        config = {'host': 'localhost', 'port': '3306', 'user': 'python', 'password': 'python', 'database': 'agatereports'}
        data_source = MysqlAdapter(**config)

        pdf_page = BasicReport(jrxml_filename=jrxml_filename, output_filename=output_filename, data_source=data_source)
        pdf_page.generate_report()


    if __name__ == '__main__':
        datasource_mysql_sample()

END


