Repository navigation
Expand file tree
/
Copy pathLecturerTest.java
More file actions
93 lines (83 loc) · 4.99 KB
/
Copy pathLecturerTest.java
File metadata and controls
93 lines (83 loc) · 4.99 KB
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
import org.junit.jupiter.api.Test;
import static org.junit.jupiter.api.Assertions.*;
class LecturerTest {
@Test
void getModule() {
DBConnect db = new DBConnect();
String statement = "INSERT INTO `User`(`User_Id`, `Username`, `Password`, `User_Type`, `Email`, `First_Name`, `Surname`, `DOB`, `Qualification`, `Active`, `Registered`) VALUES ('17', 'Test','Test','Lecturer', 'test@test.com','Test','Test' ,'1111-11-11', 'N/A',1 ,1)";
db.write(statement);
statement = "UPDATE Module SET `Lecturer_Id` = '17' WHERE Module_ID = '946'";
db.write(statement);
String[] data = {"17", "Test", "Test", "Lecturer", "1", "email", "John", "Doe", "Male", "1990-01-01"};
Lecturer lecturer = new Lecturer(data, db);
String[] expectedModuleID = {"946"};
String[] actualModule = lecturer.getModule();
assertArrayEquals(expectedModuleID, actualModule);
statement = "UPDATE Module SET `Lecturer_Id` = '19' WHERE Module_ID = '946'";
db.write(statement);
statement = "DELETE FROM `User` WHERE User_Id = '17'";
db.write(statement);
}
@Test
void viewModule() {
DBConnect db = new DBConnect();
String statement = "INSERT INTO `User`(`User_Id`, `Username`, `Password`, `User_Type`, `Email`, `First_Name`, `Surname`, `DOB`, `Qualification`, `Active`, `Registered`) VALUES ('17', 'Test','Test','Lecturer', 'test@test.com','Test','Test' ,'1111-11-11', 'N/A',1 ,1)";
db.write(statement);
statement = "UPDATE Module SET `Lecturer_Id` = '17' WHERE Module_ID = '946'";
db.write(statement);
String[] data = {"17", "username", "password", "Lecturer", "1", "email", "John", "Doe", "Male", "1990-01-01"};
Lecturer lecturer = new Lecturer(data, db);
lecturer.viewModule();
statement = "UPDATE Module SET `Lecturer_Id` = '19' WHERE Module_ID = '946'";
db.write(statement);
statement = "DELETE FROM `User` WHERE User_Id = '17'";
db.write(statement);
}
@Test
void updateModuleName2() {
DBConnect db = new DBConnect();
String statement = "INSERT INTO `User`(`User_Id`, `Username`, `Password`, `User_Type`, `Email`, `First_Name`, `Surname`, `DOB`, `Qualification`, `Active`, `Registered`) VALUES ('17', 'Test','Test','Lecturer', 'test@test.com','Test','Test' ,'1111-11-11', 'N/A',1 ,1)";
db.write(statement);
statement = "UPDATE Module SET `Lecturer_Id` = '17' WHERE Module_ID = '946'";
db.write(statement);
String[] data = {"17", "username", "password", "Lecturer", "1", "email", "John", "Doe", "Male", "1990-01-01"};
Lecturer lecturer = new Lecturer(data, db);
lecturer.updateModuleName2("Test ModuleName");
statement = "UPDATE Module SET `Lecturer_Id` = '19', `Module_Name` = 'CS312' WHERE Module_ID = '946'";
db.write(statement);
statement = "DELETE FROM `User` WHERE User_Id = '17'";
db.write(statement);
}
@Test
void updateModuleDescription2() {
DBConnect db = new DBConnect();
String statement = "INSERT INTO `User`(`User_Id`, `Username`, `Password`, `User_Type`, `Email`, `First_Name`, `Surname`, `DOB`, `Qualification`, `Active`, `Registered`) VALUES ('17', 'Test','Test','Lecturer', 'test@test.com','Test','Test' ,'1111-11-11', 'N/A',1 ,1)";
db.write(statement);
statement = "UPDATE Module SET `Lecturer_Id` = '17' WHERE Module_ID = '946'";
db.write(statement);
String[] data = {"17", "username", "password", "Lecturer", "1", "email", "John", "Doe", "Male", "1990-01-01"};
Lecturer lecturer = new Lecturer(data, db);
lecturer.updateModuleDescription2("TestDesc");
statement = "UPDATE Module SET `Lecturer_Id` = '19', `Module_Description` = 'i hate web' WHERE Module_ID = '946'";
db.write(statement);
statement = "DELETE FROM `User` WHERE User_Id = '17'";
db.write(statement);
}
@Test
void uploadNotes2() {
DBConnect db = new DBConnect();
String statement = "INSERT INTO `User`(`User_Id`, `Username`, `Password`, `User_Type`, `Email`, `First_Name`, `Surname`, `DOB`, `Qualification`, `Active`, `Registered`) VALUES ('17', 'Test','Test','Lecturer', 'test@test.com','Test','Test' ,'1111-11-11', 'N/A',1 ,1)";
db.write(statement);
statement = "UPDATE Module SET `Lecturer_Id` = '17' WHERE Module_ID = '946'";
db.write(statement);
String[] data = {"17", "username", "password", "Lecturer", "1", "email", "John", "Doe", "Male", "1990-01-01"};
Lecturer lecturer = new Lecturer(data, db);
lecturer.uploadNotes2("TestDesc", "This Is A Test xx");
statement = "UPDATE Module SET `Lecturer_Id` = '19', `Module_Description` = 'i hate web' WHERE Module_ID = '946'";
db.write(statement);
statement = "DELETE FROM `Notes` WHERE Module_ID = '946' AND `Description` = 'TestDesc'";
db.write(statement);
statement = "DELETE FROM `User` WHERE User_Id = '17'";
db.write(statement);
}
}