History DB

<< Click to Display Table of Contents >>

Navigation:  Project > Databases >

History DB

Previous pageReturn to chapter overviewNext page

To create a new history db select the menu item Project and New Database ->History or choose Databases on the Project Window, click right button on it and choose New Database>History item. You'll see the following window:

historydbproperty

List of properties:

Property

Description

Name

Name of the history database.

DB name

Write name of the database for the current history. If you enter the simple name like hisstory for example you will connect to the SQLLite database. The SQLLite database file .db will be created in /DB/ folder. If you choose names beginning with jdbc:mysql: like jdbc:mysql://192.168.0.104:3306/test the application will connect to MySQL database (for iOS you can’t use MySQL databases at this time).

Table name

Write table name of the database for the recipe.

Username

Username if needed for MySQL databases.

Password

Password if needed for MySQL database.

Storage type

Choose storage type - Time or Tag. If you chose Time every Save period values of tags included in Ingredients will be saved into history database. If you choose Tag values of tags will be saved when Tag's value become True(1).

Save Period(ms)

Time interval of saving Ingredients tag values into history database. This property used when you choose Time Storage type.

Tag

Choose Tag dependent on which value (when value become True(1)) Ingredients tag values will be saved in history database.

Ingredients

Click Collection to fill up ingredients of the history. After clicking Collection button you’ll see the following window:

ingredientsrecipe

Where:

1. Choose Tag you want to bind to the ingredient.

2. Enter Name of the ingredient.

3. Enter DB column name for the database.

4. Enter Unit of the DB ingredient.