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 .
Classes: 22 packages by
Country: United States United States
Age: 63
All time rank: 111 in United States United States
Week rank: 84 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: 2422 users
All time rank: 1473
Week users: 0 users
Week rank: 1604 Equal
  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%) Good (85%) - - - - Not sure (46%) 1849
Month: Not yet rated by the users

  Packages needed by this class  
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

  Applications that use this package  
Florida Democratic Party Website
Florida Democratic Party Website
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.