Library-Management-System/database.js at master · Tus-har/Library-Management-System · 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
var mysql = require('mysql');
var operations = require('./operations');

var connection = mysql.createConnection({
    host     : 'remotemysql.com',
    user     : 'UwpIckRvEY',
    password : 'TrmVB8NUIC',
    database : 'UwpIckRvEY',
    port:3306
});

function connectDB() {
    connection.connect(function(err) {
        if (err) {
            console.error('error connecting: ' + err.stack);
            return;
        }

        console.log('connected as id ' + connection.threadId);
    });

}


function checkUser(userid,cb){
    operations.checkUser(connection,userid ,function (err,data) {
        cb(err,data) ;
    })
}


function checkAdmin(userid,cb){
    operations.checkAdmin(connection,userid ,function (err,data) {
        cb(err,data) ;
    })
}

function fetchUsers(cb){
    operations.fetchUsers(connection,function (err,data) {
        cb(err,data) ;
    })
}
function fetchBooks(cb){
    operations.fetchBooks(connection,function (err,data) {
        cb(err,data) ;
    })
}
function fetchBooks1(available,cb){
    operations.fetchBooks1(connection , available ,function (err,data) {
        cb(err,data) ;
    })
}
function fetchBooks2(category,cb){
    operations.fetchBooks2(connection,category,function (err,data) {
        cb(err,data) ;
    })
}
function fetchBooks3(name,cb){
    operations.fetchBooks3(connection,name, function (err,data) {
        cb(err,data) ;
    })
}
function createUser(userid,password,name,cb){
    operations.createUser(connection,userid,password,name,function (err,data) {
        cb(err,data) ;
    })
}
function issueBook(userid,isbn,cb){
    operations.issueBook(connection,userid,isbn,function (err,data) {
        cb(err,data) ;
    })
}
function fetchFine(userid,cb){
    operations.fetchFine(connection,userid,function (err,data) {
        cb(err,data) ;
    })
}
function addBook(isbn,name,author,category,cb){
    operations.addBook(connection,isbn,name,author,category,function (err,data) {
        cb(err,data)
    })
}
function returnBook(isbn,userid,cb){
    operations.returnBook(connection,userid,isbn,function (err,data) {
        cb(err,data)
    })
}
function calFine(isbn,cb) {
    operations.calFine(connection,isbn,function (err,data) {
        cb(err,data)
    })
}
module.exports={
    connectDB,
    createUser,
    checkUser,
    checkAdmin,
    fetchUsers,
    fetchBooks,
    fetchBooks1,
    fetchBooks2,
    fetchBooks3,
    issueBook,
    fetchFine,
    addBook,
    returnBook,
    calFine
}