如何在 Vue 项目中使用 ClickHouse JS 进行增删改查？

npm install clickhouse-js

// clickhouse.js
import { client } from 'clickhouse-js';

class clickhouse {
  constructor(config) {
    this.client = new client(config);
  }

  async query(sql) {
    return this.client.query(sql);
  }

  async insert(table, data) {
    const sql = `insert into ${table} (${object.keys(data).join(', ')}) values (${object.values(data).map(() => '?').join(', ')})`;
    return this.client.query(sql, object.values(data));
  }

  async update(table, data, where) {
    const sql = `update ${table} set ${object.keys(data).map(key => `${key} = ?`).join(', ')} where ${where}`;
    return this.client.query(sql, [...object.values(data)]);
  }

  async delete(table, where) {
    const sql = `delete from ${table} where ${where}`;
    return this.client.query(sql);
  }
}

import ClickHouse from '@/clickhouse';

export default {
  data() {
    return {
      clickHouse: new ClickHouse({host: 'localhost', port: '8123', database: 'test'})
    }
  },
  methods: {
    async query() {
      const result = await this.clickHouse.query('SELECT * FROM test');
      console.log(result);
    },
    async insert() {
      const result = await this.clickHouse.insert('test', {name: 'John Doe', age: 30});
      console.log(result);
    },
    async update() {
      const result = await this.clickHouse.update('test', {name: 'Jane Doe'}, 'id = 1');
      console.log(result);
    },
    async delete() {
      const result = await this.clickHouse.delete('test', 'id = 1');
      console.log(result);
    },
  }
}