4dd7739e
Tarpit Grover
Commit
|
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
|
var express = require('express');
var app = express();
var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var bodyParser = require('body-parser');
//var methodOverride = require('method-override');
mongoose.connect('mongodb://127.0.0.1:27017/TodoAppDB');
app.use(express.static(__dirname + '/public'));
app.use(bodyParser.json());
//app.use(methodOverride());
//=============================================================================
// define Schema for all table in the DB
//tasks Schema
var TaskSchema = new Schema({
task_name: String,
task_status: Boolean,
DueDate: Date,
Project_id: { type: Schema.Types.ObjectId, ref: 'Project' }
//CreatedById: [{ type: Schema.Types.ObjectId, ref: 'User' }]
});
var Task = mongoose.model('tasks', TaskSchema); // task model
//projects Schema
var ProjectSchema = new Schema({
project_name: String,
//CreatedById: [{ type: Schema.Types.ObjectId, ref: 'User' }],
project_status: Boolean
});
var Project = mongoose.model('projects', ProjectSchema);
//===============================================================================
//Task query
app.get('/tasks', function(req, res) {
console.log("I recived a get request.");
Task.find().exec(function(err, tasks) {
res.json(tasks);
|
4dd7739e
Tarpit Grover
Commit
|
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
126
127
128
|
});
});
app.post('/tasks', function(req, res) {
Task.create(req.body, function(err, tasks) {
res.json(tasks);
});
});
app.put('/tasks/:id', function(req, res){
console.log(req.body);
Task.update({_id:req.params.id},req.body,{upsert:true},function(err) {
if(!err) {
res.send('updated');
}
else {
console.log(err);
res.send(404);
}
});
});
app.delete('/tasks/:id', function(req, res){
Task.remove({_id: req.params.id}, function(err) {
if(!err) {
res.send('deleted');
}
else {
console.log(err);
res.send(404);
}
});
});
// ==================================================================================
//Projects query
app.get('/projects', function(req, res) {
Project.find().exec(function(err, projects) {
res.json(projects);
});
});
app.post('/projects', function(req, res) {
Project.create(req.body, function(err, projects) {
res.json(projects);
});
});
app.put('/projects/:id', function(req, res){
console.log(req.body);
Project.update({_id:req.params.id},req.body,{upsert:true},function(err) {
if(!err) {
res.send('updated');
}
else {
console.log(err);
res.send(404);
}
});
});
app.delete('/projects/:id', function(req, res){
Project.remove({_id: req.params.id}, function(err) {
if(!err) {
res.send('deleted');
}
else {
console.log(err);
res.send(404);
}
});
});
// ==================================================================================
|