public List <float> GetLatestScoresForMiniGame(MiniGameCode minigameCode, int nLastDays)
{
int fromTimestamp = GenericUtilities.GetRelativeTimestampFromNow(-nLastDays);
string query = string.Format("SELECT * FROM LogPlayData WHERE MiniGame = '{0}' AND Timestamp < {1}",
(int)minigameCode, fromTimestamp);
List <LogPlayData> list = dbManager.FindLogPlayDataByQuery(query);
List <float> scores = list.ConvertAll(x => x.Score);
return(scores);
}
public void TestInsertScoreData()
{
int rndTableValue = RND.Range(0, 7);
DbTables rndTable = DbTables.Letters;
string rndId = "";
switch (rndTableValue)
{
case 0:
rndTable = DbTables.Letters;
rndId = RandomHelper.GetRandom(dbManager.GetAllLetterData()).GetId();
break;
case 1:
rndTable = DbTables.Words;
rndId = RandomHelper.GetRandom(dbManager.GetAllWordData()).GetId();
break;
case 2:
rndTable = DbTables.Phrases;
rndId = RandomHelper.GetRandom(dbManager.GetAllPhraseData()).GetId();
break;;
case 3:
rndTable = DbTables.MiniGames;
rndId = RandomHelper.GetRandom(dbManager.GetAllMiniGameData()).GetId();
break;
case 4:
rndTable = DbTables.PlaySessions;
rndId = RandomHelper.GetRandom(dbManager.GetAllPlaySessionData()).GetId();
break;
case 5:
rndTable = DbTables.Stages;
rndId = RandomHelper.GetRandom(dbManager.GetAllStageData()).GetId();
break;
case 6:
rndTable = DbTables.Rewards;
rndId = RandomHelper.GetRandom(dbManager.GetAllRewardData()).GetId();
break;
}
var lastAccessTimestamp = GenericUtilities.GetRelativeTimestampFromNow(-RND.Range(0, 5));
var score = RND.Range(0f, 1f);
this.dbManager.Debug_UpdateScoreData(rndTable, rndId, score, lastAccessTimestamp);
PrintOutput("Inserted (or replaced) new ScoreData: " + lastAccessTimestamp.ToString());
}
public void TestInsertLogPlayData()
{
var newData = new LogPlayData();
newData.Session = UnityEngine.Random.Range(0, 10).ToString();
newData.Timestamp = GenericUtilities.GetRelativeTimestampFromNow(-RND.Range(0, 5));
newData.PlaySession = "1.1.1";
newData.MiniGame = MiniGameCode.Balloons_counting;
newData.Score = RND.Range(0, 1f);
newData.PlayEvent = RND.value > 0.5f ? PlayEvent.GameFinished : PlayEvent.Skill;
newData.PlaySkill = PlaySkill.Logic;
newData.RawData = "TEST";
this.dbManager.Insert(newData);
PrintOutput("Inserted new LogPlayData: " + newData.ToString());
}
