Help wanted! Update in nested data

[MockingMagician]

Hello to everyone,

I need help, let's say we have a bin with this structure:

{
  loc' : {
    EU' : {'FR' : {'Paris', 'Lyon'}}, 
    US': { 'CA': { 'Miami'}}
}, 

Is it possible to update loc.EU and add for example ES: {'Madrid'}}

So we would finally get this bin structure:

{
  loc' : {
    EU' : {'FR' : {'Paris', 'Lyon'}, ES : {'Madrid'}}, 
    US' : {'CA' : {'Miami'}}
}, 

If it is possible to do this, can someone provide a complete example?

Thanks in advance

[juliannguyen4]

Hi @MockingMagician, you would use client.operate() to insert nested map key-value pairs. To do this, you would create an operation that puts a new map item, and you would use a list of contexts to specify where to insert this item in the bin.

Full example:

import aerospike
config = {"hosts": [("127.0.0.1", 3000)]}
client = aerospike.client(config)

key = ("test", "demo", 1)
binName = "binName"
binValue = {
    'loc': {
        'EU': {'FR': ['Paris', 'Lyon']}, 
        'US': {'CA': ['Miami']}
    }
}
binPair = {binName: binValue}
client.put(key, binPair)

# Perform operation
from aerospike_helpers import cdt_ctx
# Iterate through the bin document: loc -> EU
ctxs = [
    cdt_ctx.cdt_ctx_map_key("loc"),
    cdt_ctx.cdt_ctx_map_key("EU"),
]
# Insert ES: Madrid
import aerospike_helpers.operations.map_operations as map_ops
ops = [
    map_ops.map_put(binName, "ES", "Madrid", None, ctxs)
]
client.operate(key, ops)

# Verify results
_, _, bins = client.get(key)
import pprint
pprint.pprint(bins)

# Cleanup
client.remove(key)
client.close()

This is the output of this script (formatted for clarity):

{'binName': {
    'loc': {
        'EU': {
            'ES': 'Madrid',
            'FR': ['Paris', 'Lyon']
        },
        'US': {
            'CA': ['Miami']
        }
    }
}}