#=============================================================================
BEGIN {
- maybe_plan(17,
+ maybe_plan(25,
'SQL::Translator::Producer::PostgreSQL',
'Test::Differences',
)
is($field3_sql, 'time_field time NOT NULL', 'Create time field works');
+my $field3_datetime_with_TZ = SQL::Translator::Schema::Field->new(
+ name => 'datetime_with_TZ',
+ table => $table,
+ data_type => 'timestamp with time zone',
+ size => 7,
+);
+
+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',
+ 'Create time field with time zone and size, works'
+);
+
+my $field3_time_without_TZ = SQL::Translator::Schema::Field->new(
+ name => 'time_without_TZ',
+ table => $table,
+ data_type => 'time without time zone',
+ size => 2,
+);
+
+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',
+ 'Create time field without time zone but with size, works'
+);
+
+my $field_num = SQL::Translator::Schema::Field->new( name => 'num',
+ table => $table,
+ data_type => 'numeric',
+ size => [10,2],
+ );
+my $fieldnum_sql = SQL::Translator::Producer::PostgreSQL::create_field($field_num);
+
+is($fieldnum_sql, 'num numeric(10,2)', 'Create numeric field works');
+
+
my $field4 = SQL::Translator::Schema::Field->new( name => 'bytea_field',
table => $table,
data_type => 'bytea',
is($alter_field, q(ALTER TABLE mytable ALTER COLUMN character DROP NOT NULL), 'DROP NOT NULL');
+my $field8 = SQL::Translator::Schema::Field->new( name => 'ts_field',
+ table => $table,
+ data_type => 'timestamp with time zone',
+ size => 6,
+ is_auto_increment => 0,
+ is_nullable => 0,
+ is_foreign_key => 0,
+ is_unique => 0 );
+
+my $field8_sql = SQL::Translator::Producer::PostgreSQL::create_field($field8,{ postgres_version => 8.3 });
+
+is($field8_sql, 'ts_field timestamp(6) with time zone NOT NULL', 'timestamp with precision');
+
+my $field9 = SQL::Translator::Schema::Field->new( name => 'time_field',
+ table => $table,
+ data_type => 'time with time zone',
+ size => 6,
+ is_auto_increment => 0,
+ is_nullable => 0,
+ is_foreign_key => 0,
+ is_unique => 0 );
+
+my $field9_sql = SQL::Translator::Producer::PostgreSQL::create_field($field9,{ postgres_version => 8.3 });
+
+is($field9_sql, 'time_field time(6) with time zone NOT NULL', 'time with precision');
+
+my $field10 = SQL::Translator::Schema::Field->new( name => 'interval_field',
+ table => $table,
+ data_type => 'interval',
+ size => 6,
+ is_auto_increment => 0,
+ is_nullable => 0,
+ is_foreign_key => 0,
+ is_unique => 0 );
+
+my $field10_sql = SQL::Translator::Producer::PostgreSQL::create_field($field10,{ postgres_version => 8.3 });
+
+is($field10_sql, 'interval_field interval(6) NOT NULL', 'time with precision');
+
+
+my $field11 = SQL::Translator::Schema::Field->new( name => 'time_field',
+ table => $table,
+ data_type => 'time without time zone',
+ size => 6,
+ is_auto_increment => 0,
+ is_nullable => 0,
+ is_foreign_key => 0,
+ is_unique => 0 );
+
+my $field11_sql = SQL::Translator::Producer::PostgreSQL::create_field($field11,{ postgres_version => 8.3 });
+
+is($field11_sql, 'time_field time(6) without time zone NOT NULL', 'time with precision');
+
+
+
+my $field12 = SQL::Translator::Schema::Field->new( name => 'time_field',
+ table => $table,
+ data_type => 'timestamp',
+ is_auto_increment => 0,
+ is_nullable => 0,
+ is_foreign_key => 0,
+ is_unique => 0 );
+
+my $field12_sql = SQL::Translator::Producer::PostgreSQL::create_field($field12,{ postgres_version => 8.3 });
+
+is($field12_sql, 'time_field timestamp NOT NULL', 'time with precision');
+
{
# let's test default values! -- rjbs, 2008-09-30