File Coverage

blib/lib/Geoffrey/Converter/Pg/Tables.pm

Criterion	Covered	Total	%
statement	25	25	100.0
branch			n/a
condition			n/a
subroutine	12	12	100.0
pod	6	6	100.0
total	43	43	100.0

package Geoffrey::Converter::Pg::Tables;

use utf8;
use 5.016;
use strict;
use Readonly;
use warnings;

$Geoffrey::Converter::Pg::Tables::VERSION = '0.000203';

use parent 'Geoffrey::Role::ConverterType';

sub add { return q~CREATE TABLE {0} ( {1} )~; }

sub drop { return q~DROP TABLE {0}~; }

sub alter { return q~ALTER TABLE {0}~; }

sub add_column { return $_[0]->alter . q~ ADD COLUMN {1}~; }

sub list {
    my ( $self, $schema ) = @_;
    return q~SELECT t.*
          FROM information_schema.tables t
          WHERE t.table_type != 'VIEW' AND t.table_schema=?~;
}

sub s_list_columns {
    my ( $self, $schema ) = @_;
    return q~SELECT *
          FROM information_schema.columns
          WHERE table_name = ?
          AND table_schema = ?~;
}

1;    # End of Geoffrey::Converter::Pg::Tables

__END__