Convert a yaml file to SQL INSERT statements.
This is handy if you have a yaml file with table names as keys, where each table's value is a list of objects, where those objects are rows to be inserted into the corresponding table (schema specified elsewhere).
yaml2sql < my_data.yaml | psql my_database
my_data.yaml
, e.g.:
---
templates:
- name: simple_header
html: <div><h1>Heading: {{html}}<h1></div>
- name: simple_paragraph
html: <p>{{html}}<p>
annotators:
- name: Chris Brown
- name: Gold Standard
- name: Guest
npm -g install yaml2sql
Copyright 2014-2015 Christopher Brown. MIT Licensed.