Simplified setup by moving sql into its own script

adamfortuna · adamfortuna · commit 67e8460f4e1f · 2015-03-16T14:18:28.000-04:00
diff --git a/README.md b/README.md
@@ -4,18 +4,25 @@ This is the repo for the JavaScript.com website.
 
 ## Installing NVM
 
-- Install NVM (`$ brew install nvm` and follow instructions)
-- `$ nvm install iojs-v1.2.0`
-- `$ nvm use iojs-v1.2.0`
+Install NVM (`$ brew install nvm` and follow instructions)
+
+```bash
+nvm install iojs-v1.2.0
+nvm use iojs-v1.2.0
+npm install -g gulp
+npm install
+```
+
+This app authenticates with GitHub, so you'll need to create a GitHub Application and set ENVs for `GH_CLIENT_ID` and `GH_CLIENT_SECRET`.
 
 ## Running
 
-* Install dependencies with `$ npm install`.
-* Create the local PostgreSQL database with `$ createdb javascriptcom`.
-* Load schema with `$ psql javascriptcom < db/schema.sql`
-* This app authenticates with GitHub, so you'll need to create a GitHub Application and set ENVs for `GH_CLIENT_ID` and `GH_CLIENT_SECRET`.
-* Run the application with `$ npm start`.
-* Compile and watch Sass with `$ gulp`.
+Run the application with `$ npm start`. You can also set the environment variables at start time. Here's an example:
+
+```bash
+$ GH_CLIENT_ID=myid GH_CLIENT_SECRET=mysecret npm start
+```
+Compile and watch Sass with `$ gulp`.
 
 For debugging all the things, run `DEBUG=* npm start`.
 
diff --git a/db/setup.sh b/db/setup.sh
@@ -0,0 +1,11 @@
+# How do we only run this if the javascriptcom database doesn't exist?
+
+if psql javascriptcom -c '\q' 2>&1
+then
+  # The database exists
+  echo "javascriptcom database already loaded"
+else
+  createdb javascriptcom
+  psql javascriptcom < db/schema.sql
+fi
+
diff --git a/package.json b/package.json
@@ -6,7 +6,8 @@
     "iojs": "1.2.0"
   },
   "scripts": {
-    "start": "node --harmony_object_literals ./bin/www"
+    "start": "node --harmony_object_literals ./bin/www",
+    "postinstall": "./db/setup.sh"
   },
   "dependencies": {
     "body-parser": "~1.10.2",
