File Coverage

blib/lib/SQL/Functional/InsertClause.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::InsertClause;
25             $SQL::Functional::InsertClause::VERSION = '0.1';
26 1     1   1090 use v5.14;
  1         2  
27 1     1   3 use warnings;
  1         1  
  1         18  
28 1     1   148 use Moose;
  0            
  0            
29             use namespace::autoclean;
30             use SQL::Functional::Clause;
31             use SQL::Functional::TableClause;
32             use SQL::Functional::ValuesClause;
33              
34             with 'SQL::Functional::Clause';
35              
36             has into => (
37             is => 'ro',
38             isa => 'SQL::Functional::TableClause',
39             required => 1,
40             );
41             has fields => (
42             is => 'ro',
43             isa => 'ArrayRef[Str]',
44             required => 1,
45             auto_deref => 1,
46             );
47             has values => (
48             is => 'ro',
49             isa => 'SQL::Functional::Clause',
50             required => 1,
51             );
52              
53              
54             sub to_string
55             {
56             my ($self) = @_;
57             my @fields = $self->fields;
58             my $into = $self->into;
59             my $values = $self->values;
60              
61             my $str = 'INSERT INTO ' . $into->to_string
62             . ' (' . join( ', ', @fields ) . ')'
63             . ' ' . $values->to_string;
64             return $str;
65             }
66              
67             sub get_params
68             {
69             my ($self) = @_;
70             return $self->values->get_params;
71             }
72              
73              
74             no Moose;
75             __PACKAGE__->meta->make_immutable;
76             1;
77             __END__