2 class SQL::Translator::Object::Schema extends SQL::Translator::Object {
3 use MooseX::Types::Moose qw(HashRef Maybe Str);
4 use SQL::Translator::Types qw(Procedure Table Trigger View);
5 use MooseX::MultiMethods;
22 isa => HashRef[Table],
24 exists_table => 'exists',
26 get_tables => 'values',
29 remove_table => 'delete',
31 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
39 exists_view => 'exists',
41 get_views => 'values',
44 remove_view => 'delete',
46 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
52 isa => HashRef[Procedure],
54 exists_procedure => 'exists',
55 procedure_ids => 'keys',
56 get_procedures => 'values',
57 get_procedure => 'get',
58 add_procedure => 'set',
59 remove_procedure => 'delete',
61 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
67 isa => HashRef[Trigger],
69 exists_trigger => 'exists',
70 trigger_ids => 'keys',
71 get_triggers => 'values',
74 remove_trigger => 'delete',
76 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
79 around add_table(Table $table does coerce) {
80 die "Can't use table name " . $table->name if $self->exists_table($table->name) || $table->name eq '';
81 $table->schema($self);
82 $self->$orig($table->name, $table);
85 around add_view(View $view does coerce) {
86 die "Can't use view name " . $view->name if $self->exists_view($view->name) || $view->name eq '';
88 $self->$orig($view->name, $view)
91 around add_procedure(Procedure $procedure does coerce) { $self->$orig($procedure->name, $procedure) }
92 around add_trigger(Trigger $trigger does coerce) {
93 $trigger->schema($self);
94 $self->$orig($trigger->name, $trigger);;
97 method is_valid { return $self->get_tables ? 1 : undef }
99 around remove_table(Table|Str $table, Int :$cascade = 0) {
100 my $name = is_Table($table) ? $table->name : $table;
101 die "Can't drop non-existant table " . $name unless $self->exists_table($name);
105 around remove_view(View|Str $view) {
106 my $name = is_View($view) ? $view->name : $view;
107 die "Can't drop non-existant view " . $name unless $self->exists_view($name);
112 method perform_action_when { }
113 method database_events { }