{"info":{"_postman_id":"7c5865aa-a3fe-4707-9ddf-baa6084438d2","name":"classes","description":"

A collection with requests for /classes endpoint.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"13348269","collectionId":"7c5865aa-a3fe-4707-9ddf-baa6084438d2","publishedId":"UVR5q8Xn","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2021-12-12T12:41:10.000Z"},"item":[{"name":"Get All Classes","id":"9d60ddf3-0a62-40aa-bc2f-cddb7141ae8c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{base_url}}/classes","description":"

Response

List of classes where each list item contains:

class_erp
semester
classroom, an object representing classroom, containing fields:
- classroom_id
- classroom
- campus, an object representing campus, containing fields:
  - campus_id
  - campus
  \n
\n
subject, an object representing subject, containing fields:
- subject_code
- subject
\n
teacher, an object representing teacher, containing fields:
- teacher_id
- full_name
- average_rating
- total_reviews
\n
parent_class_erp
timeslot_1, an object representing first timeslot, containing fields:
- timeslot_id
- start_time
- end_time
- slot_number
\n
timeslot_2, an object representing second timeslot, containing fields:
- timeslot_id
- start_time
- end_time
- slot_number
\n
day_1
day_2
term_id

\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{token}}"}]},"isInherited":true,"source":{"_postman_id":"7c5865aa-a3fe-4707-9ddf-baa6084438d2","id":"7c5865aa-a3fe-4707-9ddf-baa6084438d2","name":"classes","type":"collection"}},"urlObject":{"path":["classes"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"2ff93154-646c-4f00-aa6d-6c019c3aace5","name":"Mock Get All Classes","originalRequest":{"method":"GET","header":[],"url":"{{base_url}}/classes"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"3365"},{"key":"ETag","value":"W/\"d25-jgLLBdsDyIiu8ToQ3pWfDmnfpag\""},{"key":"Date","value":"Sun, 12 Dec 2021 12:21:53 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n \"headers\": {\n \"error\": 0,\n \"message\": \"Success\"\n },\n \"body\": [\n {\n \"class_erp\": \"5755\",\n \"semester\": \"CS-7\",\n \"parent_class_erp\": null,\n \"day_1\": \"tuesday\",\n \"day_2\": \"thursday\",\n \"term_id\": 1,\n \"classroom\": {\n \"classroom_id\": 2,\n \"classroom\": \"MAC1\",\n \"campus\": {\n \"campus_id\": 1,\n \"campus\": \"MAIN\"\n }\n },\n \"subject\": {\n \"subject_code\": \"CSE452\",\n \"subject\": \"Data Warehousing\"\n },\n \"teacher\": {\n \"teacher_id\": 4,\n \"full_name\": \"Anwar-Ul-Haq\",\n \"average_rating\": \"0.000\",\n \"total_reviews\": 0\n },\n \"timeslot_1\": {\n \"timeslot_id\": 5,\n \"start_time\": \"14:30:00\",\n \"end_time\": \"15:45:00\",\n \"slot_number\": 5\n },\n \"timeslot_2\": {\n \"timeslot_id\": 5,\n \"start_time\": \"14:30:00\",\n \"end_time\": \"15:45:00\",\n \"slot_number\": 5\n }\n },\n {\n \"class_erp\": \"5756\",\n \"semester\": \"CS-3\",\n \"parent_class_erp\": null,\n \"day_1\": \"monday\",\n \"day_2\": \"wednesday\",\n \"term_id\": 1,\n \"classroom\": {\n \"classroom_id\": 1,\n \"classroom\": \"MTC1\",\n \"campus\": {\n \"campus_id\": 1,\n \"campus\": \"MAIN\"\n }\n },\n \"subject\": {\n \"subject_code\": \"CSE555\",\n \"subject\": \"Data Structures\"\n },\n \"teacher\": {\n \"teacher_id\": 5,\n \"full_name\": \"Imran Khan\",\n \"average_rating\": \"0.000\",\n \"total_reviews\": 0\n },\n \"timeslot_1\": {\n \"timeslot_id\": 2,\n \"start_time\": \"10:00:00\",\n \"end_time\": \"11:15:00\",\n \"slot_number\": 2\n },\n \"timeslot_2\": {\n \"timeslot_id\": 2,\n \"start_time\": \"10:00:00\",\n \"end_time\": \"11:15:00\",\n \"slot_number\": 2\n }\n },\n {\n \"class_erp\": \"5757\",\n \"semester\": \"CS-3\",\n \"parent_class_erp\": \"5756\",\n \"day_1\": \"monday\",\n \"day_2\": \"wednesday\",\n \"term_id\": 1,\n \"classroom\": {\n \"classroom_id\": 4,\n \"classroom\": \"MTL4\",\n \"campus\": {\n \"campus_id\": 1,\n \"campus\": \"MAIN\"\n }\n },\n \"subject\": {\n \"subject_code\": \"CSE555\",\n \"subject\": \"Data Structures\"\n },\n \"teacher\": {\n \"teacher_id\": 5,\n \"full_name\": \"Imran Khan\",\n \"average_rating\": \"0.000\",\n \"total_reviews\": 0\n },\n \"timeslot_1\": {\n \"timeslot_id\": 3,\n \"start_time\": \"11:30:00\",\n \"end_time\": \"12:45:00\",\n \"slot_number\": 3\n },\n \"timeslot_2\": {\n \"timeslot_id\": 3,\n \"start_time\": \"11:30:00\",\n \"end_time\": \"12:45:00\",\n \"slot_number\": 3\n }\n },\n {\n \"class_erp\": \"5758\",\n \"semester\": \"ACF-2\",\n \"parent_class_erp\": null,\n \"day_1\": \"tuesday\",\n \"day_2\": \"thursday\",\n \"term_id\": 2,\n \"classroom\": {\n \"classroom_id\": 3,\n \"classroom\": \"MCC1\",\n \"campus\": {\n \"campus_id\": 1,\n \"campus\": \"MAIN\"\n }\n },\n \"subject\": {\n \"subject_code\": \"SCI102\",\n \"subject\": \"Physics\"\n },\n \"teacher\": {\n \"teacher_id\": 1,\n \"full_name\": \"Waseem Arain\",\n \"average_rating\": \"5.000\",\n \"total_reviews\": 1\n },\n \"timeslot_1\": {\n \"timeslot_id\": 2,\n \"start_time\": \"10:00:00\",\n \"end_time\": \"11:15:00\",\n \"slot_number\": 2\n },\n \"timeslot_2\": {\n \"timeslot_id\": 2,\n \"start_time\": \"10:00:00\",\n \"end_time\": \"11:15:00\",\n \"slot_number\": 2\n }\n },\n {\n \"class_erp\": \"5759\",\n \"semester\": \"ECO-2\",\n \"parent_class_erp\": null,\n \"day_1\": \"tuesday\",\n \"day_2\": \"thursday\",\n \"term_id\": 2,\n \"classroom\": {\n \"classroom_id\": 5,\n \"classroom\": \"MTS2\",\n \"campus\": {\n \"campus_id\": 1,\n \"campus\": \"MAIN\"\n }\n },\n \"subject\": {\n \"subject_code\": \"HUM201\",\n \"subject\": \"Speech Communication\"\n },\n \"teacher\": {\n \"teacher_id\": 2,\n \"full_name\": \"Faisal Iradat\",\n \"average_rating\": \"3.600\",\n \"total_reviews\": 2\n },\n \"timeslot_1\": {\n \"timeslot_id\": 2,\n \"start_time\": \"10:00:00\",\n \"end_time\": \"11:15:00\",\n \"slot_number\": 2\n },\n \"timeslot_2\": {\n \"timeslot_id\": 2,\n \"start_time\": \"10:00:00\",\n \"end_time\": \"11:15:00\",\n \"slot_number\": 2\n }\n },\n {\n \"class_erp\": \"5760\",\n \"semester\": \"ECO-2\",\n \"parent_class_erp\": null,\n \"day_1\": \"tuesday\",\n \"day_2\": \"thursday\",\n \"term_id\": 2,\n \"classroom\": {\n \"classroom_id\": 5,\n \"classroom\": \"MTS2\",\n \"campus\": {\n \"campus_id\": 1,\n \"campus\": \"MAIN\"\n }\n },\n \"subject\": {\n \"subject_code\": \"HUM201\",\n \"subject\": \"Speech Communication\"\n },\n \"teacher\": {\n \"teacher_id\": 2,\n \"full_name\": \"Faisal Iradat\",\n \"average_rating\": \"3.600\",\n \"total_reviews\": 2\n },\n \"timeslot_1\": {\n \"timeslot_id\": 3,\n \"start_time\": \"11:30:00\",\n \"end_time\": \"12:45:00\",\n \"slot_number\": 3\n },\n \"timeslot_2\": {\n \"timeslot_id\": 3,\n \"start_time\": \"11:30:00\",\n \"end_time\": \"12:45:00\",\n \"slot_number\": 3\n }\n }\n ]\n}"}],"_postman_id":"9d60ddf3-0a62-40aa-bc2f-cddb7141ae8c"},{"name":"Get All Classes With Query","id":"941a7bfb-07a2-4f3e-a716-82dcc24a4841","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{base_url}}/classes?subject_code=HUM201&term_id=2","description":"

Response

List of classes, filtered by the query, where each list item contains:

class_erp
semester
classroom, an object representing classroom, containing fields:
- classroom_id
- classroom
- campus, an object representing campus, containing fields:
  - campus_id
  - campus
  \n
\n
subject, an object representing subject, containing fields:
- subject_code
- subject
\n
teacher, an object representing teacher, containing fields:
- teacher_id
- full_name
- average_rating
- total_reviews
\n
parent_class_erp
timeslot_1, an object representing first timeslot, containing fields:
- timeslot_id
- start_time
- end_time
- slot_number
\n
timeslot_2, an object representing second timeslot, containing fields:
- timeslot_id
- start_time
- end_time
- slot_number
\n
day_1
day_2
term_id

Response

class_erp
semester
classroom, an object representing classroom, containing fields:
- classroom_id
- classroom
- campus, an object representing campus, containing fields:
  - campus_id
  - campus
  \n
\n
subject, an object representing subject, containing fields:
- subject_code
- subject
\n
teacher, an object representing teacher, containing fields:
- teacher_id
- full_name
- average_rating
- total_reviews
\n
parent_class_erp
timeslot_1, an object representing first timeslot, containing fields:
- timeslot_id
- start_time
- end_time
- slot_number
\n
timeslot_2, an object representing second timeslot, containing fields:
- timeslot_id
- start_time
- end_time
- slot_number
\n
day_1
day_2
term_id

Response

affected_rows Should be 1.

\n","urlObject":{"path":["classes"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"da792639-b9f5-4e49-bef7-ad18b1f373bf","name":"Mock Add A Class","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"class_erp\": 5755,\r\n \"semester\": \"CS-7\",\r\n \"classroom_id\": 2,\r\n \"subject_code\": \"CSE452\",\r\n \"teacher_id\": \"4\",\r\n \"timeslot_1\": 5,\r\n \"timeslot_2\": 5,\r\n \"day_1\": \"tuesday\",\r\n \"day_2\": \"thursday\",\r\n \"term_id\": 1\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/classes"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"81"},{"key":"ETag","value":"W/\"51-A7rF24NqalRH94hthe9Xm8AdIFA\""},{"key":"Date","value":"Sun, 12 Dec 2021 12:15:18 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n \"headers\": {\n \"error\": 0,\n \"message\": \"Class was created!\"\n },\n \"body\": {\n \"affected_rows\": 1\n }\n}"}],"_postman_id":"75018d80-dc43-4790-a8a6-773b4068bf59"},{"name":"Add Many Class","id":"c02d7a9d-2270-435a-ab13-ff6cc1fbe13c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{admin_token}}"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"classes\": [\r\n {\r\n \"class_erp\": 5756,\r\n \"semester\": \"CS-3\",\r\n \"classroom_id\": 1,\r\n \"subject_code\": \"CSE555\",\r\n \"teacher_id\": 5,\r\n \"timeslot_1\": 2,\r\n \"timeslot_2\": 2,\r\n \"day_1\": \"monday\",\r\n \"day_2\": \"wednesday\",\r\n \"term_id\": 1,\r\n \"parent_class_erp\": \"\"\r\n },\r\n {\r\n \"class_erp\": 5757,\r\n \"semester\": \"CS-3\",\r\n \"classroom_id\": 4,\r\n \"subject_code\": \"CSE555\",\r\n \"teacher_id\": 5,\r\n \"timeslot_1\": 3,\r\n \"timeslot_2\": 3,\r\n \"day_1\": \"monday\",\r\n \"day_2\": \"wednesday\",\r\n \"term_id\": 1,\r\n \"parent_class_erp\": \"5756\"\r\n },\r\n {\r\n \"class_erp\": 5758,\r\n \"semester\": \"ACF-2\",\r\n \"classroom_id\": 3,\r\n \"subject_code\": \"HUM201\",\r\n \"teacher_id\": 1,\r\n \"timeslot_1\": 2,\r\n \"timeslot_2\": 2,\r\n \"day_1\": \"tuesday\",\r\n \"day_2\": \"thursday\",\r\n \"term_id\": 2,\r\n \"parent_class_erp\": \"\"\r\n },\r\n {\r\n \"class_erp\": 5759,\r\n \"semester\": \"ECO-2\",\r\n \"classroom_id\": 5,\r\n \"subject_code\": \"HUM201\",\r\n \"teacher_id\": 2,\r\n \"timeslot_1\": 2,\r\n \"timeslot_2\": 2,\r\n \"day_1\": \"tuesday\",\r\n \"day_2\": \"thursday\",\r\n \"term_id\": 2,\r\n \"parent_class_erp\": \"\"\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/classes/bulk","description":"

Response

affected_rows Should be equal to length of the list sent.

\n","urlObject":{"path":["classes","bulk"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"e72f4ecd-977e-4f9a-92b1-7feedf56ad98","name":"Mock Add Many Class","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"classes\": [\r\n {\r\n \"class_erp\": 5756,\r\n \"semester\": \"CS-3\",\r\n \"classroom_id\": 1,\r\n \"subject_code\": \"CSE555\",\r\n \"teacher_id\": 5,\r\n \"timeslot_1\": 2,\r\n \"timeslot_2\": 2,\r\n \"day_1\": \"monday\",\r\n \"day_2\": \"wednesday\",\r\n \"term_id\": 1,\r\n \"parent_class_erp\": \"\"\r\n },\r\n {\r\n \"class_erp\": 5757,\r\n \"semester\": \"CS-3\",\r\n \"classroom_id\": 4,\r\n \"subject_code\": \"CSE555\",\r\n \"teacher_id\": 5,\r\n \"timeslot_1\": 3,\r\n \"timeslot_2\": 3,\r\n \"day_1\": \"monday\",\r\n \"day_2\": \"wednesday\",\r\n \"term_id\": 1,\r\n \"parent_class_erp\": \"5756\"\r\n },\r\n {\r\n \"class_erp\": 5758,\r\n \"semester\": \"ACF-2\",\r\n \"classroom_id\": 3,\r\n \"subject_code\": \"HUM201\",\r\n \"teacher_id\": 1,\r\n \"timeslot_1\": 2,\r\n \"timeslot_2\": 2,\r\n \"day_1\": \"tuesday\",\r\n \"day_2\": \"thursday\",\r\n \"term_id\": 2,\r\n \"parent_class_erp\": \"\"\r\n },\r\n {\r\n \"class_erp\": 5759,\r\n \"semester\": \"ECO-2\",\r\n \"classroom_id\": 5,\r\n \"subject_code\": \"HUM201\",\r\n \"teacher_id\": 2,\r\n \"timeslot_1\": 2,\r\n \"timeslot_2\": 2,\r\n \"day_1\": \"tuesday\",\r\n \"day_2\": \"thursday\",\r\n \"term_id\": 2,\r\n \"parent_class_erp\": \"\"\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/classes/bulk"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"84"},{"key":"ETag","value":"W/\"54-3tpDCI/Pc8zw+V01xllMGPXdRmU\""},{"key":"Date","value":"Sun, 12 Dec 2021 12:16:30 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n \"headers\": {\n \"error\": 0,\n \"message\": \"Classes were created!\"\n },\n \"body\": {\n \"affected_rows\": 4\n }\n}"}],"_postman_id":"c02d7a9d-2270-435a-ab13-ff6cc1fbe13c"},{"name":"Update A Class","id":"71e62522-fae5-4da8-a2ff-9a953934316f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{admin_token}}"}]},"isInherited":false},"method":"PATCH","header":[],"body":{"mode":"raw","raw":"{\r\n \"classroom_id\": 3\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/classes/2/5755","description":"

Response

review_id The new teacher review's id
affected_rows Should be 1.

\n","urlObject":{"path":["classes","2","5755"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"e42d0912-5944-4234-bdf9-80f693ecfa4b","name":"Mock Update A Class","originalRequest":{"method":"PATCH","header":[],"body":{"mode":"raw","raw":"{\r\n \"classroom_id\": 3\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/classes/2/5755"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"155"},{"key":"ETag","value":"W/\"9b-2IWr+TUM9WDgAaJOQ4E8Qf86JiI\""},{"key":"Date","value":"Sun, 12 Dec 2021 12:19:02 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n \"headers\": {\n \"error\": 0,\n \"message\": \"Class updated successfully\"\n },\n \"body\": {\n \"rows_matched\": 1,\n \"rows_changed\": 1,\n \"info\": \"Rows matched: 1 Changed: 1 Warnings: 0\"\n }\n}"}],"_postman_id":"71e62522-fae5-4da8-a2ff-9a953934316f"},{"name":"Delete A Class","id":"01e63f36-3a7f-41b6-8135-3507528b49cb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{admin_token}}"}]},"isInherited":false},"method":"DELETE","header":[],"url":"{{base_url}}/classes/2/5755","description":"

Response

rows_removed

\n\n

Note : message header indicates result.

\n","urlObject":{"path":["classes","2","5755"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"07d09623-bbfa-4de0-b089-8079b8525485","name":"Mock Delete A Class","originalRequest":{"method":"DELETE","header":[],"url":"{{base_url}}/classes/2/5755"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"84"},{"key":"ETag","value":"W/\"54-FnOEMEwC4nfv/OqnnlBeJG2y6BA\""},{"key":"Date","value":"Sun, 12 Dec 2021 12:23:13 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n \"headers\": {\n \"error\": 0,\n \"message\": \"Class has been deleted\"\n },\n \"body\": {\n \"rows_removed\": 1\n }\n}"}],"_postman_id":"01e63f36-3a7f-41b6-8135-3507528b49cb"}],"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{token}}"}]}},"event":[{"listen":"prerequest","script":{"id":"99f594c3-a6a2-48fd-bfce-f535ff0f9553","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"725dd8a9-ee03-4bad-a269-46efd4b0d982","type":"text/javascript","exec":[""]}}]}