Update createBusy table

Software-Engineering-Group-9 / Back-End-API

Spring Boot. Backend of Doable Calendar - Endpoints, JDBC, etc.

0 stars 0 forks source link

Update createBusy table #10

Closed MingHaoC closed 3 years ago

MingHaoC commented 3 years ago

-Update the busy table so it matches what front end is sending back. -Busy table schema CREATE TABLE busyschedule(aid NUMBER(15) NOT NULL, title varchar2(40), start_time varchar2(19), end_time varchar2(19), bgColor varchar2(7), dragBgColor varchar2(7), userid varchar2(50), PRIMARY KEY(aid), FOREIGN KEY (userid) REFERENCES user(uuid) );

MingHaoC commented 3 years ago

Update to the table CREATE TABLE busyschedule(aid VARCHAR2(100) NOT NULL, title VARCHAR2(40), start_time VARCHAR2(19), end_time VARCHAR2(19), color VARCHAR2(7), userid VARCHAR2(50), PRIMARY KEY(aid), FOREIGN KEY (userid) REFERENCES user(uuid) );

MingHaoC commented 3 years ago

update the busyschedule SQL command for insert

MingHaoC commented 3 years ago

I just updated the schema for creating busyschedule table and updated the insert command. I also tested the endpoint with postman.
Need test with the actual frontend

MingHaoC commented 3 years ago

The create busyschdule features was tested with front-end on 27-Nov-2020 and it works with no error.

Need testing with retrieving the busyschedule when user logs in

MingHaoC commented 3 years ago

When user logs in, the calendar will display user busy event as well now, tested with front-end on 28-Nov-2020, works with no error