Zend Framework: Zend_Db_Model Component Proposal

Proposed Component Name	Zend_Db_Model
Developer Notes	http://framework.zend.com/wiki/display/ZFDEV/Zend_Db_Model
Proposers	Borja Fernandez
Revision	1.2 - 19 July 2006: Updated from community comments. (wiki revision: 14)

// Initialization
$model = new Zend_Db_Model();
$model->setModelsDir(APP . '/models/');

// This return an object based on
// APP . '/models/' . Users.php class
$user = $model->factory('users');

// Basic insert
$user->username='myusername';
$user->password='mypass';
$user->email=$email;
$user->insert();

// associative array insert
$user->assignArray($array);
$user->insert();

// Basic update
$user->find('myusername');
$user->password='newpassword';
$user->update();


// Basic delete
$user->find('myusername');
$user->delete();

UC-02

/** Example model file based on this table
**	CREATE TABLE users (
**		username varchar(12) not null primary key,
**		password varchar(12) not null,
**		group_id unsigned int
**  );
**
**	CREATE TABLE groups(
**		id unsigned int primary key,
**		name varchar(12) not null
**	);

// Users.php on APP . '/models/' dir
class Users Extends Zend_Db_Model_Abstract {	
	public function loadObjects() {
		$this->addObject('group','group_id');
	}
}

class Groups Extends Zend_Db_Model_Abstract {}

// Change group name if is an admin user
$users->find($id);
if ($users->group->name == 'ADMIN') {
	$users->group->name = 'SUPERADMIN';
}
$users->save();

// Others uses
echo $users->lastLogin->dateValue('Year: %Y');

9. Class Skeletons

Zend_Db_Model
	setModelsDir($dir)
	setAdapter($db)
	factory($model,$id = null)
	
Zend_Db_Model_Abstract
	public function __construct($object,$id = null)
	private function _checkDb()
	private function describeTable()	
	public function insert()
	public function update()
	public function delete()	
	public function toArray()
	public function getAdapter()
	public function assignArray($data)
	public function addField($field,$data,$filter = null)
	public function key($keyname = null)
	public function keyvalue()
	public function table($tablename = null)
	public function assignPostVars()
	public function find($id)

Zend_Db_Model_Exception

Page Operations

Browse Space

Zend_Db_Model - Borja Fernandez

Labels

Zend Framework: Zend_Db_Model Component Proposal

Table of Contents

1. Overview

2. References

3. Component Requirements, Constraints, and Acceptance Criteria

4. Dependencies on Other Framework Components

5. Theory of Operation

6. Milestones / Tasks

7. Class Index

8. Use Cases

9. Class Skeletons