ds-sdk/demo/demo.go

package main

import (
	"git.sxidc.com/go-tools/utils/strutils"
	"git.sxidc.com/service-supports/ds-sdk/sdk"
)

const (
	token         = "IpTTwAQweh/BP51fz5CzWKQFaXHvZe6ewvk6yOcAOkU="
	baseUrl       = "http://localhost:10000"
	namespace     = "ns-sdk-demo"
	dataSource    = "ds-sdk-demo"
	dataContainer = "dc-sdk-demo"
	sql           = "delete-sdk-demo"
)

var (
	dataContainerSpec = sdk.DataContainerDatabaseSpec{
		TableName: "test.classes",
		Columns: []sdk.DataContainerDatabaseColumnSpec{
			{
				Name:       "id",
				Type:       "varchar(32)",
				Comment:    "id",
				PrimaryKey: true,
			},
			{
				Name:    "name",
				Type:    "varchar(128)",
				Comment: "班名",
				NotNull: true,
			},
			{
				Name:    "student_num",
				Type:    "integer",
				Comment: "学生数量",
				Default: 60,
			},
		},
	}

	sqlSpec = sdk.SqlSpec{
		Transaction: false,
		Clauses:     "- DELETE FROM test.classes WHERE id = '{{ .id }}'",
	}
)

func main() {
	classID1 := strutils.SimpleUUID()

	err := sdk.InitInstance(token, baseUrl, namespace, dataSource)
	if err != nil {
		panic(err)
	}

	defer func() {
		err := sdk.DestroyInstance()
		if err != nil {
			panic(err)
		}
	}()

	err = sdk.GetInstance().CreateDataContainer(dataContainer, dataContainerSpec.ToMap())
	if err != nil {
		panic(err)
	}

	err = sdk.GetInstance().CreateSQL(sql, sqlSpec.ToMap())
	if err != nil {
		panic(err)
	}

	_, err = sdk.GetInstance().ExecuteSql(sql, map[string]any{"id": classID1})
	if err != nil {
		panic(err)
	}

	err = sdk.GetInstance().DeleteSQL(sql)
	if err != nil {
		panic(err)
	}

	err = sdk.GetInstance().DeleteDataContainer(dataContainer)
	if err != nil {
		panic(err)
	}
}