-package SQL::Translator::Object::Procedure;
-use Moose;
-use MooseX::Types::Moose qw(HashRef Int Maybe Str);
-use SQL::Translator::Types qw();
-use SQL::Translator::Object::Schema;
-extends 'SQL::Translator::Object';
+use MooseX::Declare;
+class SQL::Translator::Object::Procedure extends SQL::Translator::Object {
+ use MooseX::Types::Moose qw(ArrayRef Str);
+ use MooseX::MultiMethods;
+ use SQL::Translator::Types qw(Schema);
-has 'name' => (
- is => 'rw',
- isa => Str,
- required => 1
-);
+ has 'schema' => (
+ is => 'rw',
+ isa => Schema,
+ weak_ref => 1,
+ );
+
+ has 'name' => (
+ is => 'rw',
+ isa => Str,
+ required => 1
+ );
+
+ has 'sql' => (
+ is => 'rw',
+ isa => Str,
+ required => 1
+ );
+
+ has '_parameters' => (
+ traits => ['Array'],
+ isa => ArrayRef,
+ handles => {
+ _parameters => 'elements',
+ add_parameter => 'push',
+ remove_last_parameter => 'pop',
+ },
+ default => sub { [] },
-has 'contents' => (
- is => 'rw',
- isa => Str,
- required => 1
-);
+ );
+
+ has 'owner' => (
+ is => 'rw',
+ isa => Str,
+ required => 1
+ );
-has 'parameters' => (
- is => 'rw',
- isa => Maybe[HashRef[Int|Str]],
- required => 0
-);
-
-has 'owner' => (
- is => 'rw',
- isa => Str,
- required => 1
-);
-
-has 'comments' => (
- is => 'rw',
- isa => Str,
- required => 0
-);
-
-has 'schema' => (
- is => 'rw',
- isa => Schema,
- required => 1,
- default => sub { SQL::Translator::Object::Schema->new }
-);
-
-1;
+ multi method parameters(Str $parameter) { $self->add_parameter($parameter) }
+ multi method parameters(ArrayRef $parameter) { $self->add_parameter($parameter) }
+ multi method parameters { $self->_parameters }
+}