Recipe

<< Click to Display Table of Contents >>

Navigation:  Project > Databases >

Recipe

Previous pageReturn to chapter overviewNext page

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

 

recipeproperty

 

List of properties:

Property

Description

Name

Name of the recipe.

DB name

Write name of the database for the current recipe. If you enter the simple name like recipes 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. if you choose names beginning with jdbc:sqlserver: like jdbc:sqlserver://192.168.1.17:1433;databaseName=test where test name of the database you want to connect. The application will connect to MSSQL* database. If you choose names beginning with jdbc:postgresql: like jdbc:postgresql://192.168.1.17:5432/test where test name of the database you want to connect. The application will connect to PostgreSQL* database.

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.

Ingredients

Click Collection to fill up ingredients of the recipe. 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.

* for mobile device is possible to use only SQLLite databases.