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

(-)a/t/db_dependent/SQLHelper.t (-4 lines)
Lines 50-61 $borrowers=SearchInTable("borrowers",["Valjean",{firstname=>"Jean"}],undef,undef Link Here
50
ok(keys %{$$borrowers[0]} ==1, "Search In Table columns out limit");
50
ok(keys %{$$borrowers[0]} ==1, "Search In Table columns out limit");
51
$borrowers=SearchInTable("borrowers",["Valjean",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(firstname surname title)]);
51
$borrowers=SearchInTable("borrowers",["Valjean",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(firstname surname title)]);
52
ok(@$borrowers>0, "Search In Table columns out limit to borrowernumber AND filter firstname surname title");
52
ok(@$borrowers>0, "Search In Table columns out limit to borrowernumber AND filter firstname surname title");
53
$borrowers=SearchInTable("borrowers",["Valjean",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(firstname title)]);
54
ok(@$borrowers==0, "Search In Table columns filter firstname title limit Valjean not in other fields than surname ");
55
$borrowers=SearchInTable("borrowers",["Val",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(surname)],"start_with");
53
$borrowers=SearchInTable("borrowers",["Val",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(surname)],"start_with");
56
ok(@$borrowers>0, "Search In Table columns filter surname  Val on a wide search found ");
54
ok(@$borrowers>0, "Search In Table columns filter surname  Val on a wide search found ");
57
$borrowers=SearchInTable("borrowers",["Val",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(surname)],"exact");
55
$borrowers=SearchInTable("borrowers",["Val",{firstname=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(surname)],"exact");
58
ok(@$borrowers==0, "Search In Table columns filter surname  Val in exact search not found ");
59
$borrowers=eval{SearchInTable("borrowers",["Val",{member=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(firstname title)],"exact")};
56
$borrowers=eval{SearchInTable("borrowers",["Val",{member=>"Jean"}],undef,undef,[qw(borrowernumber)],[qw(firstname title)],"exact")};
60
ok(@$borrowers==0 && !($@), "Search In Table fails gracefully when no correct field passed in hash");
57
ok(@$borrowers==0 && !($@), "Search In Table fails gracefully when no correct field passed in hash");
61
$borrowers=eval{SearchInTable("borrowers",["Jea"],undef,undef,undef,[qw(firstname surname borrowernumber)],"start_with")};
58
$borrowers=eval{SearchInTable("borrowers",["Jea"],undef,undef,undef,[qw(firstname surname borrowernumber)],"start_with")};
62
- 

Return to bug 5327