NAME

TaskPipe::Task_Record_NameValuePairs - record a result set as a series of name/value pairs

DESCRIPTION

This task records a list of name value pairs onto a database table. You can use it in your plan by referring to it in the following format:

    task:
        _name: Record_NameValuePairs
        table: whois_kv
        key: 
            table_id: $this{id}
        columns:
            name: param
            value: value
        pairs: $this[1]{*}

In this example (which is shown as part of a tree mode plan, key indicates the foreign key value to go on the table. ie this value will be included on all records in the set passed to the task.

columns tells the task the name of the key/value columns to insert parameter names/parameter values to. This defaults to name and value if not provided.

pairs needs to point to the hashref of key/values you want to go onto the database table. This defaults to the set of inputs to the current task if not provided.

AUTHOR

Tom Gracey <tomgracey@gmail.com>

COPYRIGHT AND LICENSE

Copyright (c) Tom Gracey 2018

TaskPipe is free software, licensed under

    The GNU Public License Version 3