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(); } }