The Bar

Setup

clone the project
create a .env file and paste below's template
set your DATABASE_URL according to your configuration
run these commands:

composer install && npm i

php bin/console doctrine:database:create
php bin/console doctrine:migrations:migrate
php bin/console doctrine:fixtures:load

start Symfony's server:

symfony server:start

start Webpack's server:

npm run dev-server

Team

Last name	First name
ROMANA	Julian
LIMONGI	Virgil
TOMBUYSES	Emilie
LEMIRE	Tristan
MONTHUBERT	Kento

Template

.env

# In all environments, the following files are loaded if they exist,
# the latter taking precedence over the former:
#
#  * .env                contains default values for the environment variables needed by the app
#  * .env.local          uncommitted file with local overrides
#  * .env.$APP_ENV       committed environment-specific defaults
#  * .env.$APP_ENV.local uncommitted environment-specific overrides
#
# Real environment variables win over .env files.
#
# DO NOT DEFINE PRODUCTION SECRETS IN THIS FILE NOR IN ANY OTHER COMMITTED FILES.
#
# Run "composer dump-env prod" to compile .env files for production use (requires symfony/flex >=1.2).
# https://symfony.com/doc/current/best_practices.html#use-environment-variables-for-infrastructure-configuration

###> symfony/framework-bundle ###
APP_ENV=dev
APP_SECRET=84bb3174e5f7b887d2e9b785cb8220b0
###< symfony/framework-bundle ###

###> doctrine/doctrine-bundle ###
# Format described at https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url
# IMPORTANT: You MUST configure your server version, either here or in config/packages/doctrine.yaml
#
# DATABASE_URL="sqlite:///%kernel.project_dir%/var/data.db"
# DATABASE_URL="mysql://USER:PASSWORD@127.0.0.1:PORT/DB_NAME?serverVersion=SERVER_VERSION"
# DATABASE_URL="postgresql://db_user:db_password@127.0.0.1:5432/db_name?serverVersion=13&charset=utf8"
###< doctrine/doctrine-bundle ###

Question 4

Code to write in the Category Repository.

public function findCatSpecial(int $id)
{
    return $this->createQueryBuilder('c')
        ->join('c.beers', 'b') // raisonner en terme de relation
        ->where('b.id = :id')
        ->setParameter('id', $id)
        ->andWhere('c.term = :term')
        ->setParameter('term', 'special')
        ->getQuery()
        ->getResult();
}

Explanation

This code will get all the categories of term "special" of a specific beer.

The query will first find all categories which id is in the matching results in beer_category table where the beer_id is the same as the $id passed in param. Those categories results will then be filtered to keep only those that have the term "special".

Utility

This code is useful if we are on the product page of a beer and we want to display all the special categories of the beer.

kentoje/symfony-bar-tp