FusqlFS/Backend/PgSQL/Views.pm untested

filter: Statementstmt 0.0% 0 / 49 Branchbran 0.0% 0 / 2 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 0.0% 0 / 12 Podpod 0.0% 0 / 7 totaltotal 0.0% 0 / 70 CC 2 SCAR 9.6
CC
2
Cov
0%
get
6.0
init
2.0
list
2.0
CRAP 2.6
1 use strict;
2 use 5.010;
3  
4 package FusqlFS::Backend::PgSQL::Views;
5 use FusqlFS::Version;
6 our $VERSION = $FusqlFS::Version::VERSION;
7 use parent 'FusqlFS::Artifact';
8  
9 =head1 NAME
10  
11 FusqlFS::Backend::PgSQL::Views - FusqlFS PostgreSQL database views interface
12  
13 =head1 SYNOPSIS
14  
15 use FusqlFS::Backend::PgSQL::Views;
16  
17 my $views = FusqlFS::Backend::PgSQL::Views->new();
18 my $list = $views->list();
19 $views->create('aview');
20 $views->store('aview', { 'content.sql' => 'SELECT * FROM sometable' });
21 my $view = $views->get('aview');
22  
23 =head1 DESCRIPTION
24  
25 This is FusqlFS an interface to PostgreSQL database views. This class is not
26 to be used by itself.
27  
28 See L<FusqlFS::Artifact> for description of interface methods,
29 L<FusqlFS::Backend> to learn more on backend initialization and
30 L<FusqlFS::Backend::Base> for more info on database backends writing.
31  
32 =head1 EXPOSED STRUCTURE
33  
34 =over
35  
36 =item F<./content.sql>
37  
38 Plain file with C<SELECT ...> SQL statement used to construct query in it. Can
39 be written to redefine view.
40  
41 =item F<./owner>
42  
43 Symlink to view's owner in F<../../roles>.
44  
45 =back
46  
47 =cut
48  
49  
50 use FusqlFS::Backend::PgSQL::Role::Owner;
51  
52 sub init
53 {
54 my $self = shift;
55  
56 $self->{drop_expr} = 'DROP VIEW "%s"';
57 $self->{create_expr} = 'CREATE VIEW "%s" AS SELECT 1';
58 $self->{store_expr} = 'CREATE OR REPLACE VIEW "%s" AS %s';
59 $self->{rename_expr} = 'ALTER VIEW "%s" RENAME TO "%s"';
60  
61 $self->{get_expr} = $self->expr("SELECT definition FROM pg_catalog.pg_views WHERE viewname = ?");
62 $self->{list_expr} = $self->expr("SELECT viewname FROM pg_catalog.pg_views WHERE schemaname = 'public'");
63  
64 $self->{owner} = FusqlFS::Backend::PgSQL::Role::Owner->new('v');
65 }
66  
67 =begin testing list
68  
69 cmp_set $_tobj->list(), [];
70  
71 =end testing
72 =cut
73 sub list
74 {
75 my $self = shift;
76 return $self->all_col($self->{list_expr});
77 }
78  
79 =begin testing get
80  
81 is $_tobj->get('unknown'), undef;
82  
83 =end testing
84 =cut
85 sub get
86 {
87 my $self = shift;
88 my ($name) = @_;
89 my $result = $self->all_col($self->{get_expr}, $name);
90 return unless @$result;
91 return {
92 'content.sql' => $result->[0],
93 owner => $self->{owner},
94 };
95 }
96  
97 =begin testing rename after store
98  
99 isnt $_tobj->rename('fusqlfs_view', 'new_fusqlfs_view'), undef;
100 is $_tobj->get('fusqlfs_view'), undef;
101 is_deeply $_tobj->get('new_fusqlfs_view'), { 'content.sql' => 'SELECT 2;', owner => $_tobj->{owner} };
102 is_deeply $_tobj->list(), [ 'new_fusqlfs_view' ];
103  
104 =end testing
105 =cut
106 sub rename
107 {
108 my $self = shift;
109 my ($name, $newname) = @_;
110 $self->do($self->{'rename_expr'}, [$name, $newname]);
111 }
112  
113 =begin testing drop after rename
114  
115 isnt $_tobj->drop('new_fusqlfs_view'), undef;
116 is_deeply $_tobj->list(), [];
117 is $_tobj->get('new_fusqlfs_view'), undef;
118  
119 =end testing
120 =cut
121 sub drop
122 {
123 my $self = shift;
124 my ($name) = @_;
125 $self->do($self->{'drop_expr'}, [$name]);
126 }
127  
128 =begin testing create after get list
129  
130 isnt $_tobj->create('fusqlfs_view'), undef;
131 is_deeply $_tobj->list(), [ 'fusqlfs_view' ];
132 is_deeply $_tobj->get('fusqlfs_view'), { 'content.sql' => 'SELECT 1;', owner => $_tobj->{owner} };
133  
134 =end testing
135 =cut
136 sub create
137 {
138 my $self = shift;
139 my ($name) = @_;
140 $self->do($self->{'create_expr'}, [$name]);
141 }
142  
143 =begin testing store after create
144  
145 isnt $_tobj->store('fusqlfs_view', { 'content.sql' => 'SELECT 2' }), undef;
146 is_deeply $_tobj->get('fusqlfs_view'), { 'content.sql' => 'SELECT 2;', owner => $_tobj->{owner} };
147  
148 =end testing
149 =cut
150 sub store
151 {
152 my $self = shift;
153 my ($name, $data) = @_;
154 $self->do($self->{'store_expr'}, [$name, $data->{'content.sql'}]);
155 }
156  
157 1;
158  
159 __END__