forked from ThatRendle/Simple.Data
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathInsertTests.cs
More file actions
134 lines (108 loc) · 4.47 KB
/
InsertTests.cs
File metadata and controls
134 lines (108 loc) · 4.47 KB
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Simple.Data.SqlCe40Test
{
using System.Dynamic;
using System.IO;
using System.Reflection;
using NUnit.Framework;
using SqlCeTest;
[TestFixture]
public class InsertTests
{
private static readonly string DatabasePath = Path.Combine(
Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase.Substring(8)),
"TestDatabase.sdf");
[Test]
public void TestInsertWithNamedArguments()
{
var db = Database.Opener.OpenFile(DatabasePath);
var user = db.Users.Insert(Name: "Ford", Password: "hoopy", Age: 29);
Assert.IsNotNull(user);
Assert.AreEqual("Ford", user.Name);
Assert.AreEqual("hoopy", user.Password);
Assert.AreEqual(29, user.Age);
}
[Test]
public void TestInsertWithStaticTypeObject()
{
var db = Database.Opener.OpenFile(DatabasePath);
var user = new User { Name = "Zaphod", Password = "zarquon", Age = 42 };
var actual = db.Users.Insert(user);
Assert.IsNotNull(user);
Assert.AreEqual("Zaphod", actual.Name);
Assert.AreEqual("zarquon", actual.Password);
Assert.AreEqual(42, actual.Age);
}
[Test]
public void TestMultiInsertWithStaticTypeObjects()
{
var db = Database.Opener.OpenFile(DatabasePath);
var users = new[]
{
new User { Name = "Slartibartfast", Password = "bistromathics", Age = 777 },
new User { Name = "Wowbagger", Password = "teatime", Age = int.MaxValue }
};
IList<User> actuals = db.Users.Insert(users).ToList<User>();
Assert.AreEqual(2, actuals.Count);
Assert.AreNotEqual(0, actuals[0].Id);
Assert.AreEqual("Slartibartfast", actuals[0].Name);
Assert.AreEqual("bistromathics", actuals[0].Password);
Assert.AreEqual(777, actuals[0].Age);
Assert.AreNotEqual(0, actuals[1].Id);
Assert.AreEqual("Wowbagger", actuals[1].Name);
Assert.AreEqual("teatime", actuals[1].Password);
Assert.AreEqual(int.MaxValue, actuals[1].Age);
}
[Test]
public void TestInsertWithDynamicTypeObject()
{
var db = Database.Opener.OpenFile(DatabasePath);
dynamic user = new ExpandoObject();
user.Name = "Marvin";
user.Password = "diodes";
user.Age = 42000000;
var actual = db.Users.Insert(user);
Assert.IsNotNull(user);
Assert.AreEqual("Marvin", actual.Name);
Assert.AreEqual("diodes", actual.Password);
Assert.AreEqual(42000000, actual.Age);
}
[Test]
public void TestMultiInsertWithDynamicTypeObjects()
{
var db = Database.Opener.OpenFile(DatabasePath);
dynamic user1 = new ExpandoObject();
user1.Name = "Prak";
user1.Password = "truth";
user1.Age = 30;
dynamic user2 = new ExpandoObject();
user2.Name = "Eddie";
user2.Password = "tea";
user2.Age = 1;
var users = new[] { user1, user2 };
IList<dynamic> actuals = db.Users.Insert(users).ToList();
Assert.AreEqual(2, actuals.Count);
Assert.AreNotEqual(0, actuals[0].Id);
Assert.AreEqual("Prak", actuals[0].Name);
Assert.AreEqual("truth", actuals[0].Password);
Assert.AreEqual(30, actuals[0].Age);
Assert.AreNotEqual(0, actuals[1].Id);
Assert.AreEqual("Eddie", actuals[1].Name);
Assert.AreEqual("tea", actuals[1].Password);
Assert.AreEqual(1, actuals[1].Age);
}
[Test]
public void InsertBigStringIntoNTextColumn()
{
var bigString = new string('X', 8192);
var db = Database.Opener.OpenFile(DatabasePath);
var row = db.TextTest.Insert(Text: bigString);
Assert.NotNull(row);
Assert.AreNotEqual(0, row.Id);
Assert.AreEqual(bigString, row.Text);
}
}
}