NAME

OpenResty::SQL::Insert - SQL generator for insert statements

INHERITANCE

    OpenResty::SQL::Insert
        ISA OpenResty::SQL::Statement

SYNOPSIS

    use OpenResty::SQL::Insert;

    my $insert = OpenResty::SQL::Insert->new;
    $insert->insert( 'models' )
        ->values( 'abc' => '"howdy"' );
    print "$insert";
        # produces: insert into models values (abc, "howdy");

    $insert->cols('foo', 'bar');
    print $insert->generate;
        # produces: insert into models (foo, bar) values (abc, "howdy");

DESCRIPTION

This class provides an OO interface for generating SQL insert statements without the pain of concatenating plain SQL strings.

METHODS

new($table)

values(@values)

col(@column_names)

AUTHOR

Agent Zhang (agentzh) <agentzh@yahoo.cn>

SEE ALSO

OpenResty::SQL::Statement, OpenResty::SQL::Select, OpenResty::SQL::Update, OpenResty.