Man pages sections > man3 > Catmandu::Fix::add_to_store

Catmandu::Fix::add_to_store - add matching values to a store as a side effect

Catmandu::Fix::add_to_store(3pm) User Contributed Perl Documentation Catmandu::Fix::add_to_store(3pm)

NAME

Catmandu::Fix::add_to_store - add matching values to a store as a side effect

SYNOPSIS

   # Add the current record to an SQLLite database. 
   add_to_store(., DBI, data_source: "dbi:SQLite:path/data.sqlite")
   # Add the journal field to a MongoDB database. 
   add_to_store(journal, MongoDB, database_name: catalog)
   
   # Add all author values to a MongoDB database. 
   add_to_store(authors.*, MongoDB, database_name: catalog, bag: authors)

DESCRIPTION

add_to_store(PATH,STORE[,store_param: store_val, ...][,bag: bag_name])

Store a record or parts of a record in a Catmandu::Store. The values at the PATH will be stored as-is in the database but should be hashes. If the value contains an '_id' field, then it will used as record identifier in the database. If not, then a new '_id' field will be generated and added to the database and original field (for later reference).
For instance this YAML input:
    ---
    _id: 001
    title: test
    name: foo
    ---
    _id: 002
    title: test2
    name: bar
with the fix:
    add_to_store(., DBI, data_source: "dbi:SQLite:path/data.sqlite")
will create a path/data.sqlite SQLite database with two records. Each records contains the _id from the input file and all the record fields.
For instance this YAML input:
    ---
    title: test
    name: foo
    ---
    title: test2
    name: bar
with the fix:
    add_to_store(., DBI, data_source: "dbi:SQLite:path/data.sqlite")
will create a path/data.sqlite SQLite database with two records. Each records contains the a generated _id and all the record fields. The current input stream will be updated to contain the generated _id.
Use Catmandu::Fix::lookup_in_store to lookup records in a Catmandu::Store based on an '_id' key.

SEE ALSO

Catmandu::Fix , Catmandu::Fix::lookup_in_store
2017-10-01 perl v5.26.0