2 class SQL::Translator::Object::Schema extends SQL::Translator::Object {
3 use MooseX::Types::Moose qw(HashRef Maybe Str);
4 use MooseX::MultiMethods;
6 use SQL::Translator::Types qw(Procedure Table Trigger View ProcedureHash TableHash TriggerHash ViewHash IxHash);
23 isa => HashRef[Table],
25 exists_table => 'exists',
27 get_tables => 'values',
30 remove_table => 'delete',
32 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
40 exists_view => 'exists',
42 get_views => 'values',
45 remove_view => 'delete',
47 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
53 isa => HashRef[Procedure],
55 exists_procedure => 'exists',
56 procedure_ids => 'keys',
57 get_procedures => 'values',
58 get_procedure => 'get',
59 add_procedure => 'set',
60 remove_procedure => 'delete',
62 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
68 isa => HashRef[Trigger],
70 exists_trigger => 'exists',
71 trigger_ids => 'keys',
72 get_triggers => 'values',
75 remove_trigger => 'delete',
77 default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash },
80 around add_table(Table $table does coerce) {
81 die "Can't use table name " . $table->name if $self->exists_table($table->name) || $table->name eq '';
82 $table->schema($self);
83 $self->$orig($table->name, $table);
86 around add_view(View $view does coerce) {
87 die "Can't use view name " . $view->name if $self->exists_view($view->name) || $view->name eq '';
89 $self->$orig($view->name, $view)
92 around add_procedure(Procedure $procedure does coerce) {
93 $procedure->schema($self);
94 $self->$orig($procedure->name, $procedure)
97 around add_trigger(Trigger $trigger does coerce) {
98 $trigger->schema($self);
99 $self->$orig($trigger->name, $trigger);;
102 method is_valid { return $self->get_tables ? 1 : undef }
104 around remove_table(Table|Str $table, Int :$cascade = 0) {
105 my $name = is_Table($table) ? $table->name : $table;
106 die "Can't drop non-existant table " . $name unless $self->exists_table($name);
110 around remove_view(View|Str $view) {
111 my $name = is_View($view) ? $view->name : $view;
112 die "Can't drop non-existant view " . $name unless $self->exists_view($name);
116 around remove_trigger(Trigger|Str $trigger) {
117 my $name = is_Trigger($trigger) ? $trigger->name : $trigger;
118 #### die "Can't drop non-existant trigger " . $name unless $self->exists_trigger($name);
122 around remove_procedure(Procedure|Str $procedure) {
123 my $name = is_Procedure($procedure) ? $procedure->name : $procedure;
128 method perform_action_when { }
129 method database_events { }