schema

package main

import (
	"encoding/json"
	"fmt"

	"github.com/machinefi/w3bstream/pkg/depends/schema"
)

func main() {
	s := schema.Schema{
		Name: "demo",
		Tables: []*schema.Table{
			{
				Name: "tbl",
				Desc: "test table",
				Cols: []*schema.Column{{
					Name: "f_username",
					Constrains: &schema.ColumnType{
						Datatype: schema.DATATYPE__TEXT,
						Length:   255,
						Desc:     "user name",
					},
				}, {
					Name: "f_gender",
					Constrains: &schema.ColumnType{
						Datatype: schema.DATATYPE__UINT8,
						Length:   255,
						Desc:     "user name",
					},
				}},
				Keys: []*schema.Key{{
					Name:     "ui_username",
					IsUnique: true,
					IndexDef: schema.IndexDef{ColumnNames: []string{"f_username"}},
				}},
				WithSoftDeletion: true,
				WithPrimaryKey:   true,
			},
		},
	}

	data, err := json.MarshalIndent(s, "", "  ")
	if err != nil {
		panic(err)
	}
	fmt.Println(string(data))
	data, err = json.Marshal(s)
	if err != nil {
		panic(err)
	}
	fmt.Println(string(data))

}

Output:

{
  "name": "demo",
  "tables": [
    {
      "name": "tbl",
      "desc": "test table",
      "cols": [
        {
          "name": "f_username",
          "constrains": {
            "datatype": "TEXT",
            "length": 255,
            "desc": "user name"
          }
        },
        {
          "name": "f_gender",
          "constrains": {
            "datatype": "UINT8",
            "length": 255,
            "desc": "user name"
          }
        }
      ],
      "keys": [
        {
          "name": "ui_username",
          "isUnique": true,
          "columnNames": [
            "f_username"
          ]
        }
      ],
      "withSoftDeletion": true,
      "withPrimaryKey": true
    }
  ]
}
{"name":"demo","tables":[{"name":"tbl","desc":"test table","cols":[{"name":"f_username","constrains":{"datatype":"TEXT","length":255,"desc":"user name"}},{"name":"f_gender","constrains":{"datatype":"UINT8","length":255,"desc":"user name"}}],"keys":[{"name":"ui_username","isUnique":true,"columnNames":["f_username"]}],"withSoftDeletion":true,"withPrimaryKey":true}]}