index.vue
5.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
<template>
<div class="DbCopy-container app-container nohead NCC-flex-main">
<el-alert title="温馨提示：数据同步是由A数据库同步到B数据库，必须确保数据库表结构一致否则会同步失败。" type="warning" :closable="false"
show-icon class="mb-20">
</el-alert>
<el-form ref="dataForm" :model="dataForm" label-width="140px" :rules="dataRule"
@submit.native.prevent class="mt-10">
<el-form-item label="数据库连接 From" prop="dbConnectionFrom">
<el-select v-model="dataForm.dbConnectionFrom" placeholder="请选择连接">
<el-option-group v-for="group in dbOptions" :key="group.fullName" :label="group.fullName">
<el-option v-for="item in group.children" :key="item.id" :label="item.fullName"
:value="item.id" />
</el-option-group>
</el-select>
</el-form-item>
<el-form-item label="数据库连接 To" prop="dbConnectionTo">
<el-select v-model="dataForm.dbConnectionTo" placeholder="请选择连接">
<el-option-group v-for="group in dbOptions" :key="group.fullName" :label="group.fullName">
<el-option v-for="item in group.children" :key="item.id" :label="item.fullName"
:value="item.id" />
</el-option-group>
</el-select>
<el-button type="primary" @click="check" style="margin-left:10px">验证连接</el-button>
</el-form-item>
</el-form>
<div class="NCC-common-title">
<h2>数据库表</h2>
</div>
<NCC-table v-loading="listLoading" :data="list">
<el-table-column prop="table" label="表名" show-overflow-tooltip />
<el-table-column prop="sum" label="总数" />
<el-table-column prop="result" label="结果" />
<el-table-column label="操作" fixed="right" width="100">
<template slot-scope="scope">
<el-button size="mini" type="text" @click="copy(scope.row)"
:loading="scope.row.btnLoading">数据同步
</el-button>
</template>
</el-table-column>
</NCC-table>
</div>
</template>
<script>
import { getDataSourceListAll, Execute, DataSync } from '@/api/systemData/dataSource'
import { DataModelList } from '@/api/systemData/dataModel'
export default {
name: 'systemData-dataSync',
data() {
return {
key: '',
dataForm: {
dbConnectionFrom: '',
dbConnectionTo: ''
},
dbOptions: [],
dataRule: {
dbConnectionFrom: [
{ required: true, message: '数据库连接 From不能为空', trigger: 'blur' }
],
dbConnectionTo: [
{ required: true, message: '数据库连接 To不能为空', trigger: 'blur' }
]
},
list: [],
listLoading: false
}
},
created() {
this.initData()
},
methods: {
initData() {
getDataSourceListAll().then(res => {
this.dbOptions = res.data.list.filter(o => o.children && o.children.length)
})
},
check() {
this.$refs['dataForm'].validate((valid) => {
if (valid) {
if (this.dataForm.dbConnectionFrom === this.dataForm.dbConnectionTo) {
this.$message({
message: '不能已数据库连接 From 相同',
type: 'error',
duration: 1000,
})
return
}
this.listLoading = true
DataModelList(this.dataForm.dbConnectionFrom).then((res) => {
this.list = res.data.list
for (let i = 0; i < this.list.length; i++) {
const e = this.list[i];
this.$set(this.list[i], 'result', '')
this.$set(this.list[i], 'btnLoading', false)
}
this.listLoading = false
})
}
})
},
copy(row) {
row.btnLoading = true
row.result = ''
let data = {
dbConnectionFrom: this.dataForm.dbConnectionFrom,
dbConnectionTo: this.dataForm.dbConnectionTo,
dbTable: row.table
}
DataSync(data).then((res) => {
if (res.data == 0) {
this.execute(row, res.data)
} else if (res.data == 1) {
this.$message({
message: '初始库表中没有数据',
type: 'warning',
duration: 1000,
})
row.btnLoading = false
} else if (res.data == 2) {
this.$confirm('目标库中该表不存在，是否在目标库中创建该表，并同步数据?', '提示', {
type: 'warning'
}).then(() => {
this.execute(row, res.data)
}).catch(() => { row.btnLoading = false });
} else if (res.data == 3) {
this.$confirm('目标表存在数据,是否自动清除并同步数据?', '提示', {
type: 'warning'
}).then(() => {
this.execute(row, res.data)
}).catch(() => { row.btnLoading = false });
}
}).catch(() => {
row.btnLoading = false
})
},
execute(row, type) {
row.result = ''
let data = {
type,
dbConnectionFrom: this.dataForm.dbConnectionFrom,
dbConnectionTo: this.dataForm.dbConnectionTo,
dbTable: row.table
}
Execute(data).then((res) => {
row.result = res.msg
row.btnLoading = false
}).catch(() => {
row.btnLoading = false
})
}
}
}
</script>