xg_total_process_master_cloud_vue/src/api/database/dataTableService.js

import request from "@/utils/httpRequest";
import { SYS_PATH as prefix } from "../AppPath";

export default {
	executeSql: function (tableName, dataSourceId) {
		return request({
			url:
				prefix +
				`/database/table/executeSql/${tableName}?dataSourceId=${dataSourceId}`,
			method: "get",
		});
	},

	save: function (inputForm) {
		return request({
			url: prefix + "/gen/genTable/saveTableFromDB",
			method: "post",
			data: inputForm,
		});
	},

	queryAlter: function (dataSourceId, tableName) {
		return request({
			url: prefix + "/database/table/alter",
			method: "get",
			params: { dataSourceId: dataSourceId, name: tableName },
		});
	},

	submitAlter: function (inputForm) {
		return request({
			url: prefix + "/database/table/alter/do",
			method: "post",
			data: inputForm,
		});
	},

	queryCreate: function (dataSourceId) {
		return request({
			url: prefix + "/database/table/create",
			method: "get",
			params: { dataSourceId: dataSourceId },
		});
	},

	export: function (dataSourceId) {
		return request({
			url: prefix + "/database/table/export",
			method: "get",
			params: { dataSourceId: dataSourceId },
			responseType: "blob",
		});
	},

	submitCreate: function (inputForm) {
		return request({
			url: prefix + "/database/table/create/do",
			method: "post",
			data: inputForm,
		});
	},

	list: function (params) {
		return request({
			url: prefix + "/database/table/list",
			method: "get",
			params: params,
		});
	},

	drop: function (tableName, dataSourceId) {
		return request({
			url: prefix + "/database/table/drop",
			method: "delete",
			params: { tableName: tableName, dataSourceId: dataSourceId },
		});
	},
};