Re: Parsing JSON data into a data structure without knowing variable's names

On Sun, Aug 13, 2017 at 2:37 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Sun, Aug 13, 2017 at 3:22 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

As I said earlier I think code gen is the way to go - but the JSON structure can be dynamically determined just as XML-SAX allows you to do with XML.

Yes, that makes sense, but once you do the program "knows" the
structure and is built appropriately around thus said structure.

But which program are you talking about?

Maybe you are agreeing with all this, but I'm clarifying that one
program does NOT have foreknowledge of the structure, while the other
DOES. (Because it was imparted by the first program.)

Yep.. the second one that is generated. Sorry I wasn't clear.

I'm not agreeing that the structure doesn't need to be known to parse
the JSON. In the end, with a generated program or hand-written, the
structure IS known. No getting around that.

Once that's out of the way, all you have left is fine tuning those
wonderful JSON variables that are numeric, but represented as
character in your DB.. or vice versa.

Or JSON array elements that need to be mapped to a single level file
record with fields like TEXT1, TEXT2, TEXT4 (etc) instead of a more
normalized DB. No, that never happens in RPG shops. :)

Then there are date and time formats mapping to Character,numeric or
hopefully Date, Time or Timestamp data types.

I don't think a program generator could forsee those issues. But
there will almost always be some tweaking needed.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #5: Easy setup! No confusing or obscure setup
instructions, directory entries, SMTP users, aliases or host tables.
All you need is TCPIP, a connection to the internet and you're done!