Discussion :

[mdaurel]

Bonjour,

Afin de pouvoir récupérer des données ayant un nombre de colonne inconnu, je souhaiterais récupérer, avec ma Repository Symfony, le résultat d'une requête SQL qui est déjà formaté en JSON.

Résultat de ma requête SQL

{"correction_action":"TO_DEFINE","order_distribution":"01160621:1","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"43","champs06":"01160621B"}
{"correction_action":"TO_DEFINE","order_distribution":"02160621:2","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"9","champs06":"02160621B"}
{"correction_action":"TO_DEFINE","order_distribution":"44684594:1","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"10","champs06":"44684594C"}
{"correction_action":"TO_DEFINE","order_distribution":"44684594:2","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"1100","champs06":"44684594C"}
{"correction_action":"TO_DEFINE","order_distribution":"44684626:1","items":"5567359","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"50","champs06":"44684626C"}

Lorsque j'effectue la récupération de cette requête depuis mon repository, le résultat est transformé en array

["{"correction_action":"TO_DEFINE","order_distribution":"01160621:1","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"43","champs06":"01160621B"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"02160621:2","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"9","champs06":"02160621B"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"44684594:1","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"10","champs06":"44684594C"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"44684594:2","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"1100","champs06":"44684594C"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"44684626:1","items":"5567359","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"50","champs06":"44684626C"}"]

REPOSITORY

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
 
    public function rep_gettable_lasteventsdetails_json_data(
        string $var_id ,int $var_id_app,string $var_control_description,string $var_control_errors
    )
    {
        $session_user_ldap = $this->session->get('user_ldap');
        $conn = $this->em->getConnection();
        $sql = "
                SELECT  *
                FROM    f_gettable_lasteventsdetails_json_data(:var_id,:var_id_app,:var_user,:var_control_description,:var_control_errors)
                WHERE	1=1
                limit 5
                ";
        $stmt  = $conn->prepare($sql);
        $stmt ->executeQuery(['var_id' => $var_id,'var_id_app' => $var_id_app,'var_user' => $session_user_ldap,'var_control_description' => $var_control_description,'var_control_errors' => $var_control_errors]);
        $result = $stmt->fetchFirstColumn();
        return $result;

Comment puis je faire pour ne pas transformer le format du résultat de ma requête, et donc conserver le format JSON généré par la requête.

Merci

[-Nikopol-]

tu peux utiliser la methode getOneOrNullResult () sur $result
ou tout simplement faire un return $result[0]

[mdaurel]

tu peux utiliser la methode getOneOrNullResult () sur $result
ou tout simplement faire un return $result[0]

Bonjour,
Cela ne réponds pas à mon besoin qui est de récupérer la totalité des lignes de la requête, mais sans modifier son format.
En effet, le résultat de ma requête SQL est au format JSON.
Lorsque je récupère ce résultat via symfony, il transforme se résultat en array, chose que je ne veux pas.

[-Nikopol-]

ton json est simplement mis dans un tableau, si tu ne demande qu'un resultat il ne sera pas dans un tableau
et si je regarde la structure de ton return le result[0] te renverra ton json

[mdaurel]

ton json est simplement mis dans un tableau, si tu ne demande qu'un resultat il ne sera pas dans un tableau
et si je regarde la structure de ton return le result[0] te renverra ton json

Merci, je n'avais pas compris sur le coup, mais je visualise ta suggestion, cependant avec le $result[0], cela n'affiche que la première ligne du résultat de la requête.

==> return $result;
["{"correction_action":"TO_DEFINE","order_distribution":"01160621:1","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"43","champs06":"01160621B"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"02160621:2","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"9","champs06":"02160621B"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"44684594:1","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"10","champs06":"44684594C"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"44684594:2","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"1100","champs06":"44684594C"}"
,"{"correction_action":"TO_DEFINE","order_distribution":"44684626:1","items":"5567359","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"50","champs06":"44684626C"}"]

==> return $result[0];
"{"correction_action":"TO_DEFINE","order_distribution":"01160621:1","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"43","champs06":"01160621B"}"

[Pytet]

Bonjour,

Quel est le résultat json attendu au final ?

Puisque les données sont déjà enregistrées au format json en bdd, la première idée qui me vient en PHP est d'utiliser json_decode sur chaque élément du tableau :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
<?php
 
$jsonResults = [
    '{"correction_action":"TO_DEFINE","order_distribution":"01160621:1","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"43","champs06":"01160621B"}',
    '{"correction_action":"TO_DEFINE","order_distribution":"02160621:2","items":"5611838","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"9","champs06":"02160621B"}',
    '{"correction_action":"TO_DEFINE","order_distribution":"44684594:1","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"10","champs06":"44684594C"}',
    '{"correction_action":"TO_DEFINE","order_distribution":"44684594:2","items":"1047619","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"1100","champs06":"44684594C"}',
    '{"correction_action":"TO_DEFINE","order_distribution":"44684626:1","items":"5567359","champs01":null,"champs02":null,"champs03":null,"champs04":"110","champs05":"50","champs06":"44684626C"}'
];
 
$decodedResults = array_map('json_decode', $jsonResults);
 
echo json_encode($decodedResults, JSON_PRETTY_PRINT);

Avec Symfony, peut-être voir si le service Serializer ne serait pas plus adapté :
https://symfony.com/doc/current/cont...-json-response