Attachment #71436 for bug #20144

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




# Fill the quote table with the default needed and a spare
$dbh->do("DELETE FROM quotes WHERE id=3 OR id=25;");
my $sql = "INSERT INTO quotes (id,source,text,timestamp) VALUES
(25,'Richard Nixon','When the President does it, that means that it is not illegal.',NOW()),
(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());";
$dbh->do($sql);

                my $expected_quote = {
                    id          => 3,
                    source      => 'Abraham Lincoln',
                    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.',
                    timestamp   => re('\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}'),   #'YYYY-MM-DD HH:MM:SS'
                };

# test quote retrieval based on id
- 

Return to bug 20144

Lines 173-187 SKIP: Link Here

(-)a/t/db_dependent/Koha.t (-4 / +3 lines)
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	-