I have to create a nested multi level json depending on the resultset that I get from MYSQL. I created a json object initially. Now I want to add child nodes to the already child nodes in the object.

d = collections.OrderedDict()                                                           
jsonobj = {"test": dict(updated_at="today", ID="ID", ads=[])}       

for rows1 in rs:                                                                        
    jsonobj['list']["ads"].append(dict(unit = "1",                           
                                        type ="ad_type",                         
                                        id ="123",                         
                                        updated_at="today",                
                                        x_id="111",                          
                                        x_name="test"))                      


cur.execute("SELECT * from f_test")                                      
rs1 = cur.fetchall()                                                                
for rows2 in rs1:                                                                   
   propertiesObj = []                                                               
   d["name"]="propName"                                                             
   d["type"]="TypeName"                                                             
   d["value"]="Value1"                                                              
   propertiesObj.append(d)                                                          

   jsonobj['play_list']["ads"].append()

Here in the above line I want to add another child node to [play_list].[ads] which is a array list again.

the output should look like the following [list].[ads].[preferences].