use Catalyst's http method matching for REST
[catagits/Catalyst-Controller-DBIC-API.git] / lib / Catalyst / Controller / DBIC / API.pm
CommitLineData
d2739840 1package Catalyst::Controller::DBIC::API;
2
3#ABSTRACT: Provides a DBIx::Class web service automagically
4use Moose;
26e9dcd6 5BEGIN { extends 'Catalyst::Controller'; }
d2739840 6
7use CGI::Expand ();
8use DBIx::Class::ResultClass::HashRefInflator;
53429220 9use JSON ();
d2739840 10use Test::Deep::NoTest('eq_deeply');
11use MooseX::Types::Moose(':all');
12use Moose::Util;
13use Scalar::Util('blessed', 'reftype');
14use Try::Tiny;
15use Catalyst::Controller::DBIC::API::Request;
16use namespace::autoclean;
17
0b0bf911 18has '_json' => (
19 is => 'ro',
20 isa => 'JSON',
21 lazy_build => 1,
22);
23
24sub _build__json {
25 # no ->utf8 here because the request params get decoded by Catalyst
26 return JSON->new;
27}
28
d6993542 29with 'Catalyst::Controller::DBIC::API::StoredResultSource',
4e5983f2 30 'Catalyst::Controller::DBIC::API::StaticArguments';
31
32with 'Catalyst::Controller::DBIC::API::RequestArguments' => { static => 1 };
d2739840 33
34__PACKAGE__->config();
35
36=head1 SYNOPSIS
37
38 package MyApp::Controller::API::RPC::Artist;
39 use Moose;
40 BEGIN { extends 'Catalyst::Controller::DBIC::API::RPC' }
41
42 __PACKAGE__->config
43 ( action => { setup => { PathPart => 'artist', Chained => '/api/rpc/rpc_base' } }, # define parent chain action and partpath
d6993542 44 class => 'MyAppDB::Artist',
67431358 45 resultset_class => 'MyAppDB::ResultSet::Artist',
d6993542 46 create_requires => ['name', 'age'],
47 create_allows => ['nickname'],
48 update_allows => ['name', 'age', 'nickname'],
49 update_allows => ['name', 'age', 'nickname'],
50 select => [qw/name age/],
51 prefetch => ['cds'],
52 prefetch_allows => [
d2739840 53 'cds',
54 qw/ cds /,
55 { cds => 'tracks' },
d6993542 56 { cds => [qw/ tracks /] },
d2739840 57 ],
d6993542 58 ordered_by => [qw/age/],
59 search_exposes => [qw/age nickname/, { cds => [qw/title year/] }],
60 data_root => 'data',
61 use_json_boolean => 1,
62 return_object => 1,
d2739840 63 );
64
65 # Provides the following functional endpoints:
66 # /api/rpc/artist/create
67 # /api/rpc/artist/list
68 # /api/rpc/artist/id/[id]/delete
69 # /api/rpc/artist/id/[id]/update
70=cut
71
533075c7 72=method_private begin
73
74 :Private
75
76begin is provided in the base class to setup the Catalyst Request object, by applying the DBIC::API::Request role.
77
78=cut
79
80sub begin :Private
81{
82 my ($self, $c) = @_;
83
8eb64464 84 Moose::Util::ensure_all_roles($c->req, 'Catalyst::Controller::DBIC::API::Request');
533075c7 85}
86
d2739840 87=method_protected setup
88
89 :Chained('specify.in.subclass.config') :CaptureArgs(0) :PathPart('specify.in.subclass.config')
90
91This action is the chain root of the controller. It must either be overridden or configured to provide a base pathpart to the action and also a parent action. For example, for class MyAppDB::Track you might have
92
93 package MyApp::Controller::API::RPC::Track;
406086f3 94 use Moose;
533075c7 95 BEGIN { extends 'Catalyst::Controller::DBIC::API::RPC'; }
d2739840 96
97 __PACKAGE__->config
406086f3 98 ( action => { setup => { PathPart => 'track', Chained => '/api/rpc/rpc_base' } },
d2739840 99 ...
100 );
101
102 # or
103
104 sub setup :Chained('/api/rpc_base') :CaptureArgs(0) :PathPart('track') {
105 my ($self, $c) = @_;
106
107 $self->next::method($c);
108 }
109
533075c7 110This action does nothing by default.
d2739840 111
112=cut
113
533075c7 114sub setup :Chained('specify.in.subclass.config') :CaptureArgs(0) :PathPart('specify.in.subclass.config') {}
d2739840 115
116=method_protected deserialize
117
533075c7 118 :Chained('setup') :CaptureArgs(0) :PathPart('') :ActionClass('Deserialize')
119
0b0bf911 120deserialize absorbs the request data and transforms it into useful bits by using CGI::Expand->expand_hash and a smattering of JSON->decode for a handful of arguments. Current only the following arguments are capable of being expressed as JSON:
d2739840 121
122 search_arg
123 count_arg
124 page_arg
125 ordered_by_arg
126 grouped_by_arg
127 prefetch_arg
128
533075c7 129It should be noted that arguments can used mixed modes in with some caveats. Each top level arg can be expressed as CGI::Expand with their immediate child keys expressed as JSON when sending the data application/x-www-form-urlencoded. Otherwise, you can send content as raw json and it will be deserialized as is with no CGI::Expand expasion.
d2739840 130
131=cut
132
8cf0b66a 133sub deserialize :Chained('setup') :CaptureArgs(0) :PathPart('') :ActionClass('Deserialize')
d2739840 134{
d2739840 135 my ($self, $c) = @_;
136 my $req_params;
137
138 if ($c->req->data && scalar(keys %{$c->req->data}))
139 {
140 $req_params = $c->req->data;
141 }
406086f3 142 else
d2739840 143 {
144 $req_params = CGI::Expand->expand_hash($c->req->params);
145
33003023 146 foreach my $param (@{[$self->search_arg, $self->count_arg, $self->page_arg, $self->offset_arg, $self->ordered_by_arg, $self->grouped_by_arg, $self->prefetch_arg]})
d2739840 147 {
148 # these params can also be composed of JSON
149 # but skip if the parameter is not provided
150 next if not exists $req_params->{$param};
151 # find out if CGI::Expand was involved
152 if (ref $req_params->{$param} eq 'HASH')
153 {
154 for my $key ( keys %{$req_params->{$param}} )
155 {
0b0bf911 156 # copy the value because JSON::XS will alter it
157 # even if decoding failed
158 my $value = $req_params->{$param}->{$key};
d2739840 159 try
160 {
0b0bf911 161 my $deserialized = $self->_json->decode($value);
d2739840 162 $req_params->{$param}->{$key} = $deserialized;
163 }
164 catch
406086f3 165 {
d2739840 166 $c->log->debug("Param '$param.$key' did not deserialize appropriately: $_")
167 if $c->debug;
168 }
169 }
170 }
171 else
172 {
173 try
174 {
0b0bf911 175 my $value = $req_params->{$param};
176 my $deserialized = $self->_json->decode($value);
d2739840 177 $req_params->{$param} = $deserialized;
178 }
179 catch
406086f3 180 {
d2739840 181 $c->log->debug("Param '$param' did not deserialize appropriately: $_")
182 if $c->debug;
183 }
184 }
185 }
186 }
406086f3 187
d2739840 188 $self->inflate_request($c, $req_params);
189}
190
9a29ee35 191=method_protected generate_rs
192
5a3fd922 193generate_rs is used by inflate_request to get a resultset for the current
194request. It receives $c as its only argument.
195By default it returns a resultset of the controller's class.
196Override this method if you need to manipulate the default implementation of
197getting a resultset.
9a29ee35 198
199=cut
200
201sub generate_rs
202{
5a3fd922 203 my ($self, $c) = @_;
def4bb3d 204
5a3fd922 205 return $c->model($self->class);
9a29ee35 206}
207
d2739840 208=method_protected inflate_request
406086f3 209
d2739840 210inflate_request is called at the end of deserialize to populate key portions of the request with the useful bits
211
212=cut
213
214sub inflate_request
215{
d2739840 216 my ($self, $c, $params) = @_;
217
218 try
219 {
220 # set static arguments
406086f3 221 $c->req->_set_controller($self);
d2739840 222
223 # set request arguments
224 $c->req->_set_request_data($params);
8cf0b66a 225
226 # set the current resultset
9a29ee35 227 $c->req->_set_current_result_set($self->generate_rs($c));
406086f3 228
d2739840 229 }
230 catch
231 {
232 $c->log->error($_);
233 $self->push_error($c, { message => $_ });
234 $c->detach();
235 }
8cf0b66a 236}
237
238=method_protected object_with_id
239
240 :Chained('deserialize') :CaptureArgs(1) :PathPart('')
241
242This action is the chain root for all object level actions (such as delete and update) that operate on a single identifer. The provided identifier will be used to find that particular object and add it to the request's store of objects. Please see L<Catalyst::Controller::DBIC::API::Context> for more details on the stored objects.
243
244=cut
245
246sub object_with_id :Chained('deserialize') :CaptureArgs(1) :PathPart('')
247{
248 my ($self, $c, $id) = @_;
249
250 my $vals = $c->req->request_data->{$self->data_root};
251 unless(defined($vals))
252 {
253 # no data root, assume the request_data itself is the payload
254 $vals = $c->req->request_data;
255 }
256
257 try
258 {
259 # there can be only one set of data
260 $c->req->add_object([$self->object_lookup($c, $id), $vals]);
261 }
262 catch
263 {
264 $c->log->error($_);
265 $self->push_error($c, { message => $_ });
266 $c->detach();
267 }
268}
269
270=method_protected objects_no_id
271
272 :Chained('deserialize') :CaptureArgs(0) :PathPart('')
273
274This action is the chain root for object level actions (such as create, update, or delete) that can involve more than one object. The data stored at the data_root of the request_data will be interpreted as an array of hashes on which to operate. If the hashes are missing an 'id' key, they will be considered a new object to be created. Otherwise, the values in the hash will be used to perform an update. As a special case, a single hash sent will be coerced into an array. Please see L<Catalyst::Controller::DBIC::API::Context> for more details on the stored objects.
275
276=cut
277
278sub objects_no_id :Chained('deserialize') :CaptureArgs(0) :PathPart('')
279{
280 my ($self, $c) = @_;
406086f3 281
533075c7 282 if($c->req->has_request_data)
8cf0b66a 283 {
533075c7 284 my $data = $c->req->request_data;
285 my $vals;
406086f3 286
533075c7 287 if(exists($data->{$self->data_root}) && defined($data->{$self->data_root}))
8cf0b66a 288 {
533075c7 289 my $root = $data->{$self->data_root};
290 if(reftype($root) eq 'ARRAY')
291 {
292 $vals = $root;
293 }
294 elsif(reftype($root) eq 'HASH')
295 {
296 $vals = [$root];
297 }
298 else
299 {
300 $c->log->error('Invalid request data');
301 $self->push_error($c, { message => 'Invalid request data' });
302 $c->detach();
303 }
8cf0b66a 304 }
533075c7 305 else
8cf0b66a 306 {
533075c7 307 # no data root, assume the request_data itself is the payload
308 $vals = [$c->req->request_data];
8cf0b66a 309 }
533075c7 310
311 foreach my $val (@$vals)
8cf0b66a 312 {
533075c7 313 unless(exists($val->{id}))
314 {
315 $c->req->add_object([$c->req->current_result_set->new_result({}), $val]);
316 next;
317 }
318
319 try
320 {
321 $c->req->add_object([$self->object_lookup($c, $val->{id}), $val]);
322 }
323 catch
324 {
325 $c->log->error($_);
326 $self->push_error($c, { message => $_ });
327 $c->detach();
328 }
8cf0b66a 329 }
330 }
331}
332
333=method_protected object_lookup
334
335This method provides the look up functionality for an object based on 'id'. It is passed the current $c and the $id to be used to perform the lookup. Dies if there is no provided $id or if no object was found.
336
337=cut
338
339sub object_lookup
340{
341 my ($self, $c, $id) = @_;
342
343 die 'No valid ID provided for look up' unless defined $id and length $id;
344 my $object = $c->req->current_result_set->find($id);
345 die "No object found for id '$id'" unless defined $object;
346 return $object;
d2739840 347}
348
349=method_protected list
350
3d85db11 351list's steps are broken up into three distinct methods: L</list_munge_parameters>, L</list_perform_search>, and L</list_format_output>.
d2739840 352
810de6af 353The goal of this method is to call ->search() on the current_result_set, change resultset class of the result (if needed), and return it in $c->stash->{$self->stash_key}->{$self->data_root}. Please see the individual methods for more details on what actual processing takes place.
d2739840 354
355If the L</select> config param is defined then the hashes will contain only those columns, otherwise all columns in the object will be returned. L</select> of course supports the function/procedure calling semantics that L<DBIx::Class::ResultSet/select>. In order to have proper column names in the result, provide arguments in L</as> (which also follows L<DBIx::Class::ResultSet/as> semantics. Similarly L</count>, L</page>, L</grouped_by> and L</ordered_by> affect the maximum number of rows returned as well as the ordering and grouping. Note that if select, count, ordered_by or grouped_by request parameters are present then these will override the values set on the class with select becoming bound by the select_exposes attribute.
356
d666a194 357If not all objects in the resultset are required then it's possible to pass conditions to the method as request parameters. You can use a JSON string as the 'search' parameter for maximum flexibility or use L<CGI::Expand> syntax. In the second case the request parameters are expanded into a structure and then used as the search condition.
d2739840 358
359For example, these request parameters:
360
361 ?search.name=fred&search.cd.artist=luke
362 OR
363 ?search={"name":"fred","cd": {"artist":"luke"}}
364
365Would result in this search (where 'name' is a column of the schema class, 'cd' is a relation of the schema class and 'artist' is a column of the related class):
366
367 $rs->search({ name => 'fred', 'cd.artist' => 'luke' }, { join => ['cd'] })
368
369It is also possible to use a JSON string for expandeded parameters:
370
371 ?search.datetime={"-between":["2010-01-06 19:28:00","2010-01-07 19:28:00"]}
372
373Note that if pagination is needed, this can be achieved using a combination of the L</count> and L</page> parameters. For example:
374
375 ?page=2&count=20
376
377Would result in this search:
406086f3 378
d2739840 379 $rs->search({}, { page => 2, rows => 20 })
380
381=cut
382
3d85db11 383sub list
d2739840 384{
d2739840 385 my ($self, $c) = @_;
386
387 $self->list_munge_parameters($c);
388 $self->list_perform_search($c);
389 $self->list_format_output($c);
533075c7 390
391 # make sure there are no objects lingering
406086f3 392 $c->req->clear_objects();
d2739840 393}
394
395=method_protected list_munge_parameters
396
397list_munge_parameters is a noop by default. All arguments will be passed through without any manipulation. In order to successfully manipulate the parameters before the search is performed, simply access $c->req->search_parameters|search_attributes (ArrayRef and HashRef respectively), which correspond directly to ->search($parameters, $attributes). Parameter keys will be in already-aliased form.
2abdb831 398To store the munged parameters call $c->req->_set_search_parameters($newparams) and $c->req->_set_search_attributes($newattrs).
d2739840 399
400=cut
401
402sub list_munge_parameters { } # noop by default
403
404=method_protected list_perform_search
405
406list_perform_search executes the actual search. current_result_set is updated to contain the result returned from ->search. If paging was requested, search_total_entries will be set as well.
407
408=cut
409
410sub list_perform_search
411{
d2739840 412 my ($self, $c) = @_;
406086f3 413
414 try
d2739840 415 {
416 my $req = $c->req;
406086f3 417
d2739840 418 my $rs = $req->current_result_set->search
419 (
406086f3 420 $req->search_parameters,
d2739840 421 $req->search_attributes
422 );
423
424 $req->_set_current_result_set($rs);
425
426 $req->_set_search_total_entries($req->current_result_set->pager->total_entries)
df8f3121 427 if $req->has_search_attributes && (exists($req->search_attributes->{page}) && defined($req->search_attributes->{page}) && length($req->search_attributes->{page}));
d2739840 428 }
429 catch
430 {
431 $c->log->error($_);
432 $self->push_error($c, { message => 'a database error has occured.' });
433 $c->detach();
434 }
435}
436
437=method_protected list_format_output
438
439list_format_output prepares the response for transmission across the wire. A copy of the current_result_set is taken and its result_class is set to L<DBIx::Class::ResultClass::HashRefInflator>. Each row in the resultset is then iterated and passed to L</row_format_output> with the result of that call added to the output.
440
441=cut
442
443sub list_format_output
444{
d2739840 445 my ($self, $c) = @_;
446
447 my $rs = $c->req->current_result_set->search;
a0a4ed30 448 $rs->result_class($self->result_class) if $self->result_class;
406086f3 449
d2739840 450 try
451 {
452 my $output = {};
453 my $formatted = [];
406086f3 454
d2739840 455 foreach my $row ($rs->all)
456 {
4cb15235 457 push(@$formatted, $self->row_format_output($c, $row));
d2739840 458 }
406086f3 459
d2739840 460 $output->{$self->data_root} = $formatted;
461
462 if ($c->req->has_search_total_entries)
463 {
464 $output->{$self->total_entries_arg} = $c->req->search_total_entries + 0;
465 }
466
810de6af 467 $c->stash->{$self->stash_key} = $output;
d2739840 468 }
469 catch
470 {
471 $c->log->error($_);
472 $self->push_error($c, { message => 'a database error has occured.' });
473 $c->detach();
474 }
475}
476
477=method_protected row_format_output
478
4cb15235 479row_format_output is called each row of the inflated output generated from the search. It receives two arguments, the catalyst context and the hashref that represents the row. By default, this method is merely a passthrough.
d2739840 480
481=cut
482
4cb15235 483sub row_format_output
484{
def4bb3d 485 #my ($self, $c, $row) = @_;
486 my ($self, undef, $row) = @_;
4cb15235 487 return $row; # passthrough by default
488}
d2739840 489
609916e5 490=method_protected item
609916e5 491
492item will return a single object called by identifier in the uri. It will be inflated via each_object_inflate.
493
494=cut
495
3d85db11 496sub item
609916e5 497{
498 my ($self, $c) = @_;
499
500 if($c->req->count_objects != 1)
501 {
502 $c->log->error($_);
503 $self->push_error($c, { message => 'No objects on which to operate' });
504 $c->detach();
505 }
506 else
507 {
810de6af 508 $c->stash->{$self->stash_key}->{$self->item_root} = $self->each_object_inflate($c, $c->req->get_object(0)->[0]);
609916e5 509 }
510}
511
d2739840 512=method_protected update_or_create
513
b421ef50 514update_or_create is responsible for iterating any stored objects and performing updates or creates. Each object is first validated to ensure it meets the criteria specified in the L</create_requires> and L</create_allows> (or L</update_allows>) parameters of the controller config. The objects are then committed within a transaction via L</transact_objects> using a closure around L</save_objects>.
d2739840 515
516=cut
517
3d85db11 518sub update_or_create
d2739840 519{
d2739840 520 my ($self, $c) = @_;
406086f3 521
d2739840 522 if($c->req->has_objects)
523 {
524 $self->validate_objects($c);
2e978a8c 525 $self->transact_objects($c, sub { $self->save_objects($c, @_) } );
d2739840 526 }
527 else
528 {
529 $c->log->error($_);
530 $self->push_error($c, { message => 'No objects on which to operate' });
531 $c->detach();
532 }
533}
534
535=method_protected transact_objects
536
537transact_objects performs the actual commit to the database via $schema->txn_do. This method accepts two arguments, the context and a coderef to be used within the transaction. All of the stored objects are passed as an arrayref for the only argument to the coderef.
538
539=cut
540
541sub transact_objects
542{
d2739840 543 my ($self, $c, $coderef) = @_;
406086f3 544
d2739840 545 try
546 {
547 $self->stored_result_source->schema->txn_do
548 (
549 $coderef,
550 $c->req->objects
551 );
552 }
553 catch
554 {
555 $c->log->error($_);
556 $self->push_error($c, { message => 'a database error has occured.' });
557 $c->detach();
558 }
559}
560
561=method_protected validate_objects
562
563This is a shortcut method for performing validation on all of the stored objects in the request. Each object's provided values (for create or update) are updated to the allowed values permitted by the various config parameters.
564
565=cut
566
567sub validate_objects
568{
d2739840 569 my ($self, $c) = @_;
570
571 try
572 {
573 foreach my $obj ($c->req->all_objects)
574 {
575 $obj->[1] = $self->validate_object($c, $obj);
576 }
577 }
578 catch
579 {
580 my $err = $_;
581 $c->log->error($err);
bec622aa 582 $err =~ s/\s+at\s+.+\n$//g;
d2739840 583 $self->push_error($c, { message => $err });
584 $c->detach();
585 }
586}
587
588=method_protected validate_object
589
590validate_object takes the context and the object as an argument. It then filters the passed values in slot two of the tuple through the create|update_allows configured. It then returns those filtered values. Values that are not allowed are silently ignored. If there are no values for a particular key, no valid values at all, or multiple of the same key, this method will die.
591
592=cut
593
594sub validate_object
595{
d2739840 596 my ($self, $c, $obj) = @_;
597 my ($object, $params) = @$obj;
598
599 my %values;
600 my %requires_map = map
601 {
602 $_ => 1
406086f3 603 }
d2739840 604 @{
406086f3 605 ($object->in_storage)
606 ? []
d2739840 607 : $c->stash->{create_requires} || $self->create_requires
608 };
406086f3 609
d2739840 610 my %allows_map = map
611 {
612 (ref $_) ? %{$_} : ($_ => 1)
406086f3 613 }
d2739840 614 (
406086f3 615 keys %requires_map,
d2739840 616 @{
406086f3 617 ($object->in_storage)
618 ? ($c->stash->{update_allows} || $self->update_allows)
d2739840 619 : ($c->stash->{create_allows} || $self->create_allows)
620 }
621 );
622
623 foreach my $key (keys %allows_map)
624 {
625 # check value defined if key required
626 my $allowed_fields = $allows_map{$key};
406086f3 627
d2739840 628 if (ref $allowed_fields)
629 {
630 my $related_source = $object->result_source->related_source($key);
631 my $related_params = $params->{$key};
632 my %allowed_related_map = map { $_ => 1 } @$allowed_fields;
633 my $allowed_related_cols = ($allowed_related_map{'*'}) ? [$related_source->columns] : $allowed_fields;
406086f3 634
d2739840 635 foreach my $related_col (@{$allowed_related_cols})
636 {
39955b2a 637 if (defined(my $related_col_value = $related_params->{$related_col})) {
d2739840 638 $values{$key}{$related_col} = $related_col_value;
639 }
640 }
641 }
406086f3 642 else
d2739840 643 {
644 my $value = $params->{$key};
645
646 if ($requires_map{$key})
647 {
648 unless (defined($value))
649 {
650 # if not defined look for default
651 $value = $object->result_source->column_info($key)->{default_value};
652 unless (defined $value)
653 {
654 die "No value supplied for ${key} and no default";
655 }
656 }
657 }
406086f3 658
d2739840 659 # check for multiple values
0b0bf911 660 if (ref($value) && !(reftype($value) eq reftype(JSON::true)))
d2739840 661 {
662 require Data::Dumper;
663 die "Multiple values for '${key}': ${\Data::Dumper::Dumper($value)}";
664 }
665
666 # check exists so we don't just end up with hash of undefs
667 # check defined to account for default values being used
668 $values{$key} = $value if exists $params->{$key} || defined $value;
669 }
670 }
671
406086f3 672 unless (keys %values || !$object->in_storage)
d2739840 673 {
674 die 'No valid keys passed';
675 }
676
406086f3 677 return \%values;
d2739840 678}
679
680=method_protected delete
681
b421ef50 682delete operates on the stored objects in the request. It first transacts the objects, deleting them in the database using L</transact_objects> and a closure around L</delete_objects>, and then clears the request store of objects.
d2739840 683
684=cut
685
3d85db11 686sub delete
d2739840 687{
d2739840 688 my ($self, $c) = @_;
406086f3 689
d2739840 690 if($c->req->has_objects)
691 {
2e978a8c 692 $self->transact_objects($c, sub { $self->delete_objects($c, @_) });
d2739840 693 $c->req->clear_objects;
694 }
695 else
696 {
697 $c->log->error($_);
698 $self->push_error($c, { message => 'No objects on which to operate' });
699 $c->detach();
700 }
701}
702
b421ef50 703=method_protected save_objects
d2739840 704
b421ef50 705This method is used by update_or_create to perform the actual database manipulations. It iterates each object calling L</save_object>.
d2739840 706
b421ef50 707=cut
708
709sub save_objects
710{
2e978a8c 711 my ($self, $c, $objects) = @_;
d2739840 712
b421ef50 713 foreach my $obj (@$objects)
714 {
2e978a8c 715 $self->save_object($c, $obj);
b421ef50 716 }
717}
d2739840 718
b421ef50 719=method_protected save_object
d2739840 720
b421ef50 721save_object first checks to see if the object is already in storage. If so, it calls L</update_object_from_params> otherwise it calls L</insert_object_from_params>
d2739840 722
723=cut
724
b421ef50 725sub save_object
d2739840 726{
2e978a8c 727 my ($self, $c, $obj) = @_;
d2739840 728
b421ef50 729 my ($object, $params) = @$obj;
730
731 if ($object->in_storage)
d2739840 732 {
2e978a8c 733 $self->update_object_from_params($c, $object, $params);
b421ef50 734 }
406086f3 735 else
b421ef50 736 {
2e978a8c 737 $self->insert_object_from_params($c, $object, $params);
b421ef50 738 }
739
740}
741
742=method_protected update_object_from_params
743
f5113975 744update_object_from_params iterates through the params to see if any of them are pertinent to relations. If so it calls L</update_object_relation> with the object, and the relation parameters. Then it calls ->update on the object.
b421ef50 745
746=cut
747
748sub update_object_from_params
749{
2e978a8c 750 my ($self, $c, $object, $params) = @_;
b421ef50 751
752 foreach my $key (keys %$params)
753 {
754 my $value = $params->{$key};
0b0bf911 755 if (ref($value) && !(reftype($value) eq reftype(JSON::true)))
b421ef50 756 {
2e978a8c 757 $self->update_object_relation($c, $object, delete $params->{$key}, $key);
d2739840 758 }
16337d41 759 # accessor = colname
760 elsif ($object->can($key)) {
761 $object->$key($value);
762 }
763 # accessor != colname
764 else {
765 my $accessor = $object->result_source->column_info($key)->{accessor};
766 $object->$accessor($value);
767 }
d2739840 768 }
406086f3 769
3b12c2cd 770 $object->update();
b421ef50 771}
772
773=method_protected update_object_relation
774
775update_object_relation finds the relation to the object, then calls ->update with the specified parameters
776
777=cut
778
779sub update_object_relation
780{
2e978a8c 781 my ($self, $c, $object, $related_params, $relation) = @_;
b421ef50 782 my $row = $object->find_related($relation, {} , {});
8516bd76 783
784 if ($row) {
3b12c2cd 785 foreach my $key (keys %$related_params) {
786 my $value = $related_params->{$key};
0b0bf911 787 if (ref($value) && !(reftype($value) eq reftype(JSON::true)))
16337d41 788 {
789 $self->update_object_relation($c, $row, delete $related_params->{$key}, $key);
790 }
791 # accessor = colname
0f0f8776 792 elsif ($row->can($key)) {
793 $row->$key($value);
16337d41 794 }
795 # accessor != colname
796 else {
0f0f8776 797 my $accessor = $row->result_source->column_info($key)->{accessor};
798 $row->$accessor($value);
16337d41 799 }
3b12c2cd 800 }
801 $row->update();
8516bd76 802 }
803 else {
804 $object->create_related($relation, $related_params);
805 }
b421ef50 806}
807
808=method_protected insert_object_from_params
809
810insert_object_from_params sets the columns for the object, then calls ->insert
811
812=cut
813
814sub insert_object_from_params
815{
def4bb3d 816 #my ($self, $c, $object, $params) = @_;
817 my ($self, undef, $object, $params) = @_;
d8921389 818
819 my %rels;
c50b4fa4 820 while (my ($key, $value) = each %{ $params }) {
821 if (ref($value) && !(reftype($value) eq reftype(JSON::true))) {
822 $rels{$key} = $value;
d8921389 823 }
c50b4fa4 824 # accessor = colname
825 elsif ($object->can($key)) {
826 $object->$key($value);
827 }
828 # accessor != colname
d8921389 829 else {
c50b4fa4 830 my $accessor = $object->result_source->column_info($key)->{accessor};
831 $object->$accessor($value);
d8921389 832 }
833 }
834
b421ef50 835 $object->insert;
d8921389 836
837 while (my ($k, $v) = each %rels) {
838 $object->create_related($k, $v);
839 }
d2739840 840}
841
b421ef50 842=method_protected delete_objects
843
844delete_objects iterates through each object calling L</delete_object>
845
846=cut
847
d2739840 848sub delete_objects
849{
2e978a8c 850 my ($self, $c, $objects) = @_;
b421ef50 851
2e978a8c 852 map { $self->delete_object($c, $_->[0]) } @$objects;
b421ef50 853}
854
855=method_protected delete_object
856
857Performs the actual ->delete on the object
858
859=cut
860
861sub delete_object
862{
def4bb3d 863 #my ($self, $c, $object) = @_;
864 my ($self, undef, $object) = @_;
d2739840 865
b421ef50 866 $object->delete;
d2739840 867}
868
869=method_protected end
870
d2739840 871end performs the final manipulation of the response before it is serialized. This includes setting the success of the request both at the HTTP layer and JSON layer. If configured with return_object true, and there are stored objects as the result of create or update, those will be inflated according to the schema and get_inflated_columns
872
873=cut
874
3d85db11 875sub end :Private
d2739840 876{
d2739840 877 my ($self, $c) = @_;
878
e2f6c772 879 # don't change the http status code if already set elsewhere
880 unless ($c->res->status && $c->res->status != 200) {
881 if ($self->has_errors($c)) {
882 $c->res->status(400);
883 }
884 else {
885 $c->res->status(200);
886 }
887 }
d2739840 888
e2f6c772 889 if ($c->res->status == 200) {
0b0bf911 890 $c->stash->{$self->stash_key}->{success} = $self->use_json_boolean ? JSON::true : 'true';
e2f6c772 891 if($self->return_object && $c->req->has_objects) {
892 my $returned_objects = [];
893 push(@$returned_objects, $self->each_object_inflate($c, $_)) for map { $_->[0] } $c->req->all_objects;
894 $c->stash->{$self->stash_key}->{$self->data_root} = scalar(@$returned_objects) > 1 ? $returned_objects : $returned_objects->[0];
895 }
d2739840 896 }
e2f6c772 897 else {
898 $c->stash->{$self->stash_key}->{success} = $self->use_json_boolean ? JSON::false : 'false';
899 $c->stash->{$self->stash_key}->{messages} = $self->get_errors($c)
900 if $self->has_errors($c);
901 # don't return data for error responses
810de6af 902 delete $c->stash->{$self->stash_key}->{$self->data_root};
d2739840 903 }
d2739840 904
d2739840 905 $c->forward('serialize');
906}
907
c9b8a798 908=method_protected each_object_inflate
909
910each_object_inflate executes during L</end> and allows hooking into the process of inflating the objects to return in the response. Receives, the context, and the object as arguments.
911
912This only executes if L</return_object> if set and if there are any objects to actually return.
913
914=cut
915
916sub each_object_inflate
917{
def4bb3d 918 #my ($self, $c, $object) = @_;
919 my ($self, undef, $object) = @_;
d2739840 920
8ee81496 921 return { $object->get_columns };
d2739840 922}
923
b66d4310 924=method_protected serialize
925
926multiple actions forward to serialize which uses Catalyst::Action::Serialize.
927
928=cut
929
c9b8a798 930# from Catalyst::Action::Serialize
931sub serialize :ActionClass('Serialize') { }
932
d2739840 933=method_protected push_error
934
935push_error stores an error message into the stash to be later retrieved by L</end>. Accepts a Dict[message => Str] parameter that defines the error message.
936
937=cut
938
939sub push_error
940{
941 my ( $self, $c, $params ) = @_;
a80eb0e8 942 die 'Catalyst app object missing'
943 unless defined $c;
7821bdec 944 my $error = 'unknown error';
945 if (exists $params->{message}) {
946 $error = $params->{message};
947 # remove newline from die "error message\n" which is required to not
948 # have the filename and line number in the error text
949 $error =~ s/\n$//;
950 }
951 push( @{$c->stash->{_dbic_crud_errors}}, $error);
d2739840 952}
953
954=method_protected get_errors
955
956get_errors returns all of the errors stored in the stash
957
958=cut
959
960sub get_errors
961{
962 my ( $self, $c ) = @_;
a80eb0e8 963 die 'Catalyst app object missing'
964 unless defined $c;
d2739840 965 return $c->stash->{_dbic_crud_errors};
966}
967
71c17090 968=method_protected has_errors
969
970returns returns true if errors are stored in the stash
971
972=cut
973
974sub has_errors {
975 my ( $self, $c ) = @_;
976 die 'Catalyst app object missing'
977 unless defined $c;
978 return exists $c->stash->{_dbic_crud_errors};
979}
980
d2739840 981=head1 DESCRIPTION
982
983Easily provide common API endpoints based on your L<DBIx::Class> schema classes. Module provides both RPC and REST interfaces to base functionality. Uses L<Catalyst::Action::Serialize> and L<Catalyst::Action::Deserialize> to serialise response and/or deserialise request.
984
985=head1 OVERVIEW
986
987This document describes base functionlity such as list, create, delete, update and the setting of config attributes. L<Catalyst::Controller::DBIC::API::RPC> and L<Catalyst::Controller::DBIC::API::REST> describe details of provided endpoints to those base methods.
988
989You will need to create a controller for each schema class you require API endpoints for. For example if your schema has Artist and Track, and you want to provide a RESTful interface to these, you should create MyApp::Controller::API::REST::Artist and MyApp::Controller::API::REST::Track which both subclass L<Catalyst::Controller::DBIC::API::REST>. Similarly if you wanted to provide an RPC style interface then subclass L<Catalyst::Controller::DBIC::API::RPC>. You then configure these individually as specified in L</CONFIGURATION>.
990
991Also note that the test suite of this module has an example application used to run tests against. It maybe helpful to look at that until a better tutorial is written.
992
993=head2 CONFIGURATION
994
995Each of your controller classes needs to be configured to point at the relevant schema class, specify what can be updated and so on, as shown in the L</SYNOPSIS>.
996
997The class, create_requires, create_allows and update_requires parameters can also be set in the stash like so:
998
999 sub setup :Chained('/api/rpc/rpc_base') :CaptureArgs(1) :PathPart('any') {
1000 my ($self, $c, $object_type) = @_;
1001
1002 if ($object_type eq 'artist') {
1003 $c->stash->{class} = 'MyAppDB::Artist';
1004 $c->stash->{create_requires} = [qw/name/];
1005 $c->stash->{update_allows} = [qw/name/];
1006 } else {
1007 $self->push_error($c, { message => "invalid object_type" });
1008 return;
1009 }
1010
1011 $self->next::method($c);
1012 }
1013
1014Generally it's better to have one controller for each DBIC source with the config hardcoded, but in some cases this isn't possible.
1015
1016Note that the Chained, CaptureArgs and PathPart are just standard Catalyst configuration parameters and that then endpoint specified in Chained - in this case '/api/rpc/rpc_base' - must actually exist elsewhere in your application. See L<Catalyst::DispatchType::Chained> for more details.
1017
1018Below are explanations for various configuration parameters. Please see L<Catalyst::Controller::DBIC::API::StaticArguments> for more details.
1019
1020=head3 class
1021
1022Whatever you would pass to $c->model to get a resultset for this class. MyAppDB::Track for example.
1023
a0a4ed30 1024=head3 resultset_class
1025
1026Desired resultset class after accessing your model. MyAppDB::ResultSet::Track for example. By default, it's DBIx::Class::ResultClass::HashRefInflator. Set to empty string to leave resultset class without change.
1027
810de6af 1028=head3 stash_key
1029
1030Controls where in stash request_data should be stored, and defaults to 'response'.
1031
d2739840 1032=head3 data_root
1033
810de6af 1034By default, the response data is serialized into $c->stash->{$self->stash_key}->{$self->data_root} and data_root defaults to 'list' to preserve backwards compatibility. This is now configuable to meet the needs of the consuming client.
d2739840 1035
1036=head3 use_json_boolean
1037
0b0bf911 1038By default, the response success status is set to a string value of "true" or "false". If this attribute is true, JSON's true() and false() will be used instead. Note, this does not effect other internal processing of boolean values.
d2739840 1039
1040=head3 count_arg, page_arg, select_arg, search_arg, grouped_by_arg, ordered_by_arg, prefetch_arg, as_arg, total_entries_arg
1041
1042These attributes allow customization of the component to understand requests made by clients where these argument names are not flexible and cannot conform to this components defaults.
1043
1044=head3 create_requires
1045
1046Arrayref listing columns required to be passed to create in order for the request to be valid.
1047
1048=head3 create_allows
1049
1050Arrayref listing columns additional to those specified in create_requires that are not required to create but which create does allow. Columns passed to create that are not listed in create_allows or create_requires will be ignored.
1051
1052=head3 update_allows
1053
1054Arrayref listing columns that update will allow. Columns passed to update that are not listed here will be ignored.
1055
1056=head3 select
1057
1058Arguments to pass to L<DBIx::Class::ResultSet/select> when performing search for L</list>.
1059
1060=head3 as
1061
1062Complements arguments passed to L<DBIx::Class::ResultSet/select> when performing a search. This allows you to specify column names in the result for RDBMS functions, etc.
1063
1064=head3 select_exposes
1065
1066Columns and related columns that are okay to return in the resultset since clients can request more or less information specified than the above select argument.
1067
1068=head3 prefetch
1069
1070Arguments to pass to L<DBIx::Class::ResultSet/prefetch> when performing search for L</list>.
1071
1072=head3 prefetch_allows
1073
1074Arrayref listing relationships that are allowed to be prefetched.
1075This is necessary to avoid denial of service attacks in form of
1076queries which would return a large number of data
1077and unwanted disclosure of data.
1078
1079=head3 grouped_by
1080
1081Arguments to pass to L<DBIx::Class::ResultSet/group_by> when performing search for L</list>.
1082
1083=head3 ordered_by
1084
1085Arguments to pass to L<DBIx::Class::ResultSet/order_by> when performing search for L</list>.
1086
1087=head3 search_exposes
1088
1089Columns and related columns that are okay to search on. For example if only the position column and all cd columns were to be allowed
1090
1091 search_exposes => [qw/position/, { cd => ['*'] }]
1092
1093You can also use this to allow custom columns should you wish to allow them through in order to be caught by a custom resultset. For example:
1094
1095 package RestTest::Controller::API::RPC::TrackExposed;
406086f3 1096
d2739840 1097 ...
406086f3 1098
d2739840 1099 __PACKAGE__->config
1100 ( ...,
1101 search_exposes => [qw/position title custom_column/],
1102 );
1103
1104and then in your custom resultset:
1105
1106 package RestTest::Schema::ResultSet::Track;
406086f3 1107
d2739840 1108 use base 'RestTest::Schema::ResultSet';
406086f3 1109
d2739840 1110 sub search {
1111 my $self = shift;
1112 my ($clause, $params) = @_;
1113
1114 # test custom attrs
1115 if (my $pretend = delete $clause->{custom_column}) {
1116 $clause->{'cd.year'} = $pretend;
1117 }
1118 my $rs = $self->SUPER::search(@_);
1119 }
1120
1121=head3 count
1122
1123Arguments to pass to L<DBIx::Class::ResultSet/rows> when performing search for L</list>.
1124
1125=head3 page
1126
04f135e4 1127Arguments to pass to L<DBIx::Class::ResultSet/page> when performing search for L</list>.
d2739840 1128
1129=head1 EXTENDING
1130
1131By default the create, delete and update actions will not return anything apart from the success parameter set in L</end>, often this is not ideal but the required behaviour varies from application to application. So normally it's sensible to write an intermediate class which your main controller classes subclass from.
1132
1133For example if you wanted create to return the JSON for the newly created object you might have something like:
1134
1135 package MyApp::ControllerBase::DBIC::API::RPC;
1136 ...
1137 use Moose;
1138 BEGIN { extends 'Catalyst::Controller::DBIC::API::RPC' };
1139 ...
1140 sub create :Chained('setup') :Args(0) :PathPart('create') {
1141 my ($self, $c) = @_;
1142
1143 # $c->req->all_objects will contain all of the created
1144 $self->next::method($c);
1145
406086f3 1146 if ($c->req->has_objects) {
810de6af 1147 # $c->stash->{$self->stash_key} will be serialized in the end action
1148 $c->stash->{$self->stash_key}->{$self->data_root} = [ map { { $_->get_inflated_columns } } ($c->req->all_objects) ] ;
d2739840 1149 }
1150 }
1151
d2739840 1152 package MyApp::Controller::API::RPC::Track;
1153 ...
1154 use Moose;
1155 BEGIN { extends 'MyApp::ControllerBase::DBIC::API::RPC' };
1156 ...
1157
d666a194 1158It should be noted that the return_object attribute will produce the above result for you, free of charge.
d2739840 1159
d2739840 1160Similarly you might want create, update and delete to all forward to the list action once they are done so you can refresh your view. This should also be simple enough.
1161
406086f3 1162If more extensive customization is required, it is recommened to peer into the roles that comprise the system and make use
d2739840 1163
1164=head1 NOTES
1165
1166It should be noted that version 1.004 and above makes a rapid depature from the status quo. The internals were revamped to use more modern tools such as Moose and its role system to refactor functionality out into self-contained roles.
1167
0b0bf911 1168To this end, internally, this module now understands JSON boolean values (as represented by the JSON module) and will Do The Right Thing in handling those values. This means you can have ColumnInflators installed that can covert between JSON booleans and whatever your database wants for boolean values.
d2739840 1169
1170Validation for various *_allows or *_exposes is now accomplished via Data::DPath::Validator with a lightly simplified, via subclass, Data::DPath::Validator::Visitor. The rough jist of the process goes as follows: Arguments provided to those attributes are fed into the Validator and Data::DPaths are generated. Then, incoming requests are validated against these paths generated. The validator is set in "loose" mode meaning only one path is required to match. For more information, please see L<Data::DPath::Validator> and more specifically L<Catalyst::Controller::DBIC::API::Validator>.
1171
1172Since 2.00100:
1173Transactions are used. The stash is put aside in favor of roles applied to the request object with additional accessors.
1174Error handling is now much more consistent with most errors immediately detaching.
1175The internals are much easier to read and understand with lots more documentation.
1176
1177=cut
1178
11791;