| 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__ |