Class::DBI::SQLite - Extension to Class::DBI for sqlite
package Film; use base qw(Class::DBI::SQLite); __PACKAGE__->set_db('Main', 'dbi:SQLite:dbname=dbfile', '', ''); __PACKAGE__->set_up_table('Movies'); package main; my $film = Film->create({ name => 'Bad Taste', title => 'Peter Jackson', }); my $id = $film->id; # auto-incremented
Class::DBI::SQLite is an extension to Class::DBI for DBD::SQLite. It allows you to populate an auto-incremented row id after insert.
The set_up_table method automates the setup of columns and primary key(s) via the SQLite PRAGMA statement.
set_up_table
Tatsuhiko Miyagawa <miyagawa@bulknews.net>
set_up_table implementation by Tomohiro Ikebe <ikebe@cpan.org>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Class::DBI, DBD::SQLite
To install Class::DBI::SQLite, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Class::DBI::SQLite
CPAN shell
perl -MCPAN -e shell install Class::DBI::SQLite
For more information on module installation, please visit the detailed CPAN module installation guide.