Yichun Zhang (章亦春) > OpenResty-0.5.12 > OpenResty::SQL::Insert

Download:
OpenResty-0.5.12.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Source  

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.

syntax highlighting: