my $person_table = SQL::Translator::Object::Table->new({
name => 'person',
schema => $schema,
+ comments => 'foo',
});
- $person_table->comments('foo');
+
$schema->add_table($person_table);
is( $person_table->name, 'person', 'Table name is "person"' );
is( $person_table->is_valid, undef, 'Table is not yet valid' );
#
# Field default new
#
- my $person_table_column = SQL::Translator::Object::Column->new( name => 'foo' );
+ my $person_table_column = SQL::Translator::Object::Column->new( name => 'foo', extra => { foo => 'bar', baz => 'quux' } );
my $f1 = $person_table->add_column($person_table_column);
isa_ok( $f1, 'SQL::Translator::Object::Column', 'Column' );
is( $f1->name, 'foo', 'Field name is "foo"' );
is( $f1->data_type('varchar'), 'varchar', 'Field data type is "varchar"' );
is( $f1->size('30'), '30', 'Field size is "30"' );
is( $f1->is_primary_key(0), '0', 'Field is_primary_key is negative' );
+ $person_table->add_field( $f1 );
- $f1->extra({ foo => 'bar' });
- $f1->extra({ baz => 'quux' });
my %extra = $f1->extra;
is( $extra{'foo'}, 'bar', 'Field extra "foo" is "bar"' );
is( $extra{'baz'}, 'quux', 'Field extra "baz" is "quux"' );
# $schema->get_*
#
+TODO: {
+ local $TODO = 'patch Moose Native::Trait';
dies_ok( sub { my $bad_table = $schema->get_table }, 'Error on no arg to get_table' );
is($schema->get_table('baz'), undef, 'Nonexistant table returns undef');
dies_ok( sub { my $bad_view = $schema->get_view }, 'Error on no arg to get_view' );
is($schema->get_view('baz'), undef, 'Nonexistant view returns undef');
+}
my $good_table = $schema->get_table('foo');
isa_ok( $good_table, 'SQL::Translator::Object::Table', 'Table "foo"' );
# is( $t->primary_key('person_id'), undef,
# q[Can't make PK on "person_id"...] );
# like( $t->error, qr/invalid field/i, "...because it doesn't exist" );
- dies_ok( sub { $t->primary_key }, "...because it doesn't exist" );
+ dies_ok( sub { $t->primary_key('person_id') }, "...because it doesn't exist" );
$t->add_field({ name => 'person_id' });
my $c = $t->primary_key('person_id');
fields => 'person_id',
reference_table => 'person',
table => $t1,
- reference_fields => 'id',
+# reference_fields => 'id',
});
+ $c2->add_reference_column($t1->get_column('id'));
is( join('', $c2->reference_fields), 'id', 'FK found PK "person.id"' );
}
schema => $s,
});
-# $v->add_field({ name => 'name' });
-# $v->add_field({ name => 'age' });
+ $v->add_column({ name => 'name' });
+ $v->add_column({ name => 'age' });
isa_ok( $v, 'SQL::Translator::Object::View', 'View' );
isa_ok( $v->schema, 'SQL::Translator::Object::Schema', 'Schema' );
perform_action_when => $perform_action_when,
database_events => $database_events,
on_table => $on_table,
+ table => $s->get_table('foo'),
action => $action,
}) or die $s->error;
is( $t->name, $name, qq[Name is "$name"] );
is( $t->perform_action_when, $perform_action_when,
qq[Perform action when is "$perform_action_when"] );
+
is( join(',', $t->database_events), $database_events,
qq[Database event is "$database_events"] );
isa_ok( $t->table, 'SQL::Translator::Object::Table', qq[table is a Table"] );
- my $s2 = SQL::Translator::Object::Schema->new(name => 'TrigTest2');
+ my $s2 = SQL::Translator::Object::Schema->new(name => 'TrigTest2');
$s2->add_table({ name => 'foo' }) or die "Couldn't create table: ", $s2->error;
my $t2 = $s2->add_trigger({
name => 'foo_trigger',
on_table => 'foo',
action => 'update modified=timestamp();',
}) or die $s2->error;
- isa_ok( $t2, 'SQL::Translator::Object::Trigger', 'Trigger' );
+ $t2->add_database_event('insert');
+ $t2->add_database_event('update');
+ isa_ok( $t2, 'SQL::Translator::Object::Trigger', 'Trigger' );
isa_ok( $t2->schema, 'SQL::Translator::Object::Schema', 'Schema' );
is( $t2->schema->name, 'TrigTest2', qq[Schema name is "'TrigTest2'"] );
is( $t2->name, 'foo_trigger', qq[Name is "foo_trigger"] );
- is_deeply(
+ is_deeply(
[$t2->database_events],
[qw/insert update/],
"Database events are [qw/insert update/] "
);
- isa_ok($t2->database_events,'ARRAY','Database events');
-
- #
- # Trigger equal tests
- #
-# isnt(
+
+ #isa_ok($t2->database_events,'ARRAY','Database events');
+
+ #
+ # Trigger equal tests
+ #
+# isnt(
# $t1->equals($t2),
# 1,
# 'Compare two Triggers with database_event and database_events'
# );
- $t1->database_events($database_events);
- $t2->database_events($database_events);
-# is($t1->equals($t2),1,'Compare two Triggers with database_event');
+ $t1->database_events($database_events);
+ $t2->database_events($database_events);
+# is($t1->equals($t2),1,'Compare two Triggers with database_event');
- $t2->database_events('');
- $t1->database_events([qw/update insert/]);
- $t2->database_events([qw/insert update/]);
-# is($t1->equals($t2),1,'Compare two Triggers with database_events');
-
+ $t2->database_events('');
+ $t1->database_events([qw/update insert/]);
+ $t2->database_events([qw/insert update/]);
+# is($t1->equals($t2),1,'Compare two Triggers with database_events');
+
#
# $schema-> drop_trigger
#
owner => $owner,
comments => $comments,
}); # or die $s->error;
+ $p->parameters([ qw/foo bar/ ]);
isa_ok( $p, 'SQL::Translator::Object::Procedure', 'Procedure' );
isa_ok( $p->schema, 'SQL::Translator::Object::Schema', 'Schema' );
is( $p->schema->name, 'ProcTest', qq[Schema name is "'ProcTest'"] );
is( $p->name, $name, qq[Name is "$name"] );
is( $p->sql, $sql, qq[SQL is "$sql"] );
- is( join(',', $p->parameters), 'foo,bar', qq[Params = 'foo,bar'] );
+
+ is_deeply( $p->parameters, [ qw/foo bar/ ], qq[Params = 'foo,bar'] );
is( $p->comments, $comments, qq[Comments = "$comments"] );
my @procs = $s->get_procedures;
projects / dbsrgits/SQL-Translator-2.0-ish.git / blobdiff