Skip to content

Instantly share code, notes, and snippets.

@rhanka
Last active June 16, 2021 23:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rhanka/d5a2eac390679c736246f114b3e1cd8f to your computer and use it in GitHub Desktop.
Save rhanka/d5a2eac390679c736246f114b3e1cd8f to your computer and use it in GitHub Desktop.
cass to json
for file in $(find . -iname '*xml');do echo $file; (cat $file | xq '. | { chamber: (.TEXTE_JURI_JUDI.META.META_SPEC.META_JURI_JUDI.FORMATION | sub(".*_(?<x>...).*"; "\(.x)") | ascii_downcase), decision_date: .TEXTE_JURI_JUDI.META.META_SPEC.META_JURI.DATE_DEC, ecli: (if (.TEXTE_JURI_JUDI.META.META_SPEC.META_JURI_JUDI.ECLI != null) then .TEXTE_JURI_JUDI.META.META_SPEC.META_JURI_JUDI.ECLI else .TEXTE_JURI_JUDI.META.META_COMMUN.ID end), jurisdiction: (.TEXTE_JURI_JUDI.META.META_SPEC.META_JURI.JURIDICTION | sub("Cour de cassation"; "cc")), number: (if (.TEXTE_JURI_JUDI.META.META_SPEC.META_JURI_JUDI.NUMEROS_AFFAIRES.NUMERO_AFFAIRE | type=="string") then .TEXTE_JURI_JUDI.META.META_SPEC.META_JURI_JUDI.NUMEROS_AFFAIRES.NUMERO_AFFAIRE else .TEXTE_JURI_JUDI.META.META_COMMUN.ID end), publication: ["b","c"], solution: (if (.TEXTE_JURI_JUDI.META.META_SPEC.META_JURI.SOLUTION != null) then (.TEXTE_JURI_JUDI.META.META_SPEC.META_JURI.SOLUTION | ascii_downcase) else "aucune" end), update_date: .TEXTE_JURI_JUDI.META.META_SPEC.META_JURI.DATE_DEC, summary: (if(.TEXTE_JURI_JUDI.TEXTE.SOMMAIRE.ANA."#text" != null) then (.TEXTE_JURI_JUDI.TEXTE.SOMMAIRE.ANA."#text") else (([.TEXTE_JURI_JUDI.TEXTE.BLOC_TEXTUEL | .. | select(. | length > 1000)] | join(" ") ) | .[0:200] ) end), text: ([.TEXTE_JURI_JUDI.TEXTE.BLOC_TEXTUEL | .. | select(. | length > 1000)] | join(" ") ), source: "jurinet", version: 0.7, themes: ["machin", "chose"], zones: {introduction:[{start:0,end:100}],expose:[{start:100,end:200}],moyens:[{start:200,end:300}],motivations:[{start:300,end:400}],dispositif:[{start:400,end:500}]}, sourceId: .TEXTE_JURI_JUDI.META.META_COMMUN.ID, id: .TEXTE_JURI_JUDI.META.META_COMMUN.ID }' > $file.json);done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment