[reportlab-users] Problem in the chart display code
Soumya Mishra
mishras at vmware.com
Mon Jun 6 19:37:29 EDT 2011
Hi all,
I am writing this simple code to display a chart in pdf and other formats while collecting data to be displayed from mysql data database.
The code is running w/o errors but yet the files are not generated. Please help.
from rlextra.graphics.guiedit.datacharts import DataAwareDrawing, DataSource, ODBCDataSource, DataAssociation
from reportlab.graphics.shapes import _DrawingEditorMixin
from reportlab.graphics.charts.lineplots import GridLinePlot
class Ok(_DrawingEditorMixin,DataAwareDrawing):
def __init__(self,width=800,height=800,*args,**kw):
DataAwareDrawing.__init__(self,width,height,*args,**kw)
self._add(self,GridLinePlot(),name='plot',validate=None,desc=None)
self.height = 125
self.width = 300
self.plot.height =125
self.plot.width = 300
self.plot.x = 50
self.plot.y = 50
self.dataSource = ODBCDataSource()
self.dataSource.driver = 'mysql'
self.dataSource.user = 'root'
self.dataSource.password = 'soumya'
self.dataSource.name = 'fundrep'
self.dataSource.sql = 'SELECT fund_id, periodEnd, fundReturn,indexReturn FROM fundrep_monthlyreturnseriess ORDER BY fund_id, periodEnd'
self.outDir = 'output'
self.fileNamePattern = 'pleaserun'
self.formats = ['pdf', 'eps', 'gif']
self.dataSource.associations.size = 2
self.dataSource.associations.element00 = DataAssociation(column=0, target='chartId', assocType='scalar')
self.dataSource.associations.element01 = DataAssociation(column=[(1,2),(1,3)], target='plot.data', assocType='tmatrix')
if __name__=="__main__": #NORUNTESTS
Ok().go()
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://two.pairlist.net/pipermail/reportlab-users/attachments/20110606/a1560a2e/attachment.htm>
More information about the reportlab-users
mailing list