Changeset 21186 for branches/version-2_11-dev/test/class/db/SC_DB_DBFactory_Test.php

Timestamp:

2011/08/11 19:38:25 (13 years ago)

Author:

shutta

Message:

refs #800 (SQL標準関数を使用する)
CURRENT_TIMESTAMP を使用するように now() を置換。
r21185 のコミット漏れ。

File:

• branches/version-2_11-dev/test/class/db/SC_DB_DBFactory_Test.php (modified) (4 diffs)

branches/version-2_11-dev/test/class/db/SC_DB_DBFactory_Test.php

@@ -93 +93 @@
             $expected = "SELECT COUNT(total) FROM dtb_order "
                        . "WHERE del_flg = 0 "
-                         . "AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD') "
+                         . "AND to_char(create_date,'YYYY/MM/DD') = to_char(CURRENT_TIMESTAMP - interval '1 days','YYYY/MM/DD') "
                          . "AND status <> " . ORDER_CANCEL;
             break;
@@ -122 +122 @@
                         . "WHERE del_flg = 0 "
                           . "AND to_char(create_date,'YYYY/MM') = ? "
-                          . "AND to_char(create_date,'YYYY/MM/DD') <> to_char(now(),'YYYY/MM/DD') "
+                          . "AND to_char(create_date,'YYYY/MM/DD') <> to_char(CURRENT_TIMESTAMP,'YYYY/MM/DD') "
                           . "AND status <> " . ORDER_CANCEL;
             break;
@@ -130 +130 @@
                        . "WHERE del_flg = 0 "
                          . "AND date_format(create_date, '%Y/%m') = ? "
-                         . "AND date_format(create_date, '%Y/%m/%d') <> date_format(now(), '%Y/%m/%d') "
+                         . "AND date_format(create_date, '%Y/%m/%d') <> date_format(CURRENT_TIMESTAMP, '%Y/%m/%d') "
                          . "AND status <> " . ORDER_CANCEL;
             break;
@@ -154 +154 @@
                        . "WHERE A.del_flg=0 "
                          . "AND B.del_flg = 0 "
-                         . "AND to_char(A.create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD') "
-                         . "AND to_char(A.create_date,'YYYY/MM/DD') != to_char(now(),'YYYY/MM/DD')";
+                         . "AND to_char(A.create_date, 'YYYY/MM/DD') = to_char(CURRENT_TIMESTAMP - interval '1 days','YYYY/MM/DD') "
+                         . "AND to_char(A.create_date,'YYYY/MM/DD') != to_char(CURRENT_TIMESTAMP,'YYYY/MM/DD')";
             break;