Login   Register  
PHP Classes

SQL Data: Generate classes to store objects in SQL databases

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Richard Munroe
Name: Richard Munroe is available for providing paid consulting. Contact Richard Munroe .
Packages: 22 Browse all classes by Richard Munroe Browse all classes by
Country: United States United States - PHP jobs in United States
Age: 63
All time rank: 111 in United States United States
Week rank: 47 Down6 in United States United States Down
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of Richard Munroe  >  SQL Data  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Data
Base name: sqldata
Description: Generate classes to store objects in SQL databases
Version: -
PHP version: -
License: Custom (specified in a license file)
All time users: 2419 users
All time rank: 1462
Week users: 1 user
Week rank: 1909 Down
  Groups   Rate classes User ratings   Dependencies   Applications   Files Files  

Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Code Generation Compilers and tools that generate code automatically View top rated classes

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (75.0%) Good (85.0%) - - - - Not sure (46.0%) 1827
Month: Not yet rated by the users

  Packages needed by this class  
Class Dependency Why it is needed
requestUtils Required Retrive data from access independent of GET or POST method
Structured Data Dumper Required Debugging interfaces generated by the various build scripts need it.
dm.IS Layout Required Provide C++ template like expansion of the SQLData class
dm.DB Required MySQL database abstraction base class

  Applications that use this class  
Link Description
Florida Democratic Party Website Florida Democratic Party Website
www.esplanner.com Economic Security Planner web site
Your Daily Sudoku A Sudoku generation and distribution website.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
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.

Download Download all files: sqldata.tar.gz sqldata.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.