NAME

SQL::OOP::Insert

SYNOPSIS

    my $insert = SQL::OOP::Insert->new();
    
    # set clause
    $insert->set(
        $insert->ARG_TABLE => SQL::OOP::ID->new('some_table'),
        $insert->ARG_DATASET => SQL::OOP::Dataset->new(%data),
    );
    
    # reset clause by plain text
    $insert->set(
        $insert->ARG_TABLE => 'some_table',
    );
    
    my $sql  = $delete->to_string;
    my @bind = $delete->bind;
        

DESCRIPTION

SQL::OOP::Insert class represents Insert commands.

SQL::OOP::Insert CLASS

SQL::OOP::Insert->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_DATASET
    ARG_SELECT

$instance->set(%clause)

$instance->bind

$instance->to_string

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

CONSTANTS

KEYS

PREFIXES

ARG_TABLE

argument key for table name(=1)

ARG_DATASET

argument key for dataset(=2)

ARG_SELECT

argument key for select(=3)

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.