TeamBuilder

TeamBuilder is a PHP application for the module PRW-1.

Requirements

Tools	Version
Composer	2.1.6
Npm	7.20.3
Sass	1.39.0

Installation

git clone https://github.com/yannickcpnv/teambuilder.git
composer install

Database

In the folder sql, you will find some scripts, run create_teambuilder_and_inserts.sql to create the database teambuilder and insert data.

Use an existing user or create a new one

CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'user_password';
GRANT ALL ON `dbname`.* TO 'user_name'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Usage

1. In the config folger youcan find a .example.env file, rename it to .env.
2. Use your personal variables. The first 4 variables are not used directly in the project, there are here to be used in the variable DB_DSN.

   DB_SQL_DRIVER   = mysql
   DB_HOSTNAME     = localhost
   DB_PORT         = 3306
   DB_CHARSET      = utf8
   DB_NAME         = dbname
   DB_USER_NAME    = username
   DB_USER_PWD     = password
   DB_DSN          = ${DB_SQL_DRIVER}:host=${DB_HOSTNAME};dbname=${DB_NAME};port=${DB_PORT};charset=${DB_CHARSET}
   
   WEB_USER_ID     = 0

3. Enable php extensions in your php.ini :
   1. ext-pdo => Database access
   2. ext-intl => Internationalization, sort and compare utf8 strings, etc.
4. If you work on the file override_pico.scss, run the command composer sass:pico:watch

Test

composer test