1 |
package Strix::Anketa; |
2 |
|
3 |
use warnings; |
4 |
use strict; |
5 |
|
6 |
use Strix::Schema; |
7 |
use Fey::ORM::Table; |
8 |
|
9 |
with 'Frey::Collection'; |
10 |
|
11 |
use Data::Dump qw/dump/; |
12 |
|
13 |
sub collection_table { 'anketa' } |
14 |
|
15 |
sub t { |
16 |
my $table = shift; |
17 |
warn "## table $table\n"; |
18 |
return Strix::Schema->Schema()->table( $table ) || die "can't find $table"; |
19 |
} |
20 |
|
21 |
my $anketa = Strix::Schema->Schema()->table( collection_table ); |
22 |
|
23 |
has_table( $anketa ); |
24 |
|
25 |
my $anketa_pitanja = Strix::Schema->Schema()->table( 'anketa_pitanja' ) or die; |
26 |
|
27 |
my $pitanja = |
28 |
Strix::Schema->SQLFactoryClass()->new_select() |
29 |
->select( $anketa_pitanja ) |
30 |
->from( $anketa_pitanja ) |
31 |
->where( $anketa_pitanja->column('anketa_id'), '=', Fey::Placeholder->new() ) |
32 |
->order_by( $anketa_pitanja->column('orders'), 'ASC' ) |
33 |
# ->limit(5) |
34 |
; |
35 |
|
36 |
|
37 |
my $fk = Fey::FK->new( |
38 |
source_columns => [ t('anketa')->column('id') ], |
39 |
target_columns => [ t('anketa_pitanja')->column('anketa_id') ], |
40 |
); |
41 |
|
42 |
|
43 |
has_many 'pitanja' => ( |
44 |
table => Strix::Schema->Schema()->table( 'anketa_pitanja' ), |
45 |
fk => $fk, |
46 |
# select => $pitanja, |
47 |
# bind_params => sub { $_[0]->id() }, |
48 |
); |
49 |
|
50 |
#warn dump( map { $_->name } $anketa->columns ); |
51 |
|
52 |
package Strix::Anketa::Pitanja; |
53 |
|
54 |
use Strix::Schema; |
55 |
use Fey::ORM::Table; |
56 |
|
57 |
with 'Frey::Collection'; |
58 |
sub collection_table { 'anketa_pitanja' } |
59 |
my $table = Strix::Schema->Schema()->table( collection_table ); |
60 |
has_table( $table ); |
61 |
|
62 |
1; |