public void CreatingAndRemovingTableInDB()
{
DBInstance dbInstance = new DBInstance("sensor_readings");
dbInstance.InitialiseSQLiteConnection();
string newTableName = "test";
dbInstance.ExecuteNonQuery(
SensorReadingTableDetails.CreateTableSQLString(newTableName));
bool doesTableExistAfterCreation = dbInstance.DoesTableExistInDB(newTableName);
Debug.Log("Table '" + newTableName + "' should now exist: " + doesTableExistAfterCreation);
dbInstance.ExecuteNonQuery(
SensorReadingTableDetails.DropTableSQLString(newTableName));
bool doesTableExistAfterRemoved = dbInstance.DoesTableExistInDB(newTableName);
Debug.Log("Table '" + newTableName + "' should now not exist: " + doesTableExistAfterRemoved);
dbInstance.CloseSQLiteConnection();
if ((doesTableExistAfterCreation) && (!doesTableExistAfterRemoved))
{
Assert.Pass();
}
else
{
Assert.Fail();
}
}
public void GetSensorReadingsFromTableInDB()
{
DBInstance dbInstance = new DBInstance(databaseName);
dbInstance.InitialiseSQLiteConnection();
SensorReadings = dbInstance.GetSensorReadingsFromTable(tableNameInDatabase);
dbInstance.CloseSQLiteConnection();
}
public void InsertingSensorReading()
{
DBInstance dbInstance = new DBInstance("sensor_readings");
dbInstance.InitialiseSQLiteConnection();
string newTableName = "testTable";
dbInstance.ExecuteNonQuery(SensorReadingTableDetails.CreateTableSQLString(newTableName));
int numberOfRowsBeforeAddition = dbInstance.GetNumberOfRowsInTable(newTableName);
Debug.Log("Number of rows in table before addition: " + numberOfRowsBeforeAddition);
BaseSensorReading newSensorReading = new BaseSensorReading
{
sensorName = " ",
sensorType = Sensor.Type.Interaction,
areaName = " "
};
newSensorReading.SetDateTime(1, 1, 1, 1, 1, 1);
string insertSensorReadingString = SensorReadingTableDetails.InsertSensorReadingSQLString(newSensorReading, "testBookmark", 0, newTableName);
Debug.Log(insertSensorReadingString);
dbInstance.ExecuteNonQuery(insertSensorReadingString);
int numberOfRowsAfterAddition = dbInstance.GetNumberOfRowsInTable(newTableName);
Debug.Log("Number of rows in table after addition: " + numberOfRowsAfterAddition);
dbInstance.ExecuteNonQuery(SensorReadingTableDetails.DropTableSQLString(newTableName));
dbInstance.CloseSQLiteConnection();
if (numberOfRowsBeforeAddition == numberOfRowsAfterAddition - 1)
{
Assert.Pass();
}
else
{
Assert.Fail();
}
}
public void InitialiseAndCloseDBConnection()
{
DBInstance dbInstance = new DBInstance("sensor_readings");
dbInstance.InitialiseSQLiteConnection();
bool dbInitialised = dbInstance.IsDbConnectionEstablished();
dbInstance.CloseSQLiteConnection();
bool dbClosed = dbInstance.IsDbConnectionEstablished();
if ((dbInitialised) && (!dbClosed))
{
Assert.Pass();
}
else
{
Assert.Fail();
}
}
private static DBInstance dbInstance; // Database connection instance
/*
* Consider defining an interface/parent class for these methods,
* as it is shared with the DBInterfaceForInputVectors class.
*/
/// <summary>
/// Utility method for initialising a connection to a specified database.
/// </summary>
/// <param name="databaseName">Name of database to be connected to.</param>
public static void InitialiseDatabaseConnection(string databaseName)
{
dbInstance = new DBInstance(databaseName);
dbInstance.InitialiseSQLiteConnection();
}