DBIx::C...::ACCESS(3)

📦
version 0.082844 · 7 versions
, in opensuse-leap 16.0

💅 DBIx::C...::ACCESS(3) 💅

okay so this is the User Contributed Perl Documentation page for DBIx::C...::ACCESS(3) — manual name folded right in at the top, bestie — and it's all about the MS Access support situation. It's giving very specific driver energy. 🦋

🌸 NAME 🌸

  • DBIx::Class::Storage::DBI::ACCESS — Support specific to MS Access ✨

💖 DESCRIPTION 💖

This is the base class for Microsoft Access support — like, the parent-class main character for MS Access vibes. 👑

This driver supports last_insert_id, empty inserts for tables with "AUTOINCREMENT" columns, nested transactions via auto_savepoint, and "GUID" columns via DBIx::Class::Storage::DBI::UniqueIdentifier. Slay. 💅

🎀 SUPPORTED VERSIONS 🎀

ngl, this module has currently only been tested on MS Access 2010. That's the tested-version tea rn. ☕

Information about how well it works on different version of MS Access is welcome — write the mailing list, or submit a ticket to RT if you find bugs. 🫶

🦋 USING GUID COLUMNS 🦋

If you have "GUID" PKs or other "GUID" columns with auto_nextval you will need to set a new_guid callback, like so:

$schema->storage->new_guid(sub { Data::GUID->new->as_string });

Under Catalyst you can use code similar to this in your Catalyst::Model::DBIC::Schema Model.pm:

after BUILD => sub {
  my $self = shift;
  $self->storage->new_guid(sub { Data::GUID->new->as_string });
};

✨ FURTHER QUESTIONS? ✨

Check the list of additional DBIC resources. iykyk, that's where the extra DBIC lore lives. 📚

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library. 🫶

💖 cute sign-off: DBIx::C...::ACCESS(3) is from perl v5.42.0, dated 2025-01-22 — mwah, bye bestie! 💖

📦 where this page comes from