{"info":{"_postman_id":"fdcf7db2-7992-4286-9314-55d7cb4678b6","name":"DJDYNATABLE","description":"<html><head></head><body><ul>\n<li>The&nbsp;<em><strong>djdynatable</strong></em>&nbsp;library provides a convenient and flexible way to work with dynamic tables in your Django application. It allows you to create tables programmatically, add columns, modify existing tables, and perform other operations without the need for complex migrations or model definitions. However you can create tables on-the-fly based on user input or other dynamic factors.</li>\n</ul>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"11858287","collectionId":"fdcf7db2-7992-4286-9314-55d7cb4678b6","publishedId":"2sA3QqhYYp","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2024-05-26T15:54:09.000Z"},"item":[{"name":"TABLES","item":[{"name":"GET TABLE","id":"bfe7c9f9-b613-4338-ad11-d3d8ef97b2df","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://127.0.0.1:8000/api/table/?table_name=mytable","description":"<p>to get the columns and rows for that table name</p>\n","urlObject":{"protocol":"http","port":"8000","path":["api","table",""],"host":["127","0","0","1"],"query":[{"key":"table_name","value":"mytable"}],"variable":[]}},"response":[],"_postman_id":"bfe7c9f9-b613-4338-ad11-d3d8ef97b2df"},{"name":"CREATE TABLE","id":"b57c0709-dd77-4c6c-b8c5-6f746f45f492","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n   \"tblname\":\"customer_details\",\n   \"columns\":[\n      {\n         \"colname\":\"username\",\n         \"coltype\":\"string\"\n      }\n   ]\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/api/table/","description":"<p>to create a table , followed by table name and column name with column type</p>\n","urlObject":{"protocol":"http","port":"8000","path":["api","table",""],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[],"_postman_id":"b57c0709-dd77-4c6c-b8c5-6f746f45f492"},{"name":"CREATE ROW","id":"48688af4-b461-49c4-9bc0-842b8c61437c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n   \"username\": \"Jerome jack\"\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/api/row/mytable/","description":"<p>to create a row record in that table for that column</p>\n","urlObject":{"protocol":"http","port":"8000","path":["api","row","mytable",""],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[],"_postman_id":"48688af4-b461-49c4-9bc0-842b8c61437c"},{"name":"Add column","id":"a39ba845-16e1-48a4-a2db-b6768df3112e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"change\": \"add\",\n   \"colname\": \"phone_number\",\n   \"coltype\": \"string\"\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/api/table/customer_details/","description":"<p>adding a new column to the table</p>\n","urlObject":{"protocol":"http","port":"8000","path":["api","table","customer_details",""],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[],"_postman_id":"a39ba845-16e1-48a4-a2db-b6768df3112e"},{"name":"remove column","id":"9b002a2b-1f1c-43b4-b333-265646a2ea59","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"change\": \"remove\",\n   \"colname\": \"phone_number\",\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/api/table/customer_details/","description":"<p>removing the column from the table</p>\n","urlObject":{"protocol":"http","port":"8000","path":["api","table","customer_details",""],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[],"_postman_id":"9b002a2b-1f1c-43b4-b333-265646a2ea59"},{"name":"rename column","id":"6c3adf50-bc2d-473d-88f9-f61ef95851e6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n   \"change\": \"alter\",\n   \"oldcolname\": \"phone_number\",\n   \"colname\": \"email_id\",\n   \"coltype\": \"string\"\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/api/table/customer_details/","description":"<p>renaming the column name from old to new</p>\n","urlObject":{"protocol":"http","port":"8000","path":["api","table","customer_details",""],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[],"_postman_id":"6c3adf50-bc2d-473d-88f9-f61ef95851e6"}],"id":"9f1e1798-e084-479c-a6ac-8539c1ebd36d","description":"<p>holds the api for table CRUD's</p>\n","_postman_id":"9f1e1798-e084-479c-a6ac-8539c1ebd36d"}]}