freespace/app.js at master · FirstIntuition/freespace · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
const express = require('express');
const bodyParser = require('body-parser');
const request = require('request');
const app = express();
const https = require('https');
const mysql = require('mysql');
const path = require('path');

app.use(express.static(__dirname + '/public'));

app.use(bodyParser.urlencoded({extended:true}));

app.get("/", function(req, res){
  res.sendFile(path.join(__dirname,"./public","/homepage.html"));
})

app.use(bodyParser.json());
app.post("/search", function(req, res){
  var obj=req.body;
  var query='select * from documents, topics';
  var entered = false;
  if (obj.year.length) {
    if (!entered) {
      query += ' where (';
    }else {
      query += ' and (';
    }
    entered=true;
    for (var i = 0; i < obj.year.length; i++) {
      if (i) {
        query += ' or ';
      }
      query +=  "doc_date_asked = '" + obj.year[i] + "'";
    }
    query += ')';
  }
  if (obj.collegeYears.length) {
    if (!entered) {
      query += ' where (';
    }else {
      query += ' and (';
    }
    entered=true;
    for (var i = 0; i < obj.collegeYears.length; i++) {
      if (i) {
        query += ' or ';
      }
      query +=  "doc_year = '" + obj.collegeYears[i] + "'";
    }
    query += ')';
  }
  if (obj.examType.length) {
    if (!entered) {
      query += ' where (';
    }else {
      query += ' and (';
    }
    entered=true;
    for (var i = 0; i < obj.examType.length; i++) {
      if (i) {
        query += ' or ';
      }
      query +=  "doc_exam = '" + obj.examType[i] + "'";
    }
    query += ')';
  }
  if (obj.topics.length) {
    if (!entered) {
      query += ' where (';
    }else {
      query += ' and (';
    }
    entered=true;
    for (var i = 0; i < obj.topics.length; i++) {
      if (i) {
        query += ' or ';
      }
      query +=  "topic = '" + obj.topics[i] + "'";
    }
    query += ')';
  }
  if (obj.subjects.length) {
    if (!entered) {
      query += ' where (';
    }else {
      query += ' and (';
    }
    entered=true;
    for (var i = 0; i < obj.subjects.length; i++) {
      if (i) {
        query += ' or ';
      }
      query +=  "doc_subject = '" + obj.subjects[i] + "'";
    }
    query += ')';
  }
  if (entered) {
    query += ' and';
  }else {
    query += ' where';
  }
  query += ' documents.doc_id=topics.doc_id group by documents.doc_id order by documents.doc_id desc';
  //res.send(query);
  var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "freespace"
  });

  con.connect(function(err) {
    if (err) throw err;
    console.log("Connected!");
    console.log(query);
    con.query(query, function (err, result, fields) {
    if (err) throw err;
    res.json(result);
    console.log(result);
  });
  });
});

app.listen(process.env.PORT || 3000, function(){
  console.log("Server is running on port 3000.");
});