Catmandu::Fix::lookup_in_store − change the value of a HASH key or ARRAY index by looking up its value in a store
# Lookup in an SQLLite database lookup_in_store(foo.bar, DBI, data_source: "dbi:SQLite:path/data.sqlite") # Lookup in a MongoDB database lookup_in_store(foo.bar, MongoDB, database_name: lookups, bag: mydata) # Lookup in a MongoDB database, using the default bag and a default value when nothing found lookup_in_store(foo.bar, MongoDB, database_name: lookups, default: 'default value') # Lookup in a MongoDB database, using the default bag and delete the foo.bar field when nothing found lookup_in_store(foo.bar, MongoDB, database_name: lookups, delete: 1)
lookup_in_store( PATH ,STORE[,store_param: store_val, ...][,bag: bag_name][,delete:1][,default:value])
Use the lookup_in_store fix to match a field in a record to the "_id" field in a Catmandu::Store of choice. For instance, if a Catmandu::Store contains these records:
−−− _id: water fr: l'eau de: wasser en: water nl: water −−− _id: tree fr: arbre de: baum en: tree nl: boom
And you data contains these fields:
−−− _id: 001 tag: tree −−− _id: 002 tag: water
Then, the fix below will lookup a tag in the Catmandu::Store and replace it with the database value:
lookup_in_store(tag, DBI, data_source: "dbi:SQLite:path/data.sqlite")
The resulting data will contain:
−−− _id: 001 tag: _id: tree fr: arbre de: baum en: tree nl: boom −−− _id: 002 tag: _id: water fr: l'eau de: wasser en: water nl: water
Catmandu::Fix, Catmandu::Store , Catmandu::Fix::add_to_store