database

Documentation

Index

• Constants
• func Close()
• func Delete(original_id int)
• func Init()
• func Insert(originalId int, itemCode string, text string)
• func SelectIdByOriginalId(original_id int) uint
• func Update(original_id int, itemCode string, text string)
• type Replica
  • func SelectAll() []Replica
  • func SelectRow(id int) Replica

Constants

const (
	DBMS    = "mysql"
	USER    = "test_user" // DBのユーザ名
	PASS    = "test_pass" // DBのパスワード
	HOST    = "localhost" // DBのホスト名もしくはIP
	PORT    = "3306"      // DBのポート
	DBNAME  = "exampledb" // DB名
	CONNECT = USER + ":" + PASS + "@tcp(" + HOST + ":" + PORT + ")/" + DBNAME + "?parseTime=true"
)

Functions

func Close

func Close()

DBクローズ

func Delete

func Delete(original_id int)

削除

func Init

func Init()

DB初期化

func Insert

func Insert(originalId int, itemCode string, text string)

登録

func SelectIdByOriginalId

func SelectIdByOriginalId(original_id int) uint

コピー元のIDを元にレプリカのidを検索する

func Update

func Update(original_id int, itemCode string, text string)

更新

Types

type Replica

type Replica struct {
	gorm.Model
	OriginalId int
	ItemCode   string
	Text       string
}

func SelectAll

func SelectAll() []Replica

全取得

func SelectRow

func SelectRow(id int) Replica

1行取得