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);
22 isa => IxHash, #TableHash,
24 exists_table => 'EXISTS',
26 get_tables => 'Values',
29 remove_table => 'DELETE',
32 default => sub { Tie::IxHash->new() }
37 isa => IxHash, #ViewHash,
39 exists_view => 'EXISTS',
41 get_views => 'Values',
44 remove_view => 'DELETE',
47 default => sub { Tie::IxHash->new() }
52 isa => IxHash, #ProcedureHash,
54 exists_procedure => 'EXISTS',
55 procedure_ids => 'Keys',
56 get_procedures => 'Values',
57 get_procedure => 'FETCH',
58 add_procedure => 'STORE',
59 remove_procedure => 'DELETE',
62 default => sub { Tie::IxHash->new() }
67 isa => IxHash, #TriggerHash,
69 exists_trigger => 'EXISTS',
70 trigger_ids => 'Keys',
71 get_triggers => 'Values',
72 get_trigger => 'FETCH',
73 add_trigger => 'STORE',
74 remove_trigger => 'DELETE',
77 default => sub { Tie::IxHash->new() }
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);
84 return $self->get_table($table->name);
87 around add_view(View $view does coerce) {
88 die "Can't use view name " . $view->name if $self->exists_view($view->name) || $view->name eq '';
90 $self->$orig($view->name, $view);
91 return $self->get_view($view->name);
94 around add_procedure(Procedure $procedure does coerce) {
95 $procedure->schema($self);
96 $self->$orig($procedure->name, $procedure);
97 return $self->get_procedure($procedure->name);
100 around add_trigger(Trigger $trigger does coerce) {
101 $trigger->schema($self);
102 $self->$orig($trigger->name, $trigger);
103 return $self->get_trigger($trigger->name);
106 method is_valid { return $self->get_tables ? 1 : undef }
108 around remove_table(Table|Str $table, Int :$cascade = 0) {
109 my $name = is_Table($table) ? $table->name : $table;
110 die "Can't drop non-existant table " . $name unless $self->exists_table($name);
114 around remove_view(View|Str $view) {
115 my $name = is_View($view) ? $view->name : $view;
116 die "Can't drop non-existant view " . $name unless $self->exists_view($name);
120 around remove_trigger(Trigger|Str $trigger) {
121 my $name = is_Trigger($trigger) ? $trigger->name : $trigger;
122 #### die "Can't drop non-existant trigger " . $name unless $self->exists_trigger($name);
126 around remove_procedure(Procedure|Str $procedure) {
127 my $name = is_Procedure($procedure) ? $procedure->name : $procedure;
132 method perform_action_when { }
133 method database_events { }