package MusicBrainz::Server::Data::Role::Editable;
use MooseX::Role::Parameterized;

use MusicBrainz::Server::Data::Utils qw( placeholders );
use Sql;

parameter 'table' => (
    isa => 'Str',
    required => 1
);

role {
    my $params = shift;
    my $table = $params->table;

    requires '_dbh';

    method 'adjust_edit_pending' => sub
    {
        my ($self, $adjust, @ids) = @_;
        my $query = "UPDATE $table SET edits_pending = numeric_larger(0, edits_pending + ?) WHERE id IN (" . placeholders(@ids) . ")";
        $self->sql->do($query, $adjust, @ids);
        if ($self->does('MusicBrainz::Server::Data::Role::EntityCacheBase')) {
            $self->_delete_from_cache(@ids);
        }
    };

};

no Moose::Role;
1;

=head1 COPYRIGHT

Copyright (C) 2009 Oliver Charles

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

=cut