The Sysadmin Notebook  

Sitemap

CatalystReporting Project

Example catalyst project

create catalyst project:

catalyst.pl Reports

Create database

mysql> create database ReportsDB;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on ReportsDB.* to dr00 identified by 'password';
Query OK, 0 rows affected (0.00 sec)

create tables

dr00@sobig:~/Reports/sql> mysql -u dr00 -ppassword ReportsDB < createResults.sql

create some sample data:

dr00@sobig:~/Reports/sql> mysql -u dr00 -ppassword ReportsDB < createResultsData.sql 

create schema

dr00@sobig:~/Reports> perl script/reports_create.pl model ReportsDB \ 
DBIC::Schema Reports::Schema::ReportsDB create=static \
dbi:mysql:ReportsDB dr00 password

create the TT view

dr00@sobig:~/Reports> perl script/reports_create.pl view HTML TTSite