243 lines
8.0 KiB
Go
243 lines
8.0 KiB
Go
|
package dao
|
||
|
|
|
||
|
|
import (
|
||
|
|
"context"
|
||
|
|
"testing"
|
||
|
|
|
||
|
|
"github.com/smartystreets/goconvey/convey"
|
||
|
|
)
|
||
|
|
|
||
|
|
func TestDaoPastAwards(t *testing.T) {
|
||
|
|
convey.Convey("PastAwards", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award(award_id,award_name,open_status) VALUES(666,'test','2') ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
as, err := d.PastAwards(c)
|
||
|
|
convCtx.Convey("Then err should be nil.as should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(as, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoJoinedSpecialAwards(t *testing.T) {
|
||
|
|
convey.Convey("JoinedSpecialAwards", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
awardIDs = []int64{666}
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award(award_id,award_name,open_status) VALUES(666,'test','2') ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
sas, err := d.JoinedSpecialAwards(c, awardIDs)
|
||
|
|
convCtx.Convey("Then err should be nil.sas should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(sas, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetAwardSchedule(t *testing.T) {
|
||
|
|
convey.Convey("GetAwardSchedule", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
awardID = int64(0)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award(award_id,award_name,open_status) VALUES(666,'test','2') ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
award, err := d.GetAwardSchedule(c, awardID)
|
||
|
|
convCtx.Convey("Then err should be nil.award should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(award, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetResources(t *testing.T) {
|
||
|
|
convey.Convey("GetResources", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
awardID = int64(0)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award_resource(award_id,resource_type,content,resource_index) VALUES(666,1,'test',1) ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
res, err := d.GetResources(c, awardID)
|
||
|
|
convCtx.Convey("Then err should be nil.res should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(res, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetWinners(t *testing.T) {
|
||
|
|
convey.Convey("GetWinners", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
awardID = int64(0)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award_winner(award_id,mid,division_name) VALUES(666,2,'test') ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
mids, err := d.GetWinners(c, awardID)
|
||
|
|
convCtx.Convey("Then err should be nil.mids should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(mids, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoAwardIDsByWinner(t *testing.T) {
|
||
|
|
convey.Convey("AwardIDsByWinner", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
mid = int64(2)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
am, err := d.AwardIDsByWinner(c, mid)
|
||
|
|
convCtx.Convey("Then err should be nil.am should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(am, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoDivisionName(t *testing.T) {
|
||
|
|
convey.Convey("DivisionName", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
mid = int64(2)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
names, err := d.DivisionName(c, mid)
|
||
|
|
convCtx.Convey("Then err should be nil.names should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(names, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoJoinedCount(t *testing.T) {
|
||
|
|
convey.Convey("JoinedCount", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
mid = int64(2)
|
||
|
|
awardID = int64(666)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award_record(award_id,mid) VALUES(666,2) ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
count, err := d.JoinedCount(c, mid, awardID)
|
||
|
|
convCtx.Convey("Then err should be nil.count should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(count, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoAwardBonus(t *testing.T) {
|
||
|
|
convey.Convey("AwardBonus", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
awardID = int64(66)
|
||
|
|
prizeID = int64(2)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award_prize(award_id,prize_id, bonus) VALUES(66,2,100) ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
bonus, err := d.AwardBonus(c, awardID, prizeID)
|
||
|
|
convCtx.Convey("Then err should be nil.bonus should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(bonus, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoAddToAwardRecord(t *testing.T) {
|
||
|
|
convey.Convey("AddToAwardRecord", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
mid = int64(2)
|
||
|
|
awardID = int64(666)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "DELETE FROM special_award_record WHERE mid=2")
|
||
|
|
rows, err := d.AddToAwardRecord(c, mid, awardID)
|
||
|
|
convCtx.Convey("Then err should be nil.rows should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(rows, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetSpecialAwards(t *testing.T) {
|
||
|
|
convey.Convey("GetSpecialAwards", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
awards, err := d.GetSpecialAwards(c)
|
||
|
|
convCtx.Convey("Then err should be nil.awards should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(awards, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetSpecialAwardDivision(t *testing.T) {
|
||
|
|
convey.Convey("GetSpecialAwardDivision", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
awardID = int64(0)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
Exec(c, "INSERT INTO special_award_division(award_id,division_name) VALUES(666,'test') ON DUPLICATE KEY UPDATE award_id=VALUES(award_id)")
|
||
|
|
divisions, err := d.GetSpecialAwardDivision(c, awardID)
|
||
|
|
convCtx.Convey("Then err should be nil.divisions should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(divisions, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetAwardWinRecord(t *testing.T) {
|
||
|
|
convey.Convey("GetAwardWinRecord", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
mid = int64(2)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
awardIDs, err := d.GetAwardWinRecord(c, mid)
|
||
|
|
convCtx.Convey("Then err should be nil.awardIDs should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(awardIDs, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestDaoGetAwardJoinRecord(t *testing.T) {
|
||
|
|
convey.Convey("GetAwardJoinRecord", t, func(convCtx convey.C) {
|
||
|
|
var (
|
||
|
|
c = context.Background()
|
||
|
|
mid = int64(2)
|
||
|
|
)
|
||
|
|
convCtx.Convey("When everything goes positive", func(convCtx convey.C) {
|
||
|
|
awardIDs, err := d.GetAwardJoinRecord(c, mid)
|
||
|
|
convCtx.Convey("Then err should be nil.awardIDs should not be nil.", func(convCtx convey.C) {
|
||
|
|
convCtx.So(err, convey.ShouldBeNil)
|
||
|
|
convCtx.So(awardIDs, convey.ShouldNotBeNil)
|
||
|
|
})
|
||
|
|
})
|
||
|
|
})
|
||
|
|
}
|