Commit | Line | Data |
---|---|---|
e99c53fb BA |
1 | const db = require("../utils/database"); |
2 | ||
3 | const CourseEntity = | |
4 | { | |
5 | /* | |
6 | * Structure: | |
7 | * _id: BSON id | |
8 | * uid: prof ID | |
9 | * code: varchar | |
10 | * description: varchar | |
11 | * password: monitoring password hash | |
12 | * students: array of | |
13 | * number: student number | |
14 | * forename: varchar | |
15 | * name: varchar | |
16 | * group: integer | |
17 | */ | |
18 | ||
19 | getByUser: function(uid, callback) | |
20 | { | |
21 | db.courses.find( | |
22 | { uid: uid }, | |
23 | callback | |
24 | ); | |
25 | }, | |
26 | ||
27 | getById: function(cid, callback) | |
28 | { | |
29 | db.courses.findOne( | |
30 | { _id: cid }, | |
31 | callback | |
32 | ); | |
33 | }, | |
34 | ||
35 | getByPath: function(uid, code, callback) | |
36 | { | |
37 | db.courses.findOne( | |
38 | { | |
39 | $and: [ | |
40 | { uid: uid }, | |
41 | { code: code }, | |
42 | ] | |
43 | }, | |
44 | callback | |
45 | ); | |
46 | }, | |
47 | ||
48 | insert: function(uid, code, description, cb) | |
49 | { | |
50 | db.courses.insert( | |
51 | { | |
52 | uid: uid, | |
53 | code: code, | |
54 | description: description, | |
55 | students: [ ], | |
56 | }, | |
57 | cb); | |
58 | }, | |
59 | ||
60 | setStudents: function(cid, students, cb) | |
61 | { | |
62 | db.courses.update( | |
63 | { _id: cid }, | |
64 | { $set: { students: students } }, | |
65 | cb | |
66 | ); | |
67 | }, | |
68 | ||
69 | // Note: return { students: { ... } }, pointing on the requested row | |
70 | getStudent: function(cid, number, cb) | |
71 | { | |
72 | db.courses.findOne( | |
73 | { _id: cid }, | |
74 | { | |
75 | _id: 0, | |
76 | students: { $elemMatch: {number: number} } | |
77 | }, | |
78 | cb | |
79 | ); | |
80 | }, | |
81 | ||
82 | setPassword: function(cid, pwd, cb) | |
83 | { | |
84 | db.courses.update( | |
85 | { _id: cid }, | |
86 | { $set: { password: pwd } }, | |
87 | cb | |
88 | ); | |
89 | }, | |
90 | ||
91 | remove: function(cid, cb) | |
92 | { | |
93 | db.courses.remove( | |
94 | { _id: cid }, | |
95 | cb | |
96 | ); | |
97 | }, | |
98 | } | |
99 | ||
100 | module.exports = CourseEntity; |