public async Task ReadAsync_ReadsItems()
{
await PrepareTodoTable();
// insert rows and make sure they are inserted
TestUtilities.ExecuteNonQuery(TestDbName, "INSERT INTO todo (id, __createdAt) VALUES ('abc', 1), ('def', 2), ('ghi', 3)");
long count = TestUtilities.CountRows(TestDbName, TestTable);
Assert.AreEqual(count, 3L);
using (var store = new MobileServiceSQLiteStore(TestDbName))
{
DefineTestTable(store);
await store.InitializeAsync();
var query = MobileServiceTableQueryDescription.Parse(TestTable, "$filter=__createdAt gt 1&$inlinecount=allpages");
JToken item = await store.ReadAsync(query);
Assert.IsNotNull(item);
var results = item["results"].Value <JArray>();
long resultCount = item["count"].Value <long>();
Assert.AreEqual(results.Count, 2);
Assert.AreEqual(resultCount, 2L);
}
}
private static async Task <T> Query <T>(string query) where T : JToken
{
using (MobileServiceSQLiteStore store = await SetupTestTable())
{
return((T)await store.ReadAsync(MobileServiceTableQueryDescription.Parse(TestTable, query)));
}
}
public async Task <List <Patient> > GetItemsAsync()
{
var query = new MobileServiceTableQueryDescription("Patient");
JToken jtoken = await database.ReadAsync(query);
ObservableCollection <Patient> patientlist = new ObservableCollection <Patient>();
var converted_result = jtoken.Select(x => JsonConvert.DeserializeObject <Patient>(x.ToString()));
return(converted_result.ToList());
}
public async Task UpsertAsync_CanProcessManyRecordsAtOnce()
{
TestUtilities.DropTestTable(TestDbName, TestTable);
using (var store = new MobileServiceSQLiteStore(TestDbName))
{
var template = new JObject
{
{ "id", 0 },
{ "value1", "Hello, world" },
{ "value2", "Hello, world" },
{ "value3", "Hello, world" },
{ "value4", "Hello, world" },
{ "value5", "Hello, world" }
};
store.DefineTable(TestTable, template);
//create the table
await store.InitializeAsync();
//add a whole bunch of items. We want {number of items} * {number of fields} to exceed sqlite's parameter limit
const int insertedItemCount = 500;
var itemsToInsert = Enumerable.Range(1, insertedItemCount)
.Select(id =>
{
var o = new JObject(template)
{
["id"] = id
};
return(o);
})
.ToArray();
//Insert the items
await store.UpsertAsync(TestTable, itemsToInsert, ignoreMissingColumns : false);
JArray records = (JArray)await store.ReadAsync(MobileServiceTableQueryDescription.Parse(TestTable, "$orderby=id"));
//Verify that all 500 records were inserted
Assert.Equal(records.Count, insertedItemCount);
//Verify that all fields are intact
for (var i = 0; i < insertedItemCount; i++)
{
Assert.True(JToken.DeepEquals(itemsToInsert[i], records[i]), "Results retrieved from DB do not match input");
}
}
}
public async Task UpsertAsync_ThenReadAsync_AllTypes()
{
TestUtilities.DropTestTable(TestDbName, TestTable);
// first create a table called todo
using (MobileServiceSQLiteStore store = new MobileServiceSQLiteStore(TestDbName))
{
store.DefineTable(TestTable, JObjectTypes.GetObjectWithAllTypes());
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) }
};
await store.UpsertAsync(TestTable, new[] { upserted }, false);
var query = new MobileServiceTableQueryDescription(TestTable);
var items = await store.ReadAsync(query) as JArray;
Assert.IsNotNull(items);
Assert.AreEqual(items.Count, 1);
var lookedup = items.First as JObject;
Assert.AreEqual(upserted.ToString(Formatting.None), lookedup.ToString(Formatting.None));
}
}
private static async Task <T> Query <T>(MobileServiceSQLiteStore store, string tableName, string query) where T : JToken
{
return((T)await store.ReadAsync(MobileServiceTableQueryDescription.Parse(tableName, query)));
}
public async Task UpsertAsync_ThenReadAsync_AllTypes()
{
TestUtilities.DropTestTable(TestDbName, TestTable);
// first create a table called todo
using (MobileServiceSQLiteStore store = new MobileServiceSQLiteStore(TestDbName))
{
store.DefineTable(TestTable, JObjectTypes.GetObjectWithAllTypes());
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) }
};
await store.UpsertAsync(TestTable, new[] { upserted }, false);
var query = new MobileServiceTableQueryDescription(TestTable);
var items = await store.ReadAsync(query) as JArray;
Assert.IsNotNull(items);
Assert.AreEqual(items.Count, 1);
var lookedup = items.First as JObject;
Assert.AreEqual(upserted.ToString(Formatting.None), lookedup.ToString(Formatting.None));
}
}
public async Task UpsertAsync_CanProcessManyRecordsAtOnce()
{
TestUtilities.DropTestTable(TestDbName, TestTable);
using (var store = new MobileServiceSQLiteStore(TestDbName))
{
var template = new JObject
{
{ "id", 0 },
{ "value1", "Hello, world" },
{ "value2", "Hello, world" },
{ "value3", "Hello, world" },
{ "value4", "Hello, world" },
{ "value5", "Hello, world" }
};
store.DefineTable(TestTable, template);
//create the table
await store.InitializeAsync();
//add a whole bunch of items. We want {number of items} * {number of fields} to exceed sqlite's parameter limit
const int insertedItemCount = 500;
var itemsToInsert = Enumerable.Range(1, insertedItemCount)
.Select(id =>
{
var o = new JObject(template);
o["id"] = id;
return o;
})
.ToArray();
//Insert the items
await store.UpsertAsync(TestTable, itemsToInsert, ignoreMissingColumns: false);
JArray records = (JArray)await store.ReadAsync(MobileServiceTableQueryDescription.Parse(TestTable, "$orderby=id"));
//Verify that all 500 records were inserted
Assert.AreEqual(records.Count, insertedItemCount);
//Verify that all fields are intact
for (var i = 0; i < insertedItemCount; i++)
{
Assert.IsTrue(JToken.DeepEquals(itemsToInsert[i], records[i]), "Results retrieved from DB do not match input");
}
}
}
public async Task ReadAsync_ReadsItems()
{
await PrepareTodoTable();
// insert rows and make sure they are inserted
TestUtilities.ExecuteNonQuery(TestDbName, "INSERT INTO todo (id, createdAt) VALUES ('abc', 1), ('def', 2), ('ghi', 3)");
long count = TestUtilities.CountRows(TestDbName, TestTable);
Assert.AreEqual(count, 3L);
using (var store = new MobileServiceSQLiteStore(TestDbName))
{
DefineTestTable(store);
await store.InitializeAsync();
var query = MobileServiceTableQueryDescription.Parse(TestTable, "$filter=createdAt gt 1&$inlinecount=allpages");
JToken item = await store.ReadAsync(query);
Assert.IsNotNull(item);
var results = item["results"].Value<JArray>();
long resultCount = item["count"].Value<long>();
Assert.AreEqual(results.Count, 2);
Assert.AreEqual(resultCount, 2L);
}
}
