func beforeClueTest() { table.LoadFixtures(table.Fixtures{ "questions": []table.RowFixture{ table.RowFixture{ "question_id": 1, "text": "Text 1", "answer": "Answer 1", "hint_one": "Hint 1A", "hint_two": "Hint 1B", "description": "Description 1", "is_enabled": 1, }, table.RowFixture{ "question_id": 2, "text": "Text 2", "answer": "Answer 2", "hint_one": "Hint 2A", "hint_two": "Hint 2B", "description": "Description 2", "is_enabled": 1, }, }, "team_progress": []table.RowFixture{ table.RowFixture{ "team_id": 1, "question_id": 1, "hint_cnt": 0, }, }, }) }
func TestLeastUsedTrackId_NoTeamTracks(t *T) { table.LoadFixtures(table.Fixtures{ "team_tracks": []table.RowFixture{}, "tracks": []table.RowFixture{ table.RowFixture{ "track_id": 1, "question_id_order": "1|2|3", "start_time": time.Now().Add(-1 * time.Hour), "end_time": time.Now().Add(1 * time.Hour), }, table.RowFixture{ "track_id": 2, "question_id_order": "3|2|1", "start_time": time.Now().Add(-1 * time.Hour), "end_time": time.Now().Add(1 * time.Hour), }, table.RowFixture{ "track_id": 3, "question_id_order": "2|1|3", "start_time": time.Now().Add(-1 * time.Hour), "end_time": time.Now().Add(1 * time.Hour), }, }, }) trackId, err := table.LeastUsedTrackId(time.Now()) rdtest.Assert(t, err == nil, err) rdtest.Assert(t, trackId >= 1 && trackId <= 3, "%d", trackId) }
func beforeTeamTest() { table.LoadFixtures(table.Fixtures{ "users": []table.RowFixture{ table.RowFixture{ "team_id": 100, "telephone": "1231231234", }, table.RowFixture{ "team_id": 100, "telephone": "3213213214", }, }, "teams": []table.RowFixture{ table.RowFixture{ "team_id": 100, "name": "Team 100", "track_id": 50, }, }, "phrases": []table.RowFixture{ table.RowFixture{ "phrase_id": 1000, "phrase": "phrase 1000", "team_id": 100, }, }, }) }
func beforeTrackTest() { table.LoadFixtures(table.Fixtures{ "teams": []table.RowFixture{ table.RowFixture{"team_id": 1, "track_id": 1, "name": "Team 1"}, table.RowFixture{"team_id": 2, "track_id": 1, "name": "Team 1"}, table.RowFixture{"team_id": 3, "track_id": 1, "name": "Team 1"}, table.RowFixture{"team_id": 4, "track_id": 2, "name": "Team 1"}, table.RowFixture{"team_id": 5, "track_id": 2, "name": "Team 1"}, table.RowFixture{"team_id": 6, "track_id": 3, "name": "Team 1"}, }, "users": []table.RowFixture{ table.RowFixture{ "team_id": 1, "telephone": "1231231234", }, table.RowFixture{ "team_id": 2, "telephone": "3213213214", }, }, "tracks": []table.RowFixture{ table.RowFixture{ "track_id": 1, "question_id_order": "1|2|3", "start_time": time.Now().Add(-1 * time.Hour), "end_time": time.Now().Add(1 * time.Hour), "name": "Track 1", }, table.RowFixture{ "track_id": 2, "question_id_order": "3|2|1", "start_time": time.Now().Add(-1 * time.Hour), "end_time": time.Now().Add(1 * time.Hour), "name": "Track 2", }, table.RowFixture{ "track_id": 3, "question_id_order": "2|1|3", "start_time": time.Now().Add(-1 * time.Hour), "end_time": time.Now().Add(1 * time.Hour), "name": "Track 3", }, }, }) }
func beforePhraseTest() { table.LoadFixtures(table.Fixtures{ "phrases": []table.RowFixture{ table.RowFixture{ "phrase_id": 1, "phrase": "phrase_1", }, table.RowFixture{ "phrase_id": 2, "phrase": "phrase_2", }, table.RowFixture{ "phrase_id": 3, "phrase": "phrase_3", }, }, }) }
func beforeHintTest() { table.LoadFixtures(table.Fixtures{ "hints": []table.RowFixture{ table.RowFixture{ "idx": 0, "question_id": 1, "hint": "This is a hint", }, table.RowFixture{ "idx": 1, "question_id": 1, "hint": "This is a loaction hint", "latitude": 12.12, "longitude": 12.12, }, }, }) }
func beforeTeamTest() { table.LoadFixtures(table.Fixtures{ "phrases": []table.RowFixture{ table.RowFixture{"phrase_id": 1, "phrase": "phrase_1"}, table.RowFixture{"phrase_id": 2, "phrase": "phrase_2"}, table.RowFixture{"phrase_id": 3, "phrase": "phrase_3"}, }, "teams": []table.RowFixture{}, "users": []table.RowFixture{}, "challenges": []table.RowFixture{ table.RowFixture{ "challenge_id": 1, "name": "Challenge 1", "start_time": time.Now().Add(-2 * time.Hour), "end_time": time.Now().Add(2 * time.Hour), }, }, "tracks": []table.RowFixture{ table.RowFixture{"track_id": 1, "challenge_id": 1}, }, }) }
func beforeUserTest() { table.LoadFixtures(table.Fixtures{ "teams": []table.RowFixture{ table.RowFixture{"team_id": 1, "track_id": 1, "name": "Team 1"}, table.RowFixture{"team_id": 2, "track_id": 1, "name": "Team 1"}, table.RowFixture{"team_id": 3, "track_id": 1, "name": "Team 1"}, table.RowFixture{"team_id": 4, "track_id": 2, "name": "Team 1"}, table.RowFixture{"team_id": 5, "track_id": 2, "name": "Team 1"}, table.RowFixture{"team_id": 6, "track_id": 3, "name": "Team 1"}, }, "users": []table.RowFixture{ table.RowFixture{ "user_id": 100, "telephone": "9998887777", "team_id": 1, "did_accept_waiver": true, }, }, "phrases": []table.RowFixture{ table.RowFixture{ "phrase_id": 1000, "phrase": "the phrase", "team_id": 1, }, }, }) }
func beforeHintTest() { table.LoadFixtures(table.Fixtures{ "questions": []table.RowFixture{ table.RowFixture{ "question_id": 1, "text": "Text 1", "answer": "Answer 1", "hint_one": "Hint 1A", "hint_two": "Hint 1B", "description": "Description 1", "is_enabled": 1, }, }, "team_progress": []table.RowFixture{ table.RowFixture{ "team_id": 1, "question_id": 1, "hint_cnt": 0, }, }, "teams": []table.RowFixture{ table.RowFixture{ "team_id": 1, "name": "Team 1", "track_id": 1, }, }, "tracks": []table.RowFixture{ table.RowFixture{ "track_id": 1, "question_id_order": "1|2|3|4", "start_time": time.Now(), }, }, }) }
func beforeCurrentTest() { table.LoadFixtures(table.Fixtures{ "questions": []table.RowFixture{ table.RowFixture{ "question_id": 1, "text": "Text 1", "answer": "Answer 1", "hint_one": "Hint 1A", "hint_two": "Hint 1B", "description": "Description 1", "is_enabled": 1, }, table.RowFixture{ "question_id": 2, "text": "Text 2", "answer": "Answer 2", "hint_one": "Hint 2A", "hint_two": "Hint 2B", "description": "Description 2", "is_enabled": 0, }, table.RowFixture{ "question_id": 3, "text": "Text 3", "answer": "Answer 3", "hint_one": "Hint 3A", "hint_two": "Hint 3B", "description": "Description 3", "is_enabled": 1, }, table.RowFixture{ "question_id": 4, "text": "Text 4", "answer": "Answer 4", "hint_one": "Hint 4A", "hint_two": "Hint 4B", "description": "Description 4", "is_enabled": 1, }, }, "team_progress": []table.RowFixture{ table.RowFixture{ "team_id": 1, "question_id": 1, "hint_cnt": 0, "answer_time": time.Date(2016, 1, 1, 13, 0, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 2, "question_id": 1, "hint_cnt": 2, }, table.RowFixture{ "team_id": 3, "question_id": 1, "hint_cnt": 0, "answer_time": time.Date(2016, 1, 1, 13, 0, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 3, "question_id": 3, "hint_cnt": 0, "answer_time": time.Date(2016, 1, 1, 13, 0, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 3, "question_id": 4, "hint_cnt": 1, }, table.RowFixture{ "team_id": 1, "question_id": 2, "hint_cnt": 0, }, }, "teams": []table.RowFixture{ table.RowFixture{ "team_id": 1, "name": "Team 1", "track_id": 1, }, table.RowFixture{ "team_id": 2, "name": "Team 2", "track_id": 2, }, table.RowFixture{ "team_id": 3, "name": "Team 3", "track_id": 3, }, }, "tracks": []table.RowFixture{ table.RowFixture{ "track_id": 1, "question_id_order": "1|2|3|4", "start_time": clueTestNow.Add(-24 * time.Hour), "end_time": clueTestNow.Add(24 * time.Hour), }, }, }) }
func beforeAnswerTest() { table.LoadFixtures(table.Fixtures{ "questions": []table.RowFixture{ table.RowFixture{ "question_id": 1, "text": "Text 1", "answer": "Answer 1|1|1BA|1ba|trailing | prefixing", "hint_one": "Hint 1A", "hint_two": "Hint 1B", "description": "Description 1", "is_enabled": 1, }, table.RowFixture{ "question_id": 2, "text": "Text 2", "answer": "Answer 2", "hint_one": "Hint 2A", "hint_two": "Hint 2B", "description": "Description 2", "is_enabled": 0, }, table.RowFixture{ "question_id": 3, "text": "Text 3", "answer": "Answer 3|answer3|AnSWER33", "hint_one": "Hint 3A", "hint_two": "Hint 3B", "description": "Description 3", "is_enabled": 1, }, table.RowFixture{ "question_id": 4, "text": "Text 4", "answer": "Answer 4", "hint_one": "Hint 4A", "hint_two": "Hint 4B", "description": "Description 4", "is_enabled": 1, }, }, "team_progress": []table.RowFixture{ table.RowFixture{ "team_id": 1, "question_id": 1, "hint_cnt": 0, }, }, "teams": []table.RowFixture{ table.RowFixture{ "team_id": 1, "name": "Team 1", "track_id": 1, }, }, "tracks": []table.RowFixture{ table.RowFixture{ "track_id": 1, "question_id_order": "1|2|3|4", "start_time": time.Now().Add(time.Hour * -24), "end_time": time.Now().Add(time.Hour * 24), }, }, }) }
func beforeTeamProgressTest() { table.LoadFixtures(table.Fixtures{ "teams": []table.RowFixture{ table.RowFixture{ "team_id": 20, "name": "Team 20", "track_id": 1, }, table.RowFixture{ "team_id": 21, "name": "Team 20", "track_id": 2, }, table.RowFixture{ "team_id": 22, "name": "Team 22", "track_id": 1, "finish_time": time.Now(), }, }, "phrases": []table.RowFixture{ table.RowFixture{ "phrase_id": 1, "team_id": 20, "phrase": "Phrase 1", }, table.RowFixture{ "phrase_id": 2, "team_id": 21, "phrase": "Phrase 2", }, table.RowFixture{ "phrase_id": 3, "team_id": 22, "phrase": "Phrase 3", }, }, "tracks": []table.RowFixture{ table.RowFixture{ "track_id": 1, "question_id_order": "1|2|3", "start_time": time.Date(2016, 6, 1, 0, 0, 0, 0, time.UTC), "end_time": time.Date(2016, 7, 1, 0, 0, 0, 0, time.UTC), }, table.RowFixture{ "track_id": 2, "question_id_order": "3|1|2", "start_time": time.Date(2016, 6, 1, 0, 0, 0, 0, time.UTC), "end_time": time.Date(2016, 7, 1, 0, 0, 0, 0, time.UTC), }, }, "questions": []table.RowFixture{ table.RowFixture{ "question_id": 1, "text": "Text 1", "answer": "Answer 1", "hint_one": "hint 1", "hint_two": "hint b1", "description": "Description 1", "is_enabled": 1, }, table.RowFixture{ "question_id": 2, "text": "Text 2", "answer": "Answer 2", "hint_one": "hint 2", "hint_two": "hint b2", "description": "Description 2", "is_enabled": 1, }, table.RowFixture{ "question_id": 3, "text": "Text 3", "answer": "Answer 3", "hint_one": "hint 3", "hint_two": "hint b3", "description": "Description 3", "is_enabled": 1, }, table.RowFixture{ "question_id": 4, "text": "Text 4", "answer": "Answer 4", "hint_one": "hint 4", "hint_two": "hint b4", "description": "Description 4", "is_enabled": 1, }, }, "team_progress": []table.RowFixture{ table.RowFixture{ "team_id": 1, "question_id": 1, "hint_cnt": 0, }, table.RowFixture{ "team_id": 1, "question_id": 2, "hint_cnt": 0, }, table.RowFixture{ "team_id": 22, "question_id": 3, "hint_cnt": 2, "answer_time": time.Date(2016, 6, 6, 13, 0, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 20, "question_id": 2, "hint_cnt": 1, "answer_time": time.Date(2016, 6, 6, 13, 0, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 20, "question_id": 3, "hint_cnt": 1, }, table.RowFixture{ "team_id": 21, "question_id": 2, "hint_cnt": 2, "answer_time": time.Date(2016, 6, 6, 13, 0, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 21, "question_id": 3, "hint_cnt": 1, "answer_time": time.Date(2016, 6, 6, 13, 5, 0, 0, time.UTC), }, table.RowFixture{ "team_id": 21, "question_id": 4, "hint_cnt": 0, }, }, "hints": []table.RowFixture{ table.RowFixture{ "idx": 0, "question_id": 3, "hint": "This is a hint 0", }, table.RowFixture{ "idx": 1, "question_id": 3, "hint": "This is a hint 1", }, table.RowFixture{ "idx": 0, "question_id": 1, "hint": "This is a hint 0 for quesiton 1", }, table.RowFixture{ "idx": 1, "question_id": 1, "hint": "This is a hint 1 for quesiton 1", }, }, }) }