Skip to content

Instantly share code, notes, and snippets.

@hugeuser
hugeuser / PUT login
Created February 28, 2014 14:48
PUT login
exports.loginprocess = function (req, res) {
connection.query(
'SELECT * FROM mocha_test_table WHERE user_name="'+req.body.user_name+
'" AND email="'+req.body.email+'";',function(err,results){
if(results.length===0) {
res.render('../views/login');
} else {
res.render('../views/form', {
user_name:req.body.user_name,
email:req.body.email,
@hugeuser
hugeuser / GET login
Created February 28, 2014 14:47
GET login
exports.login = function (req, res) {
res.render('../views/login');
};
@hugeuser
hugeuser / GET home
Created February 28, 2014 14:47
GET home
exports.home = function (req, res) {
res.render('../views/home');
};
@hugeuser
hugeuser / forms controller
Created February 28, 2014 14:45
forms controller
var connection = require('../database');
connection.query('CREATE TABLE IF NOT EXISTS mocha_test_table(user_name varchar(10),'+
'email varchar(10),fname varchar(10),lname varchar(10));', function(err) {if(err){console.log(err);}});
@hugeuser
hugeuser / route requests
Created February 28, 2014 14:43
route requests
module.exports = function(app, serverport) {
app.set('view engine', 'hbs');
var form = require('./controllers/form');
app.get('/', form.home);
app.get('/login’, form.login);
app.post('/login', form.loginprocess);
app.post('/form', form.formprocess);
app.listen(serverport);
@hugeuser
hugeuser / stylesheet main.css
Created February 28, 2014 14:42
stylesheet main.css
.text {
font: normal 15px Arial, Helvetica, sans-serif;
text-align: center;
padding: 10px;
}
.large-text {
font:normal 20px Arial, Helvetica, sans-serif;
text-align: center;
}
@hugeuser
hugeuser / Console message
Created February 28, 2014 14:41
Console message
var express = require('express');
var mysql = require('mysql');
var app = express();
app.use(express.bodyParser()); // need this to see the body in req object
var serverport = 3000;
require('./routes')(app, serverport);
app.use('/styles', express.static(__dirname + '/styles'));
console.log('The node server is now running on port ' + serverport);
module.exports = app;
@hugeuser
hugeuser / Write the tests to match these specs
Created February 28, 2014 14:40
Write the tests to match these specs
var async = require('async'),
request = require('supertest'),
should = require('should'),
app = require('../server'),
connection = require('../database');
describe('Req 1: Landing page functionality', function(){
before(function (done) {
this.timeout(5000);
async.series([
@hugeuser
hugeuser / Set up a base project
Created February 28, 2014 14:38
Set up a base project
{
"name": "name-of-the-project-but-in-one-word",
"description": "a short description about the project”,
"version": "what version number of the project this is, usually 0.0.1",
"dependencies": {
"mocha": "1.14.0",
"supertest": "0.8.0",
"should": "2.0.2",
"async": "0.2.9",
"mysql": "2.0.0-alpha9"
@hugeuser
hugeuser / new project
Created February 27, 2014 22:05
new project
" Set indentation to 2 spaces, convert tabs to spaces.
set expandtab tabstop=2 shiftwidth=2 softtabstop=2