Test::...:SQLite(3pm)

💖 NAME 💖

okay bestie, say hi to Test::DBIx::Class::SchemaManager::Trait::SQLite — she's The Default Role 💅

(and yes, the manual page itself goes by the truncated lil' nickname Test::...:SQLite(3pm), filed under User Contributed Perl Documentation, because apparently we're all about ✨mystery✨ here)

🌸 DESCRIPTION 🌸

So this is the default Storage trait, and her whole gig is: she gives you the ability to deploy to a SQLite database. iconic behaviour, no notes 🫶

She also sets some %ENV and/or configuration options that you can use to specify an alternative database setup. like, options, but make it flexible 💫

On top of the %ENV settings that are already documented, this Trait adds the following:

🎀 DBNAME 🎀

Defaults to ':memory:', which creates an in memory database. because sometimes we don't need a whole file, we just need vibes ✨

Provide a string suitable for the "dbname=XXX" part of your connect string. Typically this should be the path to a location on the filesystem you want the database file to be stored. 📁

⚠️ okay listen bestie, IMPORTANT: please note that this file will automatically be deleted unless you have specified 'keep_db' in the config or via the $ENV{KEEP_DB} setting. she will literally vanish. gone. poof. 💀

Also note: if you specify a path that already exists, we will automatically add the option 'force_drop_table', on the assumption you are roundtripping tests to the same database file. This way you can avoid having to specifically tell the system to delete the file each time. lowkey convenient tbh 😌

👑 AUTHOR 👑

John Napiorkowski "<jjnapiork@cpan.org>" — the main character who made this all happen fr fr 💜

🌈 CONTRIBUTORS 🌈

• Tristan Pratt 🦋

🎀 COPYRIGHT & LICENSE 🎀

Copyright 2009, John Napiorkowski "<jjnapiork@cpan.org>"

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

and that's a wrap, bestie 💖 this page is brought to you by perl v5.36.0, dated 2023-01-29, straight from the Test::...:SQLite(3pm) files ✨ slay, read responsibly, and go deploy something cute 🫶🎀