#!/usr/bin/perl
my
$a
= SQL::Abstract->new();
my
$b
= SQL::Maker->new(
driver
=>
'mysql'
);
print
"insert\n"
;
cmpthese(
-1
=> {
'SQL::Abstract'
=>
sub
{
$a
->insert(
foo
=> {
a
=> 1,
foo
=> 4}); },
'SQL::Maker'
=>
sub
{
$b
->insert(
foo
=> {
a
=> 1,
foo
=> 4}); },
},
);
print
"\n"
;
print
"update\n"
;
cmpthese(
-1
=> {
'SQL::Abstract'
=>
sub
{
$a
->update(
foo
=> {
a
=> 1,
foo
=> 4}, {
john
=> 4,
man
=> 3}); },
'SQL::Maker'
=>
sub
{
$b
->update(
foo
=> {
a
=> 1,
foo
=> 4}, {
john
=> 4,
man
=> 3}); },
},
);
print
"\n"
;
print
"delete\n"
;
cmpthese(
-1
=> {
'SQL::Abstract'
=>
sub
{
$a
->
delete
(
foo
=> {
john
=> 4,
man
=> 3}); },
'SQL::Maker'
=>
sub
{
$b
->
delete
(
foo
=> {
john
=> 4,
man
=> 3}); },
},
);
print
"\n"
;
print
"select\n"
;
cmpthese(
-1
=> {
'SQL::Abstract'
=>
sub
{
$a
->
select
(
foo
=> [
qw/a b/
], {
john
=> 4,
man
=> 3}); },
'SQL::Maker'
=>
sub
{
$b
->
select
(
foo
=> [
qw/a b/
], {
john
=> 4,
man
=> 3}); },
},
);