/ 
DB-Object-v1.11.0
/ DB::Object::SQLite::Statement

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.301.0

DESCRIPTION

This is a SQLite specific statement object class.

Any methods not documented here is called directly via the SQL driver.

If an error occurs, undef or an an empty list is returned, and the error code, if any, can be retrieved with $sth->error->code and the error message, if any, with $sth->error->message

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

my $value = $sth->only;

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

priority

my $value = $sth->priority;

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

unprepared_statements

my $value = $sth->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-2026 DEGUEST Pte. Ltd.

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