The jsontocsv from kata198

jsontocsv's People

Contributors

Stargazers

Watchers

jsontocsv's Issues

Not being able to parse "first level lists"

I am trying to parse a json that consists in a list of maps such as [{"a":"1}, {"a":3}] but I am not being able to define the parse string for it. A simple + demands a key, which means that this list would need to be contained in a map. Am I missing something?

Thanks

List ignored

In a complex example one list are ignored

Json to parse (example.json) :

{
   "example":[
      {
         "message":{
            "data":"DATA_1",
            "pages":{
               "pages":[
                  {
                     "lines":{
                        "lines":[
                           {
                              "content":"CONTENT_1_1"
                           },
                           {
                              "content":"CONTENT_1_2"
                           },
                           {
                              "content":"CONTENT_1_3"
                           }
                        ]
                     },
                     "duration":"DURATION_1"
                  }
               ]
            },
            "pictures":"PICTURES_1"
         }
      },
      {
         "message":{
            "data":"DATA_2",
            "pages":{
               "pages":[
                  {
                     "lines":{
                        "lines":[
                           {
                              "content":"CONTENT_2_1"
                           },
                           {
                              "content":"CONTENT_2_2"
                           },
                           {
                              "content":"CONTENT_2_3"
                           }
                        ]
                     },
                     "duration":"DURATION_2"
                  }
               ]
            },
            "pictures":"PICTURES_2"
         }
      }
   ]
}

Parse string :

PARSE_STR = '''
        +"example"[
            ."message"[
                "data",
                "pictures"
                ."pages"[
                    +"pages"[
                        "duration"
                        ."lines"[
                            +"lines"[
                                "content"
                            ]
                        ]
                    ]
                ]
            ]
        ]
'''

Python Code

with open('example.json', 'rt') as f:
  contents = f.read()
  parser = JsonToCsv(PARSE_STR, nullValue=NULL_VALUE, debug=IS_DEBUG)
  csvDataStr = parser.convertToCsv(contents)

output (second content list are ignored) :

DATA_1,PICTURES_1,DURATION_1,CONTENT_1_1
DATA_1,PICTURES_1,DURATION_1,CONTENT_1_2
DATA_1,PICTURES_1,DURATION_1,CONTENT_1_3
DATA_2,PICTURES_2,DURATION_2

expected output :

DATA_1,PICTURES_1,DURATION_1,CONTENT_1_1
DATA_1,PICTURES_1,DURATION_1,CONTENT_1_2
DATA_1,PICTURES_1,DURATION_1,CONTENT_1_3
DATA_2,PICTURES_2,DURATION_2,CONTENT_2_1
DATA_2,PICTURES_2,DURATION_2,CONTENT_2_2
DATA_2,PICTURES_2,DURATION_2,CONTENT_2_3

Recommend Projects