This repo allows users to dynamically create databases. It consists of the following API:-
-
POST http://{url}/api/createSchema INPUT: {
"tableName":"TABLENAME", "columns":[
{
"name":"first_name", "type":"char", "arguments":["20"], "unique":true }, {
"name":"last_name", "type":"char", "arguments":["20"] }, {
"name":"address", "type":"varchar", "arguments":["200"] }, {
"name":"pincode", "type":"integer", "default":"323131" } ] } -
GET http://{url}/api/listSchema
-
DELETE http://{url}/api/{schemaname}/dropSchema
-
POST http://{url}/api/{schemaname}/add-data INPUT: {
"first_name" : "ABC", "last_name" : "XYZ", "address" : "abcd efgh ijkl mnop", "pincode" : 564321 } -
GET http://{url}/api/{schemaname}/get-data
-
POST http://{url}/api/{schemaname}/update-data INPUT: {
"id":1, "content":{
"first_name" : "ABCDEF", "last_name" : "XYZ123", "address" : "abcd efgh ijkl mnop qrst", "pincode" : 698756 } } -
DELETE http://{url}/api/{schemaname}/delete-data