Merge multiple JSON en 1 JSON avec un script shell

Bonjour à tous,

Je souhaite fusionner/merger des fichiers json (quelques 300 fichiers) en un seul pour pouvoir ensuite le gérer avec StudioR

Chaque fichier suit la même structure (1 ligne unique) :

Code:

---

{"start_time":1566725555000,"end_time":1566727091000,"created_at":1566725557000,"updated_at":1566732764000,"start_time_timezone_offset":7200000,"end_time_timezone_offset":7200000,"distance":4140,"duration":1535377,"elevation_gain":10,"elevation_loss":13,"average_speed":9.709,"calories":294,"longitude":2.0698986,"latitude":47.89151,"max_speed":13.897117,"pause_duration":0,"duration_per_km":370864,"temperature":28.0,"pulse_avg":0,"pulse_max":0,"avg_cadence":0,"max_cadence":0,"manual":false,"edited":false,"completed":true,"live_tracking_active":false,"live_tracking_enabled":true,"cheering_enabled":true,"indoor":false,"id":"9f024351-f3a7-4672-9bba-46f4a81731bb","weather_condition_id":"1","subjective_feeling_id":"2","sport_type_id":"1","user_equipment_ids":["5d6260469584a75f61f1dc99"]}

---

Je souhaite donc obtenir un fichier unique avec un script shell

Je connais très mal les commandes linux/shell et j'essaye en vain depuis ce matin à regardant le forum etc.

Bonjour,

à quoi doit ressembler le fichier final ?

Citation:

---

Envoyé par N_BaH

Bonjour,

à quoi doit ressembler le fichier final ?

---

Aucune idée de la structuration dudit fichier unique, c'est ça mon problème, j'avais pas prévu d'avoir des fichiers json en entrée à l'origine

Je pensais à cela :

Code:

---

1 2 3 4

{ "fichier1":[{"start_time":1566725555000,"end_time":1566727091000,"created_at":1566725557000}], "fichier2":[{"start_time":1566725555000,"end_time":1566727091000,"created_at":1566725557000}] }

---

Citation:

---

Aucune idée de la structuration dudit fichier unique

---

consulte la doc de StudioR pour savoir ce qu'il attend !
puis reviens nous dire.

J'ai justement parcouru la documentation et quelques forums

J'ai trouvé une commande json

Code:

---

1 2 3 4 5 6 7 8 9 10

#!/bin/bash   json={ for filepath in "/Home/Running/data_running/sessionsjson/*" do json="${json}$(cat $filepath)," done json="${json%?} ] }"   echo $json

---

mais je ne comprend pas son fonctionnement "man json" ne me donne rien d'exploitable et je ne suis pas sûr de comprendre la synthaxe des commandes en question

Citation:

---

J'ai justement parcouru la documentation et quelques forums

---

et ? ça valide le format que tu as indiqué ?

JSON est un format de fichier, ce n'est pas une commande.
ce script est en bash.

Bonjour :coucou:

Code:

---

awk '/./{l++;t[l]=FILENAME;c[l]=$0;} END{print "{"; for (i=1;i<=l;i++) print "\t\""t[i]"\":["c[i]"]"((i<l)?",":""); print "}";}' * > resultat.json

---

Pour le fun en built_in:

Code:

---

1 2 3 4 5 6 7 8

$ ls fx* fx1.json fx2.json fx3.json $ echo {$'\n'"$(for i in fx* ; do [ -z "$fl" ] || printf ",\n" ; printf "$i:[$(<$i)]" ; fl=1 ; done)"$'\n'} { fx1.json:[{"start_time":1566725555000,"end_time":1566727091000,"created_at":1566725557000,"updated_at":1566732764000,"start_time_timezone_offset":7200000,"end_time_timezone_offset":7200000,"distance":4140,"duration":1535377,"elevation_gain":10,"elevation_loss":13,"average_speed":9.709,"calories":294,"longitude":2.0698986,"latitude":47.89151,"max_speed":13.897117,"pause_duration":0,"duration_per_km":370864,"temperature":28.0,"pulse_avg":0,"pulse_max":0,"avg_cadence":0,"max_cadence":0,"manual":false,"edited":false,"completed":true,"live_tracking_active":false,"live_tracking_enabled":true,"cheering_enabled":true,"indoor":false,"id":"9f024351-f3a7-4672-9bba-46f4a81731bb","weather_condition_id":"1","subjective_feeling_id":"2","sport_type_id":"1","user_equipment_ids":["5d6260469584a75f61f1dc99"]}], fx2.json:[{"start_time":1566725555000,"end_time":1566727091000,"created_at":1566725557000,"updated_at":1566732764000,"start_time_timezone_offset":7200000,"end_time_timezone_offset":7200000,"distance":4140,"duration":1535377,"elevation_gain":10,"elevation_loss":13,"average_speed":9.709,"calories":294,"longitude":2.0698986,"latitude":47.89151,"max_speed":13.897117,"pause_duration":0,"duration_per_km":370864,"temperature":28.0,"pulse_avg":0,"pulse_max":0,"avg_cadence":0,"max_cadence":0,"manual":false,"edited":false,"completed":true,"live_tracking_active":false,"live_tracking_enabled":true,"cheering_enabled":true,"indoor":false,"id":"9f024351-f3a7-4672-9bba-46f4a81731bb","weather_condition_id":"1","subjective_feeling_id":"2","sport_type_id":"1","user_equipment_ids":["5d6260469584a75f61f1dc99"]}], fx3.json:[{"start_time":1566725555000,"end_time":1566727091000,"created_at":1566725557000,"updated_at":1566732764000,"start_time_timezone_offset":7200000,"end_time_timezone_offset":7200000,"distance":4140,"duration":1535377,"elevation_gain":10,"elevation_loss":13,"average_speed":9.709,"calories":294,"longitude":2.0698986,"latitude":47.89151,"max_speed":13.897117,"pause_duration":0,"duration_per_km":370864,"temperature":28.0,"pulse_avg":0,"pulse_max":0,"avg_cadence":0,"max_cadence":0,"manual":false,"edited":false,"completed":true,"live_tracking_active":false,"live_tracking_enabled":true,"cheering_enabled":true,"indoor":false,"id":"9f024351-f3a7-4672-9bba-46f4a81731bb","weather_condition_id":"1","subjective_feeling_id":"2","sport_type_id":"1","user_equipment_ids":["5d6260469584a75f61f1dc99"]}] }

---