dao

Documentation

Index

• func Asset(filePath string) ([]byte, error)
• func AssetFile(filePath string) ([]byte, error)
• func GenerateQuery(tableName string, queryName string, args map[string]interface{}) (string, []interface{}, error)
• func QuestTableColumns() []string
• func QuestTableName() string
• func SampleTableColumns() []string
• func SampleTableName() string
• func SetupQueryArgs(rootDir string, sqlFile bool)
• type QuestDao
  • func Quest(db *sql.DB) QuestDao
  • func (g QuestDao) Delete(id int) (sql.Result, error)
  • func (g QuestDao) Exec(query string, args ...interface{}) (sql.Result, error)
  • func (g QuestDao) Insert(e entity.Quest) (sql.Result, error)
  • func (g QuestDao) Query(query string, args ...interface{}) (*sql.Rows, error)
  • func (g QuestDao) SelectAll() ([]entity.Quest, error)
  • func (g QuestDao) SelectByID(id int) (entity.Quest, error)
  • func (g QuestDao) SelectLimit(limit int) ([]entity.Quest, error)
  • func (g QuestDao) Update(e entity.Quest) (sql.Result, error)
• type QuestDaoQueryer
• type SampleDao
  • func Sample(db *sql.DB) SampleDao
  • func (g SampleDao) Delete(id int) (sql.Result, error)
  • func (g SampleDao) Exec(query string, args ...interface{}) (sql.Result, error)
  • func (g SampleDao) Insert(e entity.Sample) (sql.Result, error)
  • func (g SampleDao) Query(query string, args ...interface{}) (*sql.Rows, error)
  • func (g SampleDao) SelectAll() ([]entity.Sample, error)
  • func (g SampleDao) SelectByID(id int) (entity.Sample, error)
  • func (g SampleDao) Update(e entity.Sample) (sql.Result, error)
• type SampleDaoQueryer
• type TxQuestDao
  • func TxQuest(tx *sql.Tx) TxQuestDao
  • func (g TxQuestDao) Delete(id int) (sql.Result, error)
  • func (g TxQuestDao) Exec(query string, args ...interface{}) (sql.Result, error)
  • func (g TxQuestDao) Insert(e entity.Quest) (sql.Result, error)
  • func (g TxQuestDao) Query(query string, args ...interface{}) (*sql.Rows, error)
  • func (g TxQuestDao) SelectAll() ([]entity.Quest, error)
  • func (g TxQuestDao) SelectByID(id int) (entity.Quest, error)
  • func (g TxQuestDao) Update(e entity.Quest) (sql.Result, error)
• type TxSampleDao
  • func TxSample(tx *sql.Tx) TxSampleDao
  • func (g TxSampleDao) Delete(id int) (sql.Result, error)
  • func (g TxSampleDao) Exec(query string, args ...interface{}) (sql.Result, error)
  • func (g TxSampleDao) Insert(e entity.Sample) (sql.Result, error)
  • func (g TxSampleDao) Query(query string, args ...interface{}) (*sql.Rows, error)
  • func (g TxSampleDao) SelectAll() ([]entity.Sample, error)
  • func (g TxSampleDao) SelectByID(id int) (entity.Sample, error)
  • func (g TxSampleDao) Update(e entity.Sample) (sql.Result, error)

Functions

func Asset

func Asset(filePath string) ([]byte, error)

Asset default read file

func AssetFile

func AssetFile(filePath string) ([]byte, error)

AssetFile default read file

func GenerateQuery

func GenerateQuery(tableName string, queryName string, args map[string]interface{}) (string, []interface{}, error)

GenerateQuery exported queryArgs

func QuestTableColumns

func QuestTableColumns() []string

QuestTableColumns quest table columns

func QuestTableName

func QuestTableName() string

QuestTableName quest table name

func SampleTableColumns

func SampleTableColumns() []string

SampleTableColumns sample table columns

func SampleTableName

func SampleTableName() string

SampleTableName sample table name

func SetupQueryArgs

func SetupQueryArgs(rootDir string, sqlFile bool)

SetupQueryArgs setup query file path

Types

type QuestDao

type QuestDao struct {
	*sql.DB
	TableName string
	Columns   []string
}

QuestDao is generated quest table.

func Quest

func Quest(db *sql.DB) QuestDao

Quest is QuestDao.

func (QuestDao) Delete

func (g QuestDao) Delete(id int) (sql.Result, error)

Delete delete quest table.

func (QuestDao) Exec

func (g QuestDao) Exec(query string, args ...interface{}) (sql.Result, error)

Exec QuestDao exec

func (QuestDao) Insert

func (g QuestDao) Insert(e entity.Quest) (sql.Result, error)

Insert insert quest table.

func (QuestDao) Query

func (g QuestDao) Query(query string, args ...interface{}) (*sql.Rows, error)

Query QuestDao query

func (QuestDao) SelectAll

func (g QuestDao) SelectAll() ([]entity.Quest, error)

SelectAll select quest table all recode.

func (QuestDao) SelectByID

func (g QuestDao) SelectByID(id int) (entity.Quest, error)

SelectByID select quest table by primaryKey.

func (QuestDao) SelectLimit

func (g QuestDao) SelectLimit(limit int) ([]entity.Quest, error)

SelectLimit select quest table by primaryKey.

func (QuestDao) Update

func (g QuestDao) Update(e entity.Quest) (sql.Result, error)

Update update quest table.

type QuestDaoQueryer

type QuestDaoQueryer interface {
	Query(query string, args ...interface{}) (*sql.Rows, error)
	Exec(query string, args ...interface{}) (sql.Result, error)
}

QuestDaoQueryer is interface

type SampleDao

type SampleDao struct {
	*sql.DB
	TableName string
	Columns   []string
}

SampleDao is generated sample table.

func Sample

func Sample(db *sql.DB) SampleDao

Sample is SampleDao.

func (SampleDao) Delete

func (g SampleDao) Delete(id int) (sql.Result, error)

Delete delete sample table.

func (SampleDao) Exec

func (g SampleDao) Exec(query string, args ...interface{}) (sql.Result, error)

Exec SampleDao exec

func (SampleDao) Insert

func (g SampleDao) Insert(e entity.Sample) (sql.Result, error)

Insert insert sample table.

func (SampleDao) Query

func (g SampleDao) Query(query string, args ...interface{}) (*sql.Rows, error)

Query SampleDao query

func (SampleDao) SelectAll

func (g SampleDao) SelectAll() ([]entity.Sample, error)

SelectAll select sample table all recode.

func (SampleDao) SelectByID

func (g SampleDao) SelectByID(id int) (entity.Sample, error)

SelectByID select sample table by primaryKey.

func (SampleDao) Update

func (g SampleDao) Update(e entity.Sample) (sql.Result, error)

Update update sample table.

type SampleDaoQueryer

type SampleDaoQueryer interface {
	Query(query string, args ...interface{}) (*sql.Rows, error)
	Exec(query string, args ...interface{}) (sql.Result, error)
}

SampleDaoQueryer is interface

type TxQuestDao

type TxQuestDao struct {
	*sql.Tx
	TableName string
	Columns   []string
}

TxQuestDao is generated quest table transaction.

func TxQuest

func TxQuest(tx *sql.Tx) TxQuestDao

TxQuest is QuestDao.

func (TxQuestDao) Delete

func (g TxQuestDao) Delete(id int) (sql.Result, error)

Delete transaction delete quest table.

func (TxQuestDao) Exec

func (g TxQuestDao) Exec(query string, args ...interface{}) (sql.Result, error)

Exec TxQuestDao exec

func (TxQuestDao) Insert

func (g TxQuestDao) Insert(e entity.Quest) (sql.Result, error)

Insert transaction insert quest table.

func (TxQuestDao) Query

func (g TxQuestDao) Query(query string, args ...interface{}) (*sql.Rows, error)

Query TxQuestDao query

func (TxQuestDao) SelectAll

func (g TxQuestDao) SelectAll() ([]entity.Quest, error)

SelectAll transaction select quest table all recode.

func (TxQuestDao) SelectByID

func (g TxQuestDao) SelectByID(id int) (entity.Quest, error)

SelectByID transaction select quest table by primaryKey.

func (TxQuestDao) Update

func (g TxQuestDao) Update(e entity.Quest) (sql.Result, error)

Update transaction update quest table.

type TxSampleDao

type TxSampleDao struct {
	*sql.Tx
	TableName string
	Columns   []string
}

TxSampleDao is generated sample table transaction.

func TxSample

func TxSample(tx *sql.Tx) TxSampleDao

TxSample is SampleDao.

func (TxSampleDao) Delete

func (g TxSampleDao) Delete(id int) (sql.Result, error)

Delete transaction delete sample table.

func (TxSampleDao) Exec

func (g TxSampleDao) Exec(query string, args ...interface{}) (sql.Result, error)

Exec TxSampleDao exec

func (TxSampleDao) Insert

func (g TxSampleDao) Insert(e entity.Sample) (sql.Result, error)

Insert transaction insert sample table.

func (TxSampleDao) Query

func (g TxSampleDao) Query(query string, args ...interface{}) (*sql.Rows, error)

Query TxSampleDao query

func (TxSampleDao) SelectAll

func (g TxSampleDao) SelectAll() ([]entity.Sample, error)

SelectAll transaction select sample table all recode.

func (TxSampleDao) SelectByID

func (g TxSampleDao) SelectByID(id int) (entity.Sample, error)

SelectByID transaction select sample table by primaryKey.

func (TxSampleDao) Update

func (g TxSampleDao) Update(e entity.Sample) (sql.Result, error)

Update transaction update sample table.