DB::Object::SQLite::Statement - SQLite Statement Object
use DB::Object::SQLite::Statement; my $this = DB::Object::SQLite::Statement->new || die( DB::Object::SQLite::Statement->error, "\n" );
v0.300.1
This is a SQLite specific statement object class.
Provided with an optional column and called upon a SELECT query and this will modify the query to add the keyword DISTINCT
SELECT
DISTINCT
$sth->distinct; # produces SELECT DISTINCT.... $sth->distinct( 'name' ); # produces SELECT DISTINCT ON (name)....
See SQLite documentation for more information
This is inherited from "dump" in DB::Object::Statement
This takes no argument and this will modify the queries of type insert, or update to add the keyword IGNORE
insert
update
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.
This returns an error as SELECT FROM ONLY is not supported by SQLite and will return an error.
SELECT FROM ONLY
This is unsupported under SQLite and if used returns an error.
This returns the natural SQLite statement property sqlite_unprepared_statements, which provides the remaining unprepared statements in case where multiple statements were prepared.
sqlite_unprepared_statements
See DBD::SQLite documentation for more information
This is unsupported under SQLite and it will be silently ignore, returning the current object.
perl
Jacques Deguest <jack@deguest.jp>
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.
To install DB::Object, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DB::Object
CPAN shell
perl -MCPAN -e shell install DB::Object
For more information on module installation, please visit the detailed CPAN module installation guide.