Class::DBI::SQLite(3pm)

Class::DBI::SQLite3pm

Extension to class::dbi for sqlite

Usage

  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

Overview

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.

Releases

10 releases since Debian 4.0 (Etch); the text changed 5 times.

  1. 4.0
  2. 5.0
  3. 6.0–9
  4. 10
  5. 11
  6. 12–13

Author

Tatsuhiko Miyagawa <[email protected]>

"set_up_table" implementation by Tomohiro Ikebe <[email protected]>

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

From libclass-dbi-sqlite-perl 0.11-6 in Debian 13 (Trixie). Parsed by carta from the page's man source.