JSFiddle - React, Tailwind, and code Playground
by rasikaceg
JavaScript
/**
* Module dependencies.
*/
var application_root = __dirname;
var express = require('express');
var url = require('url');
filesys = require("fs");
var mysql = require('mysql');
var routes = require('./routes');
var user = require('./routes/user');
var http = require('http');
var path = require('path');
var app = express();
// Database
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'siso@123',
database: "test"
});
// Config
app.configure(function () {
app.use(express.bodyParser());
app.use(express.methodOverride());
app.use(app.router);
app.use(express.static(__dirname + '/public'));
app.use(express.errorHandler({
dumpExceptions: true,
showStack: true
}));
});
// all environments
app.set('port', process.env.PORT || 3000);
app.set("view options", {
layout: false
});
app.use(express.favicon());
app.use(express.logger('dev'));
app.use(express.json());
app.use(express.urlencoded());
// development only
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
app.get('/', function (req, res) {
var html = "<p> <b>Welcome to LiveUpdate : </b>" + new Date() + ".</p></br>";
res.end(html);
});
app.get('/getallusers/:input', function (req, res) {
var input_domain = req.params.input;
connection.query('SELECT DBName FROM CrawlerDBInfo where Domain =' + "'" + input_domain + "'" + ';', function (error, rows, fields) {
res.writeHead(200, {
'Content-Type': 'text/plain'
});
str = '';
len = rows.length;
for (i = 0; i < rows.length - 1; i++)
str = str + rows[i].DBName + ',';
str = str + rows[i].DBName;
res.end(str);
});
});
app.post('/ModuleOwner', function (req, res) {
console.log("POST: ");
MODULE = req.body.modulename;
OWNER = req.body.Ownername;
EMAIL = req.body.Ownermail;
TEAM = req.body.teamname;
REMARK = req.body.remark;
...