X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F01generate.t;h=e6d1c6cd2e223dca98cd307c3f85cefdc343399d;hb=85327cd53cf6ff59413f4d0bf70e2e624c38b572;hp=020dfa5f27b73a02d9738d558d3143b721a69a3f;hpb=27fa2a14ad5d889570cf3edc42a031050046ffbc;p=scpubgit%2FQ-Branch.git diff --git a/t/01generate.t b/t/01generate.t index 020dfa5..e6d1c6c 100644 --- a/t/01generate.t +++ b/t/01generate.t @@ -595,6 +595,27 @@ my @tests = ( stmt_q => 'UPDATE `mytable` SET `foo` = ? WHERE `baz` = ? RETURNING `id`, `created_at`', bind => [42, 32], }, + { + func => 'delete', + args => ['test', {requestor => undef}, {returning => 'id'}], + stmt => 'DELETE FROM test WHERE ( requestor IS NULL ) RETURNING id', + stmt_q => 'DELETE FROM `test` WHERE ( `requestor` IS NULL ) RETURNING `id`', + bind => [] + }, + { + func => 'delete', + args => ['test', {requestor => undef}, {returning => \'*'}], + stmt => 'DELETE FROM test WHERE ( requestor IS NULL ) RETURNING *', + stmt_q => 'DELETE FROM `test` WHERE ( `requestor` IS NULL ) RETURNING *', + bind => [] + }, + { + func => 'delete', + args => ['test', {requestor => undef}, {returning => ['id', 'created_at']}], + stmt => 'DELETE FROM test WHERE ( requestor IS NULL ) RETURNING id, created_at', + stmt_q => 'DELETE FROM `test` WHERE ( `requestor` IS NULL ) RETURNING `id`, `created_at`', + bind => [] + }, ); # check is( not) => undef