NAME

DB::Object::SQLite::Statement - SQLite Statement Object

SYNOPSIS

    use DB::Object::SQLite::Statement;
    my $this = DB::Object::SQLite::Statement->new || die( DB::Object::SQLite::Statement->error, "\n" );

VERSION

    v0.300.1

DESCRIPTION

This is a SQLite specific statement object class.

METHODS

distinct

Provided with an optional column and called upon a SELECT query and this will modify the query to add the keyword DISTINCT

    $sth->distinct;
    # produces SELECT DISTINCT....
    $sth->distinct( 'name' );
    # produces SELECT DISTINCT ON (name)....

See SQLite documentation for more information

dump

This is inherited from "dump" in DB::Object::Statement

ignore

This takes no argument and this will modify the queries of type insert, or update to add the keyword IGNORE

    $sth->ignore;
    # produces INSERT IGNORE....

If called in void context, this will execute the prepare statement handler immediately.

It returns the newly created statement handler.

See SQLite documentation for more information

only

This returns an error as SELECT FROM ONLY is not supported by SQLite and will return an error.

priority

This is unsupported under SQLite and if used returns an error.

unprepared_statements

This returns the natural SQLite statement property sqlite_unprepared_statements, which provides the remaining unprepared statements in case where multiple statements were prepared.

See DBD::SQLite documentation for more information

wait

This is unsupported under SQLite and it will be silently ignore, returning the current object.

SEE ALSO

perl

AUTHOR

Jacques Deguest <jack@deguest.jp>

COPYRIGHT & LICENSE

Copyright (c) 2019-2021 DEGUEST Pte. Ltd.

You can use, copy, modify and redistribute this package and associated files under the same terms as Perl itself.

cpanm DB::Object

perl -MCPAN -e shell
install DB::Object