From 5a4e3ff9bf1db2db4fc5ae8d3bd7dcefc8c58e25 Mon Sep 17 00:00:00 2001
From: Adam Soltys <adam.soltys@pwgsc-tpsgc.gc.ca>
Date: Wed, 7 Nov 2012 11:50:43 -0800
Subject: Store and use commission rate, move DB connection info into separate
 file

---
 app.js | 22 ++++++++++++++++++++--
 1 file changed, 20 insertions(+), 2 deletions(-)

(limited to 'app.js')

diff --git a/app.js b/app.js
index 10219d1c..dd932ce1 100644
--- a/app.js
+++ b/app.js
@@ -2,6 +2,7 @@ var express = require('express')
   , http = require('http')
   , path = require('path')
   , engines = require('consolidate')
+  , config = require('./config')
   , app = express();
 
 app.engine('html', engines.hogan);
@@ -17,10 +18,27 @@ app.get('/report', function(req, res) {
   res.render('report');
 });
 
+app.get('/calculator', function(req, res) {
+  res.render('calculator');
+});
+
+app.get('/client/:login', function(req, res) {
+  var connection = require('mysql').createConnection(config.database);
+
+  connection.connect();
+  connection.query("SELECT name, address, commission, logo FROM users WHERE login = ?", 
+    [req.params.login], function(err, rows) {
+      res.write(JSON.stringify(rows));
+      connection.end();
+      res.end();
+    }
+  );
+});
+
 app.get('/ticker', function(req, res) {
   var options = {
     host: 'bitcoincharts.com', 
-    path: '/t/depthcalc.json?symbol=virtexCAD&type=bid&amount=1001&currency=true'
+    path: '/t/depthcalc.json?symbol=virtexCAD&type=bid&amount=1000&currency=true'
   }
 
   require('http').get(options, function(r) {
@@ -32,7 +50,7 @@ app.get('/ticker', function(req, res) {
 });
 
 app.get('/:client', function(req, res) {
-  res.render('calculator', { title: req.param('client') });
+  res.render('calculator', { client: req.params.client });
 });
 
 app.listen(3000);
-- 
cgit v1.2.3