예제 #1
0
 function triggerPostUpdate($where, $values)
 {
     echo __CLASS__ . "::" . __FUNCTION__ . "\n";
     var_export($where);
     echo "\n";
     var_export($values);
     echo "\n";
     test\tbl1::factory($this->getDb())->delete()->where($where)->exec();
 }
예제 #2
0
error_reporting(-1);
require_once "Nov/Loader.php";
Nov\Loader::init();
use Nov\Db\Orm\Instance;
use Orm\test;
echo "<pre>";
$db = Nov\Db::factory(NovConf::PG1);
$db->beginTransaction();
$values = array('id' => 'max(' . test\tbl1::ID . ')');
$id = test\tbl1::factory($db)->select($values)->exec(Nov\Db::FETCH_ONE);
$id++;
$values = array(test\tbl1::ID => $id, test\tbl1::FIELD1 => "user_{$id}");
test\tbl1::factory($db)->insert($values)->exec();
test\tbl1::factory($db)->update(array(test\tbl1::FIELD1 => 'xxx'))->where(array(test\tbl1::ID => $id))->exec();
$db->commit();
$all = test\tbl1::factory($db)->select()->exec();
foreach ($all as $reg) {
    $ar = new test\tbl1_Record($reg);
    echo $ar->id();
    echo "::";
    echo $ar->field1();
    echo "\n";
}
$all = test\vw1::factory($db)->select()->exec();
foreach ($all as $reg) {
    $ar = new test\vw1_Record($reg);
    echo $ar->id();
    echo "::";
    echo $ar->field1();
    echo "\n";
}