| 1 | package # hide from PAUSE | ||
| 2 | CellBIS::SQL::Abstract::Test::Query; | ||
| 3 | |||
| 4 | use Mojo::Base -base; | ||
| 5 | |||
| 6 | has 'users'; | ||
| 7 | has 'roles'; | ||
| 8 | |||
| 9 | sub new { | ||
| 10 | my $self = shift->SUPER::new(); | ||
| 11 | |||
| 12 | $self->{users} = __PACKAGE__ . '::_users'; | ||
| 13 | $self->{roles} = __PACKAGE__ . '::_roles'; | ||
| 14 | |||
| 15 | } | ||
| 16 | |||
| 17 | package CellBIS::SQL::Abstract::Test::Query::_users; | ||
| 18 | $CellBIS::SQL::Abstract::Test::Query::_users::VERSION = '1.5'; | ||
| 19 | use Mojo::Base -base; | ||
| 20 | |||
| 21 | # Table fields | ||
| 22 | has table_name => 'users'; | ||
| 23 | has id => 'id_users'; | ||
| 24 | has id_roles => 'roles_id'; | ||
| 25 | has firstname => 'firstname'; | ||
| 26 | has lastname => 'lastname'; | ||
| 27 | has fullname => 'fullname'; | ||
| 28 | has username => 'username'; | ||
| 29 | has password => 'password'; | ||
| 30 | has create_date => 'date_create'; | ||
| 31 | has update_date => 'date_update'; | ||
| 32 | has status => 'status'; | ||
| 33 | |||
| 34 | sub create { | ||
| 35 | my $self = shift; | ||
| 36 | |||
| 37 | return ( | ||
| 38 | $self->table_name, | ||
| 39 | [ | ||
| 40 | $self->id_roles, $self->firstname, $self->lastname, | ||
| 41 | $self->fullname, $self->username, $self->password, | ||
| 42 | $self->create_date, $self->update_date, $self->status, | ||
| 43 | ], | ||
| 44 | { | ||
| 45 | 1, 'Achmad Yusri', 'Afandi', 'Achmad Yusri Afandi', | ||
| 46 | 'yusrideb', 's3cr3tm3', ['now()'], ['now()'] | ||
| 47 | } | ||
| 48 | ); | ||
| 49 | } | ||
| 50 | |||
| 51 | package CellBIS::SQL::Abstract::Test::Query::_roles; | ||
| 52 | $CellBIS::SQL::Abstract::Test::Query::_roles::VERSION = '1.5'; | ||
| 53 | use Mojo::Base -base; | ||
| 54 | |||
| 55 | # Table fields | ||
| 56 | has table_name => 'roles'; | ||
| 57 | has id => 'id_roles'; | ||
| 58 | has name => 'name'; | ||
| 59 | has config => 'config'; | ||
| 60 | |||
| 61 | 1; |