2021-01-02 14:46:27 +01:00
|
|
|
<template>
|
|
|
|
<BaseContextMenu
|
|
|
|
:context-event="contextEvent"
|
|
|
|
@close-context="closeContext"
|
|
|
|
>
|
|
|
|
<div
|
2022-06-14 20:02:17 +02:00
|
|
|
v-if="['procedure', 'routine', 'function'].includes(selectedMisc.type)"
|
2021-02-25 17:43:23 +01:00
|
|
|
class="context-element"
|
|
|
|
@click="runElementCheck"
|
2021-01-02 14:46:27 +01:00
|
|
|
>
|
2023-09-17 18:49:37 +02:00
|
|
|
<span class="d-flex">
|
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiPlay"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.run') }}</span>
|
2021-01-02 14:46:27 +01:00
|
|
|
</div>
|
2021-11-04 21:54:42 +01:00
|
|
|
<div
|
|
|
|
v-if="selectedMisc.type === 'trigger' && customizations.triggerEnableDisable"
|
|
|
|
class="context-element"
|
|
|
|
@click="toggleTrigger"
|
|
|
|
>
|
|
|
|
<span v-if="!selectedMisc.enabled" class="d-flex">
|
2023-09-17 18:49:37 +02:00
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiPlay"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.enable') }}
|
2021-11-04 21:54:42 +01:00
|
|
|
</span>
|
|
|
|
<span v-else class="d-flex">
|
2023-09-17 18:49:37 +02:00
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiPause"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.disable') }}
|
2021-11-04 21:54:42 +01:00
|
|
|
</span>
|
|
|
|
</div>
|
2021-11-06 12:21:33 +01:00
|
|
|
<div
|
|
|
|
v-if="selectedMisc.type === 'scheduler'"
|
|
|
|
class="context-element"
|
|
|
|
@click="toggleScheduler"
|
|
|
|
>
|
|
|
|
<span v-if="!selectedMisc.enabled" class="d-flex">
|
2023-09-17 18:49:37 +02:00
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiPlay"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.enable') }}
|
2021-11-06 12:21:33 +01:00
|
|
|
</span>
|
|
|
|
<span v-else class="d-flex">
|
2023-09-17 18:49:37 +02:00
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiPause"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.disable') }}
|
2021-11-06 12:21:33 +01:00
|
|
|
</span>
|
|
|
|
</div>
|
2023-11-29 18:15:22 +01:00
|
|
|
<div class="context-element" @click="copyName(selectedMisc.name)">
|
|
|
|
<span class="d-flex">
|
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiContentCopy"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.copyName') }}</span>
|
|
|
|
</div>
|
2021-01-02 14:46:27 +01:00
|
|
|
<div class="context-element" @click="showDeleteModal">
|
2023-09-17 18:49:37 +02:00
|
|
|
<span class="d-flex">
|
|
|
|
<BaseIcon
|
|
|
|
class="text-light mt-1 mr-1"
|
|
|
|
icon-name="mdiTableRemove"
|
|
|
|
:size="18"
|
|
|
|
/> {{ t('general.delete') }}</span>
|
2021-01-02 14:46:27 +01:00
|
|
|
</div>
|
|
|
|
<ConfirmModal
|
|
|
|
v-if="isDeleteModal"
|
|
|
|
@confirm="deleteMisc"
|
|
|
|
@hide="hideDeleteModal"
|
|
|
|
>
|
2021-12-10 17:34:44 +01:00
|
|
|
<template #header>
|
2021-01-02 14:46:27 +01:00
|
|
|
<div class="d-flex">
|
2023-09-17 18:49:37 +02:00
|
|
|
<BaseIcon
|
|
|
|
class="text-light mr-1"
|
|
|
|
icon-name="mdiDelete"
|
|
|
|
:size="24"
|
|
|
|
/>
|
2021-06-13 11:16:21 +02:00
|
|
|
<span class="cut-text">{{ deleteMessage }}</span>
|
2021-01-02 14:46:27 +01:00
|
|
|
</div>
|
|
|
|
</template>
|
2021-12-10 17:34:44 +01:00
|
|
|
<template #body>
|
2021-01-02 14:46:27 +01:00
|
|
|
<div class="mb-2">
|
2023-08-03 18:28:50 +02:00
|
|
|
{{ t('general.deleteConfirm') }} "<b>{{ selectedMisc.name }}</b>"?
|
2021-01-02 14:46:27 +01:00
|
|
|
</div>
|
2021-12-10 17:34:44 +01:00
|
|
|
</template>
|
2021-01-02 14:46:27 +01:00
|
|
|
</ConfirmModal>
|
2021-02-25 17:43:23 +01:00
|
|
|
<ModalAskParameters
|
|
|
|
v-if="isAskingParameters"
|
2022-06-09 20:08:32 +02:00
|
|
|
:local-routine="(localElement as any)"
|
2021-04-10 20:38:46 +02:00
|
|
|
:client="workspace.client"
|
2021-02-25 17:43:23 +01:00
|
|
|
@confirm="runElement"
|
|
|
|
@close="hideAskParamsModal"
|
|
|
|
/>
|
2021-01-02 14:46:27 +01:00
|
|
|
</BaseContextMenu>
|
|
|
|
</template>
|
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
<script setup lang="ts">
|
2023-08-18 15:57:31 +02:00
|
|
|
import { EventInfos, FunctionInfos, IpcResponse, RoutineInfos, TriggerInfos } from 'common/interfaces/antares';
|
2022-06-09 20:08:32 +02:00
|
|
|
import { storeToRefs } from 'pinia';
|
2023-08-18 15:57:31 +02:00
|
|
|
import { computed, Prop, Ref, ref } from 'vue';
|
2022-06-09 20:08:32 +02:00
|
|
|
import { useI18n } from 'vue-i18n';
|
2023-08-18 15:57:31 +02:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
import ConfirmModal from '@/components/BaseConfirmModal.vue';
|
2023-08-18 15:57:31 +02:00
|
|
|
import BaseContextMenu from '@/components/BaseContextMenu.vue';
|
2023-09-17 18:49:37 +02:00
|
|
|
import BaseIcon from '@/components/BaseIcon.vue';
|
2022-06-09 20:08:32 +02:00
|
|
|
import ModalAskParameters from '@/components/ModalAskParameters.vue';
|
2021-01-10 18:40:19 +01:00
|
|
|
import Functions from '@/ipc-api/Functions';
|
2023-08-18 15:57:31 +02:00
|
|
|
import Routines from '@/ipc-api/Routines';
|
2021-01-14 18:11:36 +01:00
|
|
|
import Schedulers from '@/ipc-api/Schedulers';
|
2023-08-18 15:57:31 +02:00
|
|
|
import Triggers from '@/ipc-api/Triggers';
|
2023-11-29 18:15:22 +01:00
|
|
|
import { copyText } from '@/libs/copyText';
|
2023-08-18 15:57:31 +02:00
|
|
|
import { useNotificationsStore } from '@/stores/notifications';
|
|
|
|
import { useWorkspacesStore } from '@/stores/workspaces';
|
2021-01-02 14:46:27 +01:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
const { t } = useI18n();
|
2021-11-06 12:21:33 +01:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
const props = defineProps({
|
|
|
|
contextEvent: MouseEvent,
|
|
|
|
selectedMisc: Object as Prop<{ name:string; type:string; enabled?: boolean }>,
|
|
|
|
selectedSchema: String
|
|
|
|
});
|
2021-11-04 21:54:42 +01:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
const emit = defineEmits(['close-context', 'reload']);
|
2021-11-06 12:21:33 +01:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
const { addNotification } = useNotificationsStore();
|
|
|
|
const workspacesStore = useWorkspacesStore();
|
|
|
|
|
|
|
|
const { getSelected: selectedWorkspace } = storeToRefs(workspacesStore);
|
|
|
|
|
|
|
|
const {
|
|
|
|
getWorkspace,
|
|
|
|
addLoadingElement,
|
|
|
|
removeLoadingElement,
|
|
|
|
removeTabs,
|
|
|
|
newTab
|
|
|
|
} = workspacesStore;
|
|
|
|
|
|
|
|
const isDeleteModal = ref(false);
|
|
|
|
const isAskingParameters = ref(false);
|
|
|
|
const localElement: Ref<TriggerInfos | RoutineInfos | FunctionInfos | EventInfos> = ref(null);
|
|
|
|
|
|
|
|
const workspace = computed(() => {
|
|
|
|
return getWorkspace(selectedWorkspace.value);
|
|
|
|
});
|
|
|
|
|
|
|
|
const customizations = computed(() => {
|
|
|
|
return getWorkspace(selectedWorkspace.value).customizations;
|
|
|
|
});
|
|
|
|
|
|
|
|
const deleteMessage = computed(() => {
|
|
|
|
switch (props.selectedMisc.type) {
|
|
|
|
case 'trigger':
|
2023-08-03 18:28:50 +02:00
|
|
|
return t('database.deleteTrigger');
|
2023-09-17 18:49:37 +02:00
|
|
|
case 'routine':
|
2022-06-09 20:08:32 +02:00
|
|
|
case 'procedure':
|
2023-08-03 18:28:50 +02:00
|
|
|
return t('database.deleteRoutine');
|
2022-06-09 20:08:32 +02:00
|
|
|
case 'function':
|
|
|
|
case 'triggerFunction':
|
2023-08-03 18:28:50 +02:00
|
|
|
return t('database.deleteFunction');
|
2022-06-09 20:08:32 +02:00
|
|
|
case 'scheduler':
|
2023-08-03 18:28:50 +02:00
|
|
|
return t('database.deleteScheduler');
|
2022-06-09 20:08:32 +02:00
|
|
|
default:
|
|
|
|
return '';
|
|
|
|
}
|
|
|
|
});
|
|
|
|
|
2023-11-29 18:15:22 +01:00
|
|
|
const copyName = (name: string) => {
|
|
|
|
copyText(name);
|
|
|
|
closeContext();
|
|
|
|
};
|
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
const showDeleteModal = () => {
|
|
|
|
isDeleteModal.value = true;
|
|
|
|
};
|
|
|
|
|
|
|
|
const hideDeleteModal = () => {
|
|
|
|
isDeleteModal.value = false;
|
|
|
|
};
|
|
|
|
|
|
|
|
const showAskParamsModal = () => {
|
|
|
|
isAskingParameters.value = true;
|
|
|
|
};
|
|
|
|
|
|
|
|
const hideAskParamsModal = () => {
|
|
|
|
isAskingParameters.value = false;
|
|
|
|
closeContext();
|
|
|
|
};
|
2021-11-06 12:21:33 +01:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
const closeContext = () => {
|
|
|
|
emit('close-context');
|
|
|
|
};
|
|
|
|
|
|
|
|
const deleteMisc = async () => {
|
|
|
|
try {
|
2022-06-14 20:02:17 +02:00
|
|
|
let res: IpcResponse;
|
2022-06-09 20:08:32 +02:00
|
|
|
|
|
|
|
switch (props.selectedMisc.type) {
|
|
|
|
case 'trigger':
|
|
|
|
res = await Triggers.dropTrigger({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
trigger: props.selectedMisc.name
|
|
|
|
});
|
|
|
|
break;
|
2022-06-14 20:02:17 +02:00
|
|
|
case 'routine':
|
2022-06-09 20:08:32 +02:00
|
|
|
case 'procedure':
|
|
|
|
res = await Routines.dropRoutine({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
routine: props.selectedMisc.name
|
|
|
|
});
|
|
|
|
break;
|
|
|
|
case 'function':
|
|
|
|
case 'triggerFunction':
|
|
|
|
res = await Functions.dropFunction({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
func: props.selectedMisc.name
|
2021-11-06 12:21:33 +01:00
|
|
|
});
|
2022-06-09 20:08:32 +02:00
|
|
|
break;
|
|
|
|
case 'scheduler':
|
|
|
|
res = await Schedulers.dropScheduler({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
scheduler: props.selectedMisc.name
|
|
|
|
});
|
|
|
|
break;
|
|
|
|
}
|
|
|
|
|
|
|
|
const { status, response } = res;
|
2021-11-06 12:21:33 +01:00
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
if (status === 'success') {
|
|
|
|
removeTabs({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
elementName: props.selectedMisc.name,
|
|
|
|
elementType: props.selectedMisc.type,
|
|
|
|
schema: props.selectedSchema
|
2021-11-06 12:21:33 +01:00
|
|
|
});
|
|
|
|
|
2022-06-09 20:08:32 +02:00
|
|
|
closeContext();
|
|
|
|
emit('reload');
|
2021-01-02 14:46:27 +01:00
|
|
|
}
|
2022-06-09 20:08:32 +02:00
|
|
|
else
|
|
|
|
addNotification({ status: 'error', message: response });
|
|
|
|
}
|
|
|
|
catch (err) {
|
|
|
|
addNotification({ status: 'error', message: err.stack });
|
|
|
|
}
|
|
|
|
};
|
|
|
|
|
|
|
|
const runElementCheck = () => {
|
2022-06-14 20:02:17 +02:00
|
|
|
if (['procedure', 'routine'].includes(props.selectedMisc.type))
|
2022-06-09 20:08:32 +02:00
|
|
|
runRoutineCheck();
|
|
|
|
else if (props.selectedMisc.type === 'function')
|
|
|
|
runFunctionCheck();
|
|
|
|
};
|
|
|
|
|
|
|
|
const runElement = (params: string[]) => {
|
2022-09-07 18:18:15 +02:00
|
|
|
if (['procedure', 'routine'].includes(props.selectedMisc.type))
|
2022-06-09 20:08:32 +02:00
|
|
|
runRoutine(params);
|
|
|
|
else if (props.selectedMisc.type === 'function')
|
|
|
|
runFunction(params);
|
|
|
|
};
|
|
|
|
|
|
|
|
const runRoutineCheck = async () => {
|
|
|
|
const params = {
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
routine: props.selectedMisc.name
|
|
|
|
};
|
|
|
|
|
|
|
|
try {
|
|
|
|
const { status, response } = await Routines.getRoutineInformations(params);
|
|
|
|
if (status === 'success')
|
|
|
|
localElement.value = response;
|
|
|
|
|
|
|
|
else
|
|
|
|
addNotification({ status: 'error', message: response });
|
|
|
|
}
|
|
|
|
catch (err) {
|
|
|
|
addNotification({ status: 'error', message: err.stack });
|
|
|
|
}
|
|
|
|
|
|
|
|
if ((localElement.value as RoutineInfos).parameters.length)
|
|
|
|
showAskParamsModal();
|
|
|
|
else
|
|
|
|
runRoutine();
|
|
|
|
};
|
|
|
|
|
|
|
|
const runRoutine = (params?: string[]) => {
|
|
|
|
if (!params) params = [];
|
|
|
|
|
|
|
|
let sql;
|
|
|
|
switch (workspace.value.client) { // TODO: move in a better place
|
|
|
|
case 'maria':
|
|
|
|
case 'mysql':
|
|
|
|
case 'pg':
|
|
|
|
sql = `CALL ${localElement.value.name}(${params.join(',')})`;
|
|
|
|
break;
|
2022-11-17 15:27:39 +01:00
|
|
|
case 'firebird':
|
|
|
|
sql = `EXECUTE PROCEDURE "${localElement.value.name}"(${params.join(',')})`;
|
|
|
|
break;
|
2022-06-14 20:02:17 +02:00
|
|
|
// case 'mssql':
|
|
|
|
// sql = `EXEC ${localElement.value.name} ${params.join(',')}`;
|
|
|
|
// break;
|
2022-06-09 20:08:32 +02:00
|
|
|
default:
|
|
|
|
sql = `CALL \`${localElement.value.name}\`(${params.join(',')})`;
|
|
|
|
}
|
|
|
|
|
|
|
|
newTab({
|
|
|
|
uid: workspace.value.uid,
|
|
|
|
content: sql,
|
|
|
|
type: 'query',
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
autorun: true
|
|
|
|
});
|
|
|
|
closeContext();
|
|
|
|
};
|
|
|
|
|
|
|
|
const runFunctionCheck = async () => {
|
|
|
|
const params = {
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
func: props.selectedMisc.name
|
|
|
|
};
|
|
|
|
|
|
|
|
try {
|
|
|
|
const { status, response } = await Functions.getFunctionInformations(params);
|
|
|
|
if (status === 'success')
|
|
|
|
localElement.value = response;
|
|
|
|
else
|
|
|
|
addNotification({ status: 'error', message: response });
|
|
|
|
}
|
|
|
|
catch (err) {
|
|
|
|
addNotification({ status: 'error', message: err.stack });
|
|
|
|
}
|
|
|
|
|
|
|
|
if ((localElement.value as FunctionInfos).parameters.length)
|
|
|
|
showAskParamsModal();
|
|
|
|
else
|
|
|
|
runFunction();
|
|
|
|
};
|
|
|
|
|
|
|
|
const runFunction = (params?: string[]) => {
|
|
|
|
if (!params) params = [];
|
|
|
|
|
|
|
|
let sql;
|
|
|
|
switch (workspace.value.client) { // TODO: move in a better place
|
|
|
|
case 'maria':
|
|
|
|
case 'mysql':
|
|
|
|
sql = `SELECT \`${localElement.value.name}\` (${params.join(',')})`;
|
|
|
|
break;
|
|
|
|
case 'pg':
|
|
|
|
sql = `SELECT ${localElement.value.name}(${params.join(',')})`;
|
|
|
|
break;
|
2022-06-14 20:02:17 +02:00
|
|
|
// case 'mssql':
|
|
|
|
// sql = `SELECT ${localElement.value.name} ${params.join(',')}`;
|
|
|
|
// break;
|
2022-06-09 20:08:32 +02:00
|
|
|
default:
|
|
|
|
sql = `SELECT \`${localElement.value.name}\` (${params.join(',')})`;
|
|
|
|
}
|
|
|
|
|
|
|
|
newTab({
|
|
|
|
uid: workspace.value.uid,
|
|
|
|
content: sql,
|
|
|
|
type: 'query',
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
autorun: true
|
|
|
|
});
|
|
|
|
closeContext();
|
|
|
|
};
|
|
|
|
|
|
|
|
const toggleTrigger = async () => {
|
|
|
|
addLoadingElement({
|
|
|
|
name: props.selectedMisc.name,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
type: 'trigger'
|
|
|
|
});
|
|
|
|
|
|
|
|
try {
|
|
|
|
const { status, response } = await Triggers.toggleTrigger({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
trigger: props.selectedMisc.name,
|
|
|
|
enabled: props.selectedMisc.enabled
|
|
|
|
});
|
|
|
|
|
|
|
|
if (status !== 'success')
|
|
|
|
addNotification({ status: 'error', message: response });
|
2021-01-02 14:46:27 +01:00
|
|
|
}
|
2022-06-09 20:08:32 +02:00
|
|
|
catch (err) {
|
|
|
|
addNotification({ status: 'error', message: err.stack });
|
|
|
|
}
|
|
|
|
|
|
|
|
removeLoadingElement({
|
|
|
|
name: props.selectedMisc.name,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
type: 'trigger'
|
|
|
|
});
|
|
|
|
|
|
|
|
closeContext();
|
|
|
|
emit('reload');
|
|
|
|
};
|
|
|
|
|
|
|
|
const toggleScheduler = async () => {
|
|
|
|
addLoadingElement({
|
|
|
|
name: props.selectedMisc.name,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
type: 'scheduler'
|
|
|
|
});
|
|
|
|
|
|
|
|
try {
|
|
|
|
const { status, response } = await Schedulers.toggleScheduler({
|
|
|
|
uid: selectedWorkspace.value,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
scheduler: props.selectedMisc.name,
|
|
|
|
enabled: props.selectedMisc.enabled
|
|
|
|
});
|
|
|
|
|
|
|
|
if (status !== 'success')
|
|
|
|
addNotification({ status: 'error', message: response });
|
|
|
|
}
|
|
|
|
catch (err) {
|
|
|
|
addNotification({ status: 'error', message: err.stack });
|
|
|
|
}
|
|
|
|
|
|
|
|
removeLoadingElement({
|
|
|
|
name: props.selectedMisc.name,
|
|
|
|
schema: props.selectedSchema,
|
|
|
|
type: 'scheduler'
|
|
|
|
});
|
|
|
|
|
|
|
|
closeContext();
|
|
|
|
emit('reload');
|
2021-01-02 14:46:27 +01:00
|
|
|
};
|
|
|
|
</script>
|