PHP Classes

SQL Data: Generate classes to store objects in SQL databases

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 43%Total: 2,451 All time: 1,587 This week: 455Up
Version License Categories
sqldata 1.0Custom (specified...Databases, Code Generation
Description 

Author

SQLData is an extension of the dm.DB class. SQLData provides object-relational mappings to store and retrieve persistent objects in an SQL database.

SQLData comes with additional scripts for generating classes to be used by applications to access given database tables using the SQLData class.

These scripts are meant to run from the command line. They retrieve the definitions of a given database table and then the generate classes to access the table rows as objects or to manipulate them via Web forms. They will generate classes and forms for any SQL database supported by dm.DB.

Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms for MySQL tables.

SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. dm.DB provides a RDBMS independent access layer so, in principle, SQLData can be used by any database supported by dm.DB.

This class is officially compatible with PHP 5.

This is a major revision to SQLData which now supports all databases supported by dm.DB.

Picture of Richard Munroe
Name: Richard Munroe is available for providing paid consulting. Contact Richard Munroe .
Classes: 22 packages by
Country: United States United States
Age: 73
All time rank: 112 in United States United States
Week rank: 227 Down23 in United States United States Down
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

  Files folder image Files (11)  
File Role Description
Accessible without login Plain text file buildClass.php Appl. Class builder
Accessible without login Plain text file buildDatabaseConf.php Appl. Builds a file containing MySQL access information
Accessible without login Plain text file buildForm.php Appl. Input/Edit Form Builder
Accessible without login Plain text file buildProcessForm.php Appl. Build the "save" action associated with a generated form
Accessible without login Plain text file buildSyntacticValidation.php Appl. Generate JavaScript routines for field validation
Plain text file class.SQLData.php Class Generic MySQL Table abstraction base class
Accessible without login Plain text file class.SQLData.template Data C++ template like class for generating proper inhertances to specific database implementations.
Accessible without login Plain text file license.txt Lic. Modified NetBSD License
Accessible without login Plain text file options.php Aux. Common command line options handling.
Accessible without login Plain text file syntacticValidationFramework.css Data Cascading Style Sheet for the generated forms.
Accessible without login Plain text file syntacticValidationFramework.js Data JavaScript framework for validating generated form fields.

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsqldata-2007-12-26.zip 22KB
Downloadsqldata-2007-12-26.tar.gz
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
requestUtils Download .zip .tar.gz Retrive data from access independent of GET or POST method Required
Structured Data Dumper Download .zip .tar.gz Debugging interfaces generated by the various build scripts need it. Required
dm.IS Layout Download .zip .tar.gz Provide C++ template like expansion of the SQLData class Required
dm.DB Download .zip .tar.gz MySQL database abstraction base class Required
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,451
This week:0
All time:1,587
This week:455Up
 User Ratings  
 
 All time
Utility:70%StarStarStarStar
Consistency:79%StarStarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:43%StarStarStar
Rank:3568