blib/lib/CellBIS/SQL/Abstract/Test/Table.pm

filter: Statementstmt 83.3% 40 / 48 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 60.0% 6 / 10 Podpod 100% 1 / 1 totaltotal 79.6% 47 / 59 CC 1 SCAR 3.4
CC
1
Cov
83%
mariadb
2.0
pg
2.0
mariadb
2.0
CRAP 1.4
« blib/lib/CellBIS/SQL/Abstract/Test/Query.pm ↑ Summary
1 package CellBIS::SQL::Abstract::Test::Table;
2 4 $CellBIS::SQL::Abstract::Test::Table::VERSION = '1.5';
3 4 ▶use Mojo::Base -base;
Subroutine BEGIN: called CC=1 SCAR=0.0
4  
5 4 has 'users';
6 4 has 'roles';
7  
8 1 ▶sub new {
Subroutine new: called CC=1 SCAR=0.0
Pod documented
9 1 my $self = shift->SUPER::new(@_);
10  
11 1 my $table_users = __PACKAGE__ . '::_users';
12 1 my $table_roles = __PACKAGE__ . '::_roles';
13  
14 1 $self->{users} = $table_users->new;
15 1 $self->{roles} = $table_roles->new;
16  
17 1 return $self;
18 }
19  
20 package CellBIS::SQL::Abstract::Test::Table::_users;
21 4 $CellBIS::SQL::Abstract::Test::Table::_users::VERSION = '1.5';
22 4 ▶use Mojo::Base -base;
Subroutine BEGIN: called CC=1 SCAR=0.0
23  
24 # Table fields
25 4 has table_name => 'users';
26 4 has id => 'id_users';
27 4 has id_roles => 'roles_id';
28 4 has firstname => 'firstname';
29 4 has lastname => 'lastname';
30 4 has fullname => 'fullname';
31 4 has username => 'username';
32 4 has password => 'password';
33 4 has create => 'date_create';
34 4 has update => 'date_update';
35 4 has status => 'status';
36  
37 2 ▶sub sqlite {
Subroutine sqlite: called CC=1 SCAR=0.0
38 2 my $self = shift;
39  
40 return (
41 2 $self->table_name,
42 [
43 $self->id, $self->id_roles, $self->firstname, $self->lastname,
44 $self->fullname, $self->username, $self->password, $self->create,
45 $self->update, $self->status
46 ],
47 {
48 $self->id =>
49 {type => {name => 'integer'}, is_primarykey => 1, is_autoincre => 1},
50 $self->id_roles => {type => {name => 'integer'}, is_null => 0},
51 $self->firstname => {type => {name => 'varchar', size => 50}},
52 $self->lastname => {type => {name => 'varchar', size => 50}},
53 $self->fullname => {type => {name => 'varchar', size => 100}},
54 $self->username => {type => {name => 'varchar', size => 60}},
55 $self->password => {type => {name => 'text'}},
56 $self->create => {type => {name => 'datetime'}},
57 $self->update => {type => {name => 'datetime'}},
58 $self->status => {type => {name => 'int', size => 1}}
59 }
60 );
61 }
62  
63 0 ▶sub mariadb {
Subroutine mariadb: not called CC=1 SCAR=6.9
64 0 my $self = shift;
65  
66 return (
67 0 $self->table_name,
68 [
69 $self->id, $self->id_roles, $self->firstname, $self->lastname,
70 $self->fullname, $self->username, $self->password, $self->create,
71 $self->update, $self->status
72 ],
73 {
74 $self->id =>
75 {type => {name => 'int'}, is_primarykey => 1, is_autoincre => 1},
76 $self->id_roles => {type => {name => 'int'}, is_null => 0},
77 $self->firstname => {type => {name => 'varchar', size => 50}},
78 $self->lastname => {type => {name => 'varchar', size => 50}},
79 $self->fullname => {type => {name => 'varchar', size => 100}},
80 $self->username => {type => {name => 'varchar', size => 60}},
81 $self->password => {type => {name => 'text'}},
82 $self->create => {type => {name => 'datetime'}},
83 $self->update => {type => {name => 'datetime'}},
84 $self->status => {type => {name => 'int', size => 1}}
85 }
86 );
87 }
88  
89 0 ▶sub pg {
Subroutine pg: not called CC=1 SCAR=6.9
90 0 my $self = shift;
91 return (
92 0 $self->table_name,
93 [
94 $self->id, $self->id_roles, $self->firstname, $self->lastname,
95 $self->fullname, $self->username, $self->password, $self->create,
96 $self->update, $self->status
97 ],
98 {
99 $self->id => {type => {name => 'serial'}, is_primarykey => 1},
100 $self->id_roles => {type => {name => 'int'}, is_null => 0},
101 $self->firstname => {type => {name => 'varchar', size => 50}},
102 $self->lastname => {type => {name => 'varchar', size => 50}},
103 $self->fullname => {type => {name => 'varchar', size => 100}},
104 $self->username => {type => {name => 'varchar', size => 60}},
105 $self->password => {type => {name => 'text'}},
106 $self->create => {type => {name => 'timestamp'}},
107 $self->update => {type => {name => 'timestamp'}},
108 $self->status => {type => {name => 'int'}}
109 }
110 );
111 }
112  
113 package CellBIS::SQL::Abstract::Test::Table::_roles;
114 4 $CellBIS::SQL::Abstract::Test::Table::_roles::VERSION = '1.5';
115 4 ▶use Mojo::Base -base;
Subroutine BEGIN: called CC=1 SCAR=0.0
116  
117 # Table fields
118 4 has table_name => 'roles';
119 4 has id => 'id_roles';
120 4 has name => 'name';
121 4 has config => 'config';
122  
123 2 ▶sub sqlite {
Subroutine sqlite: called CC=1 SCAR=0.0
124 2 my $self = shift;
125  
126 return (
127 2 $self->table_name,
128 [$self->id, $self->name, $self->config],
129 {
130 $self->id =>
131 {type => {name => 'integer'}, is_primarykey => 1, is_autoincre => 1},
132 $self->name => {type => {name => 'varchar', size => 50}},
133 $self->config => {type => {name => 'text'}}
134 }
135 );
136 }
137  
138 0 ▶sub mariadb {
Subroutine mariadb: not called CC=1 SCAR=6.9
139 0 my $self = shift;
140  
141 return (
142 0 $self->table_name,
143 [$self->id, $self->name, $self->config],
144 {
145 $self->id =>
146 {type => {name => 'int'}, is_primarykey => 1, is_autoincre => 1},
147 $self->name => {type => {name => 'varchar', size => 50}},
148 $self->config => {type => {name => 'text'}}
149 }
150 );
151 }
152  
153 0 ▶sub pg {
Subroutine pg: not called CC=1 SCAR=6.9
154 0 my $self = shift;
155  
156 return (
157 0 $self->table_name,
158 [$self->id, $self->name, $self->config],
159 {
160 $self->id => {type => {name => 'serial'}, is_primarykey => 1},
161 $self->name => {type => {name => 'varchar', size => 50}},
162 $self->config => {type => {name => 'text'}}
163 }
164 );
165 }
166  
167 4 1;
168  
169 =encoding utf8
170  
171 =head1 NAME
172  
173 CellBIS::SQL::Abstract::Test::Table - A part of Unit Testing
174 with contain information of tables
175  
176 =head1 SYNOPSIS
177  
178 use CellBIS::SQL::Abstract::Test::Table;
179
180 my $tables = CellBIS::SQL::Abstract::Test::Table->new;
181 my $users = $tables->users;
182 my $roles = $tables->roles;
183
184 # get table field - users;
185 $users->id;
186 $users->id_roles;
187 $users->firstname;
188 $users->lastname;
189 $users->fullname;
190 $users->username;
191 $users->password;
192 $users->create;
193 $users->update;
194 $users->status;
195
196 # get table field - roles;
197 $roles->id;
198 $roles->name;
199 $roles->config;
200
201 # get table query for users
202 my $users_sqlite = $users->sqlite;
203 my $users_mariadb = $users->mariadb;
204 my $users_pg = $users->pg;
205
206 # get table query for roles
207 my $roles_sqlite = $roles->sqlite;
208 my $roles_mariadb = $roles->mariadb;
209 my $roles_pg = $roles->pg;
210  
211 =head1 DESCRIPTION
212  
213 This module is only for testing which contains 2 sample tables,
214 namely C<users> and C<roles>.
215  
216 =head1 ATTRIBUTES AND METHODS
217  
218 L<CellBIS::SQL::Abstract::Test::Table> implements two attributes,
219 namely C<users> and C<roles>.
220 Each attributes can call C<table field> attributes and method
221 for table query (C<sqlite, mariadb, pg>).
222  
223 =head1 AUTHOR
224  
225 Achmad Yusri Afandi, C<yusrideb@cpan.org>
226  
227 =head1 COPYRIGHT AND LICENSE
228  
229 Copyright (C) 2021 by Achmad Yusri Afandi
230  
231 This program is free software, you can redistribute it and/or modify
232 it under the terms of the Artistic License version 2.0.
233  
234 =cut
« blib/lib/CellBIS/SQL/Abstract/Test/Query.pm ↑ Summary