All ChartDirector database sample scripts described in this documentation are based on Ruby On Rails with a MySQL database. The sample scripts are provided for reference purposes. To actually run the sample scripts, you would need to set up your database system as follows:
- Set up "config/database.yml" in your Ruby On Rails application to MySQL as the database engine. (You may need to restart the application after this step.
- Import the table and records in "ChartDirector/db/sample.sql" into the database.
The sample database that contains only one table called "revenues". The table stores the monthly revenue data for three business units - Hardware, Software and Services. It contains four columns as follows:
Column Name | Type |
---|
TimeStamp | Date/Time |
Hardware | Number |
Software | Number |
Services | Number |
Each row in the database table contains monthly revenues for the business units, where the date is stored in the "TimeStamp" column. The sample database contains rows from Jan 1990 to Dec 2001.
© 2017 Advanced Software Engineering Limited. All rights reserved.