package main

import (
	"github.com/gogf/gf/v2/database/gdb"
	"github.com/gogf/gf/v2/frame/g"
)

var db gdb.DB

type Address struct {
	Id        int
	Name      string
	Address   string
	Host      bool
	Remark    string
	CreatedAt string
	UpdatedAt string
	CreatedBy string
	UpdateBy  string
}

func initOrm() {
	db = g.DB()
	_, err := db.Exec(ctx, `
-- auto-generated definition
create table t_address
(
    name       varchar(255) not null,
    address    varchar(255) not null,
    remark     TEXT,
    created_at datetime,
    updated_at datetime,
    created_by varchar(255),
    updated_by varchar(255),
    id         INTEGER
        constraint t_address_pk
            primary key autoincrement,
    enable     char(1) default 'N'
);
create index t_address_address_index
    on t_address (remark);
create index t_address_enable_index
    on t_address (enable);
create unique index t_address_name_index
    on t_address (name);
`)
	if err != nil {
		g.Log().Error(ctx, err)
	}
	_, err = db.Exec(ctx, `alter table t_address add host smallint default 0`)
	if err != nil {
		g.Log().Error(ctx, err)
	}
	_, err = db.Exec(ctx, `create index  t_address_host_index on t_address(host)`)
	if err != nil {
		g.Log().Error(ctx, err)
	}
}