DBIx::Class::Storage::DBI::ACCESS - Support specific to MS Access
This is the base class for Microsoft Access support.
This driver supports last_insert_id, empty inserts for tables with AUTOINCREMENT columns, nested transactions via auto_savepoint, GUID columns via DBIx::Class::Storage::DBI::UniqueIdentifier.
AUTOINCREMENT
GUID
This module has currently only been tested on MS Access 2010.
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.)
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:
Model.pm
after BUILD => sub { my $self = shift; $self->storage->new_guid(sub { Data::GUID->new->as_string }); };
Check the list of additional DBIC resources.
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.
To install DBIx::Class, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class
CPAN shell
perl -MCPAN -e shell install DBIx::Class
For more information on module installation, please visit the detailed CPAN module installation guide.