// Update is called once per frame public int UpdateTimeTaken(float TimeTaken) { int statusCode = 0; try { ExperimentalDesignDb expdb = new ExperimentalDesignDb(); Start(); TestSuiteDatabase tsd = new TestSuiteDatabase(); if (tsd.testUpdateTimeTaken(dbConnection, "SELECT COUNT(ID) FROM experimental_results where TimeTaken = 0 ;")) { expdb.Update(dbConnection, "UPDATE experimental_results SET TimeTaken='" + TimeTaken + "' WHERE ID IN (SELECT Max(ID) FROM experimental_results);"); statusCode = 200; } else { statusCode = 400; } } catch (SqliteException sqlEx) { statusCode = 400; Debug.LogError(sqlEx); } return(statusCode); }
public float averagevalue(string yAxisValue, string InputAlgorithmValue, string MazeSizeValue, float Threshold, string SensorTypeValue) { ExperimentalDesignDb expdb = new ExperimentalDesignDb(); Start(); TestSuiteDatabase tsd = new TestSuiteDatabase(); tsd.TestSelectValuesfromDB(yAxisValue); float range = expdb.averagevalue(dbConnection, yAxisValue, InputAlgorithmValue, MazeSizeValue, Threshold, SensorTypeValue); return(range); }