public async Task DeleteAsyncById_CanDeleteEntities()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
await store.UpsertAsync(TestTable, IdEntityValues, false);
// Page before the deletion.
var page = await store.GetPageAsync(new QueryDescription(TestTable) { IncludeTotalCount = true });
Assert.Equal(IdEntityValues.Length, page.Count);
Assert.Contains(page.Items, o => o.Value <string>("stringValue") == "item#1");
var ids = IdEntityValues.Skip(2).Take(2).Select(o => o.Value <string>("id")).ToArray();
await store.DeleteAsync(TestTable, ids);
// Page after the deletion.
var page2 = await store.GetPageAsync(new QueryDescription(TestTable) { IncludeTotalCount = true });
Assert.Equal(IdEntityValues.Length - 2, page2.Count);
Assert.DoesNotContain(page2.Items, o => o.Value <string>("id") == ids[0]);
Assert.DoesNotContain(page2.Items, o => o.Value <string>("id") == ids[1]);
}
public async Task UpsertAsync_MissingColumn_Throws()
{
using var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, JObjectWithAllTypes);
await store.InitializeAsync();
var upserted = new JObject()
{
{ "id", "xyz" },
{ "Object", new JObject()
{
{ "id", "abc" }
} },
{ "Array", new JArray()
{
new JObject()
{
{ "id", 3 }
}
} },
{ "Integer", 123L },
{ "Float", 12.5m },
{ "String", "def" },
{ "Boolean", true },
{ "SomeExtraField", new DateTime(2003, 5, 6, 4, 5, 1, DateTimeKind.Utc) },
{ "Bytes", new byte[] { 1, 2, 3 } },
{ "Guid", new Guid("AB3EB1AB-53CD-4780-928B-A7E1CB7A927C") },
{ "TimeSpan", new TimeSpan(1234) }
};
await Assert.ThrowsAsync <InvalidOperationException>(() => store.UpsertAsync(TestTable, new[] { upserted }, false));
}
public void Ctor_Works_WithValidConnectionString()
{
var store = new OfflineSQLiteStore(ConnectionString);
Assert.NotNull(store);
Assert.NotNull(store.DbConnection);
}
public async Task DeleteAsyncByQuery_Throws_OnMissingTable()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
await Assert.ThrowsAsync <InvalidOperationException>(() => store.DeleteAsync(new QueryDescription("movies")));
}
public async Task DefineTable_Throws_WhenStoreIsInitialized()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
Assert.Throws <InvalidOperationException>(() => store.DefineTable("movies", new JObject()));
}
public async Task InitializeAsync_InitializesDatabase()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
Assert.NotNull(store.DbConnection.connection);
}
public async Task GetItemAsync_ReturnsItem_WhenPresent()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
await store.UpsertAsync(TestTable, IdEntityValues, false);
var expected = IdEntityValues.Skip(2).First();
var result = await store.GetItemAsync(TestTable, expected.Value <string>("id"));
Assert.Equal(expected.ToString(Formatting.None), result.ToString(Formatting.None));
}
public async Task GetItemAsync_ReturnsNull_WhenMissing()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
await store.UpsertAsync(TestTable, IdEntityValues, false);
// Page before the deletion.
var result = await store.GetItemAsync(TestTable, Guid.NewGuid().ToString());
Assert.Null(result);
}
public async Task UpsertAsync_Returns_OnNoColumns()
{
using var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, JObjectWithAllTypes);
await store.InitializeAsync();
var upserted = new JObject[] { new JObject() };
await store.UpsertAsync(TestTable, upserted, false);
var query = new QueryDescription(TestTable);
var page = await store.GetPageAsync(query);
Assert.Empty(page.Items);
}
public async Task UpsertAsync_ThenGetPageAsync_AllTypes()
{
using var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, JObjectWithAllTypes);
await store.InitializeAsync();
var upserted = new JObject()
{
{ "id", "xyz" },
{ "Object", new JObject()
{
{ "id", "abc" }
} },
{ "Array", new JArray()
{
new JObject()
{
{ "id", 3 }
}
} },
{ "Integer", 123L },
{ "Float", 12.5m },
{ "String", "def" },
{ "Boolean", true },
{ "Date", new DateTime(2003, 5, 6, 4, 5, 1, DateTimeKind.Utc) },
{ "Bytes", new byte[] { 1, 2, 3 } },
{ "Guid", new Guid("AB3EB1AB-53CD-4780-928B-A7E1CB7A927C") },
{ "TimeSpan", new TimeSpan(1234) },
{ "Uri", new Uri("http://localhost/") }
};
await store.UpsertAsync(TestTable, new[] { upserted }, false);
var query = new QueryDescription(TestTable);
var page = await store.GetPageAsync(query);
Assert.Single(page.Items);
Assert.Equal(upserted.ToString(Formatting.None), page.Items.First().ToString(Formatting.None));
}
public async Task DeleteAsyncById_EmptyListOfIds()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
await store.UpsertAsync(TestTable, IdEntityValues, false);
// Page before the deletion.
var page = await store.GetPageAsync(new QueryDescription(TestTable) { IncludeTotalCount = true });
Assert.Equal(IdEntityValues.Length, page.Count);
var ids = Array.Empty <string>();
await store.DeleteAsync(TestTable, ids);
// Page after the deletion.
var page2 = await store.GetPageAsync(new QueryDescription(TestTable) { IncludeTotalCount = true });
Assert.Equal(IdEntityValues.Length, page2.Count);
}
public async Task DeleteAsyncByQuery_CanDeleteEntities()
{
var store = new OfflineSQLiteStore(ConnectionString);
store.DefineTable(TestTable, IdEntityDefinition);
await store.InitializeAsync();
await store.UpsertAsync(TestTable, IdEntityValues, false);
// Page before the deletion.
var page = await store.GetPageAsync(new QueryDescription(TestTable) { IncludeTotalCount = true });
Assert.Equal(IdEntityValues.Length, page.Count);
Assert.Contains(page.Items, o => o.Value <string>("stringValue") == "item#1");
QueryDescription query = QueryDescription.Parse(TestTable, "$filter=(stringValue eq 'item#1')");
await store.DeleteAsync(query);
// Page after the deletion.
var page2 = await store.GetPageAsync(new QueryDescription(TestTable) { IncludeTotalCount = true });
Assert.Equal(IdEntityValues.Length - 1, page2.Count);
Assert.DoesNotContain(page2.Items, o => o.Value <string>("stringValue") == "item#1");
}
public async Task DeleteAsyncByQuery_Throws_WhenStoreIsNotInitialized()
{
var store = new OfflineSQLiteStore(ConnectionString);
await Assert.ThrowsAsync <InvalidOperationException>(() => store.DeleteAsync(new QueryDescription(TestTable)));
}
public async Task TableModificationsWork()
{
var filename = Path.GetTempFileName();
var uri = new UriBuilder(filename)
{
Query = "?mode=rwc"
}.Uri.ToString();
Assert.StartsWith("file://", uri);
try
{
JObject table = new()
{
{ "id", string.Empty },
{ "stringValue", string.Empty }
};
// Create the first store
var store1 = new OfflineSQLiteStore(uri);
store1.DefineTable(TestTable, table);
await store1.InitializeAsync();
var results1 = await store1.ExecuteQueryAsync(new JObject(), $"PRAGMA table_info({TestTable})");
// Do Assertions here
Assert.Equal(table.Properties().Count(), results1.Count);
foreach (var prop in table.Properties())
{
Assert.Contains(prop.Name, results1.Select(o => o.Value <string>("name")));
}
// Clean up
store1.DbConnection.connection.Close();
// Create the second store.
table["addedColumn"] = string.Empty;
var store2 = new OfflineSQLiteStore(uri);
store2.DefineTable(TestTable, table);
await store2.InitializeAsync();
var results2 = await store2.ExecuteQueryAsync(new JObject(), $"PRAGMA table_info({TestTable})");
// Do Assertions here
Assert.Equal(table.Properties().Count(), results2.Count);
foreach (var prop in table.Properties())
{
Assert.Contains(prop.Name, results2.Select(o => o.Value <string>("name")));
}
// Clean up
store2.DbConnection.connection.Close();
// Create the first store
table.Remove("stringValue");
var store3 = new OfflineSQLiteStore(uri);
store3.DefineTable(TestTable, table);
await store3.InitializeAsync();
var results3 = await store3.ExecuteQueryAsync(new JObject(), $"PRAGMA table_info({TestTable})");
// Do Assertions here
Assert.Equal(table.Properties().Count(), results3.Count);
foreach (var prop in table.Properties())
{
Assert.Contains(prop.Name, results3.Select(o => o.Value <string>("name")));
}
// Clean up
store3.DbConnection.connection.Close();
}
public async Task GetItemAsync_Throws_WhenStoreIsNotInitialized()
{
var store = new OfflineSQLiteStore(ConnectionString);
await Assert.ThrowsAsync <InvalidOperationException>(() => store.GetItemAsync(TestTable, "id"));
}
public async Task DeleteAsyncById_Throws_WhenStoreIsNotInitialized()
{
var store = new OfflineSQLiteStore(ConnectionString);
await Assert.ThrowsAsync <InvalidOperationException>(() => store.DeleteAsync(TestTable, new[] { "id" }));
}
