import api from "../api";

const database={

list:()=>api.get("/api/database"),

tables:()=>api.get("/api/database/tables"),

schema:(table)=>api.get(`/api/database/schema/${table}`),

query:(sql)=>api.post("/api/database/query",{sql}),

insert:(table,data)=>api.post(`/api/database/${table}`,data),

update:(table,id,data)=>api.put(`/api/database/${table}/${id}`,data),

remove:(table,id)=>api.delete(`/api/database/${table}/${id}`),

backup:()=>api.post("/api/database/backup"),

restore:(file)=>api.post("/api/database/restore",file)

};

export default database;