8 use lib "$FindBin::Bin";
15 my $sql = SQL::Abstract->new;
20 name => 'Nathan Wiger',
21 phone => '123-456-7890',
22 addr => 'Yeah, right',
29 name => 'Jimbo Bobson',
30 phone => '321-456-0987',
38 name => 'Mr. Garrison',
39 phone => '123-456-7890',
48 phone => '1-800-Sucky-Sucky',
49 addr => 'Mr. Garrison',
55 user => 'barbara_streisand',
56 name => 'MechaStreisand!',
64 # Note to self: I have no idea what this does anymore
65 # It looks like a cool fucking segment of code though!
66 # I just wish I remembered writing it... :-\
69 my($laststmt, $numfields);
73 $stmt = $sql->insert('yo_table', $t);
74 my @val = $sql->values($t);
77 ok((! $laststmt || $stmt eq $laststmt) && @val == $numfields
78 && equal(\@val, [map { $t->{$_} } sort keys %$t])) or
82 "[$t->{stmt}] [stuff]\n\n";
88 return 0 if @$a != @$b;
89 for (my $i = 0; $i < $#{$a}; $i++) {
90 next if (! defined($a->[$i])) && (! defined($b->[$i]));
91 return 0 if $a->[$i] ne $b->[$i];