sql2couch beer data import scripts

README

This code was used to import the openbeerdatabase.com data into .json docs onto the filesystem.

This fork of sql2couchdb was used:
https://github.com/BigBlueHat/sql2couchdb/tree/bulk_insert_batches

Plus a few .json sql2couchdb mappings in this repo.

beer.json

{
  "query": "SELECT beers.*, CONCAT('beer_', REPLACE(beers.name, ' ', '_')) AS beer_name, breweries.name as brewery_name, breweries.city as brewery_city, breweries.state as brewery_state, breweries.country as brewery_country, breweries.code as brewery_code, cat_name, style_name FROM `beers` LEFT JOIN categories ON beers.cat_id = categories.id LEFT JOIN styles ON beers.style_id = styles.id LEFT JOIN breweries ON beers.brewery_id = breweries.id",
  "doc": {
    "_id": "beer_name",
    "brewery": "brewery_name",
    "name": "name",
    "abv": "abv",
    "ibu": "ibu",
    "srm": "srm",
    "upc": "upc",
    "description": "descript",
    "category": "cat_name",
    "style": "style_name",
    "updated": "last_mod"
  }
}

breweries.json

{
  "query": "SELECT *, CONCAT('brewery_', REPLACE(breweries.name, ' ', '_')) as brewery_name FROM breweries LEFT JOIN breweries_geocode ON breweries_geocode.brewery_id = breweries.id",
  "doc": {
    "_id": "brewery_name",
    "name": "name",
    "address": ["address1", "address2"],
    "city": "city",
    "state": "state",
    "code": "code",
    "country": "country",
    "phone": "phone",
    "website": "website",
    "description": "descript",
    "geo": {
      "loc": ["longitude","latitude"],
      "accuracy": "accuracy"
    },
    "updated": "last_mod"
  }
}