-
Notifications
You must be signed in to change notification settings - Fork 303
/
QueryTest.cs
69 lines (64 loc) · 2.13 KB
/
QueryTest.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
using System.IO;
using System.Reflection;
using NUnit.Framework;
namespace Simple.Data.SqlCe40Test
{
[TestFixture]
public class QueryTest
{
private static readonly string DatabasePath = Path.Combine(
Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase.Substring(8)),
"TestDatabase.sdf");
[Test]
public void ShouldSelectFromOneToTen()
{
var db = Database.Opener.OpenFile(DatabasePath);
var query = db.PagingTest.QueryById(1.to(100)).Take(10);
int index = 1;
foreach (var row in query)
{
Assert.AreEqual(index, row.Id);
index++;
}
}
[Test]
public void ShouldSelectFromOneToTenWithCount()
{
var db = Database.Opener.OpenFile(DatabasePath);
Promise<int> count;
var query = db.PagingTest.QueryById(1.to(100)).WithTotalCount(out count).Take(10);
int index = 1;
foreach (var row in query)
{
Assert.AreEqual(index, row.Id);
index++;
}
Assert.IsTrue(count.HasValue);
Assert.AreEqual(100, count.Value);
}
[Test]
public void ShouldSelectFromElevenToTwenty()
{
var db = Database.Opener.OpenFile(DatabasePath);
var query = db.PagingTest.QueryById(1.to(100)).Skip(10).Take(10);
int index = 11;
foreach (var row in query)
{
Assert.AreEqual(index, row.Id);
index++;
}
}
[Test]
public void ShouldSelectFromOneHundredToNinetyOne()
{
var db = Database.Opener.OpenFile(DatabasePath);
var query = db.PagingTest.QueryById(1.to(100)).OrderByDescending(db.PagingTest.Id).Skip(0).Take(10);
int index = 100;
foreach (var row in query)
{
Assert.AreEqual(index, row.Id);
index--;
}
}
}
}