NAME

SQL::OOP::Delete

SYNOPSIS

use SQL::OOP::Delete;

my $delete= SQL::OOP::Delete->new();

# set clause
$delete->set(
    $delete->ARG_TABLE => 'some_table',
    $delete->ARG_WHERE => SQL::OOP::Where->cmp('=', 'a', 'b'),
);

# reset clause by plain text
$delete->set(
    $delete->ARG_WHERE => 'a = b'
);

my $sql  = $delete->to_string;
my @bind = $sth->execute($delete->bind);

DESCRIPTION

SQL::OOP::Delete class represents Delete commands.

SQL::OOP::Delete CLASS

SQL::OOP::Delete->new(%clause)

Constructor. It takes arguments in hash. The Hash keys are provided by following methods. They can call either class method or instance method.

ARG_TABLE
ARG_WHERE

$instance->set(%clause)

This method resets the clause data. It takes same argument as constructor.

$instance->to_string

$instance->bind

CONSTANTS

KEYS

PREFIXES

ARG_TABLE

argument key for table name(=1)

ARG_WHERE

argument key for where clause(=2)

SEE ALSO