1Class::DBI::SQLite(3) User Contributed Perl DocumentationClass::DBI::SQLite(3)
2
3
4
6 Class::DBI::SQLite - Extension to Class::DBI for sqlite
7
9 package Film;
10 use base qw(Class::DBI::SQLite);
11 __PACKAGE__->set_db('Main', 'dbi:SQLite:dbname=dbfile', '', '');
12 __PACKAGE__->set_up_table('Movies');
13
14 package main;
15 my $film = Film->create({
16 name => 'Bad Taste',
17 title => 'Peter Jackson',
18 });
19 my $id = $film->id; # auto-incremented
20
22 Class::DBI::SQLite is an extension to Class::DBI for DBD::SQLite. It
23 allows you to populate an auto-incremented row id after insert.
24
25 The "set_up_table" method automates the setup of columns and primary
26 key(s) via the SQLite PRAGMA statement.
27
29 Tatsuhiko Miyagawa <miyagawa@bulknews.net>
30
31 "set_up_table" implementation by Tomohiro Ikebe <ikebe@cpan.org>
32
33 This library is free software; you can redistribute it and/or modify it
34 under the same terms as Perl itself.
35
37 Class::DBI, DBD::SQLite
38
39
40
41perl v5.36.0 2022-07-22 Class::DBI::SQLite(3)