| 1 | package XTaTIK::Model::Quotes; | ||
| 2 | |||
| 3 | our $VERSION = '0.005003'; # VERSION | ||
| 4 | |||
| 5 | 1 | ▶ | use Mojo::Base -base; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 6 | 0 | ▶ | use XTaTIK::Model::Products; |
|
Subroutine
BEGIN: called CC=1 SCAR=2.6
| |||
| 7 | use XTaTIK::Model::Quote; | ||
| 8 | use Mojo::Pg; | ||
| 9 | use JSON::Meth; | ||
| 10 | |||
| 11 | use experimental 'postderef'; | ||
| 12 | |||
| 13 | has [qw/ | ||
| 14 | pg | ||
| 15 | /]; | ||
| 16 | |||
| 17 | sub all { | ||
| 18 | my $self = shift; | ||
| 19 | |||
| 20 | my $db_data = $self->pg->db->query('SELECT * FROM quotes')->hashes; | ||
| 21 | my @quotes; | ||
| 22 | |||
| 23 | for my $row ( @$db_data ) { | ||
| 24 | my $q = XTaTIK::Model::Quote->new; | ||
| 25 | $q->$_( $row->{$_} ) for $q->accessors; | ||
| 26 | $q->contents( ($row->{contents}//'[]')->$j ); | ||
| 27 | push @quotes, $q; | ||
| 28 | } | ||
| 29 | |||
| 30 | return \@quotes; | ||
| 31 | } | ||
| 32 | |||
| 33 | 1; | ||
| 34 | |||
| 35 | __END__ | ||