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); }