|
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 |
- |
|
|