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
| <template> <div class="hello"> <textarea v-model.lazy="item" cols="30" rows="10"></textarea> <textarea v-model.lazy="sql" id="" cols="30" rows="10"></textarea> </div> <div> <textarea v-model="result" cols="30" rows="10" readonly></textarea> </div> </template>
<script> import * as a from "lodash";
export default { name: "HelloWorld", data() { return { item: "", sql: "", }; }, method: { getDataDebounced() {}, }, created() { this.getDataDebounced = a.debounce(() => { let items = a.chunk( this.item.split("\n").filter((str) => str !== ""), 1000 ); console.log(items); items = items.map((a) => { a = a.map((str) => "'" + str + "'"); return a.join(","); }); let r = ""; items.forEach((item) => { let aa = this.sql.replace("::id::", item); console.log(aa); r += aa; r += "\n"; }); console.log(r); this.result = r; console.log(this.result); }, 1000); }, computed: { result() { let items = a.chunk( this.item.split("\n").filter((str) => str !== ""), 1000 ); console.log(items); items = items.map((a) => { a = a.map((str) => "'" + str + "'"); return a.join(","); }); let r = ""; items.forEach((item) => { let aa = this.sql.replace("::id::", item); console.log(aa); r += aa; r += "\n"; }); return r; }, }, }; </script>
<style scoped> h3 { margin: 40px 0 0; } ul { list-style-type: none; padding: 0; } li { display: inline-block; margin: 0 10px; } a { color: #42b983; } </style>
|