Class:...SQLite(3pm)

💖 Class::DBI::Loader::SQLite 💖

okay bestie, so this is the SQLite implementation of Class::DBI::Loader — like, the plug that lets your SQLite database show up as a whole lil family of Perl classes. it lives in the User Contributed Perl Documentation pile and it is genuinely so cute of it. 🫶

---

✨ NAME ✨

Class::DBI::Loader::SQLite — that's the module, and what it is, is the Class::DBI::Loader SQLite Implementation. boom. iconic. 💅

---

🌸 SYNOPSIS 🌸

the way you literally just do this:

  use Class::DBI::Loader;

  # $loader is a Class::DBI::Loader::SQLite
  my $loader = Class::DBI::Loader->new(
    dsn       => "dbi:SQLite:dbname=/path/to/dbfile",
    namespace => "Data",
  );
  my $class = $loader->find_class('film'); # $class => Data::Film
  my $obj = $class->retrieve(1);

okay so quick tour: you use Class::DBI::Loader, you build yourself a loader with your dsn (dbi:SQLite:dbname=/path/to/dbfile, so yes, you point it right at your actual db file 💀) plus a namespace, and ngl that $loader you just made is a Class::DBI::Loader::SQLite — that's the whole bit. then find_class('film') hands you back the class, so $class is Data::Film, and $class->retrieve(1) goes and grabs you the object. slay. ✨

---

🦋 DESCRIPTION 🦋

okay so the tea:

• Multi-column primary keys are supported. yes bestie, composite keys, we love to see it. 👑
• Multi-column foreign keys are also totally fine to define — you can write them, no one's stopping you, no cap — but they will be ignored, because Class::DBI does not support them. so like. they're giving decorative. 🎀 it's not this module's fault, it's just how Class::DBI rolls. don't come for me.

and if you wanna go deeper, go see Class::DBI::Loader and Class::DBI::Loader::Generic.

---

🌈 SEE ALSO 🌈

• Class::DBI::Loader
• Class::DBI::Loader::Generic

---

🎀 the sign-off 🎀

this whole lil page came from the User Contributed Perl Documentation, brought to you by perl v5.36.0, dated 2022-12-07 — so yeah, it's been out here being correct since then, and it ate. go build something, bestie. 💖✨🦋