Black Car Service / BCS

4DFLib example application!!!

This is an example application showing how you can use 4dflib (https://github.com/briangormanly/4dflib) to manage all your applications data over time and it is an ORM tool to boot, abstracting away your database so you can concentrate on the really important things, like coding the next app that will take over the world!

Instructions

prerequisites

• Assumes MariaDB, PostgreSQL or MySQL 5.7 is running, and no root password is set (default). If this is true, you may run, else see 'Database Settings' Below
• Java 8 JRE is available
• You have Git and Gradle installed

Clone and Run! clone this repository: git clone https://github.com/briangormanly/4dflib-bcs-example.git run: gradle run (in project folder)

Congratulations! Your done, the demo ran, created a database, built out tables and created some data.

Database Configuration

To configure database settings, setting the root password, changing to using PostgreSQL, or other database connection related details see this file: 4dflib-bcs-example/src/main/java/com/fdflib/example/BlackCarService.java Change the following as appropriate to your needs: Root username and password: ````Java fdfSettings.DB_ROOT_USER = "root"; fdfSettings.DB_ROOT_PASSWORD = ""; ```` PostgreSQL: (uncomment) and remove / comment out the MySQL ones ````Java // PostgreSQL settings fdfSettings.PERSISTENCE = DatabaseUtil.DatabaseType.POSTGRES; fdfSettings.DB_PROTOCOL = DatabaseUtil.DatabaseProtocol.JDBC_POSTGRES;

// MariaDB settings
//fdfSettings.PERSISTENCE = DatabaseUtil.DatabaseType.MARIADB;
//fdfSettings.DB_PROTOCOL = DatabaseUtil.DatabaseProtocol.JDBC_MARIADB;

// MySQL settings Version 5.7 only!!!!!!!! (no support for version 8)
//fdfSettings.PERSISTENCE = DatabaseUtil.DatabaseType.MYSQL;
//fdfSettings.DB_PROTOCOL = DatabaseUtil.DatabaseProtocol.JDBC_MYSQL;

// Note that you will likely have to set the root password for postgreSQL as well
fdfSettings.DB_ROOT_PASSWORD = "mycoolpasssword";

<h2>How it works...</h2>
If you go to MariaDB (or whatever database you used, for the purpose of brevity I will be showing Maria / MySQL commands here.) and issue:
````SQL
mysql> show databases

You should see that there is a new database, called 'blackcardemo' Now, if you view the tables, you will see that 4 tables were created..

mysql> use blackcardemo;
mysql> show tables;
+------------------------+
| Tables_in_blackcardemo |
+------------------------+
| Car                    |
| Driver                 |
| FdfSystem              |
| FdfTenant              |
+------------------------+
4 rows in set (0.00 sec)

Note that FdfSystem and FdfTenant are created by the 4DFLib, they are used to make your software natively multi-tenant and to manage Systems that will connect to your application and there access.

The other 2 tables, Car and Driver were created to persist data related to the 2 classes in the com.fdflib.example.model package and were created because we did the following in the BlackCarService.java main()

// Create a array that will hold the classes that make up our 4df data model
List<Class> myModel = new ArrayList<>();

// Add our 2 classes
myModel.add(Driver.class);
myModel.add(Car.class);

...

// call the initialization of library!
FdfServices.initializeFdfDataModel(myModel);