public int AddScoreRecordToStorage (ScoreRecord record) { var stopWatch = Stopwatch.StartNew (); var id = m_dataStorage.AddScoreRecordToStorage(record); stopWatch.Stop (); m_logger.Info(string.Format ("{0} AddScoreRecordToStorage: Call took {1} Ms", m_dataStorage.GetType(), stopWatch.ElapsedMilliseconds)); return(id); }
public void AddScoreRecordToStorage_GivenGameNameAndSingleScoreRecord_RecordGetsAddedToCache() { var record = new ScoreRecord { PlayerName = "Player1", Score = 3000, GameName = "game1"}; string gameName = "Game1"; m_gameScoreBoardCache.AddScoreRecordToStorage(record); Assert.AreEqual(m_gameScoreBoardCache.GetAllScoresForGame(gameName).FirstOrDefault().PlayerName, record.PlayerName); }
public void GetAllScoresForUsername_GivenValidUsername_ReturnsScoreForUsername() { var exampleRecord = new ScoreRecord { GameName = m_gameName, PlayerName = m_playerName, Score = 1000 }; m_mysqlConnection.AddScoreRecordToStorage (exampleRecord); var resultFromDb = m_mysqlConnection.GetAllScoresForUsername (m_playerName); var playerRecord = resultFromDb.FirstOrDefault (); Assert.IsTrue (resultFromDb.Count() > 0); Assert.AreEqual (m_playerName, playerRecord.PlayerName); Assert.AreEqual (1000, playerRecord.Score ); }
public int AddScoreRecordToStorage(ScoreRecord record) { List<ScoreRecord> gameScoreRecords; m_gameScoreBoardCache.TryGetValue (record.GameName.ToLower (), out gameScoreRecords); if (gameScoreRecords == null) { gameScoreRecords = new List<ScoreRecord> (); } gameScoreRecords.Add(record); m_gameScoreBoardCache.AddOrUpdate(record.GameName, gameScoreRecords, (id, oldScoreList) => gameScoreRecords); return m_gameScoreBoardCache.Count(); }
public int AddScoreRecordToStorage (ScoreRecord record) { var sql = @"INSERT INTO GameScoreBoard(GameName,PlayerName,Score) VALUES (@GameName, @PlayerName, @Score); SELECT LAST_INSERT_ID();"; using (var connection = m_connectionFactory.GetOpenConnection()) { try { return connection.Query<int>(sql, record).FirstOrDefault(); } catch(MySqlException e) { Console.WriteLine (e); return -1; } finally { connection.Close(); } } }
public TestStringCipher () { m_chiper = new StringCipher (); m_scoreRecord = new ScoreRecord { PlayerName = "player1", GameName = "Game1", Score = 5000 }; }
public void AddScoreBoardData_GivenValidGameRecordObjectAsJson_ReturnsCorrectObjectFromStorage() { IDataStorage cache = new GameScoreBoardDataCache (); TestDataProvider.ProvideTestData (cache); var bootstrapper = new TestableLightInjectNancyBootstrapper (cache); var browser = new Browser(bootstrapper, defaults: to => to.Accept("application/json")); string expectedGameName = "game5"; int expectedCount = 1; var scoreRecordObject = new ScoreRecord { GameName = expectedGameName, PlayerName = expectedCount.ToString(), Score = 5000 }; var post = browser.Post ("/api/v1/addScoreBoardData", with => { with.Header("Content-Type", "application/json"); with.JsonBody (scoreRecordObject); }); var response = browser.Get("/api/v1/gameScoreBoard", with => { with.HttpRequest(); with.Query("gameName", expectedGameName); with.Query("count", expectedCount.ToString()); }); var postRespons = JsonConvert.DeserializeObject<int> (post.Body.AsString ()); var responseModels = JsonConvert.DeserializeObject<IEnumerable<ScoreRecord>> (response.Body.AsString()); Assert.IsTrue (postRespons > -1); Assert.IsTrue (responseModels.Count() == expectedCount); Assert.AreEqual (expectedGameName, responseModels.FirstOrDefault ().GameName); }
public void AddScoreBoardData_GivenValidGameRecordObjectAsJson_ReturnsHttpCreated() { IDataStorage cache = new GameScoreBoardDataCache (); TestDataProvider.ProvideTestData (cache); var bootstrapper = new TestableLightInjectNancyBootstrapper (cache); var browser = new Browser(bootstrapper, defaults: to => to.Accept("application/json")); var scoreRecordObject = new ScoreRecord { GameName = "game5", PlayerName = "player5", Score = 5000 }; var response = browser.Post ("/api/v1/addScoreBoardData", with => { with.Header("Content-Type", "application/json"); with.JsonBody (scoreRecordObject); }); Assert.AreEqual (HttpStatusCode.Created, response.StatusCode); }
public void AddScoreRecordToStorage_GivenValidScoreRecord_ReturnsIdFromDataStorage() { var exampleRecord = new ScoreRecord { GameName = m_gameName, PlayerName = m_playerName, Score = 1000 }; Assert.IsTrue (m_mysqlConnection.AddScoreRecordToStorage (exampleRecord) > -1); }