DBIx::Class::Helper::ResultSet::MySQLHacks - Useful MySQL-specific operations for DBIx::Class
version v1.0.0
# Your base resultset package MySchema::ResultSet; use strict; use warnings; use parent 'DBIx::Class::ResultSet'; __PACKAGE__->load_components('Helper::ResultSet::MySQLHacks'); # In other resultset classes package MySchema::ResultSet::Bar; use strict; use warnings; use parent 'MySchema::ResultSet'; # In code using the resultset $rs->multi_table_delete(qw< rel1 rel2 >); $rs->multi_table_update(\%values);
This MySQL-specific ResultSet helper contains a series of hacks for various SQL operations that only work for MySQL. These hacks are exactly that, so it's possible that the SQL manipulation isn't as clean as it should be.
my $underlying_storage_rv = $rs->multi_table_delete; # deletes rows from the current table my $underlying_storage_rv = $rs->multi_table_delete(qw< rel1 rel2 >);
Runs a delete using the multiple table syntax, which supports join operations. This is useful in cases with a joined ResultSet that require rows to be deleted, and using "delete_all" in DBIx::Class::ResultSet would be too slow.
Without arguments, it will delete rows from the current table, ie: "current_source_alias" in DBIx::Class::ResultSet. Otherwise, it can take a list of relationships to delete from. These must be existing relationship aliases tied to the joins, not table names.
This method works by taking a count ResultSet, removing the SELECT COUNT(*) portion, and splicing in the DELETE @aliases part.
SELECT COUNT(*)
DELETE @aliases
The return value is a pass through of what the underlying storage backend returned, and may vary. See "execute" in DBI for the most common case.
NOTE: This method will not delete from views, per MySQL limitations.
my $underlying_storage_rv = $rs->multi_table_update(\%values);
Runs a update using the multiple table syntax, which supports join operations. This is useful in cases with a joined ResultSet that require rows to be updated, and using "update_all" in DBIx::Class::ResultSet would be too slow.
A values hashref is required. It's highly recommended that the keys are named as alias.column pairs, since multiple tables are involved.
alias.column
This method works by acquiring the FROM, SET, and WHERE clauses separately and merging them back into a proper multi-table UPDATE query.
FROM
SET
WHERE
UPDATE
my $rv = $rs->dbh_execute($sql, $bind); my ($rv, $sth, @bind) = $rs->dbh_execute($sql, $bind);
Sends any SQL statement to the $dbh via "dbh_do" in DBIx::Class::Storage::DBI while running the usual query loggers and re-connection protections that come with DBIC.
$dbh
This runs code similar to DBIx::Class::Storage::DBI's _execute method, except that it takes SQL and binds as input. Like _dbh_execute and _execute, it returns different outputs, depending on the context.
_execute
_dbh_execute
Grant Street Group <developers@grantstreet.com>
This software is Copyright (c) 2021 by Grant Street Group.
This is free software, licensed under:
The Artistic License 2.0 (GPL Compatible)
To install DBIx::Class::Helper::ResultSet::MySQLHacks, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class::Helper::ResultSet::MySQLHacks
CPAN shell
perl -MCPAN -e shell install DBIx::Class::Helper::ResultSet::MySQLHacks
For more information on module installation, please visit the detailed CPAN module installation guide.