# Collection of code snippets by Arne Vajhøj 
# (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) 
from java.sql import DriverManager

from net.sf.jasperreports.engine import JasperCompileManager, JasperFillManager, JasperExportManager, JRResultSetDataSource

con = DriverManager.getConnection('jdbc:mysql://arnepc5/Test', 'arne', 'hemmeligt')
stmt = con.createStatement()
rs = stmt.executeQuery("SELECT customer,COUNT(DISTINCT customer) AS n,SUM(qty*price) AS total FROM orders JOIN orderlines ON orders.id = orderlines.orderid WHERE status = 'Delivered' GROUP BY customer ORDER BY total DESC")
rep = JasperCompileManager.compileReport('rep.jrxml')
prt = JasperFillManager.fillReport(rep, None, JRResultSetDataSource(rs))
JasperExportManager.exportReportToPdfFile(prt, 'orders2.pdf')
rs.close()
stmt.close()
con.close()