LJCDataManager

/ LJCPHPCodeDoc / LJCDataManagerLib / LJCDataManager

Syntax

PHP
class LJCDataManager

Provides Standard DB Table methods.

Remarks

The DataManager class provides a higher level of abstraction on top of the DataAccess class.

It does not require the developer to create SQL statements. Instead the developer can use strongly typed DataObjects, KeyColumn definitions, Join definitions and Included PropertyNames arrays to interact with the database.

The DataManager retrieves the Table SchemaColumn Definitions from the database. It uses these definitions to create the SQL statements and modifies them based on KeyColumn definitions, Join definitions and PropertyNames arrays.

The retrieved data can be mapped into strongly typed DataObjects using the methods CreateDataCollection() and CreateDataObject().

Public Functions

construct	Initializes a class instance with the provided values.
Add	Adds the record for the provided values.
Delete	Deletes the records for the provided values.
Load	Loads the records for the provided values.
Retrieve	Retrieves the record for the provided values.
Update	Updates the records for the provided values.
SQLExecute	Executes an Add, Delete or Update SQL statement.
SQLLoad	Executes a Select SQL statement.
SQLRetrieve	Executes a Select SQL statement.
CreateDataCollection	Creates an array of typed Data Objects from a DB rows array.
CreateDataObject	Populates a typed Data Object with values from a DB row.

11 Functions

Public Properties

$DbAccess	The DbAccess object.
$Joins	The Join definitions.
$OrderByNames	The OrderBy names.
$SchemaColumns	The column definitions.
$SQL	The last SQL statement.
$TableName	The table name.