This documentation is powered by the Dispute component based on the pj DataProvider and the pj DataProvider Framework respectively.
- The pj DataProvider is a general usage framework usable in any PHP environment;
- IDataProvider defines a function set the actual database engine interface must provide;
- MySqlDataProvider is the IDataProvider layer to the MySql database engine (mysqli).
Other database layers have only to be developed (e.g. PostgreDataProvider, SqlServerDataProvider, OracleDataProvider etc.) and implemented in the place of MySqlDataProvider with no effects for the application code itself;
- InfoBase, representing one single database table row, is a base class for extension's classes with specific functionality related to application's database tables.
The developer writes own DataProvider class, which instantiates and opens a singleton IDataProvider database connection (MySqlDataProvider) and eventually implemments specific business layer functions.
Then, he/she designs business layer classes extending InfoBase corresponding to the database model and registers them at start-up in the DataProvider. It is not necessary to add any code to bare class declaration, although it is convenient to outsource specific functionality there.
The framework offers full database access for registered InfoBase classes, including retrieving by ID or by queries passed either by string or by SearchKey structure. It recognizes changes of instance data and inserts, updates and deletes instances together with corresponding table rows, optionally in nested transactions. It ensures that at any time, there exists at most one unique instance of InfoBase class representing one database table row.