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) {
92 $procedure->schema($self);
93 $self->$orig($procedure->name, $procedure)
96 around add_trigger(Trigger $trigger does coerce) {
97 $trigger->schema($self);
98 $self->$orig($trigger->name, $trigger);;
101 method is_valid { return $self->get_tables ? 1 : undef }
103 around remove_table(Table|Str $table, Int :$cascade = 0) {
104 my $name = is_Table($table) ? $table->name : $table;
105 die "Can't drop non-existant table " . $name unless $self->exists_table($name);
109 around remove_view(View|Str $view) {
110 my $name = is_View($view) ? $view->name : $view;
111 die "Can't drop non-existant view " . $name unless $self->exists_view($name);
115 around remove_trigger(Trigger|Str $trigger) {
116 my $name = is_Trigger($trigger) ? $trigger->name : $trigger;
117 #### die "Can't drop non-existant trigger " . $name unless $self->exists_trigger($name);
121 around remove_procedure(Procedure|Str $procedure) {
122 my $name = is_Procedure($procedure) ? $procedure->name : $procedure;
127 method perform_action_when { }
128 method database_events { }