public void ExecuteQueryWithParametersTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
var parameters = new List <SQLiteParameter>();
var aParameter = SqliteExtensions.Create("a", DbType.String, "string1");
var bParameter = SqliteExtensions.Create("b", DbType.Int32, 32);
parameters.Add(aParameter);
parameters.Add(bParameter);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a, b);");
using (var c = DatabaseWrapper.ExecuteSingleResultQuery($"SELECT a FROM {tableName} WHERE a = 'nothing';"))
{
Assert.IsTrue(c.IsEmpty);
}
DatabaseWrapper.ExecuteSqlWithParameters($"INSERT INTO {tableName}(a, b) VALUES ({aParameter.ParameterName}, {bParameter.ParameterName});", parameters);
using (var c = DatabaseWrapper.ExecuteQueryWithParameters($"SELECT a FROM {tableName} WHERE a = {aParameter.ParameterName};", parameters))
{
Assert.AreEqual(c.GetString(0), "string1");
}
aParameter = SqliteExtensions.Create("a", DbType.String, "string2");
bParameter = SqliteExtensions.Create("b", DbType.Int32, 64);
DatabaseWrapper.ExecuteSqlWithParameters($"INSERT INTO {tableName}(a, b) VALUES ({aParameter.ParameterName}, {bParameter.ParameterName});", parameters);
using (var c = DatabaseWrapper.ExecuteQueryWithParameters($"SELECT b FROM {tableName} WHERE b = {bParameter.ParameterName};", parameters))
{
Assert.AreEqual(32, c.GetInt(0));
}
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
public void ExecuteSqlWithParametersTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
var parameters = new List <SQLiteParameter>();
var testParameter = new SQLiteParameter("@testParamName", DbType.String)
{
Value = "testValue"
};
parameters.Add(testParameter);
try
{
DatabaseWrapper.ExecuteSqlWithParameters($"INSERT INTO {tableName}(a,b) VALUES ('test0', {testParameter.ParameterName});", parameters);
}
catch (Exception)
{
Assert.Fail();
}
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
public void TransactionsTest()
{
DatabaseWrapper.BeginTransaction();
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test0', 'test1');");
DatabaseWrapper.CommitTransaction();
using (var cursor = DatabaseWrapper.ExecuteSingleResultQuery($"SELECT * FROM {tableName};"))
{
Assert.IsTrue(DatabaseWrapper.HasOneRecordAndClose(cursor));
}
DatabaseWrapper.BeginTransaction();
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test20', 'test21');");
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test20', 'test21');");
DatabaseWrapper.RollBackTransaction();
Assert.AreEqual(DatabaseWrapper.ExecuteCountQuery($"SELECT COUNT(a) FROM {tableName};"), 1);
DatabaseWrapper.BeginTransaction();
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test20', 'test21');");
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test20', 'test21');");
DatabaseWrapper.CommitTransaction();
Assert.AreEqual(DatabaseWrapper.ExecuteCountQuery($"SELECT COUNT(a) FROM {tableName};"), 3);
}
public void GetFetchSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new IdentifyingInfo
{
Id = id
};
var parameters = new List <SQLiteParameter>();
var table = new GenreTable();
var expected = $"SELECT * FROM {TableFactory<Genre>.GetTable<GenreTable>().TableName} WHERE {GenreTable.IdColumnName} = @{GenreTable.IdColumnName};";
Assert.AreEqual(expected, table.GetFetchSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
parameters.Clear();
value = new IdentifyingInfo
{
Name = StringExtensions.GetRandomStringAsync(25).Result
};
expected = $"SELECT * FROM {TableFactory<Genre>.GetTable<GenreTable>().TableName} WHERE {GenreTable.NameColumnName} = @{GenreTable.NameColumnName};";
Assert.AreEqual(expected, table.GetFetchSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
}
public void DumpConjunctionTest()
{
var swc = HelperObjectFactory.MakeSqlWhereClause();
Assert.AreNotEqual(Conjunction.None, swc.Conjunction);
swc.DumpConjunction();
Assert.AreEqual(Conjunction.None, swc.Conjunction);
}
public async Task DropTableTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
await DatabaseWrapper.DropTableAsync(tableName);
Assert.IsFalse(DatabaseWrapper.TableExists(tableName));
}
public void GetHashCodeTest()
{
var swc1 = HelperObjectFactory.MakeIdentifyingInfo();
var swc2 = HelperObjectFactory.MakeIdentifyingInfo();
var swc3 = new IdentifyingInfo(swc1);
Assert.AreEqual(swc1.GetHashCode(), swc1.GetHashCode());
Assert.AreEqual(swc1.GetHashCode(), swc3.GetHashCode());
Assert.AreNotEqual(swc1.GetHashCode(), swc2.GetHashCode());
}
public void TableExistsTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
Assert.IsFalse(DatabaseWrapper.TableExists(tableName));
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
Assert.IsTrue(DatabaseWrapper.TableExists(tableName));
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
public void GetInsertSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new Genre(id, StringExtensions.GetRandomStringAsync(23).Result);
var parameters = new List <SQLiteParameter>();
var table = new GenreTable();
var expected = $"INSERT OR IGNORE INTO {TableFactory<Genre>.GetTable<GenreTable>().TableName} ({GenreTable.IdColumnName}, {AlbumTable.NameColumnName}) VALUES(@{GenreTable.IdColumnName}, @{GenreTable.NameColumnName});";
Assert.AreEqual(expected, table.GetInsertSql(value, ref parameters));
Assert.AreEqual(2, parameters.Count);
}
public void GetUpdateSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new Genre(id, StringExtensions.GetRandomStringAsync(23).Result);
var parameters = new List <SQLiteParameter>();
var table = new GenreTable();
var expected = $"UPDATE {TableFactory<Genre>.GetTable<GenreTable>().TableName} SET {GenreTable.NameColumnName} = @{GenreTable.NameColumnName} WHERE {GenreTable.IdColumnName} = @{GenreTable.IdColumnName};";
Assert.AreEqual(expected, table.GetUpdateSql(value, ref parameters));
Assert.AreEqual(2, parameters.Count);
}
public void GetHashCodeTest()
{
const string cn = "columnName";
const string cv = "columnValue";
var swc1 = HelperObjectFactory.MakeSqlWhereClause();
var swc2 = HelperObjectFactory.MakeSqlWhereClause(Conjunction.Between, cn, Operator.NotEqual, cv);
var swc3 = new SqlWhereClause(swc1);
Assert.AreEqual(swc1.GetHashCode(), swc1.GetHashCode());
Assert.AreEqual(swc1.GetHashCode(), swc3.GetHashCode());
Assert.AreNotEqual(swc1.GetHashCode(), swc2.GetHashCode());
}
private static async Task InitializeAsync()
{
var random = new Random();
DatabaseWrapper = new DatabaseWrapper();
DBPath = Path.Combine(Path.GetDirectoryName(Uri.UnescapeDataString(new UriBuilder(Assembly.GetExecutingAssembly().CodeBase).Path)), TestDbLocation);
await DatabaseWrapper.OpenAsync(DBPath);
_now = DateTime.Now.ToUniversalTime();
TableName = "testingTable" + HelperObjectFactory.GetRandomInt(0, 100);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {TableName} (string TEXT PRIMARY KEY, stringNullable TEXT, boolTrue NUMERIC NOT NULL, boolFalse NUMERIC NOT NULL, boolNullable NUMERIC, short INTEGER, int INTEGER, long INTEGER, float REAL, double REAL, guid TEXT, dateTime NUMERIC, nullColumn TEXT, blob NONE) WITHOUT ROWID;");
for (var i = 0; i < NumberOfEntriesInTable; i++)
{
var mod = i & 1;
var randomBytes = new byte[TestBlobSize];
random.NextBytes(randomBytes);
var parameters = new List <SQLiteParameter>();
var stringParameter = SqliteExtensions.Create("@string", DbType.String, "this is a string" + HelperObjectFactory.GetRandomInt());
var stringNullableParameter = SqliteExtensions.Create("@stringNullable", DbType.String, mod == 0 ? null : "this is a string" + HelperObjectFactory.GetRandomInt());
var boolTrueParameter = SqliteExtensions.Create("@boolTrue", DbType.Boolean, true);
var boolFalseParameter = SqliteExtensions.Create("@boolFalse", DbType.Boolean, false);
var boolNullableParameter = SqliteExtensions.Create("@boolNullable", DbType.Boolean, mod == 0 ? null : new bool?(Convert.ToBoolean(mod)));
var shortParameter = SqliteExtensions.Create("@short", DbType.Int16, mod == 0 ? null : (short?)HelperObjectFactory.GetRandomInt());
var intParameter = SqliteExtensions.Create("@int", DbType.Int32, mod == 0 ? null : (int?)HelperObjectFactory.GetRandomInt());
var longParameter = SqliteExtensions.Create("@long", DbType.Int64, mod == 0 ? null : (long?)HelperObjectFactory.GetRandomInt());
var floatParameter = SqliteExtensions.Create("@float", DbType.Single, mod == 0 ? null : (float?)random.NextDouble());
var doubleParameter = SqliteExtensions.Create("@double", DbType.Double, mod == 0 ? null : (double?)random.NextDouble());
var guidParameter = SqliteExtensions.Create("@guid", DbType.Guid, mod == 0 ? null : (Guid?)Guid.NewGuid());
var dateTimeParameter = SqliteExtensions.Create("@dateTime", DbType.Int64, mod == 0 ? null : (long?)_now.Ticks);
var nullParameter = SqliteExtensions.Create("@nullColumn", DbType.Int32, null);
var blobParameter = SqliteExtensions.Create("@blob", DbType.Binary, mod == 0 ? null : randomBytes);
parameters.Add(stringParameter);
parameters.Add(stringNullableParameter);
parameters.Add(boolTrueParameter);
parameters.Add(boolFalseParameter);
parameters.Add(boolNullableParameter);
parameters.Add(shortParameter);
parameters.Add(intParameter);
parameters.Add(longParameter);
parameters.Add(floatParameter);
parameters.Add(doubleParameter);
parameters.Add(dateTimeParameter);
parameters.Add(guidParameter);
parameters.Add(nullParameter);
parameters.Add(blobParameter);
DatabaseWrapper.ExecuteSqlWithParameters($"INSERT INTO {TableName} (string, stringNullable, boolTrue, boolFalse, boolNullable, short, int, long, float, double, dateTime, guid, nullColumn, blob) VALUES ({stringParameter.ParameterName}, {stringNullableParameter.ParameterName}, {boolTrueParameter.ParameterName}, {boolFalseParameter.ParameterName}, {boolNullableParameter.ParameterName}, {shortParameter.ParameterName}, {intParameter.ParameterName}, {longParameter.ParameterName}, {floatParameter.ParameterName}, {doubleParameter.ParameterName}, {dateTimeParameter.ParameterName}, {guidParameter.ParameterName}, {nullParameter.ParameterName}, {blobParameter.ParameterName});", parameters);
}
}
public void GetColumnNamesTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
var columnNames = DatabaseWrapper.GetColumnNames(tableName);
Assert.AreEqual(columnNames.Count, 2);
Assert.IsTrue(columnNames.Contains("a"));
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
public void GetIdFromNameExceptionTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new IdentifyingInfo
{
Id = id
};
var parameters = new List <SQLiteParameter>();
var table = new ArtistTable();
Assert.That(() => table.GetIdFromNameSql(value, ref parameters), Throws.ArgumentException);
}
public void VersionTest()
{
var randomVersion = HelperObjectFactory.GetRandomInt(0);
try
{
DatabaseWrapper.SetVersionAsync(randomVersion);
Assert.AreEqual(randomVersion, DatabaseWrapper.GetVersion());
}
catch (Exception)
{
Assert.Fail();
}
}
public void ExecuteSqlTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
try
{
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
catch (Exception)
{
Assert.Fail();
}
}
public void EqualsTest()
{
var swc1 = HelperObjectFactory.MakeIdentifyingInfo();
var swc2 = HelperObjectFactory.MakeIdentifyingInfo();
var swc3 = new IdentifyingInfo(swc1);
Assert.IsFalse(swc1.Equals((object)null));
Assert.IsFalse(swc1.Equals(null));
Assert.IsTrue(swc1.Equals((object)swc1));
Assert.IsTrue(swc1.Equals(swc1));
Assert.IsFalse(swc1.Equals(swc2));
Assert.IsTrue(swc1.Equals(swc3));
}
public void GetCountSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new IdentifyingInfo
{
Id = id
};
var parameters = new List <SQLiteParameter>();
var table = new GenreTable();
var expected = $"SELECT COUNT(*) FROM {TableFactory<Genre>.GetTable<GenreTable>().TableName} WHERE {GenreTable.IdColumnName} = @{GenreTable.IdColumnName};";
Assert.AreEqual(expected, table.GetCountSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
}
public void ToStringTest()
{
const string cn = "columnName";
const string cv = "columnValue";
var swc1 = HelperObjectFactory.MakeSqlWhereClause();
var swc2 = HelperObjectFactory.MakeSqlWhereClause(Conjunction.Between, cn, Operator.NotEqual, cv);
Assert.AreEqual("AND id = @id", swc1.ToString());
swc1.DumpConjunction();
Assert.AreEqual("id = @id", swc1.ToString());
Assert.AreEqual("BETWEEN columnName != columnValue", swc2.ToString());
swc2.DumpConjunction();
Assert.AreEqual("columnName != columnValue", swc2.ToString());
}
public void ExecuteCountQueryTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
Assert.AreEqual(DatabaseWrapper.ExecuteCountQuery($"SELECT COUNT(a) FROM {tableName}"), 0);
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test0', 'test1');");
Assert.AreEqual(DatabaseWrapper.ExecuteCountQuery($"SELECT COUNT(a) FROM {tableName}"), 1);
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test6', 'test3');");
Assert.AreEqual(DatabaseWrapper.ExecuteCountQuery($"SELECT COUNT(a) FROM {tableName}"), 2);
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
private void ExecuteSqlWithParametersTest_Insert()
{
var album = HelperObjectFactory.MakeAlbum(AlbumId, ArtistId, GenreId, AlbumName, Year);
var artist = HelperObjectFactory.MakeArtist(ArtistId, ArtistName);
var genre = HelperObjectFactory.MakeGenre(GenreId, GenreName);
var parameters = new List <SQLiteParameter>();
// Assert the tables exist
Assert.AreEqual(1, _dataAccess.ExecuteSqlWithParametersAsync(TableFactory <Genre> .GetTable <GenreTable>().GetInsertSql(genre, ref parameters), parameters).Result);
parameters.Clear();
Assert.AreEqual(1, _dataAccess.ExecuteSqlWithParametersAsync(TableFactory <Album> .GetTable <AlbumTable>().GetInsertSql(album, ref parameters), parameters).Result);
parameters.Clear();
Assert.AreEqual(1, _dataAccess.ExecuteSqlWithParametersAsync(TableFactory <Artist> .GetTable <ArtistTable>().GetInsertSql(artist, ref parameters), parameters).Result);
}
public void GetDeleteAlbumsByArtistSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new IdentifyingInfo
{
Id = id
};
var parameters = new List <SQLiteParameter>();
var table = new ArtistTable();
var expected = $"DELETE FROM {TableFactory<Album>.GetTable<AlbumTable>().TableName} WHERE {AlbumTable.ArtistIdColumnName} = @{AlbumTable.ArtistIdColumnName};";
Assert.AreEqual(expected, table.GetDeleteAlbumsByArtistSql(value, ref parameters));
Assert.AreEqual(1, parameters.Count);
}
public void ExecuteQueryTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test0', 'test1');");
using (var cursor = DatabaseWrapper.ExecuteQuery($"SELECT * FROM {tableName};"))
{
Assert.IsNotNull(cursor);
Assert.IsNotNull(cursor.GetString(cursor.GetColumnIndex("a")));
Assert.IsNotNull(cursor.GetString(cursor.GetColumnIndex("b")));
}
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
public void ExecuteSingleResultQueryTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test0', 'test1');");
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test6', 'test3');");
using (var cursor = DatabaseWrapper.ExecuteSingleResultQuery($"SELECT * FROM {tableName};"))
{
Assert.IsNotNull(cursor);
Assert.IsFalse(cursor.MoveToNextRow());
}
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
public async Task ConvertJObjectToDictionaryAsyncTest()
{
var dict = await JObject.FromObject(HelperObjectFactory.MakeAlbum(Id, ArtistId, GenreId, NameKey, Year)).ConvertJObjectToDictionaryAsync();
Assert.IsTrue(dict.ContainsKey(IdKey));
Assert.IsTrue(dict.ContainsKey(ArtistIdKey));
Assert.IsTrue(dict.ContainsKey(GenreIdKey));
Assert.IsTrue(dict.ContainsKey(NameKey));
Assert.IsTrue(dict.ContainsKey(YearKey));
Assert.IsTrue(dict[IdKey] == Id.ToString());
Assert.IsTrue(dict[ArtistIdKey] == ArtistId.ToString());
Assert.IsTrue(dict[GenreIdKey] == GenreId.ToString());
Assert.IsTrue(dict[NameKey] == NameKey);
Assert.IsTrue(dict[YearKey] == Year.ToString());
}
public void EqualsTest()
{
const string cn = "columnName";
const string cv = "columnValue";
var swc1 = HelperObjectFactory.MakeSqlWhereClause();
var swc2 = HelperObjectFactory.MakeSqlWhereClause(Conjunction.Between, cn, Operator.NotEqual, cv);
var swc3 = new SqlWhereClause(swc1);
Assert.IsFalse(swc1.Equals((object)null));
Assert.IsFalse(swc1.Equals(null));
Assert.IsTrue(swc1.Equals((object)swc1));
Assert.IsTrue(swc1.Equals(swc1));
Assert.IsFalse(swc1.Equals(swc2));
Assert.IsTrue(swc1.Equals(swc3));
}
public void ConstructorAndPropertiesTests()
{
int? id = HelperObjectFactory.GetRandomInt();
const string filterText = "filter text";
var name = StringExtensions.GetRandomStringAsync(25).Result;
var ii = HelperObjectFactory.MakeIdentifyingInfo(id, filterText, name);
Assert.AreEqual(id, ii.Id);
Assert.AreEqual(filterText, ii.FilterText);
Assert.AreEqual(name, ii.Name);
var ii2 = new IdentifyingInfo(ii);
Assert.AreEqual(id, ii2.Id);
Assert.AreEqual(filterText, ii2.FilterText);
Assert.AreEqual(name, ii2.Name);
}
public void ConstructorAndPropertiesTests()
{
const string cn = "columnName";
const string cv = "columnValue";
var swc = HelperObjectFactory.MakeSqlWhereClause(Conjunction.Between, cn, Operator.NotEqual, cv);
Assert.AreEqual(Conjunction.Between, swc.Conjunction);
Assert.AreEqual(cn, swc.ColumnName);
Assert.AreEqual(Operator.NotEqual, swc.Operator);
Assert.AreEqual(cv, swc.ColumnValue);
var swc2 = new SqlWhereClause(swc);
Assert.AreEqual(swc2.Conjunction, swc.Conjunction);
Assert.AreEqual(swc2.ColumnName, swc.ColumnName);
Assert.AreEqual(swc2.Operator, swc.Operator);
Assert.AreEqual(swc2.ColumnValue, swc.ColumnValue);
}
public async Task SerializeObjectTest()
{
var a1 = HelperObjectFactory.MakeAlbum(Id, ArtistId, GenreId, NameKey, Year);
var s = JsonExtensions.SerializeObject(a1);
Assert.IsNotNull(s);
var a2 = await s.DeserializeObjectAsync <Album>();
Assert.AreEqual(a1, a2);
var obj = StringExtensions.GetRandomStringAsync(256).Result;
s = JsonExtensions.SerializeObject(obj);
Assert.AreEqual('"' + obj + '"', s);
var random = new Random().Next();
s = JsonExtensions.SerializeObject(random);
Assert.AreEqual(random.ToString(), s);
}
public void HasOneRecordAndCloseTest()
{
var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0);
DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);");
using (var cursor = DatabaseWrapper.ExecuteSingleResultQuery($"SELECT * FROM {tableName};"))
{
Assert.IsFalse(DatabaseWrapper.HasOneRecordAndClose(cursor));
Assert.IsTrue(cursor.IsClosed());
}
DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test0', 'test1');");
using (var cursor = DatabaseWrapper.ExecuteSingleResultQuery($"SELECT * FROM {tableName};"))
{
Assert.IsTrue(DatabaseWrapper.HasOneRecordAndClose(cursor));
Assert.IsTrue(cursor.IsClosed());
}
DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};");
}
