Class GenericJSONParser

x.__init__(...) initializes x; see help(type(x)) for signature

Parameters:

• jsonToRelationConverter (JSONToRelation) - JSONToRelation instance

Overrides: object.__init__

Given a JSON string that is one entire JSON object, parse the string into nested dicts. Derive relational column names from the (possibly nested) labels. Cooperate with the parent JSONToRelations instance to build a schema of typed SQL columns. Fill the passed-in row with values from the JSON string. The following mappings from Python values are used:

   ('null', None)
       ('boolean', <true orfFalse>)
       ('number', <int or Decimal>)
       ('string', <unicode>)
       ('map_key', <str>)
       ('start_map', None)
       ('end_map', None)
       ('start_array', None)
       ('end_array', None)
       
       @param jsonStr: string of a single, self contained JSON object
       @type jsonStr: String
       @param row: partially filled array of values.
       @type row: List<<any>>

Given a column name, a value and a partially filled row, add the column to the row, or set the value in an already existing row. Uses the JSONToRelation instance passed to __init__() to obtain current schema.

Parameters:

• theRow (List<<any>>) - list of values in their proper column positions
• colName (String) - name of column into which value is to be inserted.
• value (<any>, as per ColDataType) - the field value

Given a label, like employee.item.name, remove the last occurrence of 'item'

Parameters:

• label (String) - string from which last 'item' occurrence is to be removed

REMOVE_ITEM_FROM_STRING_PATTERN

Value:

re.compile(r'(item)\.([^\.]*$)')