#=============================================================================
BEGIN {
- maybe_plan(51,
+ maybe_plan(53,
'SQL::Translator::Producer::PostgreSQL',
'Test::Differences',
)
my $PRODUCER = \&SQL::Translator::Producer::PostgreSQL::create_field;
+{
+ my $table = SQL::Translator::Schema::Table->new( name => 'foo.bar' );
+ my $field = SQL::Translator::Schema::Field->new( name => 'baz',
+ table => $table,
+ data_type => 'VARCHAR',
+ size => 10,
+ default_value => 'quux',
+ is_auto_increment => 0,
+ is_nullable => 0,
+ is_foreign_key => 0,
+ is_unique => 0 );
+ $table->add_field($field);
+ my ($create, $fks) = SQL::Translator::Producer::PostgreSQL::create_table($table, { quote_table_names => q{"} });
+ is($table->name, 'foo.bar');
+
+ my $expected = "--\n-- Table: foo.bar\n--\nCREATE TABLE \"foo\".\"bar\" (\n \"baz\" character varying(10) DEFAULT 'quux' NOT NULL\n)";
+ is($create, $expected);
+}
+
my $table = SQL::Translator::Schema::Table->new( name => 'mytable');
my $field1 = SQL::Translator::Schema::Field->new( name => 'myfield',
size => 7,
);
-my $field3_datetime_with_TZ_sql =
+my $field3_datetime_with_TZ_sql =
SQL::Translator::Producer::PostgreSQL::create_field(
$field3_datetime_with_TZ
);
is(
- $field3_datetime_with_TZ_sql,
- 'datetime_with_TZ timestamp(6) with time zone',
+ $field3_datetime_with_TZ_sql,
+ 'datetime_with_TZ timestamp(6) with time zone',
'Create time field with time zone and size, works'
);
size => 2,
);
-my $field3_time_without_TZ_sql
+my $field3_time_without_TZ_sql
= SQL::Translator::Producer::PostgreSQL::create_field(
$field3_time_without_TZ
);
is(
- $field3_time_without_TZ_sql,
- 'time_without_TZ time(2) without time zone',
+ $field3_time_without_TZ_sql,
+ 'time_without_TZ time(2) without time zone',
'Create time field without time zone but with size, works'
);
CREATE VIEW view_foo ( id, name ) AS
SELECT id, name FROM thing
";
-
+
is($drop_view_8_1_produced, $drop_view_8_1_expected, "My DROP VIEW statement for 8.1 is correct");
my $drop_view_opts2 = { add_drop_view => 1, no_comments => 1, postgres_version => 9.001 };
CREATE VIEW view_foo ( id, name ) AS
SELECT id, name FROM thing
";
-
+
is($drop_view_9_1_produced, $drop_view_9_1_expected, "My DROP VIEW statement for 9.1 is correct");