use Test::SQL::Translator qw(maybe_plan table_ok);
BEGIN {
- maybe_plan(49, 'SQL::Translator::Parser::DBI::PostgreSQL');
+ maybe_plan(60, 'SQL::Translator::Parser::DBI::PostgreSQL');
SQL::Translator::Parser::DBI::PostgreSQL->import('parse');
}
SKIP: {
if (my $err = ($@ || $DBI::err )) {
chomp $err;
- skip "No connection to test db. DBI says '$err'", 48;
+ skip "No connection to test db. DBI says '$err'", 59;
}
ok($dbh, "dbh setup correctly");
create table sqlt_test1 (
f_serial serial NOT NULL primary key,
- f_varchar character varying (255),
- f_text text default 'FOO'
+ f_varchar character varying(255),
+ f_text text default 'FOO',
+ f_to_drop integer,
+ f_last text
);
+ comment on table sqlt_test1 is 'this is a comment on the first table';
+ comment on column sqlt_test1.f_text is 'this is a comment on a field of the first table';
+
+ create index sqlt_test1_f_last_idx on sqlt_test1 (f_last);
create table sqlt_test2 (
f_id integer NOT NULL,
name text,
price numeric
);
+
+ -- drop a column, to not have a linear id
+ -- When the table t_test1 is created, f_last get id 5 but
+ -- after this drop, there is only 4 columns.
+ alter table sqlt_test1 drop column f_to_drop;
];
$| = 1;
my $t1 = $schema->get_table("sqlt_test1");
is( $t1->name, 'sqlt_test1', 'Table sqlt_test1 exists' );
+is( $t1->comments, 'this is a comment on the first table', 'First table has a comment');
my @t1_fields = $t1->get_fields;
-is( scalar @t1_fields, 3, '3 fields in sqlt_test1' );
+is( scalar @t1_fields, 4, '4 fields in sqlt_test1' );
my $f1 = shift @t1_fields;
is( $f1->name, 'f_serial', 'First field is "f_serial"' );
-#FIXME: it should better be 'INTEGER' instead of 'int4'
-is( $f1->data_type, 'int4', 'Field is an integer' );
+is( $f1->data_type, 'integer', 'Field is an integer' );
is( $f1->is_nullable, 0, 'Field cannot be null' );
is( $f1->default_value, "nextval('sqlt_test1_f_serial_seq'::regclass)", 'Default value is nextval()' );
is( $f1->is_primary_key, 1, 'Field is PK' );
my $f2 = shift @t1_fields;
is( $f2->name, 'f_varchar', 'Second field is "f_varchar"' );
-is( $f2->data_type, 'varchar', 'Field is a varchar' );
+is( $f2->data_type, 'character varying(255)', 'Field is a character varying(255)' );
is( $f2->is_nullable, 1, 'Field can be null' );
#FIXME: should not be 255?
is( $f2->size, 259, 'Size is "259"' );
is( $f2->default_value, undef, 'Default value is undefined' );
is( $f2->is_primary_key, 0, 'Field is not PK' );
is( $f2->is_auto_increment, 0, 'Field is not auto increment' );
+is( $f2->comments, '', 'There is no comment on the second field');
my $f3 = shift @t1_fields;
is( $f3->name, 'f_text', 'Third field is "f_text"' );
is( $f3->default_value, "'FOO'::text", 'Default value is "FOO"' );
is( $f3->is_primary_key, 0, 'Field is not PK' );
is( $f3->is_auto_increment, 0, 'Field is not auto increment' );
+is( $f3->comments, 'this is a comment on a field of the first table', 'There is a comment on the third field');
+
+my $f4 = shift @t1_fields;
+is( $f4->name, 'f_last', 'Fouth field is "f_last"' );
+is( $f4->data_type, 'text', 'Field is a text' );
+is( $f4->is_nullable, 1, 'Field can be null' );
+is( $f4->size, 0, 'Size is 0' );
+is( $f4->default_value, undef, 'No default value' );
+is( $f4->is_primary_key, 0, 'Field is not PK' );
+is( $f4->is_auto_increment, 0, 'Field is not auto increment' );
#TODO: no 'NOT NULL' constraint not set
my $t2 = $schema->get_table("sqlt_test2");
is( $t2->name, 'sqlt_test2', 'Table sqlt_test2 exists' );
+is( $t2->comments, undef, 'No comment on table sqlt_test2');
my @t2_fields = $t2->get_fields;
is( scalar @t2_fields, 3, '3 fields in sqlt_test2' );
my $t2_f1 = shift @t2_fields;
is( $t2_f1->name, 'f_id', 'First field is "f_id"' );
-is( $t2_f1->data_type, 'int4', 'Field is an integer' );
+is( $t2_f1->data_type, 'integer', 'Field is an integer' );
is( $t2_f1->is_nullable, 0, 'Field cannot be null' );
is( $t2_f1->size, 0, 'Size is "0"' );
is( $t2_f1->default_value, undef, 'Default value is undefined' );
my $t2_f2= shift @t2_fields;
is( $t2_f2->name, 'f_int', 'Third field is "f_int"' );
-is( $t2_f2->data_type, 'int2', 'Field is an integer' );
+is( $t2_f2->data_type, 'smallint', 'Field is an smallint' );
is( $t2_f2->is_nullable, 1, 'Field can be null' );
is( $t2_f2->size, 0, 'Size is "0"' );
is( $t2_f2->default_value, undef, 'Default value is undefined' );
my $t2_f3 = shift @t2_fields;
is( $t2_f3->name, 'f_fk1', 'Third field is "f_fk1"' );
-is( $t2_f3->data_type, 'int4', 'Field is an integer' );
+is( $t2_f3->data_type, 'integer', 'Field is an integer' );
is( $t2_f3->is_nullable, 0, 'Field cannot be null' );
is( $t2_f3->size, 0, 'Size is "0"' );
is( $t2_f3->default_value, undef, 'Default value is undefined' );