File Coverage

blib/lib/SQL/Functional/UpdateClause.pm
Criterion Covered Total %
statement 6 8 75.0
branch n/a
condition n/a
subroutine 3 3 100.0
pod n/a
total 9 11 81.8


line stmt bran cond sub pod time code
1             # Copyright (c) 2016 Timm Murray
2             # All rights reserved.
3             #
4             # Redistribution and use in source and binary forms, with or without
5             # modification, are permitted provided that the following conditions are met:
6             #
7             # * Redistributions of source code must retain the above copyright notice,
8             # this list of conditions and the following disclaimer.
9             # * Redistributions in binary form must reproduce the above copyright
10             # notice, this list of conditions and the following disclaimer in the
11             # documentation and/or other materials provided with the distribution.
12             #
13             # THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
14             # AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
15             # IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
16             # ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
17             # LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
18             # CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
19             # SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
20             # INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
21             # CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
22             # ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
23             # POSSIBILITY OF SUCH DAMAGE.
24             package SQL::Functional::UpdateClause;
25             $SQL::Functional::UpdateClause::VERSION = '0.1';
26 1     1   1078 use v5.14;
  1         3  
27 1     1   3 use warnings;
  1         0  
  1         17  
28 1     1   150 use Moose;
  0            
  0            
29             use namespace::autoclean;
30             use SQL::Functional::Clause;
31              
32             with 'SQL::Functional::Clause';
33              
34             has table => (
35             is => 'ro',
36             isa => 'Str',
37             required => 1,
38             );
39             has set => (
40             is => 'ro',
41             isa => 'SQL::Functional::SetClause',
42             required => 1,
43             );
44             has where => (
45             is => 'ro',
46             isa => 'Maybe[SQL::Functional::WhereClause]',
47             required => 1,
48             );
49              
50              
51             sub to_string
52             {
53             my ($self) = @_;
54             my $where = $self->where;
55             my $str = 'UPDATE ' . $self->table
56             . ' ' . $self->set->to_string
57             . (defined $where ? ' ' . $where->to_string : '');
58             return $str;
59             }
60              
61             sub get_params
62             {
63             my ($self) = @_;
64             my $where = $self->where;
65             my @where_params = defined $where
66             ? $where->get_params
67             : ();
68             return ($self->set->get_params, @where_params);
69             }
70              
71              
72             no Moose;
73             __PACKAGE__->meta->make_immutable;
74             1;
75             __END__