Skip to content

Latest commit

 

History

History
31 lines (23 loc) · 1.54 KB

README.md

File metadata and controls

31 lines (23 loc) · 1.54 KB

To build project: npm run postinstall To start server: npm run serve

To import Product Catalog data from spreadsheet:

CURRENT DESIGN IN POSTGRES: prepare UNSPSC spreadsheet (Data tab has a 'Remove Duplicates' feature that helps)

To populate Commodity table: run ruby ./lib/commodity_import.rb locally

To push local db to Heroku: heroku pg:push postgres://localhost/tonicapi_development postgresql-corrugated-38351

OLDER DESGN: Dev DB: psql=# COPY unspsc_nodes(id,cat_name,created_at,updated_at) FROM '/Users/byofuel/code/misc-tonicmart/UNSPSC/UNSPSC-EXPORT-8digit.csv' DELIMITER ',' CSV; psql=# COPY commodities(commodity_name,id,created_at,updated_at) FROM '/Users/byofuel/code/misc-tonicmart/UNSPSC/UNSPSC-COMM-EXPORT.csv' DELIMITER ',' CSV;

Prod DB Heroku: heroku pg:credentials provides string for connecting to the heroku db outside of heroku's tools (host name is not guaranteed to remain constant)

plug credentials into this BASH command: (based on https://gist.github.com/jboesch/5605747) PGPASSWORD=pw psql -h ec2-54-243-253-17.compute-1.amazonaws.com -U xbncgknuihxenu d7f1r434o2or6o -c "\copy unspsc_nodes(id,cat_name,created_at,updated_at) FROM '/Users/byofuel/code/misc-tonicmart/UNSPSC/UNSPSC-EXPORT.csv' DELIMITER ',' CSV"

ORIGINAL DESIGN: last two columns should be product description and price columns before the last two represent the tree branches product is categorized under copy the spreadsheet data into https://shancarter.github.io/mr-data-converter/, with output as JSON- Row Arrays paste the results into index.es6, preloadedState.rawCatalog =