Why this project ?

See issue MYISSUE for more details

Install

Docker

$ docker-compose up -d

to ease the use of containers you can run

$ source ./bin/functions.sh

Set up database

Execute the following scripts:

• ./docker/postgres/init.sql
• ./docker/postgres/fixtures.sql

If in need to reset use the script: ./docker/postgres/reset.sql

Access to the test script:

Add 127.0.0.1 local.pomm.issue to your /etc/hosts then access to http://local.pomm.issue/

What is expected ?

• I expect an array of Country
• For each Country object I expect a province field of type Province
• For each Province object I expect a city field of type City

Result

⚠️ I do not see any city field.

Generated SQL

The generated SQL looks like this:

SELECT
    country."country_id" AS "country_id",
    country."name"       AS "name",
    (
        SELECT
            ARRAY_AGG(province)
            FROM
                (
                    SELECT
                        province."province_id" AS "province_id",
                        province."name"        AS "name",
                        province."country_id"  AS "country_id",
                        ARRAY_AGG(city)        AS "city"
                        FROM
                            pomm.province province
                            INNER JOIN pomm.city city
                                       USING (province_id)
                        GROUP BY province_id
                ) AS province
    )                    AS "province"
    FROM
        pomm.country country
        LEFT JOIN pomm.province province
                  USING (country_id)
    GROUP BY
        country_id;

Mettre à jour les entitées

$ pomm pomm:generate:schema-all pomm_issue pomm --psr4 -d ./src/Persistence/Model/ -a "App\\\\Persistence\\\\Model"