On Time Data Dictionary and Record Trait: Store and validate values in a data dictionary

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not yet rated by the users				Total: 47		All time: 10,774 This week: 206

Version		License		PHP version		Categories
`dyr` 1.0.1		Public Domain		5		PHP 5, Databases, Data types, Traits

Description

Author

Mario Carrocera

This package can store and validate values in a data dictionary.

It provides traits that can create named fields to store values of a given types, like string, integer, array, date, time, key, etc..

The package can also validate the stored values according to the types of the fields.

Mario Carrocera

Performance

Level

Name:	Mario Carrocera `<contact>`
Classes:	18 packages by Mario Carrocera
Country:	Mexico

Level 3

Innovation award

Nominee: 2x

Winner: 1x

Example


<?php



ini_set('display_errors', true);

error_reporting(E_ERROR | E_PARSE | E_NOTICE | E_WARNING);



$base='ontime/';

$AdminPassword='OT2021Free';

include_once($base."OnTime.php");

$demo=new OnTime();



echo "**********+++++++++++ <br> Data dictionary & record Demo <br> **********+++++++++++ <br> <br>";

echo "********** <br> Create Class  <br> ********** <br> <br>";

$demo->ot_error('basic content exist').'<br>';

echo "**********+++++++++++ <br> Conecting like admin <br> **********+++++++++++ <br> <br>";

echo "Connect('admin','OT2021Free') ";

$demo->Connect('admin',$AdminPassword);

echo  "<br>";$demo->ot_error("Connected!!!");echo "<br>";

echo "**********+++++++++++ <br> Data Dictionary <br> **********+++++++++++ <br> <br>";

echo "********** <br> Show Field Types <br> ********** <br> <br>";

echo "********** <br> Create Basic container for data dictionari <br> ********** <br> <br>";

echo "CrtFtrBsc('ddd')) ";

$demo->CrtFtrBsc('ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> Create Field Type Container for data dictionari <br> ********** <br> <br>";

echo "AddCntIn('type','Field Type','ddd') ";

$demo->AddCntIn('type','Field Type','ddd') ;

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> Make Field Type Container public <br> ********** <br> <br>";

echo "PblBscInAdd('type','ddd') ";

$demo->PblBscInAdd('type','ddd') ;

echo  "<br>";$demo->ot_error("Asigned!!!");echo "<br>";

echo "********** <br> Adding Field Type  array in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('A','Array','type','ddd')";

$demo->InsCntIn('A','Array','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type  string in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('S','String','type','ddd')";

$demo->InsCntIn('S','String','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type integer in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('I','Integer','type','ddd')";

$demo->InsCntIn('I','Integer','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type float in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('F','Float','type','ddd')";

$demo->InsCntIn('F','Float','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type date time in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('D','Date Time','type','ddd')";

$demo->InsCntIn('D','Date Time','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type key in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('K','Key Field','type','ddd')";

$demo->InsCntIn('K','Key Field','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type Time Stamp in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('T','TimeStamp','type','ddd')";

$demo->InsCntIn('T','TimeStamp','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type Time in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('t','Time','type','ddd')";

$demo->InsCntIn('t','Time','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type Date in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('d','Date','type','ddd')";

$demo->InsCntIn('d','Date','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type Bool in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('B','Logic Value','type','ddd')";

$demo->InsCntIn('B','Logic Value','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type Related to in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('R','Relate','type','ddd')";

$demo->InsCntIn('R','Relate','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Adding Field Type Varius types to in data dictionary <br> ********** <br> <br>";

echo "InsCntIn('V','Not defined','type','ddd')";

$demo->InsCntIn('V','Not defined','type','ddd');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Show Field Types <br> ********** <br> <br>";

echo "ShwCntIn('type','ddd') ";

$demo->ot_show($demo->ShwCntIn('type','ddd'));



echo "********** <br> Stop record validation to can modify ddd record <br> ********** <br> <br>";

echo "VldStp() ";

$demo->VldStp();



echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldNme', array('FldTpe'=>'K','FldDsc'=>'Field name'))";

$demo->DddAddFld('FldNme', array('FldTpe'=>'K','FldDsc'=>'Field name'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldDsc', array('FldTpe'=>'S','FldDsc'=>'Field description'))";

$demo->DddAddFld('FldDsc', array('FldTpe'=>'S','FldDsc'=>'Field description'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldTpe', array('FldTpe'=>'R','FldDsc'=>'Field type','FldVld'=>array('Name'=>'lookin','content'=>'type', 'in'=>'ddd')))";

$demo->DddAddFld('FldTpe', array('FldTpe'=>'R','FldDsc'=>'Field type','FldVld'=>array('Name'=>'lookin','content'=>'type', 'in'=>'ddd')));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldVld', array('FldTpe'=>'A','FldDsc'=>'Field validation'))";

$demo->DddAddFld('FldVld', array('FldTpe'=>'A','FldDsc'=>'Field validation'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldLen', array('FldTpe'=>'I','FldDsc'=>'Field length'))";

$demo->DddAddFld('FldLen', array('FldTpe'=>'I','FldDsc'=>'Field length'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldEmp', array('FldTpe'=>'B','FldDsc'=>'Field bool'))";

$demo->DddAddFld('FldEmp', array('FldTpe'=>'B','FldDsc'=>'Field bool'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Create field FlDName in data dictionary <br> ********** <br> <br>";

echo "ShwCntIn('type','ddd') ";

$demo->DddAddFld('FldFmt', array('FldTpe'=>'S','FldDsc'=>'Field format'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Crete field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldCap', array('FldTpe'=>'S','FldDsc'=>'Field caption'))";

$demo->DddAddFld('FldCap', array('FldTpe'=>'S','FldDsc'=>'Field caption'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Crete field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldTtt', array('FldTpe'=>'S','FldDsc'=>'Field tool tip text'))";

$demo->DddAddFld('FldTtt', array('FldTpe'=>'S','FldDsc'=>'Field tool tip text'));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Crete field FlDName in data dictionary <br> ********** <br> <br>";

echo "DddAddFld('FldDfl', array('FldTpe'=>'V','FldDsc'=>'Default Value','FldEmp'=>FALSE))";

$demo->DddAddFld('FldDfl', array('FldTpe'=>'V','FldDsc'=>'Default Value','FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Star record validation after modify ddd record <br> ********** <br> <br>";

echo "VldStr() ";

$demo->VldStr();



echo "********** <br> Show Data Dictionary<br> ********** <br> <br>";

echo "ShwDdd() ";

$demo->ot_show($demo->ShwDdd());

echo "********** <br> Show Field<br> ********** <br> <br>";

echo "ShwFld('FldTpe') ";

$demo->ot_show($demo->ShwFld('FldTpe'));





echo "********** <br> Create record <br> ********** <br> <br>";

echo "CrtRcd('ddd','Data Dictionary')";

$demo->CrtRcd('ddd','Data Dictionary');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";





echo "********** <br> Add Field to record <br> ********** <br> <br>";

echo "RcdAddIn('ddd','FldNme', array('FldEmp'=>FALSE))";

$demo->RcdAddIn('ddd','FldNme', array('FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Add Field to  record <br> ********** <br> <br>";

echo "RcdAddIn('ddd','FldDsc', array('FldEmp'=>FALSE))";

$demo->RcdAddIn('ddd','FldDsc', array('FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Add Field to  record <br> ********** <br> <br>";

echo "RcdAddIn('ddd','FldTpe', array('FldLen'=>1,'FldEmp'=>FALSE)";

$demo->RcdAddIn('ddd','FldTpe', array('FldLen'=>1,'FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Add Field to  record <br> ********** <br> <br>";

echo "RcdAddIn('ddd','FldVld', array('FldEmp'=>TRUE))";

$demo->RcdAddIn('ddd','FldVld', array('FldEmp'=>TRUE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Add Field to  record <br> ********** <br> <br>";

echo "RcdAddIn('ddd','FldLen', array('FldLen'=>10,'FldEmp'=>TRUE))";

$demo->RcdAddIn('ddd','FldLen', array('FldLen'=>10,'FldEmp'=>TRUE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";

echo "********** <br> Add Field to  record <br> ********** <br> <br>";

echo "RcdAddIn('ddd','FldEmp', array('FldLen'=>10,'FldEmp'=>TRUE)";

$demo->RcdAddIn('ddd','FldEmp', array('FldLen'=>10,'FldEmp'=>TRUE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> Show record list <br> ********** <br> <br>";

echo "ShwRecLst() ";

$demo->ot_show($demo->ShwRecLst());



echo "********** <br> Show record  <br> ********** <br> <br>";

echo "ShwRec('FldTpe') ";

$demo->ot_show($demo->ShwRec('FldTpe'));



echo "********** <br> Get  record information  <br> ********** <br> <br>";

echo "ShwRec('FldTpe') ";

$demo->ot_show($demo->ShwRec('FldTpe'));





echo "********** <br> Create field sample with validation record Active <br> ********** <br> <br>";

echo "DddAddFld('sample', array('FldTpe'=>'V','FldDsc'=>'Default Value','FldEmp'=>FALSE))";

$demo->DddAddFld('sample', array('FldTpe'=>'V','FldDsc'=>'Default Value','FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> change field sample with validation record Active <br> ********** <br> <br>";

echo "DddChgFld('sample', array('FldTpe'=>'V','FldDsc'=>'Default Value','FldEmp'=>FALSE))";

$demo->DddChgFld('sample', array('FldTpe'=>'V','FldDsc'=>'Other value','FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> Delete field sample with validation record Active <br> ********** <br> <br>";

echo "DddDltFld('sample')";

$demo->DddDltFld('sample');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";





echo "********** <br> Create sample record <br> ********** <br> <br>";

echo "CrtRcd('sample','Record Sample')";

$demo->CrtRcd('sample','Record Sample');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";





echo "********** <br> change sample record <br> ********** <br> <br>";

echo "ChgRcd('sample','New Desc')";

$demo->ChgRcd('sample','New Desc');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> Add Field to record <br> ********** <br> <br>";

echo "RcdAddIn('sample','FldNme', array('FldEmp'=>FALSE))";

$demo->RcdAddIn('sample','FldNme', array('FldEmp'=>FALSE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> change Field to record <br> ********** <br> <br>";

echo "RcdChgIn('sample','FldNme', array('FldEmp'=>TRUE))";

$demo->RcdChgIn('sample','FldNme', array('FldEmp'=>TRUE));

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";



echo "********** <br> delete Field to record <br> ********** <br> <br>";

echo "RcdDltIn('sample','FldNme')";

$demo->RcdDltIn('sample','FldNme');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";









echo "********** <br> delete sample record <br> ********** <br> <br>";

echo "RmvRcd('sample','Record Sample')";

$demo->RmvRcd('sample','New Desc');

echo  "<br>";$demo->ot_error("Created!!!");echo "<br>";







echo "**********+++++++++++ <br> Demo Finish<br> **********+++++++++++ <br> <br>";

?>

Details

Trait DDD & Record for ontime

The OnTime framework is designed to be modular, scalable and comprehensive, so that each new feature integrates without difficulty and maintains a unique class definition (OnTime) and all "additional classes" are "trait" that enrich it, in such a way that an integrated system is obtained, not separate programs which do not necessarily have to behave correctly together. This trait will be need if you wan have advanced and complex tables

Installation in test environment:

1.- Copy all the files in the directory where was instaled ontrime core

2.- With the browser of your preference, locate the directory and enter it

3.- Execute the OntimeInstallerDyR.php file

4.- When executing the file, the files where moved and the required environment was created

Recommendations:

If you know how to create a subdomain that points to the "demo" directory, it is more comfortable and realistic.

After install

When installing, the necessary environment is defined to define access security, I create a User called "Admin" and that his password is "OT2021Free", this environment left the class prepared for definitions of the data dictionary and records.

Also include basic validation, like the existence of a field in a basic content feature, field tYpe and field empty, when you define a record validate that just have a key field, but someone is included, validate that all the fields includes in the data suply exist on the record, and if a field in the record, is missing in the data suply have empty option.

The data supply must satisfy the validation in the record and datadictonaty definition

mario.carrocera@hotmail.com

+++++++++++ Data dictionary & record Demo +++++++++++

Create Class

basic content exist +++++++++++ Conecting like admin +++++++++++

Connect('admin','OT2021Free') Connected!!!

+++++++++++ Data Dictionary +++++++++++

Show Field Types

Create Basic container for data dictionari

CrtFtrBsc('ddd')) Created!!!

Create Field Type Container for data dictionari

AddCntIn('type','Field Type','ddd') Created!!!

Make Field Type Container public

PblBscInAdd('type','ddd') Asigned!!!

Adding Field Type array in data dictionary

InsCntIn('A','Array','type','ddd') Created!!!

Adding Field Type string in data dictionary

InsCntIn('S','String','type','ddd') Created!!!

Adding Field Type integer in data dictionary

InsCntIn('I','Integer','type','ddd') Created!!!

Adding Field Type float in data dictionary

InsCntIn('F','Float','type','ddd') Created!!!

Adding Field Type date time in data dictionary

InsCntIn('D','Date Time','type','ddd') Created!!!

Adding Field Type key in data dictionary

InsCntIn('K','Key Field','type','ddd') Created!!!

Adding Field Type Time Stamp in data dictionary

InsCntIn('T','TimeStamp','type','ddd') Created!!!

Adding Field Type Time in data dictionary

InsCntIn('t','Time','type','ddd') Created!!!

Adding Field Type Date in data dictionary

InsCntIn('d','Date','type','ddd') Created!!!

Adding Field Type Bool in data dictionary

InsCntIn('B','Logic Value','type','ddd') Created!!!

Adding Field Type Related to in data dictionary

InsCntIn('R','Relate','type','ddd') Created!!!

Adding Field Type Varius types to in data dictionary

InsCntIn('V','Not defined','type','ddd') Created!!!

Show Field Types

ShwCntIn('type','ddd') 1D.- A=>Array 1D.- S=>String 1D.- I=>Integer 1D.- F=>Float 1D.- D=>Date Time 1D.- K=>Key Field 1D.- T=>TimeStamp 1D.- t=>Time 1D.- d=>Date 1D.- B=>Logic Value 1D.- R=>Relate 1D.- V=>Not defined Stop record validation to can modify ddd record

VldStp() Create field FlDName in data dictionary

DddAddFld('FldNme', array('FldTpe'=>'K','FldDsc'=>'Field name')) Created!!!