public void CloseDescription()
{
float duration = Time.time - AppManager.startDescriptionTime;
AppManager.startDescriptionTime = 0f;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "CloseDescription_" + AppManager.currentDescription, duration.ToString());
}
//private SqliteDbManager sqliteManager;
// Use this for initialization
void Start()
{
if (ageContainer != null)
{
statsAge = ageContainer.GetComponentsInChildren <Toggle> ();
}
else
{
statsAge = new Toggle[0];
}
if (sexContainer != null)
{
statsSex = sexContainer.GetComponentsInChildren <Toggle> ();
}
else
{
statsSex = new Toggle[0];
}
//sqliteManager = this.GetComponent<SqliteDbManager> ();
SqliteDbManager.Init();
if (testNum != -1)
{
StatTest(testNum);
}
}
public int Insert(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("INSERT INTO localization (key, text, language_id) VALUES (@key, @text, @lang_id);", new SqliteParameter("@key", values[0]),
new SqliteParameter("@text", values[1]), new SqliteParameter("@lang_id", values[2])));
}
public void FoundTarget(string name)
{
AppManager.foundTargetTime = Time.time;
AppManager.nbTargetFound++;
AppManager.currentTargetName = name;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "FoundTarget", name);
}
private void StartSession()
{
AppManager.sessionId = Random.Range(10000, 99999);
ShowSessionId();
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StartSession", "");
AppManager.startSessionTime = Time.time;
}
public void ValidateSex()
{
foreach (Toggle sex in statsSex)
{
if (sex.isOn)
{
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Sex", sex.gameObject.name);
}
}
}
public void LostTarget()
{
if (AppManager.currentTargetName != "")
{
float duration = Time.time - AppManager.foundTargetTime;
AppManager.foundTargetTime = 0f;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "LostTarget_" + AppManager.currentTargetName, duration.ToString());
AppManager.currentTargetName = "";
}
}
public void StopSession()
{
if (AppManager.startTestTime != 0f)
{
StopTest();
}
float duration = Time.time - AppManager.startSessionTime;
AppManager.startSessionTime = 0f;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StopSession", duration.ToString());
}
public void StatTest(int nb)
{
if (AppManager.startTestTime != 0f)
{
StopTest();
}
AppManager.startTestTime = Time.time;
AppManager.nbTargetFound = 0;
AppManager.currentTest = nb;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StartTest_" + nb.ToString(), "");
}
public void ValidateAge()
{
StartSession();
foreach (Toggle age in statsAge)
{
if (age.isOn)
{
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Age", age.gameObject.name);
}
}
}
public void StopTest()
{
if (AppManager.foundTargetTime != 0f)
{
LostTarget();
}
float duration = Time.time - AppManager.startTestTime;
AppManager.startTestTime = 0f;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "NbTargetFound_" + AppManager.currentTest, AppManager.nbTargetFound.ToString());
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StopTest_" + AppManager.currentTest.ToString(), duration.ToString());
}
public List <Language> ReadAll()
{
List <Language> languages = new List <Language>();
IDbManager dbMgr = new SqliteDbManager();
List <object[]> values = dbMgr.Read("SELECT * FROM languages;");
foreach (object[] row in values)
{
languages.Add(new Language(int.Parse(row[0].ToString()), row[1].ToString()));
}
return(languages);
}
public List <object[]> Read(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
if (values.Length == 1)
{
return(dbMgr.Read("SELECT key, text FROM localization WHERE language_id = @lang_id;", new SqliteParameter("@lang_id", values[0])));
}
else if (values.Length == 1)
{
return(dbMgr.Read("SELECT text FROM localization WHERE key = @key AND language_id = @lang_id;", new SqliteParameter("@key", values[0]), new SqliteParameter("@lang_id", values[1])));
}
return(new List <object[]>());
}
public int Update(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("UPDATE localization SET text = @text WHERE key = @key AND language_id = @lang_id;", new SqliteParameter("@text", values[0]), new SqliteParameter("@key", values[1]), new SqliteParameter("@lang_id", values[2])));
}
public List <object[]> ReadAll()
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Read("SELECT * FROM localization;"));
}
public void Like()
{
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Result_" + AppManager.currentTest, "like");
}
public int Delete(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("DELETE FROM localization WHERE key = @key;", new SqliteParameter("@key", values[0])));
}
public int Update(Language value)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("UPDATE languages SET name = @name WHERE language_id = @id;", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name)));
}
public int Insert(Language value)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("INSERT INTO languages (language_id, name) VALUES (@id, @name);", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name)));
}
public int Delete(Language value)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("DELETE FROM languages WHERE language_id = @id AND name = @name;", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name)));
}
public void OpenDescription(string content)
{
AppManager.startDescriptionTime = Time.time;
AppManager.currentDescription = content;
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "OpenDescription", content);
}
public void DontLikeDescription()
{
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Result_" + AppManager.currentDescription + AppManager.currentTest, "dont-like");
}
public void FoundVoucher(string target)
{
SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "FoundVoucher", target);
}
