CellBIS::SQL::Abstract::Test::Table - A part of Unit Testing with contain information of tables
use CellBIS::SQL::Abstract::Test::Table; my $tables = CellBIS::SQL::Abstract::Test::Table->new; my $users = $tables->users; my $roles = $tables->roles; # get table field - users; $users->id; $users->id_roles; $users->firstname; $users->lastname; $users->fullname; $users->username; $users->password; $users->create; $users->update; $users->status; # get table field - roles; $roles->id; $roles->name; $roles->config; # get table query for users my $users_sqlite = $users->sqlite; my $users_mariadb = $users->mariadb; my $users_pg = $users->pg; # get table query for roles my $roles_sqlite = $roles->sqlite; my $roles_mariadb = $roles->mariadb; my $roles_pg = $roles->pg;
This module is only for testing which contains 2 sample tables, namely users and roles.
users
roles
CellBIS::SQL::Abstract::Test::Table implements two attributes, namely users and roles. Each attributes can call table field attributes and method for table query (sqlite, mariadb, pg).
table field
sqlite, mariadb, pg
Achmad Yusri Afandi, yusrideb@cpan.org
yusrideb@cpan.org
Copyright (C) 2021 by Achmad Yusri Afandi
This program is free software, you can redistribute it and/or modify it under the terms of the Artistic License version 2.0.
To install CellBIS::SQL::Abstract, copy and paste the appropriate command in to your terminal.
cpanm
cpanm CellBIS::SQL::Abstract
CPAN shell
perl -MCPAN -e shell install CellBIS::SQL::Abstract
For more information on module installation, please visit the detailed CPAN module installation guide.