123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188 |
- package dao
- import (
- "context"
- "testing"
- "github.com/smartystreets/goconvey/convey"
- )
- func TestDaoGetUpDailyCharge(t *testing.T) {
- convey.Convey("GetUpDailyCharge", t, func(ctx convey.C) {
- var (
- c = context.Background()
- mid = int64(1001)
- begin = "2018-01-01"
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO up_daily_charge(mid, date, inc_charge) VALUES(1001, '2018-06-01', 100)")
- incs, err := d.GetUpDailyCharge(c, mid, begin)
- ctx.Convey("Then err should be nil.incs should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(incs, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListAvIncome(t *testing.T) {
- convey.Convey("ListAvIncome", t, func(ctx convey.C) {
- var (
- c = context.Background()
- mid = int64(1001)
- startTime = "2018-01-01"
- endTime = "2019-01-01"
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO av_income(av_id, mid, date, income) VALUES(1000, 1001, '2018-06-01', 100)")
- avs, err := d.ListAvIncome(c, mid, startTime, endTime)
- ctx.Convey("Then err should be nil.avs should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(avs, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListAvIncomeByID(t *testing.T) {
- convey.Convey("ListAvIncomeByID", t, func(ctx convey.C) {
- var (
- c = context.Background()
- avID = int64(1000)
- endTime = "2019-01-01"
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO av_income(av_id, mid, date, income) VALUES(1000, 1001, '2018-06-01', 100)")
- avs, err := d.ListAvIncomeByID(c, avID, endTime)
- ctx.Convey("Then err should be nil.avs should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(avs, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListAvBlackList(t *testing.T) {
- convey.Convey("ListAvBlackList", t, func(ctx convey.C) {
- var (
- c = context.Background()
- avIds = []int64{1000}
- typ = int(0)
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO av_black_list(av_id, ctype) VALUES(1000, 0) ON DUPLICATE KEY UPDATE ctype = 0")
- avb, err := d.ListAvBlackList(c, avIds, typ)
- ctx.Convey("Then err should be nil.avb should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(avb, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListActiveInfo(t *testing.T) {
- convey.Convey("ListActiveInfo", t, func(ctx convey.C) {
- var (
- c = context.Background()
- avIds = []int64{1000}
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO activity_info(archive_id, tag_id) VALUES(1000, 1)")
- acM, err := d.ListActiveInfo(c, avIds)
- ctx.Convey("Then err should be nil.acM should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(acM, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListTagInfo(t *testing.T) {
- convey.Convey("ListTagInfo", t, func(ctx convey.C) {
- var (
- c = context.Background()
- tagIds = []int64{1000}
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO tag_info(id, ratio, icon) VALUES(1000, 10, 'aaaaaa')")
- tagM, err := d.ListTagInfo(c, tagIds)
- ctx.Convey("Then err should be nil.tagM should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(tagM, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListUpIncome(t *testing.T) {
- convey.Convey("ListUpIncome", t, func(ctx convey.C) {
- var (
- c = context.Background()
- mid = int64(1001)
- table = "up_income"
- startTime = "2018-01-01"
- endTime = "2019-01-01"
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO up_income(mid, date) VALUES(1001, '2018-06-01')")
- ups, err := d.ListUpIncome(c, mid, table, startTime, endTime)
- ctx.Convey("Then err should be nil.ups should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(ups, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoListUpAccount(t *testing.T) {
- convey.Convey("ListUpAccount", t, func(ctx convey.C) {
- var (
- c = context.Background()
- mid = int64(1001)
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO up_account(mid, is_deleted) VALUES(1001, 0) ON DUPLICATE KEY UPDATE is_deleted = 0")
- up, err := d.ListUpAccount(c, mid)
- ctx.Convey("Then err should be nil.up should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(up, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoGetUpIncome(t *testing.T) {
- convey.Convey("GetUpIncome", t, func(ctx convey.C) {
- var (
- c = context.Background()
- mid = int64(1001)
- begin = "2018-01-01"
- end = "2019-01-01"
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO up_income(mid, date) VALUES(1001, '2018-06-01')")
- result, err := d.GetUpIncome(c, mid, begin, end)
- ctx.Convey("Then err should be nil.result should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(result, convey.ShouldNotBeNil)
- })
- })
- })
- }
- func TestDaoGetUpIncomeCount(t *testing.T) {
- convey.Convey("GetUpIncomeCount", t, func(ctx convey.C) {
- var (
- c = context.Background()
- date = "2018-06-01"
- )
- ctx.Convey("When everything goes positive", func(ctx convey.C) {
- Exec(c, "INSERT INTO up_income(mid, date) VALUES(1001, '2018-06-01')")
- count, err := d.GetUpIncomeCount(c, date)
- ctx.Convey("Then err should be nil.count should not be nil.", func(ctx convey.C) {
- ctx.So(err, convey.ShouldBeNil)
- ctx.So(count, convey.ShouldNotBeNil)
- })
- })
- })
- }
|