Asquery/app.js at main · Arindam2002/Asquery · 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
require("dotenv").config({path: './.env'});
const cors = require("cors");
const mysql = require("mysql2");
const express = require("express");
const path = require("path");
const bodyParser = require("body-parser");
const ejs = require("ejs");
const cookieParser = require("cookie-parser");

const methodOverride = require("method-override");
// const { Sequelize } = require('sequelize');

// const mongoose = require("mongoose");


const app = express();

// const sequelize = new Sequelize('database', 'username', 'password', {
//   host: 'localhost',
//   dialect: 'mysql'
// });
app.use(cors());
app.use(express.json());
app.use(cookieParser());
app.use(express.urlencoded({
  extended : false
}));

const publicDirectory = path.join(__dirname, "./public")
app.use(express.static(publicDirectory));

app.set("view engine", "ejs");


// --------------------------------------------
// app.use(bodyParser.urlencoded({
//   extended: true
// }));
// --------------------------------------------
const db = mysql.createConnection({
  host: process.env.DATABASE_HOST,
  user: process.env.DATABASE_USER,
  password: process.env.DATABASE_PASSWORD,
  database: process.env.DATABASE,
  multipleStatements: true
});

// mysqlConnection.connect((err)=>{
//   if (!err) {
//     console.log("Connected Successfully!");
//   } else {
//     console.log(err);
//   }
// });

db.connect(function(err){
  if (!err) {
    console.log("connected Successfully");
  } else {
    console.log(err);
  }
});

app.use(methodOverride("_method"));
app.use("/", require("./routes/pages"));
app.use("/auth", require("./routes/auth"));


// app.get("/signup", function(req, res){
//   res.render("signup");
// });
//
// app.get("/login", function(req, res){
//   res.render("login");
// });
//
// app.get("/posts", function(req, res){
//   res.render("posts");
// });

// app.post("/signup", function(req, res){
//   fName: ;
// });


app.listen(3000, function(){
  console.log("Server started on port 3000.");
});