TASK 1 TASK2

84795/Task1/createDB.js
var sqlite3 = require('sqlite3').verbose();
var express = require('express');
var http = require('http');
var app = express();
var server = http.createServer(app);
var db = new sqlite3.Database('./database/usersDatabase.db');
db.run('CREATE TABLE IF NOT EXISTS user (id TEXT, name TEXT)');
app.get('/', function(req,res){
res.send("

Hi there, You are database is created successfully, now to enter and retrieve data from database use'server.js from Console window'.

");
});
server.listen(3000, function(){
console.log("server is listening on port: 3000");
});
84795/Task1/database/usersDatabase.db
84795/Task1/public/index.html



Add new user
User ID


Name


Save User



View user
Get User
84795/Task1/Screenshots/AfterEnterButtonClicked.JPG
84795/Task1/Screenshots/AfterServerJsIsExecuted.JPG
84795/Task1/Screenshots/AfterViewUserButtonIsClicked.JPG
84795/Task1/Screenshots/EnterUser.JPG
84795/Task1/Screenshots/OnCreateDb.JPG
84795/Task1/server.js
var sqlite3 = require('sqlite3').verbose();
var express = require('express');
var session = require('express-session');
var http = require('http');
var path = require("path");
var bodyParser = require('body-parser');
var app = express();
app.use(session({
    secret: 'secret',
    resave: true,
    saveUninitialized: true
}));
var server = http.createServer(app);
var db = new sqlite3.Database('./database/usersDatabase.db');
app.use(bodyParser.urlencoded({extended: false}));
app.use(express.static(path.join(__dirname,'./public')));
app.get('/', function(req,res){
res.sendFile(path.join(__dirname,'./public/index.html'));
});
app.post('/add', function(req,res){
db.serialize(()=>{
db.run('INSERT INTO user (id,name) VALUES(?,?)', [req.body.id, req.body.name], function(err) {
if (err) {
return console.log(err.message);
}
res.send("New user has been added");
...