Class::DBI::SQLite - Extension to Class::DBI for sqlite

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

       Class::DBI::SQLite - Extension to Class::DBI for sqlite

       Class::DBI, DBD::SQLite

perl v5.36.0                                       2022-12-10                            Class::DBI::SQLite(3pm)

         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