public function test_get_all()
{
$session = Cascade::getAccessor(self::SCHEMA_NAME);
$data_01 = $session->getAll();
// -----------------------------
$this->assertEquals(1, $data_01[1]['id']);
$this->assertEquals(1, $data_01[1]['category']);
$this->assertEquals('勇者の剣', $data_01[1]['name']);
$this->assertEquals(1000, $data_01[1]['str']);
$this->assertEquals(0, $data_01[1]['def']);
// -----------------------------
$this->assertEquals(2, $data_01[2]['id']);
$this->assertEquals(2, $data_01[2]['category']);
$this->assertEquals('勇者の盾', $data_01[2]['name']);
$this->assertEquals(0, $data_01[2]['str']);
$this->assertEquals(1000, $data_01[2]['def']);
}
public function test_insert_failed_2()
{
$accessor = Cascade::getAccessor(self::SCHEMA_NAME);
$stmt_name = 'insert';
$object = new stdClass();
$object->foo = 'bar';
$object->hoge = 'fuga';
$params = array('user_id' => $object, 'item_id' => 2, 'num' => null);
try {
$data_04 = $accessor->execute($stmt_name, $params, $hint = NULL);
// exceition
} catch (Cascade_Exception_DBException $exception) {
$expected = "Invalid Z_TYPE of bind-value {z_type, value} object stdClass(\n foo: bar,\n hoge: fuga\n)";
$this->assertSame($expected, $exception->getMessage());
return;
}
$this->fail();
}
public function test_to_execute_02()
{
$accessor = Cascade::getAccessor(self::SCHEMA_NAME);
$stmt_name = 'inc_num';
$params = array('user_id' => 200, 'item_id' => 5, 'diff_num' => 3);
$data_01 = $accessor->execute($stmt_name, $params, $hint = NULL);
$stmt_name = 'sum_num';
$params = array('user_id' => 200);
$data_02 = $accessor->toValue($stmt_name, $params, $hint = NULL, $use_master = TRUE);
// -----------------------------
$this->assertEquals(1, $data_01);
$this->assertEquals(3, $data_02);
}
public function test_inc_01()
{
$key = 564;
$offset = 1;
$accessor = Cascade::getAccessor(self::SCHEMA_NAME);
$accessor->delete($key);
// -----------------------------
$accessor->add($key, 0);
for ($i = 1; $i <= 100; $i++) {
$data_01 = $accessor->increment($key, $offset);
$this->assertEquals($data_01, $i * $offset);
}
// -----------------------------
for ($i = 1; $i < 100; $i++) {
$data_01 = $accessor->decrement($key, $offset);
$this->assertEquals($data_01, 100 - $i * $offset);
}
}
public function test_create_db()
{
$accessor = Cascade::getAccessor(self::SCHEMA_NAME);
$accessor->createDB();
}
public function test_count_01()
{
$accessor = Cascade::getAccessor(self::SCHEMA_NAME);
$data_01 = $accessor->count('staging');
// -----------------------------
$this->assertEquals(2, $data_01);
}
