<?php
/**
*@author Dave Gullo: $
*$Generated-date: __DATE__ $
*$Scheminator-XSL: ___XSL___ $
*/
require_once "Cachable.php";
require_once "DBXMLObject.php";
class extends DBXMLObject implements Cachable {
private $debug = false;
protected $lastmodified; //-= Member of the Cachable interface
protected $classname = ''; //-= Magic variable not returned by the Reflection API (TBD)???
public $id;
$;
function ($id = null) {
$this->setSchema("http://snowboards-for-sale.com/xsd/.xsd");
parent::DBXMLObject(); //-= Init our DB
if (isset($id)) {
self::init("CALL .get(". $this->db->escape($id) .")");
}
}
//-= Implementation of abstract method DBXMLObject::save()
function save() {
//-= Perform pattern matching for ``
if (!eregi("", $this->)) {
throw new Exception("Unable to save() $this->classname, pattern facet failed: //");
}
if (isset($this->id) && strlen($this->id) > 0) {
//-= This is already in the database, perform an UPDATE...
$sql = "CALL .update(
$this->id,
". $this->db->nullIfEmpty($this->) .",
)";
$this->db->getQuery($sql);
} else {
//-= This is a brand new instance, INSERT into the database...
$sql = "CALL .insert(
". $this->db->nullIfEmpty($this->) .",
)";
$result = mysqli_fetch_object($this->db->getQuery($sql));
self::__construct($result->);
}
if ($this->debug) echo $sql;
}
//-= Cachable interface implementation
function isCachable() {
return true;
}
function getLastModified() {
$result = $this->db->getObject("CALL .lastmod(". (int)$this->id .")");
return $result->lastmodified;
}
function setLastModified($date) {
if ((int)$date > 0) {
$this->lastmodified = $date;
} else {
throw new Exception(":setLastModified() expects an integer-based timestamp!");
}
$this->db->getQuery("CALL .touch(". (int)$this->id .")");
}
//-= Your custom methods go here, and will be merged in via CVS when this class gets re-autogenerated...
}
if (basename($_SERVER['PHP_SELF']) == basename(__FILE__)) {
switch ($_REQUEST['action']) {
case 'procs':
require_once "Database.php";
$db = new Database();
$db->getQuery("DROP PROCEDURE IF EXISTS .get");
$sql = "
CREATE PROCEDURE .get(IN id int)
BEGIN
SELECT
AS id,
UNIX_TIMESTAMP() AS lastmodified, /* satifies the Cachable interface */
AS ,
FROM .
WHERE = id;
END
";
$db->getQuery($sql);
$db->getQuery("DROP PROCEDURE IF EXISTS .update");
$sql = "
CREATE PROCEDURE .update(
IN id int,
IN in_ ,
)
BEGIN
UPDATE . SET
= in_,
WHERE = id;
END
";
$db->getQuery($sql);
$db->getQuery("DROP PROCEDURE IF EXISTS .insert");
$sql = "
CREATE PROCEDURE .insert(
IN in_ ,
)
BEGIN
INSERT INTO .(
,
) VALUES (
in_,
);
SELECT last_insert_id() AS ;
END
";
$db->getQuery($sql);
$db->getQuery("DROP PROCEDURE IF EXISTS .touch");
$sql = "
CREATE PROCEDURE .touch(IN id int)
BEGIN
UPDATE . SET lastmodified = now() WHERE = id;
END
";
$db->getQuery($sql);
//-= Depending on the composite nature of this entity, this may take into consideration
//-= children objects and relationships.
$db->getQuery("DROP PROCEDURE IF EXISTS .lastmod");
$sql = "
CREATE PROCEDURE .lastmod(IN id int)
BEGIN
SELECT lastmodified FROM . WHERE = id;
END
";
$db->getQuery($sql);
header("Content-type: text/xml");
echo $db->getXMLFromSQL("CALL procs()", 'procs')->saveXML();
break;
default:
//-= Default test case is to toXML using max(primarykey) from tablename
$o = new ();
header("Content-type: text/xml");
echo $o->toXML();
break;
}
}
?>