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