---
name: "Catmandu::Fix::add_to_store"
section: "3pm"
platform: "linux"
package: "libcatmandu-perl"
version: "1.2024-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Catmandu::Fix::add_to_store"
---

# Catmandu::Fix::add\_to\_store(3pm)

add matching values to a store as a side effect

## NAME

Catmandu::Fix::add\_to\_store - add matching values to a store as a side effect

## SYNOPSIS

```
   # Add the current record to an SQLite 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)
   # Or, a much faster option: use a named store in a catmandu.yml file
   #
   # store:
   #  mydbi:
   #    package: DBI
   #    options:
   #      data_source: "dbi:SQLite:path/data.sqlite"
   #  mymongo:
   #    package: MongoDB
   #    options:
   #      database_name: catalog
   add_to_store(., mydbi)
   add_to_store(journal, mymongo)
   add_to_store(authors.*, mymongo, 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.

## DATABASE CONNECTIONS

For every call to a `"add_to_store"` a new database connection is created. It is much more effient to used named stores in a `"catmandu.yml"` file. This file needs to contain all the connection parameters to the database. E.g.

```
    store:
       mystore:
         package: MongoDB
         options:
            database_name: mydata
```

The  `"catmandu.yml"` file should be available in the same directory as where the `"catmandu"` command is executed. Or, this directory can be set with the `"-L"` option:

```
    $ catmandu -L /tmp/path convert ...
```

## SEE ALSO

Catmandu::Fix , Catmandu::Fix::lookup\_in\_store