* @version 0.4.0, 2009-01-27
*/
/** Zend_Db */
require_once 'Zend/Db.php';
/** Zend_Db_Table */
require_once 'Zend/Db/Table.php';
/** Setup database */
require_once 'db.inc.php';
// Create data source
$departments = null;
require_once 'departments.inc.php';
$createTables = '
CREATE TABLE departments (
Id INTEGER NOT NULL PRIMARY KEY,
Name VARCHAR(100)
);
';
$db->query($createTables);
foreach ($departments as $department) {
$db->insert('departments', (array) $department);
}
// DepartmentTable class
class DepartmentTable extends Zend_Db_Table
{
protected $_name = 'departments';
// table name
protected $_primary = 'Id';
}
$departmentTable = new DepartmentTable(array('db' => $db));
$departmentTable->setRowClass('Department');
