View | Details | Raw Unified | Return to bug 20144
Collapse All | Expand All

(-)a/t/db_dependent/Koha.t (-4 / +3 lines)
Lines 173-187 SKIP: Link Here
173
# Fill the quote table with the default needed and a spare
173
# Fill the quote table with the default needed and a spare
174
$dbh->do("DELETE FROM quotes WHERE id=3 OR id=25;");
174
$dbh->do("DELETE FROM quotes WHERE id=3 OR id=25;");
175
my $sql = "INSERT INTO quotes (id,source,text,timestamp) VALUES
175
my $sql = "INSERT INTO quotes (id,source,text,timestamp) VALUES
176
(25,'Richard Nixon','When the President does it, that means that it is not illegal.','0000-00-00 00:00:00'),
176
(25,'Richard Nixon','When the President does it, that means that it is not illegal.',NOW()),
177
(3,'Abraham Lincoln','Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.','0000-00-00 00:00:00');";
177
(3,'Abraham Lincoln','Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',NOW());";
178
$dbh->do($sql);
178
$dbh->do($sql);
179
179
180
                my $expected_quote = {
180
                my $expected_quote = {
181
                    id          => 3,
181
                    id          => 3,
182
                    source      => 'Abraham Lincoln',
182
                    source      => 'Abraham Lincoln',
183
                    text        => 'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',
183
                    text        => 'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',
184
                    timestamp   => re('\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}'),   #'0000-00-00 00:00:00',
184
                    timestamp   => re('\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}'),   #'YYYY-MM-DD HH:MM:SS'
185
                };
185
                };
186
186
187
# test quote retrieval based on id
187
# test quote retrieval based on id
188
- 

Return to bug 20144