dynamicDBService.ts

import api from "@/services/api";

export interface ColumnReq {
    name: string;
    type: string;
}

export interface DDLTableReq {
    table_name: string;
    columns: ColumnReq[];
}

export const dynamicDBService = {
    createTable: async (projectId: number, data: DDLTableReq) => {
        const response = await api.post(`/protected/project/manage/table/create/${projectId}`, data);
        return response.data;
    },

    addColumn: async (projectId: number, tableId: number, data: DDLTableReq) => {
        const response = await api.post(`/protected/project/manage/table/create/col/${projectId}/${tableId}`, data);
        return response.data;
    },

    getTables: async (projectId: number): Promise<DynTableDef[]> => {
        const response = await api.get(`/protected/project/${projectId}/tables`);
        return response.data.data;
    },

    deleteTable: async (projectId: number, tableId: number) => {
        const response = await api.delete(`/protected/project/manage/table/drop/${projectId}/${tableId}`, {
            data: {
                project_id: projectId,
                table_id: tableId
            }
        });
        return response.data;
    }
};

export interface DynColDef {
    id: number;
    dyn_table_def_id: number;
    name: string;
    data_type: string;
}

export interface DynTableDef {
    id: number;
    project_id: number;
    name: string;
    alias: string;
    columns: DynColDef[];
}