<?php
\test\db\DateTime::create_table();
\test\db\DateTime::find_delete();
$time = time();
$obj = new \test\db\DateTime();
$obj->ts(date('Y/m/d H:i:s', $time));
$obj->date(date('Y/m/d H:i:s', $time));
$obj->idate(date('Y/m/d H:i:s', $time));
$obj->save();
foreach (\test\db\DateTime::find() as $o) {
eq(date('c', $time), $o->fm_ts());
eq(date('Y-m-d', $time), $o->fm_date());
eq(date('Ymd', $time), $o->idate());
}
$db = \ebi\Dao::connection(\test\db\DateTime::class);
$db->query('select ts,date,idate from date_time');
foreach ($db as $data) {
$t = new \DateTime(date('Y/m/d H:i:s', $time));
$t->setTimezone(new \DateTimeZone('UTC'));
if (\ebi\Conf::appmode() == 'mamp') {
eq(date('Y-m-d H:i:s', $time), $data['ts']);
// mysqlの接続設定でtimezoneをJSTで取得している
} else {
eq($t->format('Y-m-d H:i:s'), $data['ts']);
}
eq(date('Y-m-d', $time), $data['date']);
eq(date('Ymd', $time), $data['idate']);
}
<?php
\test\db\DateTime::create_table();
\test\db\DateTime::find_delete();
$obj = new \test\db\DateTime();
eq(null, $obj->ts());
eq(null, $obj->date());
eq(null, $obj->idate());
$obj->save();
foreach (\test\db\DateTime::find() as $o) {
eq(null, $o->ts());
eq(null, $o->date());
eq(null, $o->idate());
}