1import {
2    MochowClient,
3    AutoBuildTiming,
4    FieldSchema,
5    FieldType,
6    IndexSchema,
7    IndexType, MetricType, PartitionType, TableSchema, CreateTableArgs
8} from "@mochow/mochow-sdk-node";
9
10const mochowClient = new MochowClient({
11    credential: {
12        account: "root",
13        apiKey: "您的账户API密钥",
14    },
15    endpoint: "您的实例访问端点", // 例如：'http://127.0.0.1:5287'
16})
17
18let fields: FieldSchema[]
19fields = [
20    {
21        fieldName: "id",
22        fieldType: FieldType.String,
23        primaryKey: true,
24        partitionKey: true,
25        autoIncrement: false,
26        notNull: true,
27    },
28    {
29        fieldName: "bookName",
30        fieldType: FieldType.String,
31        notNull: true,
32    },
33    {
34        fieldName: "author",
35        fieldType: FieldType.String,
36        notNull: true,
37    },
38    {
39        fieldName: "vector",
40        fieldType: FieldType.FloatVector,
41        notNull: true,
42        dimension: 3,
43    }
44]
45
46// Indexes
47let autoBuildPolicy = AutoBuildTiming("2024-11-29 18:35:00")
48let indexes: IndexSchema[] = [
49    {
50        indexName: "book_name_idx",
51        field: "bookName",
52        indexType: IndexType.SecondaryIndex,
53    },
54    {
55        indexName: "vector_idx",
56        field: "vector",
57        indexType: IndexType.HNSW,
58        metricType: MetricType.L2,
59        params: {
60            "M": 32,
61            "efConstruction": 200,
62        },
63        autoBuild: true,
64        autoBuildPolicy: autoBuildPolicy,
65    }
66]
67
68// create table
69let schema: TableSchema = { fields: fields, indexes: indexes }
70let createTableArgs: CreateTableArgs = {
71    database: "db_test",
72    table: "table_test",
73    description: "test",
74    replication: 1,
75    partitionParams: {
76        partitionType: PartitionType.HASH,
77        partitionNum: 1,
78    },
79    enableDynamicField: false,
80    schema: schema
81}
82
83let createTableResp = await mochowClient.createTable(createTableArgs)

1import { MochowClient } from "@mochow/mochow-sdk-node";
2
3const mochowClient = new MochowClient({
4    credential: {
5        account: "root",
6        apiKey: "您的账户API密钥",
7    },
8    endpoint: "您的实例访问端点", // 例如：'http://127.0.0.1:5287'
9})
10
11// drop table
12let dropTableResponse = await mochowClient.dropTable("db_test", "table_test")

1import { MochowClient } from "@mochow/mochow-sdk-node";
2
3const mochowClient = new MochowClient({
4    credential: {
5        account: "root",
6        apiKey: "您的账户API密钥",
7    },
8    endpoint: "您的实例访问端点", // 例如：'http://127.0.0.1:5287'
9})
10
11// describe table
12let descTableResponse = await mochowClient.descTable("db_test", "table_test")

1import { MochowClient } from "@mochow/mochow-sdk-node";
2
3const mochowClient = new MochowClient({
4    credential: {
5        account: "root",
6        apiKey: "您的账户API密钥",
7    },
8    endpoint: "您的实例访问端点", // 例如：'http://127.0.0.1:5287'
9})
10
11// list tables
12let listTablesResponse = await mochowClient.listTables("db_test")