• NOTICE - Please read the ChangeLog file for latest updates and changes regarding v0.7RC2.
• I officially started working on a version that supports Zend Framework 2.
• (about time!) :)

Zend-Db-Model-Generator

Instructions:

1. copy config.php-default to config.php inside data directory
2. edit config.php and configure your db and other relevant directives.
3. execute it.

parameters: --database : database name (required option) --location : specify where to create the files (default is current directory) --templates : specify the location of the templates (default is "templates") --namespace : override config file's default namespace

• --table : table name (parameter can be used more then once) --table-prefix : remove that prefix of table name (can be used more then once) --all-tables : create classes for all the scripts in the database
• --ignore-table : not to create a class for a specific table
• --ignore-tables-regex : ignore tables by perl regular expression

• --tables-regex : add tables by perl regular expression

              parameters with * can be used more then once.

For comments/suggestions please e-mail,msn,google talk, google wave me at kfirufk@gmail.com.

REQUIREMENTS

1. php-cli 5.2+
2. PDO extension
3. This script was only tested on MySQL and MS-SQL server. if it works on any other servers please let me know.

NOTICE

Since version 0.4, in order to prevent code duplication, common classes where seperated from the model class to MainModel.php and from the DbTable class to MainDbTable.php. these classes are already placed by the script in their appropriate places

USAGE

class::toArray() - returns an array, keys are the column names class::fetchAll() - fetch all rows class::findOneBy($value) - find a row where the field eq $value class::findBy($value) - find an array class::find($id) - find a row by primary key class::fetchList($where=null, $order=null, $count=null, $offset=null) - fetch all , filtered by where, order, count and offset. class::fetchListToArray($where=null, $order=null, $count=null, $offset=null) - fetch all , filtered by where, order, count and offset. returns each row in an array instead of an instance of the class. class::save($ignoreEmptyValuesOnUpdate=true) - save the current row class::set($value) - sets a field with a value class::get() - get a field's value class::fetchAllToArray() - returns all the rows of the table in an array

class::deleteRowByPrimaryKey() - in general it's used to delete the current loaded row class::delete($where) - delete rows in the table by $where class::countAllRows() - counts all rows class::getPrimaryKeyName() - returns the name of the primary key column class::countByQuery($where='') - count query results class::select2Paginator(Zend_Db_Select $select) - created a Zend_Paginator class by a given select class::fetchAll2Paginator() - fetch all rows into a Zend_Paginator class::fetchListToPaginator($where=null, $order=null, $count=null, $offset=null) - fetchs all rows optionally filtered by where, order, count and offset class::getTableName() - returns the table name class::getSelect($withFromPart=true,$resetColumns=true,$resetOrder=true,$resetLimitOffset=true) - returns a Zend_Db_Table_select object class::query2Paginator($query) - creates a Zend_Paginator for a query string

Example:

class for database table 'users':

===== example.php =======

<?php

/* The following code may be needed without the usage of Zend Framework MVC.

• here i include the Users.php file created by this script, the the
• Zend_Db_Adapter_Mysqli in order to create a connection
• to the database, and the Zend_Db_Table
• class in order to set the default adapter. */

require_once("Users.php");

require_once("Zend/Db/Adapter/Mysqli.php"); require_once("Zend/Db/Table.php");

$db = new Zend_Db_Adapter_Mysqli(array( 'host' => '127.0.0.1', 'username' => 'root', 'password' => '', 'dbname' => '' ));

Zend_Db_Table::setDefaultAdapter($db);

$users = new Default_Model_Users();

// example 1: fetchs an array of Default_Model_Users filtered by username eq 'admin'.

$data=$users->fetchList('username = \'admin\'',null,1); var_dump($data[0]->toArray());

// fetchs one row where username eq 'admin' $users->findOneByUsername('admin'); var_dump($users->toArray());

// fetches all rows where username eq 'admin' $data=$users->findByUsername('admin'); var_dump($data[0]->toArray());

// finds a row where username eq 'admin' and saves it $users->findOneByUsername('admin'); $users->setUsername('root'); $users->save();

// finds a row by primary key 1 and delete it $users->setId(1); $users->deleteRowByPrimaryKey();

// updates username in row 9 $users->setId(9); $users->setUsername('newuser'); $users->save();

?>

==== end of example.php ==

** more examples can be found in testzdmg directory.

THANKS

I want to thank the following people for their feedback/patches/comments: Charles Spraggs,Richard Hamilton,AJIT DIXIT,Aleksandar Scepanovic,Ivan Mosquera Paulo

Changelog is created by svn2cl (http://arthurdejong.org/svn2cl).