mysql_dao

Documentation

Index

• type AuthSeqUpdatesDAO
  • func NewAuthSeqUpdatesDAO(db *sqlx.DB) *AuthSeqUpdatesDAO
  • func (dao *AuthSeqUpdatesDAO) Insert(ctx context.Context, do *dataobject.AuthSeqUpdatesDO) (lastInsertId, rowsAffected int64, err error)
  • func (dao *AuthSeqUpdatesDAO) InsertTx(tx *sqlx.Tx, do *dataobject.AuthSeqUpdatesDO) (lastInsertId, rowsAffected int64, err error)
  • func (dao *AuthSeqUpdatesDAO) SelectByGtDate(ctx context.Context, auth_id int64, user_id int64, date2 int64, limit int32) (rList []dataobject.AuthSeqUpdatesDO, err error)
  • func (dao *AuthSeqUpdatesDAO) SelectByGtDateWithCB(ctx context.Context, auth_id int64, user_id int64, date2 int64, limit int32, ...) (rList []dataobject.AuthSeqUpdatesDO, err error)
  • func (dao *AuthSeqUpdatesDAO) SelectByGtSeq(ctx context.Context, auth_id int64, user_id int64, seq int32) (rList []dataobject.AuthSeqUpdatesDO, err error)
  • func (dao *AuthSeqUpdatesDAO) SelectByGtSeqWithCB(ctx context.Context, auth_id int64, user_id int64, seq int32, ...) (rList []dataobject.AuthSeqUpdatesDO, err error)
  • func (dao *AuthSeqUpdatesDAO) SelectLastSeq(ctx context.Context, auth_id int64, user_id int64) (rValue *dataobject.AuthSeqUpdatesDO, err error)
• type UserPtsUpdatesDAO
  • func NewUserPtsUpdatesDAO(db *sqlx.DB) *UserPtsUpdatesDAO
  • func (dao *UserPtsUpdatesDAO) Insert(ctx context.Context, do *dataobject.UserPtsUpdatesDO) (lastInsertId, rowsAffected int64, err error)
  • func (dao *UserPtsUpdatesDAO) InsertTx(tx *sqlx.Tx, do *dataobject.UserPtsUpdatesDO) (lastInsertId, rowsAffected int64, err error)
  • func (dao *UserPtsUpdatesDAO) SelectByGtPts(ctx context.Context, user_id int64, pts int32, limit int32) (rList []dataobject.UserPtsUpdatesDO, err error)
  • func (dao *UserPtsUpdatesDAO) SelectByGtPtsWithCB(ctx context.Context, user_id int64, pts int32, limit int32, ...) (rList []dataobject.UserPtsUpdatesDO, err error)
  • func (dao *UserPtsUpdatesDAO) SelectLastPts(ctx context.Context, user_id int64) (rValue *dataobject.UserPtsUpdatesDO, err error)

Types

type AuthSeqUpdatesDAO

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

func NewAuthSeqUpdatesDAO

func NewAuthSeqUpdatesDAO(db *sqlx.DB) *AuthSeqUpdatesDAO

func (*AuthSeqUpdatesDAO) Insert

func (dao *AuthSeqUpdatesDAO) Insert(ctx context.Context, do *dataobject.AuthSeqUpdatesDO) (lastInsertId, rowsAffected int64, err error)

Insert insert into auth_seq_updates(auth_id, user_id, seq, update_type, update_data, date2) values (:auth_id, :user_id, :seq, :update_type, :update_data, :date2) TODO(@benqi): sqlmap

func (*AuthSeqUpdatesDAO) InsertTx

func (dao *AuthSeqUpdatesDAO) InsertTx(tx *sqlx.Tx, do *dataobject.AuthSeqUpdatesDO) (lastInsertId, rowsAffected int64, err error)

InsertTx insert into auth_seq_updates(auth_id, user_id, seq, update_type, update_data, date2) values (:auth_id, :user_id, :seq, :update_type, :update_data, :date2) TODO(@benqi): sqlmap

func (*AuthSeqUpdatesDAO) SelectByGtDate

func (dao *AuthSeqUpdatesDAO) SelectByGtDate(ctx context.Context, auth_id int64, user_id int64, date2 int64, limit int32) (rList []dataobject.AuthSeqUpdatesDO, err error)

SelectByGtDate select auth_id, user_id, seq, update_type, update_data, date2 from auth_seq_updates where auth_id = :auth_id and user_id = :user_id and date2 > :date2 order by seq asc limit :limit TODO(@benqi): sqlmap

func (*AuthSeqUpdatesDAO) SelectByGtDateWithCB

func (dao *AuthSeqUpdatesDAO) SelectByGtDateWithCB(ctx context.Context, auth_id int64, user_id int64, date2 int64, limit int32, cb func(i int, v *dataobject.AuthSeqUpdatesDO)) (rList []dataobject.AuthSeqUpdatesDO, err error)

SelectByGtDateWithCB select auth_id, user_id, seq, update_type, update_data, date2 from auth_seq_updates where auth_id = :auth_id and user_id = :user_id and date2 > :date2 order by seq asc limit :limit TODO(@benqi): sqlmap

func (*AuthSeqUpdatesDAO) SelectByGtSeq

func (dao *AuthSeqUpdatesDAO) SelectByGtSeq(ctx context.Context, auth_id int64, user_id int64, seq int32) (rList []dataobject.AuthSeqUpdatesDO, err error)

SelectByGtSeq select auth_id, user_id, seq, update_type, update_data, date2 from auth_seq_updates where auth_id = :auth_id and user_id = :user_id and seq > :seq order by seq asc TODO(@benqi): sqlmap

func (*AuthSeqUpdatesDAO) SelectByGtSeqWithCB

func (dao *AuthSeqUpdatesDAO) SelectByGtSeqWithCB(ctx context.Context, auth_id int64, user_id int64, seq int32, cb func(i int, v *dataobject.AuthSeqUpdatesDO)) (rList []dataobject.AuthSeqUpdatesDO, err error)

SelectByGtSeqWithCB select auth_id, user_id, seq, update_type, update_data, date2 from auth_seq_updates where auth_id = :auth_id and user_id = :user_id and seq > :seq order by seq asc TODO(@benqi): sqlmap

func (*AuthSeqUpdatesDAO) SelectLastSeq

func (dao *AuthSeqUpdatesDAO) SelectLastSeq(ctx context.Context, auth_id int64, user_id int64) (rValue *dataobject.AuthSeqUpdatesDO, err error)

SelectLastSeq select seq from auth_seq_updates where auth_id = :auth_id and user_id = :user_id order by seq desc limit 1 TODO(@benqi): sqlmap

type UserPtsUpdatesDAO

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

func NewUserPtsUpdatesDAO

func NewUserPtsUpdatesDAO(db *sqlx.DB) *UserPtsUpdatesDAO

func (*UserPtsUpdatesDAO) Insert

func (dao *UserPtsUpdatesDAO) Insert(ctx context.Context, do *dataobject.UserPtsUpdatesDO) (lastInsertId, rowsAffected int64, err error)

Insert insert into user_pts_updates(user_id, pts, pts_count, update_type, update_data, date2) values (:user_id, :pts, :pts_count, :update_type, :update_data, :date2) TODO(@benqi): sqlmap

func (*UserPtsUpdatesDAO) InsertTx

func (dao *UserPtsUpdatesDAO) InsertTx(tx *sqlx.Tx, do *dataobject.UserPtsUpdatesDO) (lastInsertId, rowsAffected int64, err error)

InsertTx insert into user_pts_updates(user_id, pts, pts_count, update_type, update_data, date2) values (:user_id, :pts, :pts_count, :update_type, :update_data, :date2) TODO(@benqi): sqlmap

func (*UserPtsUpdatesDAO) SelectByGtPts

func (dao *UserPtsUpdatesDAO) SelectByGtPts(ctx context.Context, user_id int64, pts int32, limit int32) (rList []dataobject.UserPtsUpdatesDO, err error)

SelectByGtPts select user_id, pts, pts_count, update_type, update_data from user_pts_updates where user_id = :user_id and pts > :pts order by pts asc limit :limit TODO(@benqi): sqlmap

func (*UserPtsUpdatesDAO) SelectByGtPtsWithCB

func (dao *UserPtsUpdatesDAO) SelectByGtPtsWithCB(ctx context.Context, user_id int64, pts int32, limit int32, cb func(i int, v *dataobject.UserPtsUpdatesDO)) (rList []dataobject.UserPtsUpdatesDO, err error)

SelectByGtPtsWithCB select user_id, pts, pts_count, update_type, update_data from user_pts_updates where user_id = :user_id and pts > :pts order by pts asc limit :limit TODO(@benqi): sqlmap

func (*UserPtsUpdatesDAO) SelectLastPts

func (dao *UserPtsUpdatesDAO) SelectLastPts(ctx context.Context, user_id int64) (rValue *dataobject.UserPtsUpdatesDO, err error)

SelectLastPts select pts from user_pts_updates where user_id = :user_id order by pts desc limit 1 TODO(@benqi): sqlmap