<< Click to Display Table of Contents >> Recipe |
|
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:
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:
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.