-package SQL::Translator::Object::Procedure;
-use Moose;
-use MooseX::Types::Moose qw(HashRef Int Maybe Str);
-use MooseX::AttributeHelpers;
-use SQL::Translator::Types qw();
-use SQL::Translator::Object::Schema;
-extends 'SQL::Translator::Object';
-
-has 'name' => (
- is => 'rw',
- isa => Str,
- required => 1
-);
-
-has 'contents' => (
- is => 'rw',
- isa => Str,
- required => 1
-);
-
-has 'parameters' => (
- metaclass => 'Collection::Hash',
- is => 'rw',
- isa => Maybe[HashRef[Int|Str]],
- provides => {
- exists => 'exists_parameter',
- keys => 'parameter_ids',
- get => 'get_parameter',
- set => 'set_parameter',
- },
- 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 }
-);
-
-no Moose;
-__PACKAGE__->meta->make_immutable;
-
-1;
+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 '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 'owner' => (
+ is => 'rw',
+ isa => Str,
+ required => 1
+ );
+
+ multi method parameters(Str $parameter) { $self->add_parameter($parameter) }
+ multi method parameters(ArrayRef $parameter) { $self->add_parameter($parameter) }
+ multi method parameters { $self->_parameters }
+}