database

Documentation

Index

• Constants
• type Client
  • func NewClient(params *Params) (*Client, error)
  • func (c *Client) Begin(opts ...*sql.TxOptions) (*gorm.DB, error)
  • func (c *Client) Close(tx *gorm.DB) func()
  • func (c *Client) GetListCount(table string, db *gorm.DB, q *ListQuery) (int, error)
  • func (c *Client) GetListQuery(table string, db *gorm.DB, q *ListQuery) *gorm.DB
• type ConditionQuery
• type ListQuery
• type OrderQuery
• type Params

Constants

const (
	OrderByAsc  int = iota // 昇順
	OrderByDesc            // 降順
)

ソート順

Types

type Client

type Client struct {
	DB *gorm.DB
}

Client - DB操作用のクライアント構造体

func NewClient

func NewClient(params *Params) (*Client, error)

NewClient - DBクライアントの構造体

func (*Client) Begin

func (c *Client) Begin(opts ...*sql.TxOptions) (*gorm.DB, error)

func (*Client) Close

func (c *Client) Close(tx *gorm.DB) func()

func (*Client) GetListCount

func (c *Client) GetListCount(table string, db *gorm.DB, q *ListQuery) (int, error)

検索クエリの作成用

func (*Client) GetListQuery

func (c *Client) GetListQuery(table string, db *gorm.DB, q *ListQuery) *gorm.DB

一覧取得クエリの作成用

type ConditionQuery

type ConditionQuery struct {
	Field    string
	Operator string // ==, !=, >、>=, <=, <, IN, LIKE, BETWEEN
	Value    interface{}
}

ConditionQuery - 絞り込み用の構造体

type ListQuery

type ListQuery struct {
	Limit      int
	Offset     int
	Order      *OrderQuery
	Conditions []*ConditionQuery
}

ListQuery - 一覧取得時のクエリ用構造体

type OrderQuery

type OrderQuery struct {
	Field   string
	OrderBy int
}

OrderQuery - ソートクエリ用の構造体

type Params

type Params struct {
	Socket        string
	Host          string
	Port          string
	Database      string
	Username      string
	Password      string
	DisableLogger bool
}