{"info":{"_postman_id":"b0b998b7-700d-8a61-700c-d6c25b707cbf","name":"Anton","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"<html><head></head><body></body></html>","owner":"2128082","collectionId":"b0b998b7-700d-8a61-700c-d6c25b707cbf","publishedId":"6thxg7i","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2017-09-24T04:42:28.000Z"},"item":[{"name":"Schema","item":[{"name":"Create Schema","id":"19859ed2-36b4-5a53-4876-5e0a15d49877","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"schema_name\"\n}"},"url":"localhost/api/create-schema","description":"<p>Create a new schema</p>\n","urlObject":{"path":["api","create-schema"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"19859ed2-36b4-5a53-4876-5e0a15d49877"},{"name":"Drop Schema","id":"802182b9-77fa-890b-9f39-dd9df80408a2","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"schema_name\"\n}"},"url":"localhost/api/drop-schema","description":"<p>Drop a schema</p>\n","urlObject":{"path":["api","drop-schema"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"802182b9-77fa-890b-9f39-dd9df80408a2"},{"name":"Get Schemas","id":"635f7e0e-b6dd-7d6a-f06e-3bfafc6d839e","request":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[]},"url":"localhost/api/get-schemas","description":"<p>Get list of schemas</p>\n<p>Returns:</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n    code: xxx,\n    data: [\n        schema1,\n        schema2,\n        ...\n    ]\n}\n</code></pre>\n","urlObject":{"path":["api","get-schemas"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"635f7e0e-b6dd-7d6a-f06e-3bfafc6d839e"},{"name":"Rename Schema","id":"11f52181-ad51-cc87-4489-1bbac0b12f4b","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"old_schema_name\",\n\t\"new_name\": \"new_schema_name\"\n}"},"url":"localhost/api/rename-schema","description":"<p>Rename a schema</p>\n","urlObject":{"path":["api","rename-schema"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"11f52181-ad51-cc87-4489-1bbac0b12f4b"}],"id":"d7c390e4-63c0-4ff1-e787-4db26f70a68b","description":"<p>Schema requests</p>\n","_postman_id":"d7c390e4-63c0-4ff1-e787-4db26f70a68b"},{"name":"Table","item":[{"name":"Get Table Data","id":"636e7ff6-827d-bbc3-2b17-59e82b1c531c","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"table\": \"table_name\",\n\t\"schema\": \"schema_name\"\n}"},"url":"localhost/api/get-table-data","description":"<p>Get table data with table headers</p>\n<p>Returns</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n    code: xxx,\n    data: {\n        headers:[\n            \"colname1\",\n            \"colname2\",\n            ...\n        ],\n        values:[\n            [\n                row1col1val,\n                row1col2val,\n                ...\n            ],\n            [\n                row2col1val,\n                row2col2val,\n                ...\n            ],\n            ...\n        ]\n    }\n}\n</code></pre>\n","urlObject":{"path":["api","get-table-data"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"636e7ff6-827d-bbc3-2b17-59e82b1c531c"},{"name":"Get Table Info","id":"9debd821-34b4-56a9-c8af-a5d95e56479d","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"table\": \"table_name\",\n\t\"schema\": \"schema_name\"\n}"},"url":"localhost/api/get-table-info","description":"<p>Returns column names with attributes like data-type, nullable and default</p>\n<p>Returns</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n    code: xxx,\n    data: {\n        columns:[{\n            default: default_val,\n            name: column_name,\n            nullable: YES/NO,\n            type: data type\n        },{\n            ...\n        }\n        ],\n        schema: schema_name,\n        table: table_name\n    }\n}\n</code></pre>\n","urlObject":{"path":["api","get-table-info"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"9debd821-34b4-56a9-c8af-a5d95e56479d"},{"name":"Get Tables","id":"0515eb9f-9c50-2569-7cc3-839ce27a5d70","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"schema_name\"\n}"},"url":"localhost/api/get-tables","description":"<p>Get list of tables in a schema </p>\n<p>Returns:</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n    code: xxx,\n    data: [\n        table1,\n        table2,\n        ...\n    ]\n}\n</code></pre>\n","urlObject":{"path":["api","get-tables"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"0515eb9f-9c50-2569-7cc3-839ce27a5d70"},{"name":"Rename Table","id":"c3797149-cc5c-6faa-7bc4-4eb322b8a4f2","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"public\",\n\t\"table\": \"table_name\",\n\t\"new_name\": \"new_name\"\n}"},"url":"localhost/api/rename-table","description":"<p>Renames a table in a schema</p>\n","urlObject":{"path":["api","rename-table"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"c3797149-cc5c-6faa-7bc4-4eb322b8a4f2"},{"name":"Drop Table","id":"28370097-7198-012a-f96f-63496accb65c","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"schema_name\",\n\t\"table\": \"table_name\"\n}"},"url":"localhost/api/drop-table","description":"<p>Drop an existing table</p>\n","urlObject":{"path":["api","drop-table"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"28370097-7198-012a-f96f-63496accb65c"}],"id":"99c91ac8-a535-b7a6-85e7-a7ca6c10a30d","description":"<p>Table requests</p>\n","_postman_id":"99c91ac8-a535-b7a6-85e7-a7ca6c10a30d"},{"name":"Auth","item":[{"name":"Login","id":"64f7a75d-bbe5-abf9-3544-961a3fdc056f","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"username\": \"postgres\",\n\t\"password\": \"password\",\n\t\"host\": \"localhost\",\n\t\"port\": 5432\n}"},"url":"localhost/api/login","description":"<p>Login to Anton</p>\n","urlObject":{"path":["api","login"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"64f7a75d-bbe5-abf9-3544-961a3fdc056f"},{"name":"Logout","id":"4ade2e65-836a-71e9-13e1-20ce75d97aaf","request":{"method":"POST","header":[],"body":{"mode":"raw","raw":""},"url":"localhost/api/logout","description":"<p>Logs you out from Anton</p>\n","urlObject":{"path":["api","logout"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"4ade2e65-836a-71e9-13e1-20ce75d97aaf"}],"id":"7b4b4e74-4c65-2752-8f2f-c4148ce3fd62","description":"<p>Authorization</p>\n","_postman_id":"7b4b4e74-4c65-2752-8f2f-c4148ce3fd62"},{"name":"Migration","item":[{"name":"Export Table","id":"9cf114d7-1103-30e6-1ac3-86a378f8af83","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"table\":\"table_name\",\n\t\"schema\": \"schema_name\"\n}"},"url":"localhost/api/export-table","description":"<p>Export a table. Requires table name and schema name.</p>\n","urlObject":{"path":["api","export-table"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"9cf114d7-1103-30e6-1ac3-86a378f8af83"},{"name":"Import Table","id":"dec07696-cef1-c7c0-d8ec-ebce4d89f7b5","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"schema_name\",\n\t\"table\": \"table_name\",\n\t\"data\": {\n\t\t\"_comment\": \"insert data from export in this data section\"\t\t\t\n\t}\n}"},"url":"localhost/api/import-table","description":"<p>Import data using schema name, table name and the export data</p>\n","urlObject":{"path":["api","import-table"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"dec07696-cef1-c7c0-d8ec-ebce4d89f7b5"}],"id":"a045ef92-5cb4-9e16-0049-93d793aeddb3","_postman_id":"a045ef92-5cb4-9e16-0049-93d793aeddb3","description":""},{"name":"Raw SQL","id":"b168d17f-847b-c78c-9a89-eb7173386338","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"query\": \"SELECT * FROM test\"\n}"},"url":"localhost/api/raw-sql","description":"<p>Execute raw SQL with this</p>\n","urlObject":{"path":["api","raw-sql"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"b168d17f-847b-c78c-9a89-eb7173386338"}]}