Convert into json

Question

FAILED SQL: INSERT INTO \"brand\" (\"brand_id\", \"name\", \"notification_email\", \"notification_phone\", \"created_at\", \"updated_at\") VALUES (%(0)s, %(1)s, %(2)s, %(3)s, %(4)s, %(5)s)\nPymongo error: {\'index\': 0, \'code\': 11000, \'errmsg\': \'E11000 duplicate key error collection: f2fretaildev.brand index: name_1 dup key: { : \"shyamalas\" }\'}\nVersion: 1.2.26"

This is the error on duplicate key while adding data with djongo (django mongodb orm)

Is there a way get the pymongo error inside it as a json? I tried json.dumps and json.loads which did not work

It doesn't look like your error is with JSON rather the repeat data inside your JSON. The `duplicate key error` is important here. — Skam, May 14 '18 at 15:12
Yes I want to parse the key which is duplicated and send it as response. Is there a way to get? — Shyamala Gopalakrishnan, May 14 '18 at 15:13

SteveJ · Answer 1 · 2018-05-14T16:07:45.680

The trouble is that the error messages isn't properly formed JSON. I had to do some conditioning; The below code is just to give you an approach. It is pretty fragile in that if the error message changes, it may fail - you will have to deal with edge cases.

import json


error_msg = """
    FAILED SQL: INSERT INTO \"brand\" (\"brand_id\", \"name\", \"notification_email\", \"notification_phone\", \"created_at\",
     \"updated_at\") VALUES (%(0)s, %(1)s, %(2)s, %(3)s, %(4)s, %(5)s)\nPymongo error: {\'index\': 0, \'code\': 11000, 
     \'errmsg\': \'E11000 duplicate key error collection: f2fretaildev.brand index: name_1 dup key: 
     { : \"shyamalas\" }\'}\nVersion: 1.2.26"
"""

key = "Unknown"
try:
    mongo_msg = error_msg.split('Pymongo error:')[1].split('Version:')[0].replace('\n','').replace('"','##')\
        .replace("'", '"').replace("{ :", " ").replace("## }", "##").replace('##', '')
    as_dict = json.loads(mongo_msg)
    error_msg = as_dict['errmsg']
    value = error_msg.split('key:')[1].strip()
    print(error_msg)
    print(value)
except:
    # Log it, print it, try something different
    pass

Convert into json

1 Answers1