mysql

Documentation

Index

• Constants
• Variables
• func InitCon()
• func InitMigration()
• type Client
  • func NewClient() *Client
  • func (c *Client) CreateOrUpdate(ctx context.Context, db *sqlx.DB, data interface{}, query string) (lastId int64, err error)
  • func (c *Client) Get(ctx context.Context, db *sqlx.DB, data interface{}, query *util.Query, ...) (err error)
  • func (c *Client) Select(ctx context.Context, db *sqlx.DB, data *[]entity.Question, query *util.Query, ...) (err error)
• type IMysql

Constants

const (
	// Find
	QueryFindQuestions = `SELECT id, no, question, answer FROM questions`

	// Insert
	QueryInsertQuestion = `INSERT INTO questions (no, question, answer) VALUES (:no, :question, :answer)`

	// Update
	QueryUpdateQuestion = `UPDATE questions SET no=:no, question=:question, answer=:answer WHERE no=:no`

	// delete
	QueryDeleteQuestion = `DELETE FROM questions WHERE no=:no`
)

Variables

var QuizMasterDB *sqlx.DB

Functions

func InitCon

func InitCon()

func InitMigration

func InitMigration()

Types

type Client

type Client struct {
	// contains filtered or unexported fields
}

func NewClient

func NewClient() *Client

func (*Client) CreateOrUpdate

func (c *Client) CreateOrUpdate(ctx context.Context, db *sqlx.DB, data interface{}, query string) (lastId int64, err error)

func (*Client) Get

func (c *Client) Get(ctx context.Context, db *sqlx.DB, data interface{}, query *util.Query, queryString string) (err error)

func (*Client) Select

func (c *Client) Select(ctx context.Context, db *sqlx.DB, data *[]entity.Question, query *util.Query, queryString string) (err error)

type IMysql

type IMysql interface {
	Get(context.Context, *sqlx.DB, interface{}, *util.Query, string) error
	Select(context.Context, *sqlx.DB, *[]entity.Question, *util.Query, string) error
	CreateOrUpdate(ctx context.Context, db *sqlx.DB, data interface{}, query string) (lastId int64, err error)
}