{"info":{"_postman_id":"a88895eb-83ac-461c-a6f4-20c41f0f6960","name":"Postgre APIs App","description":"<html><head></head><body><p>The Node.js Blog App is a web application that allows users to create, read, update, and delete (CRUD) blog posts. It will be built using Node.js and Express on the server side.</p>\n<p>Here are the REST API endpoints that may be required for the Node.js Blog App.</p>\n<p><a href=\"https://postgre-apis-app.onrender.com/\">App link</a></p>\n<p>Design and created by <a href=\"https://github.com/getlost01/Postgre-APIs-App\">Aagam Jain</a></p>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"25076245","collectionId":"a88895eb-83ac-461c-a6f4-20c41f0f6960","publishedId":"2s8Z6vaEwE","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"4f8eed"},"publishDate":"2022-12-26T08:49:39.000Z"},"item":[{"name":"user APIs","item":[{"name":"/api/login","event":[{"listen":"prerequest","script":{"id":"27b8f6c9-1294-4438-99a5-1bbce95844ba","exec":[""],"type":"text/javascript"}}],"id":"9b115e7c-e573-42d9-8b45-c2f60232e366","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n    \"username\": \"gl01\",\n    \"password\": \"hello\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/login","description":"<p>Allows a user to log in by sending a POST request with their username and password.</p>\n","urlObject":{"protocol":"https","path":["api","login"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"c10c4c67-da24-41ed-986b-95c8d2c9e831","name":"/api/login","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n    \"username\": \"gl01\",\n    \"password\": \"hello\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/login"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 12:58:29 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77f9fcfa687c1b82-DEL"},{"key":"ETag","value":"W/\"50-pHUqgWzKN0ftBnyinsO9S67vE7E\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"User have been login\",\n    \"username\": \"gl01\",\n    \"name\": \"Aagam Jain\"\n}"}],"_postman_id":"9b115e7c-e573-42d9-8b45-c2f60232e366"},{"name":"/api/signup","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"c974b6f5-512d-41c0-a0b3-72bc52e60a68","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n    \"username\": \"gl05\",\n    \"name\":\"Aagam Jain\",\n    \"email\": \"aagam5@gmail.com\",\n    \"password\": \"hello\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/signup","description":"<p>Allows a user to log in by sending a POST request with their username and password.</p>\n","urlObject":{"protocol":"https","path":["api","signup"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"4ac49d23-8939-4103-857c-1e7cb42d2d1f","name":"/api/signup","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n    \"username\": \"gl05\",\n    \"name\":\"Aagam Jain\",\n    \"email\": \"aagam5@gmail.com\",\n    \"password\": \"hello\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/signup"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 12:59:42 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77f9fec6ac331b82-DEL"},{"key":"ETag","value":"W/\"9d-4Ww6m+Vpcqq9j+Pon0x8FXYEqAU\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"New user have been created\",\n    \"details\": {\n        \"user_id\": 14,\n        \"username\": \"gl05\",\n        \"name\": \"Aagam Jain\",\n        \"email\": \"aagam5@gmail.com\",\n        \"password\": \"hello\"\n    }\n}"}],"_postman_id":"c974b6f5-512d-41c0-a0b3-72bc52e60a68"},{"name":"/api/users/all","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"7a52c554-eed7-492b-9054-a63fe2375140","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/users/all","description":"<p>Allows a user to view all profiles of different users by sending a GET request.</p>\n","urlObject":{"protocol":"https","path":["api","users","all"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"9c707683-c8ce-4a69-9527-a614533052da","name":"/api/users/all","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/users/all"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:25:54 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa2526ff198ae1-DEL"},{"key":"ETag","value":"W/\"15d-khu38krpfLfAvGFqb4MjJDcEbB8\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"users\": [\n        {\n            \"user_id\": 2,\n            \"username\": \"gl01\",\n            \"email\": \"aagam@gmail.com\",\n            \"name\": \"Aagam Jain\"\n        },\n        {\n            \"user_id\": 4,\n            \"username\": \"getlost01\",\n            \"email\": \"aagam1@gmail.com\",\n            \"name\": \"Aagam Jain\"\n        },\n        {\n            \"user_id\": 11,\n            \"username\": \"gl012\",\n            \"email\": \"aagamjain@gmail.com\",\n            \"name\": \"Aagam Jain\"\n        },\n        {\n            \"user_id\": 14,\n            \"username\": \"gl05\",\n            \"email\": \"aagam5@gmail.com\",\n            \"name\": \"Aagam Jain\"\n        }\n    ]\n}"}],"_postman_id":"7a52c554-eed7-492b-9054-a63fe2375140"},{"name":"/api/users/:id","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"aedf6ec0-f39f-49a0-8c24-db03de08508b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/users/:id","description":"<p>Allows a user to view their own profile by sending a GET request and specifying their user ID in the URL.</p>\n","urlObject":{"protocol":"https","path":["api","users",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"2","key":"id"}]}},"response":[{"id":"f333c62e-9a41-4dd7-879e-ebceb3fbe178","name":"/api/users/:id","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/users/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","users",":id"],"variable":[{"key":"id","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:26:00 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa254c6ead8ae1-DEL"},{"key":"ETag","value":"W/\"59-jUnKcuHo5h3kjYexDVWSIcVx9oo\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"users\": [\n        {\n            \"username\": \"gl01\",\n            \"email\": \"aagam@gmail.com\",\n            \"name\": \"Aagam Jain\"\n        }\n    ]\n}"}],"_postman_id":"aedf6ec0-f39f-49a0-8c24-db03de08508b"}],"id":"061a28e7-3821-473f-956d-882e1475a094","description":"<p>The user APIs are that allow user to (sign in , login, and get details of user)</p>\n","_postman_id":"061a28e7-3821-473f-956d-882e1475a094"},{"name":"post APIs","item":[{"name":"/api/posts","event":[{"listen":"prerequest","script":{"id":"27b8f6c9-1294-4438-99a5-1bbce95844ba","exec":[""],"type":"text/javascript"}}],"id":"dbcdf132-3cdb-496a-905b-a453423795b6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n   \"user_id\": 2,\n   \"title\": \"PostgreSQL\", \n   \"content\": \"PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.L\",\n   \"category\": \"DBMS\",\n   \"keywords\": [\"PG\", \"Postgre\"]\n}\n","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts","description":"<p>Allows a user to create a new blog post by sending a POST request with the necessary post data (e.g., title, content, category, keywords, user, created_at).</p>\n","urlObject":{"protocol":"https","path":["api","posts"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"50fe722e-3fd2-4190-baa1-27414b106158","name":"/api/posts","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n   \"user_id\": 2,\n   \"title\": \"PostgreSQL\", \n   \"content\": \"PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.L\",\n   \"category\": \"DBMS\",\n   \"keywords\": [\"PG\", \"Postgre\"]\n}\n","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:24:56 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa23bbacff8ae1-DEL"},{"key":"ETag","value":"W/\"1bc-dwHq4NVCbXEIGySq3eJgkZ+QUHQ\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"New post have been created\",\n    \"details\": {\n        \"post_id\": 5,\n        \"user_id\": 2,\n        \"title\": \"PostgreSQL\",\n        \"content\": \"PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.L\",\n        \"category\": \"DBMS\",\n        \"keywords\": \"[\\\"PG\\\",\\\"Postgre\\\"]\",\n        \"created_at\": \"2022-12-26T13:24:56.485+00:00\",\n        \"likes\": 0,\n        \"dislikes\": 0\n    }\n}"}],"_postman_id":"dbcdf132-3cdb-496a-905b-a453423795b6"},{"name":"/api/posts/:id","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"1cb2d5c3-5c7f-49d4-8d0b-855d6908f771","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts/:id","description":"<p>Returns a specific blog post by its ID.</p>\n","urlObject":{"protocol":"https","path":["api","posts",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"2","key":"id"}]}},"response":[{"id":"83c3747f-2e3d-4650-a4e8-df0edcec4b99","name":"/api/posts/:id","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/posts/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","posts",":id"],"variable":[{"key":"id","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:27:21 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa2746fdc78ae1-DEL"},{"key":"ETag","value":"W/\"d2-mT2Ed+HdLhCdz2Zc/nwDMPmkoV8\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"post\": {\n        \"post_id\": 2,\n        \"user_id\": 2,\n        \"title\": \"Postgre\",\n        \"content\": \"TEXT NOT NULL\",\n        \"category\": \"SQL\",\n        \"keywords\": \"{\\\"SQL\\\",\\\"Postgre\\\"}\",\n        \"created_at\": \"2022-12-26T14:16:19.147+05:30\",\n        \"likes\": 3,\n        \"dislikes\": 2\n    }\n}"}],"_postman_id":"1cb2d5c3-5c7f-49d4-8d0b-855d6908f771"},{"name":"/api/posts/:id","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"88b5ea66-19e8-423f-8e05-80e1e4201cb5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"title\": \"Postgre\", \n   \"content\": \"TEXT NOT NULL\",\n   \"category\": \"SQL\",\n   \"keywords\": [\"SQL\", \"Postgre\"]\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts/:id","description":"<p>Allows a user to update an existing blog post by sending a PUT request with the updated post data.</p>\n","urlObject":{"protocol":"https","path":["api","posts",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"2","key":"id"}]}},"response":[{"id":"33cf5f4e-dd7c-4788-a450-373853ebb628","name":"/api/posts/:id","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"title\": \"Postgre\", \n   \"content\": \"TEXT NOT NULL\",\n   \"category\": \"SQL\",\n   \"keywords\": [\"SQL\", \"Postgre\"]\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/posts/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","posts",":id"],"variable":[{"key":"id","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:28:09 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa2873c9878ae1-DEL"},{"key":"ETag","value":"W/\"37-ZEnnd3ad0l67YDD5CWZKqas3Doo\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"Post id = 2 have been updated🎉\"\n}"}],"_postman_id":"88b5ea66-19e8-423f-8e05-80e1e4201cb5"},{"name":"/api/posts/:id","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"6ee83dd4-4a70-48fd-8b2b-eb2fcb2cefb4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts/:id","description":"<p>Allows a user to delete a blog post by sending a DELETE request and specifying the post ID in the URL.</p>\n","urlObject":{"protocol":"https","path":["api","posts",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"1","key":"id"}]}},"response":[{"id":"09016c27-5d66-4b8f-8645-44dfc7ee5d77","name":"/api/posts/:id","originalRequest":{"method":"DELETE","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/posts/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","posts",":id"],"variable":[{"key":"id","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:28:46 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa2959df8f8ae1-DEL"},{"key":"ETag","value":"W/\"44-dnpu+Z/ylfgArtPbVy+8LXbly7I\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"Post with post_id = 1 has deleted successfully\"\n}"}],"_postman_id":"6ee83dd4-4a70-48fd-8b2b-eb2fcb2cefb4"},{"name":"/api/posts/","event":[{"listen":"prerequest","script":{"id":"1a6e2cb5-dd50-4226-9f04-9ce207d35c1b","exec":[""],"type":"text/javascript"}}],"id":"ad9e3a91-fbb3-4972-a750-8d86d9ab9c96","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\n    \"keyword\": \"pg\",\n    \"textSearch\": \"sql\",\n    \"category\": \"DBMS\",\n    \"userId\": null,\n    \"orderBy\": \"mostRecent\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts","description":"<p>Returns a list of all blog posts with all the filters(Keyword, Text Search, Category, Posts of a specific user) and ordering(Most Liked, Most Disliked, Most Recent).</p>\n<p>In <strong>keyword:</strong> search by partial/complete keyword.<br />In <strong>textSearch</strong> : search by partial/complete title of the post.<br />In <strong>category</strong>: search by case sensitive and complete category name of the post.<br />In <strong>userId:</strong> search by userID of any user.<br />In <strong>orderBy</strong>: sort posts according to 'mostLiked' , 'mostDisliked' and 'mostRecent' basis.</p>\n","urlObject":{"protocol":"https","path":["api","posts"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"a9f337d1-ac1d-4bae-b880-37b8ad7d7fdc","name":"/api/posts/","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\n    \"keyword\": \"pg\",\n    \"textSearch\": \"sql\",\n    \"category\": \"DBMS\",\n    \"userId\": null,\n    \"orderBy\": \"mostRecent\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/posts"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:47:02 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa44190f221c5b-DEL"},{"key":"ETag","value":"W/\"49d-+UoLL9RO4LANPvpMWG9fi5GoZxc\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"posts\": [\n        {\n            \"post_id\": 4,\n            \"user_id\": 2,\n            \"title\": \"PostgreSQL\",\n            \"content\": \"PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.L\",\n            \"category\": \"DBMS\",\n            \"keywords\": \"[\\\"PG\\\",\\\"Postgre\\\"]\",\n            \"created_at\": \"2022-12-26T15:46:46.357+05:30\",\n            \"likes\": 0,\n            \"dislikes\": 0\n        },\n        {\n            \"post_id\": 3,\n            \"user_id\": 2,\n            \"title\": \"PostgreSQL\",\n            \"content\": \"PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.L\",\n            \"category\": \"DBMS\",\n            \"keywords\": \"[\\\"PG\\\",\\\"Postgre\\\"]\",\n            \"created_at\": \"2022-12-26T14:16:24.014+05:30\",\n            \"likes\": 0,\n            \"dislikes\": 0\n        },\n        {\n            \"post_id\": 5,\n            \"user_id\": 2,\n            \"title\": \"PostgreSQL\",\n            \"content\": \"PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.L\",\n            \"category\": \"DBMS\",\n            \"keywords\": \"[\\\"PG\\\",\\\"Postgre\\\"]\",\n            \"created_at\": \"2022-12-26T13:24:56.485+00:00\",\n            \"likes\": 0,\n            \"dislikes\": 0\n        }\n    ]\n}"}],"_postman_id":"ad9e3a91-fbb3-4972-a750-8d86d9ab9c96"},{"name":"/api/like/:id","event":[{"listen":"prerequest","script":{"id":"27b8f6c9-1294-4438-99a5-1bbce95844ba","exec":[""],"type":"text/javascript"}}],"id":"b47b6cf5-9a7f-41fd-8957-88de2d1032fc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/like/:id","description":"<p>Allows a user to like a post.</p>\n","urlObject":{"protocol":"https","path":["api","like",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"2","key":"id"}]}},"response":[{"id":"9abe269d-78b8-4bc9-ba6b-5307844806db","name":"/api/like/:id","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/like/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","like",":id"],"variable":[{"key":"id","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:33:45 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa30a74d168ae1-DEL"},{"key":"ETag","value":"W/\"1f-XyUjQ1tuYax9QxB3n/hfnmzuizA\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"👍 Done\"\n}"}],"_postman_id":"b47b6cf5-9a7f-41fd-8957-88de2d1032fc"},{"name":"/api/dislike/:id","event":[{"listen":"prerequest","script":{"id":"27b8f6c9-1294-4438-99a5-1bbce95844ba","exec":[""],"type":"text/javascript"}}],"id":"0227f13b-201c-49e7-886b-dc3888f47678","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/dislike/:id","description":"<p>Allows a user dislike a post.</p>\n","urlObject":{"protocol":"https","path":["api","dislike",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"2","key":"id"}]}},"response":[{"id":"e5aaee79-ec88-4f55-bf41-9f9323bf40f2","name":"/api/dislike/:id","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/dislike/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","dislike",":id"],"variable":[{"key":"id","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:33:52 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa30cfcfa38ae1-DEL"},{"key":"ETag","value":"W/\"1f-Vk/jbTrC4/WaAg7/7kGZgga9Kd4\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"👎 Done\"\n}"}],"_postman_id":"0227f13b-201c-49e7-886b-dc3888f47678"}],"id":"83635608-4509-4682-bfc0-567730d11b8e","description":"<p>Post APIs allow the user to do CURD operations with posts and post contents</p>\n","_postman_id":"83635608-4509-4682-bfc0-567730d11b8e"},{"name":"Comments APIs","item":[{"name":"/api/comment","id":"d57cb58e-28ae-409b-8fe2-f3ba7bf98fe4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n   \"post_id\": 2,\n   \"user_id\": 1,\n   \"comment\": \"TEXT NOT NULL\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/comment","description":"<p>Allows a user to leave a comment on a blog post by sending a POST request with the necessary comment data (e.g., content, post ID).</p>\n","urlObject":{"protocol":"https","path":["api","comment"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"bf62f507-0693-437c-a7f6-cc88fea08fb9","name":"/api/comment","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n   \"post_id\": 2,\n   \"user_id\": 1,\n   \"comment\": \"TEXT NOT NULL\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/comment"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:35:23 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa33088b3a8ae1-DEL"},{"key":"ETag","value":"W/\"80-AQ6XZZ48P9J4Yj6TuBaeGvbewnk\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"New comment have been created\",\n    \"details\": {\n        \"comment_id\": 7,\n        \"post_id\": 2,\n        \"user_id\": 1,\n        \"comment\": \"TEXT NOT NULL\"\n    }\n}"}],"_postman_id":"d57cb58e-28ae-409b-8fe2-f3ba7bf98fe4"},{"name":"/api/comment/:id","id":"ef7cbc35-b29b-473d-9466-b0e914b48d45","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/comment/:id","description":"<p>Returns a specific comment by its ID.</p>\n","urlObject":{"protocol":"https","path":["api","comment",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"4","key":"id"}]}},"response":[{"id":"e99345bb-b00c-4ab4-89c6-4c584bcefc92","name":"/api/comment/:id","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/comment/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","comment",":id"],"variable":[{"key":"id","value":"4"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:35:33 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa33490a0f8ae1-DEL"},{"key":"ETag","value":"W/\"5a-x9ApXSz1e1VMAjiIVFSd4Ns+21o\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"comment\": {\n        \"comment_id\": 4,\n        \"post_id\": 2,\n        \"user_id\": 1,\n        \"comment\": \"TEXT NOT NULL\"\n    }\n}"}],"_postman_id":"ef7cbc35-b29b-473d-9466-b0e914b48d45"},{"name":"/api/comment/all/:id","id":"c37d6a09-04d2-4341-8386-45b2fb68176b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/comment/all/:id","description":"<p>Returns a list of all comments of specific post, by using its postID.</p>\n","urlObject":{"protocol":"https","path":["api","comment","all",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"2","key":"id"}]}},"response":[{"id":"8cb2366d-29e0-485c-91f0-798075ae16a5","name":"/api/comment/all/:id","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/comment/all/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","comment","all",":id"],"variable":[{"key":"id","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:35:44 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa338ccfc18ae1-DEL"},{"key":"ETag","value":"W/\"126-SC+p0hrZqLOFua6CUDlNcWJBMDM\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"comments\": [\n        {\n            \"comment_id\": 4,\n            \"post_id\": 2,\n            \"user_id\": 1,\n            \"comment\": \"TEXT NOT NULL\"\n        },\n        {\n            \"comment_id\": 5,\n            \"post_id\": 2,\n            \"user_id\": 1,\n            \"comment\": \"TEXT NOT NULL\"\n        },\n        {\n            \"comment_id\": 6,\n            \"post_id\": 2,\n            \"user_id\": 1,\n            \"comment\": \"TEXT NOT NULL\"\n        },\n        {\n            \"comment_id\": 7,\n            \"post_id\": 2,\n            \"user_id\": 1,\n            \"comment\": \"TEXT NOT NULL\"\n        }\n    ]\n}"}],"_postman_id":"c37d6a09-04d2-4341-8386-45b2fb68176b"},{"name":"/api/comment/:id","id":"2ef0c275-24b3-46b3-8ba2-5a9a18e5790d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"newComment\": \"TEXT NOT NULL\"\n}","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/comment/:id","description":"<p>Allows a user to update an existing comment by sending a PUT request with the updated comment data.</p>\n","urlObject":{"protocol":"https","path":["api","comment",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"type":"any","value":"3","key":"id"}]}},"response":[{"id":"da1174f5-921c-43f3-8f3c-db96f35791f0","name":"/api/comment/:id","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"newComment\": \"TEXT NOT NULL\"\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/comment/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","comment",":id"],"variable":[{"key":"id","value":"3"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:35:53 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa33c6b96f8ae1-DEL"},{"key":"ETag","value":"W/\"3a-Guv2UFKxt7dBMdPAh4w/+/PK2So\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"Comment id = 3 have been updated🎉\"\n}"}],"_postman_id":"2ef0c275-24b3-46b3-8ba2-5a9a18e5790d"},{"name":"/api/comment/:id","id":"fbaa6a2e-7d60-4187-a824-96681c1df8e3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://postgre-apis-app.onrender.com/api/comment/:id","description":"<p>Allows a user to delete a comment by sending a DELETE request and specifying the comment ID in the URL.</p>\n","urlObject":{"protocol":"https","path":["api","comment",":id"],"host":["postgre-apis-app","onrender","com"],"query":[],"variable":[{"id":"36c4f207-a7e7-4a88-a351-1239edce1448","type":"any","value":"3","key":"id"}]}},"response":[{"id":"ddd1f88e-b95a-4e9b-a9e2-1b32b05863e2","name":"/api/comment/:id","originalRequest":{"method":"DELETE","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":{"raw":"https://postgre-apis-app.onrender.com/api/comment/:id","protocol":"https","host":["postgre-apis-app","onrender","com"],"path":["api","comment",":id"],"variable":[{"id":"36c4f207-a7e7-4a88-a351-1239edce1448","key":"id","value":"3"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 26 Dec 2022 13:36:13 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"77fa3444a98f8ae1-DEL"},{"key":"ETag","value":"W/\"44-4j8/C0M+6gg1Xi9gnHYy50bBjmM\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n    \"done\": true,\n    \"msg\": \"Post with post_id = 3 has deleted successfully\"\n}"}],"_postman_id":"fbaa6a2e-7d60-4187-a824-96681c1df8e3"}],"id":"4ea947a4-1a0e-4001-9b5b-3139eaa9f8b0","description":"<p>Comment APIs allow the user to do CURD operations with comments with a post.</p>\n","_postman_id":"4ea947a4-1a0e-4001-9b5b-3139eaa9f8b0"}]}