//Method to send query and get response and then assemble the response.
public ArrayList GetData()
{
ArrayList tempArray = new ArrayList();
try
{
//tempArray.Add(System.IO.Directory.GetCurrentDirectory());
//var credentials = GoogleCredential.FromFile("./Assets/Scripts/Additional/authKey.json");
//var credentials = GoogleCredential.FromFile("/Additional/authkey.json");
var credentials = GoogleCredential.FromJson("Not Today");
BigQueryClient ourClient = BigQueryClient.Create(projectCode, credentials);
String query = this.FormQuery();
Debug.Log(query);
BigQueryResults results = ourClient.ExecuteQuery(query, parameters: null);
ArrayList stateData = new ArrayList();
StateData currentState = new StateData();
foreach (BigQueryRow row in results)
{
String date = Convert.ToString(row["date"]);
String country = Convert.ToString(row["country_code"]);
String state = Convert.ToString(row["subregion1_name"]);
String coordinates = Convert.ToString(row["location_geometry"]);
int confirmedCases = Convert.ToInt32(row["cumulative_confirmed"]);
int deceased = Convert.ToInt32(row["cumulative_deceased"]);
if (currentState.IsValidInsertion(state))
{
currentState.AddRow(country, state, coordinates, date, confirmedCases, deceased);
}
else
{
stateData.Add(currentState);
currentState = new StateData();
currentState.AddRow(country, state, coordinates, date, confirmedCases, deceased);
getDataSize++;
}
}
Debug.Log("Made it to data");
return(stateData);
}catch (Exception e)
{
tempArray.Add(e.ToString());
return(tempArray);
}
}
