public function testType() { $a = ['types' => [['string' => 'foo', 'date' => '2013-02-20', 'datetime' => '2013-02-20 20:00:12', 'time' => '12:00:50', 'boolean' => '1', 'integer' => '2940', 'money' => '8.20', 'float' => '8.202343', 'array' => '[1,2,3]']]]; $this->setDB($a); date_default_timezone_set('Asia/Seoul'); $db = new Persistence_SQL($this->db->connection); $m = new Model($db, ['table' => 'types']); $m->addField('string', ['type' => 'string']); $m->addField('date', ['type' => 'date']); $m->addField('datetime', ['type' => 'datetime']); $m->addField('time', ['type' => 'time']); $m->addField('boolean', ['type' => 'boolean']); $m->addField('money', ['type' => 'money']); $m->addField('float', ['type' => 'float']); $m->addField('integer', ['type' => 'integer']); $m->addField('array', ['type' => 'array']); $m->load(1); $this->assertSame('foo', $m['string']); $this->assertSame(true, $m['boolean']); $this->assertSame(8.199999999999999, $m['money']); $this->assertEquals(new \DateTime('2013-02-20'), $m['date']); $this->assertEquals(new \DateTime('2013-02-21 05:00:12'), $m['datetime']); $this->assertEquals(new \DateTime('12:00:50'), $m['time']); $this->assertSame(2940, $m['integer']); $this->assertEquals([1, 2, 3], $m['array']); $this->assertSame(8.202343000000001, $m['float']); $m->duplicate()->save(); $a = ['types' => [1 => ['id' => '1', 'string' => 'foo', 'date' => '2013-02-20', 'datetime' => '2013-02-20 20:00:12', 'time' => '12:00:50', 'boolean' => 1, 'integer' => 2940, 'money' => 8.199999999999999, 'float' => 8.202343000000001, 'array' => '[1,2,3]'], 2 => ['id' => '2', 'string' => 'foo', 'date' => '2013-02-20', 'datetime' => '2013-02-20 20:00:12', 'time' => '12:00:50', 'boolean' => '1', 'integer' => '2940', 'money' => '8.2', 'float' => '8.202343', 'array' => '[1,2,3]']]]; $this->assertEquals($a, $this->getDB()); list($first, $duplicate) = $m->export(); unset($first['id']); unset($duplicate['id']); $this->assertEquals($first, $duplicate); }
public function testActual() { $db = new Persistence_SQL($this->db->connection); $a = ['user' => [1 => ['id' => 1, 'name' => 'John', 'surname' => 'Smith']]]; $this->setDB($a); $m = new Model($db, 'user'); $m->addField('first_name', ['actual' => 'name']); $m->addField('surname'); $m->insert(['first_name' => 'Peter', 'surname' => 'qq']); $m->loadBy('first_name', 'John'); $this->assertEquals('John', $m['first_name']); $d = $m->export(); $this->assertEquals('John', $d[0]['first_name']); $a = ['user' => [1 => ['id' => 1, 'name' => 'John', 'surname' => 'Smith'], 2 => ['id' => 2, 'name' => 'Peter', 'surname' => 'qq']]]; $this->assertEquals($a, $this->getDB()); $m['first_name'] = 'Scott'; $m->save(); $a = ['user' => [1 => ['id' => 1, 'name' => 'Scott', 'surname' => 'Smith'], 2 => ['id' => 2, 'name' => 'Peter', 'surname' => 'qq']]]; $this->assertEquals($a, $this->getDB()); }