Class:...SQLite(3pm)

💖 NAME 💖

Class::DBI::SQLite — the glow-up extension to Class::DBI made specially for sqlite ✨

---

🌸 SYNOPSIS 🌸

okay bestie, here's the whole vibe in one go 🫶

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

like. look at that. the $id just shows up after insert, no cap 💅

---

🦋 DESCRIPTION 🦋

So Class::DBI::SQLite is an extension to Class::DBI for DBD::SQLite. Its whole little party trick? It lets you populate an auto-incremented row id after insert 🔥 — so once you create a row, the object already knows its shiny new id and you don't have to go hunting for it.

And then there's the set_up_table method, which is the real main character 👑 — it automates the setup of columns and primary key(s) for you, doing it via the SQLite PRAGMA statement. you don't hand-write any of that, it just handles it. periodt.

---

🎀 AUTHOR 🎀

• Tatsuhiko Miyagawa <miyagawa@bulknews.net> — icon, legend, the moment 💖
• the set_up_table implementation was done by Tomohiro Ikebe</Tomohiro Ikebe> <ikebe@cpan.org> — shoutout, we love to see it 🫶

Also, for the legal girlypops: this library is free software; you can redistribute it and/or modify it under the same terms as Perl itself ✨

---

🌈 SEE ALSO 🌈

• Class::DBI
• DBD::SQLite

iykyk — go read those next, bestie 📚

---

lowkey a tiny page but it's giving essential. no notes. slay. 💅

and that's the whole thing, gorgeous — this was Class::DBI::SQLite from the Perl docs (User Contributed Perl Documentation), shipped with perl v5.36.0, dated 2022-12-10 ⭐ bye bestie, go auto-increment something 🧚💜