Sugama Keita > SQL-OOP-0.20 > SQL::OOP::Delete

Download:
SQL-OOP-0.20.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Source   Latest Release: SQL-OOP-0.21

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)

AUTHOR ^

Sugama Keita, <sugama@jamadam.com>

COPYRIGHT AND LICENSE ^

Copyright (C) 2011 by Sugama Keita.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

syntax highlighting: