public static string CrreateJson(BlobDataContract blob)
{
var limit = 0;
var js = string.Empty;
js += "[{";
js += $"\"user_anon_id\": \"{blob.user_anon_id}\",";
js += $"\"client_CountryOrRegion\": \"{blob.client_CountryOrRegion}\",";
js += $"\"client_StateOrProvince\": \"{blob.client_StateOrProvince}\",";
js += $"\"client_City\": \"{blob.client_City}\",";
js += $"\"client_OS\": \"{blob.client_OS}\",";
js += $"\"client_Model\": \"{blob.client_Model}\",";
js += $"\"client_Browser\": \"{blob.client_Browser}\",";
js += $"\"session_landing_page_vector\": {blob.session_landing_page_vector},"; // array
js += $"\"session_daytime_vector\": {blob.session_daytime_vector},"; //array
js += $"\"session_weekend\": {blob.session_weekend},";
js += $"\"n_session\": {blob.n_session},";
js += $"\"session_length_mean\": {blob.session_length_mean},";
js += $"\"session_length_std\": {blob.session_length_std},";
js += $"\"session_length_sum\": {blob.session_length_sum},";
js += $"\"game_session_daytime_vector\": {blob.game_session_daytime_vector},";// array
js += $"\"n_game_session\": {blob.n_game_session},";
js += $"\"game_session_weekend\": {blob.game_session_weekend},";
js += $"\"game_session_length_mean\": {blob.game_session_length_mean},";
js += $"\"game_session_length_std\": {blob.game_session_length_std},";
js += $"\"game_session_length_sum\": {blob.game_session_length_sum},";
js += $"\"game_completion_rate\": {blob.game_completion_rate},";
js += $"\"game_category_vector\": {blob.game_category_vector},"; //array
js += $"\"user_game_vector\": {blob.user_game_vector.Remove(blob.user_game_vector.Length - 1)},"; //array
js += $"\"timestamp\":\"{DateTime.Now:o}\"";
js += "}]";
limit++;
return(js);
}
public static List <BlobDataContract> ReadCsv(string path)
{
if (path == "Path to Csv DataBase")
{
path = @"D:\users_2019-04-23.csv";
}
var csvList = new List <BlobDataContract>();
using (var reader = new StreamReader(path))
{
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(new [] { "\",\"" }, StringSplitOptions.None);
var blobElement = new BlobDataContract
{
user_anon_id = values[0].Replace("\"\"", "").Replace("\"", ""),
client_CountryOrRegion = values[1],
client_StateOrProvince = values[2],
client_City = values[3],
client_OS = values[4],
client_Model = values[5],
client_Browser = values[6],
session_landing_page_vector = values[7],
session_daytime_vector = values[8],
session_weekend = values[9],
n_session = values[10],
session_length_mean = values[11],
session_length_std = values[12],
session_length_sum = values[13],
game_session_daytime_vector = values[14],
user_game_vector = values[22].Replace("\"\"", "\""),
n_game_session = values[15],
game_session_weekend = values[16],
game_session_length_mean = values[17],
game_session_length_std = values[18],
game_session_length_sum = values[19],
game_completion_rate = values[20],
game_category_vector = values[21],
};
if (blobElement.n_session == "n_session")
{
continue;
}
csvList.Add(blobElement);
}
}
return(csvList);
}