本文整理汇总了Golang中github.com/goatcms/goat-core/db.TX类的典型用法代码示例。如果您正苦于以下问题:Golang TX类的具体用法?Golang TX怎么用?Golang TX使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了TX类的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Golang代码示例。
示例1: Insert
// Insert store given articles to database
func (dao *BaseDAO) Insert(tx db.TX, entity interface{}) (int64, error) {
var (
res sql.Result
err error
)
if res, err = tx.NamedExec(dao.Table.insertSQL, entity); err != nil {
return 0, err
}
return res.LastInsertId()
}
示例2: Delete
// Delete remove specyfic record
func (dao *BaseDAO) Delete(tx db.TX, id int64) error {
var (
res sql.Result
err error
count int64
)
if res, err = tx.NamedExec(dao.Table.deleteByIDSQL, &IDContainer{id}); err != nil {
return err
}
if count, err = res.RowsAffected(); err != nil {
return err
}
if count != 1 {
return fmt.Errorf("Delete more than one record (%v records deleted)", count)
}
return nil
}
示例3: Update
// Update data of article
func (dao *BaseDAO) Update(tx db.TX, entity interface{}) error {
var (
res sql.Result
err error
count int64
)
if res, err = tx.NamedExec(dao.Table.updateByIDSQL, entity); err != nil {
return err
}
if count, err = res.RowsAffected(); err != nil {
return err
}
if count != 1 {
return fmt.Errorf("Update modified more then one record (%v records modyfieds)", count)
}
return nil
}
示例4: CreateTable
// CreateTable add new table to a database
func (dao *BaseDAO) CreateTable(tx db.TX) error {
tx.MustExec(dao.Table.createSQL)
return nil
}
示例5: InsertWithID
// InsertWithID store given articles to database (It persist with id from entity)
func (dao *BaseDAO) InsertWithID(tx db.TX, entity interface{}) error {
if _, err := tx.NamedExec(dao.Table.insertWithIDSQL, entity); err != nil {
return err
}
return nil
}
示例6: FindByID
// FindByID obtain article of given ID from database
func (dao *BaseDAO) FindByID(tx db.TX, id int64) *sqlx.Row {
return tx.QueryRowx(dao.Table.selectByIDSQL, id)
}
示例7: FindAll
// FindAll obtain all articles from database
func (dao *BaseDAO) FindAll(tx db.TX) (*sqlx.Rows, error) {
return tx.Queryx(dao.Table.selectSQL)
}