private static void AddEventToStore(JSONClass eventData)
#endif
{
// Check if datastore is available
if (!GAStore.IsTableReady)
{
GALogger.W("Could not add event: SDK datastore error");
return;
}
// Check if we are initialized
if (!GAState.Initialized)
{
GALogger.W("Could not add event: SDK is not initialized");
return;
}
try
{
// Check db size limits (10mb)
// If database is too large block all except user, session and business
if (GAStore.IsDbTooLargeForEvents && !GAUtilities.StringMatch(eventData["category"].AsString, "^(user|session_end|business)$"))
{
GALogger.W("Database too large. Event has been blocked.");
return;
}
// Get default annotations
JSONClass ev = GAState.GetEventAnnotations();
// Create json with only default annotations
string jsonDefaults = ev.SaveToBase64();
// Merge with eventData
foreach (KeyValuePair <string, JSONNode> pair in eventData)
{
ev.Add(pair.Key, pair.Value);
}
// Create json string representation
string json = ev.ToString();
// output if VERBOSE LOG enabled
GALogger.II("Event added to queue: " + json);
// Add to store
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("$status", "new");
parameters.Add("$category", ev["category"].Value);
parameters.Add("$session_id", ev["session_id"].Value);
parameters.Add("$client_ts", ev["client_ts"].Value);
parameters.Add("$event", ev.SaveToBase64());
string sql = "INSERT INTO ga_events (status, category, session_id, client_ts, event) VALUES($status, $category, $session_id, $client_ts, $event);";
GAStore.ExecuteQuerySync(sql, parameters);
// Add to session store if not last
if (eventData["category"].AsString.Equals(CategorySessionEnd))
{
parameters.Clear();
parameters.Add("$session_id", ev["session_id"].Value);
sql = "DELETE FROM ga_session WHERE session_id = $session_id;";
GAStore.ExecuteQuerySync(sql, parameters);
}
else
{
sql = "INSERT OR REPLACE INTO ga_session(session_id, timestamp, event) VALUES($session_id, $timestamp, $event);";
parameters.Clear();
parameters.Add("$session_id", ev["session_id"].Value);
parameters.Add("$timestamp", GAState.SessionStart);
parameters.Add("$event", jsonDefaults);
GAStore.ExecuteQuerySync(sql, parameters);
}
}
catch (Exception e)
{
GALogger.E("addEventToStoreWithEventData: error using json");
GALogger.E(e.ToString());
}
}