mirror of
https://github.com/Luzifer/twitch-bot.git
synced 2024-09-19 18:12:55 +00:00
103 lines
3.3 KiB
Go
103 lines
3.3 KiB
Go
package counter
|
|
|
|
import (
|
|
"fmt"
|
|
"testing"
|
|
"time"
|
|
|
|
"github.com/stretchr/testify/assert"
|
|
"github.com/stretchr/testify/require"
|
|
|
|
"github.com/Luzifer/twitch-bot/v3/pkg/database"
|
|
)
|
|
|
|
func TestCounterStoreLoop(t *testing.T) {
|
|
dbc := database.GetTestDatabase(t)
|
|
require.NoError(t, dbc.DB().AutoMigrate(&counter{}))
|
|
|
|
counterName := "mytestcounter"
|
|
|
|
v, err := getCounterValue(dbc, counterName)
|
|
assert.NoError(t, err, "reading non-existent counter")
|
|
assert.Equal(t, int64(0), v, "expecting 0 counter value on non-existent counter")
|
|
|
|
err = updateCounter(dbc, counterName, 5, true, time.Now())
|
|
assert.NoError(t, err, "inserting counter")
|
|
|
|
var rawCounter counter
|
|
assert.NoError(t, dbc.DB().First(&rawCounter, "name = ?", counterName).Error)
|
|
assert.Equal(t, rawCounter.FirstSeen, rawCounter.LastModified)
|
|
|
|
err = updateCounter(dbc, counterName, 1, false, time.Now())
|
|
assert.NoError(t, err, "updating counter")
|
|
|
|
assert.NoError(t, dbc.DB().First(&rawCounter, "name = ?", counterName).Error)
|
|
assert.NotEqual(t, rawCounter.FirstSeen, rawCounter.LastModified)
|
|
|
|
v, err = getCounterValue(dbc, counterName)
|
|
assert.NoError(t, err, "reading existent counter")
|
|
assert.Equal(t, int64(6), v, "expecting counter value on existing counter")
|
|
}
|
|
|
|
func TestCounterTopListAndRank(t *testing.T) {
|
|
dbc := database.GetTestDatabase(t)
|
|
require.NoError(t, dbc.DB().AutoMigrate(&counter{}))
|
|
|
|
testTime := time.Now().UTC()
|
|
|
|
counterTemplate := `#example:test:%v`
|
|
for i := 0; i < 6; i++ {
|
|
require.NoError(
|
|
t,
|
|
updateCounter(dbc, fmt.Sprintf(counterTemplate, i), int64(i), true, testTime),
|
|
"inserting counter %d", i,
|
|
)
|
|
}
|
|
|
|
cc, err := getCounterTopList(dbc, fmt.Sprintf(counterTemplate, ""), 3)
|
|
require.NoError(t, err)
|
|
assert.Len(t, cc, 3)
|
|
|
|
assert.Equal(t, []counter{
|
|
{Name: "#example:test:5", Value: 5, FirstSeen: testTime, LastModified: testTime},
|
|
{Name: "#example:test:4", Value: 4, FirstSeen: testTime, LastModified: testTime},
|
|
{Name: "#example:test:3", Value: 3, FirstSeen: testTime, LastModified: testTime},
|
|
}, cc)
|
|
|
|
cc, err = getCounterTopList(dbc, fmt.Sprintf(counterTemplate, ""), 3, "name DESC")
|
|
require.NoError(t, err)
|
|
assert.Len(t, cc, 3)
|
|
|
|
assert.Equal(t, []counter{
|
|
{Name: "#example:test:5", Value: 5, FirstSeen: testTime, LastModified: testTime},
|
|
{Name: "#example:test:4", Value: 4, FirstSeen: testTime, LastModified: testTime},
|
|
{Name: "#example:test:3", Value: 3, FirstSeen: testTime, LastModified: testTime},
|
|
}, cc)
|
|
|
|
cc, err = getCounterTopList(dbc, fmt.Sprintf(counterTemplate, ""), 3, "name")
|
|
require.NoError(t, err)
|
|
assert.Len(t, cc, 3)
|
|
|
|
assert.Equal(t, []counter{
|
|
{Name: "#example:test:0", Value: 0, FirstSeen: testTime, LastModified: testTime},
|
|
{Name: "#example:test:1", Value: 1, FirstSeen: testTime, LastModified: testTime},
|
|
{Name: "#example:test:2", Value: 2, FirstSeen: testTime, LastModified: testTime},
|
|
}, cc)
|
|
|
|
_, err = getCounterTopList(dbc, fmt.Sprintf(counterTemplate, ""), 3, "foobar")
|
|
assert.Error(t, err)
|
|
|
|
_, err = getCounterTopList(dbc, fmt.Sprintf(counterTemplate, ""), 3, "name foo")
|
|
assert.Error(t, err)
|
|
|
|
_, err = getCounterTopList(dbc, fmt.Sprintf(counterTemplate, ""), 3, "name ASC; DROP TABLE counters;")
|
|
assert.Error(t, err)
|
|
|
|
rank, count, err := getCounterRank(dbc,
|
|
fmt.Sprintf(counterTemplate, ""),
|
|
fmt.Sprintf(counterTemplate, 4))
|
|
require.NoError(t, err)
|
|
assert.Equal(t, int64(6), count)
|
|
assert.Equal(t, int64(2), rank)
|
|
}
|