|
0
|
1 using System;
|
|
|
2 using System.Linq;
|
|
|
3
|
|
|
4 using BLToolkit.Data.Linq;
|
|
|
5 using BLToolkit.Data.DataProvider;
|
|
|
6 using BLToolkit.DataAccess;
|
|
|
7 using BLToolkit.Mapping;
|
|
|
8
|
|
|
9 using NUnit.Framework;
|
|
|
10
|
|
|
11 using UnitTests.Linq.Interface.Model;
|
|
|
12
|
|
|
13 namespace Data.Linq.ProviderSpecific
|
|
|
14 {
|
|
|
15 [TestFixture, Category("PostgreSQL")]
|
|
|
16 public class PostgreSQL : TestBase
|
|
|
17 {
|
|
|
18 [TableName(Owner="public", Name="entity")]
|
|
|
19 public class Entity
|
|
|
20 {
|
|
|
21 [MapField("the_name") ] public string TheName { get; set; }
|
|
|
22 }
|
|
|
23
|
|
|
24 [Test]
|
|
|
25 public void SqlTest1([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
26 {
|
|
|
27 using (var db = new TestDbManager(context))
|
|
|
28 {
|
|
|
29 db.BeginTransaction();
|
|
|
30
|
|
|
31 db
|
|
|
32 .SetSpCommand("add_if_not_exists", db.Parameter("p_name", "one"))
|
|
|
33 .ExecuteNonQuery();
|
|
|
34
|
|
|
35 db.Insert(new Entity { TheName = "two" });
|
|
|
36 }
|
|
|
37 }
|
|
|
38
|
|
|
39 [Test]
|
|
|
40 public void SequenceInsert1([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
41 {
|
|
|
42 using (var db = new TestDbManager(context))
|
|
|
43 {
|
|
|
44 db.GetTable<PostgreSQLSpecific.SequenceTest1>().Where(_ => _.Value == "SeqValue").Delete();
|
|
|
45 db.Insert(new PostgreSQLSpecific.SequenceTest1 { Value = "SeqValue" });
|
|
|
46
|
|
|
47 var id = db.GetTable<PostgreSQLSpecific.SequenceTest1>().Single(_ => _.Value == "SeqValue").ID;
|
|
|
48
|
|
|
49 db.GetTable<PostgreSQLSpecific.SequenceTest1>().Where(_ => _.ID == id).Delete();
|
|
|
50
|
|
|
51 Assert.AreEqual(0, db.GetTable<PostgreSQLSpecific.SequenceTest1>().Count(_ => _.Value == "SeqValue"));
|
|
|
52 }
|
|
|
53 }
|
|
|
54
|
|
|
55 [Test]
|
|
|
56 public void SequenceInsert2([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
57 {
|
|
|
58 using (var db = new TestDbManager(context))
|
|
|
59 {
|
|
|
60 db.GetTable<PostgreSQLSpecific.SequenceTest2>().Where(_ => _.Value == "SeqValue").Delete();
|
|
|
61 db.Insert(new PostgreSQLSpecific.SequenceTest2 { Value = "SeqValue" });
|
|
|
62
|
|
|
63 var id = db.GetTable<PostgreSQLSpecific.SequenceTest2>().Single(_ => _.Value == "SeqValue").ID;
|
|
|
64
|
|
|
65 db.GetTable<PostgreSQLSpecific.SequenceTest2>().Where(_ => _.ID == id).Delete();
|
|
|
66
|
|
|
67 Assert.AreEqual(0, db.GetTable<PostgreSQLSpecific.SequenceTest2>().Count(_ => _.Value == "SeqValue"));
|
|
|
68 }
|
|
|
69 }
|
|
|
70
|
|
|
71 [Test]
|
|
|
72 public void SequenceInsert3([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
73 {
|
|
|
74 using (var db = new TestDbManager(context))
|
|
|
75 {
|
|
|
76 db.GetTable<PostgreSQLSpecific.SequenceTest3>().Where(_ => _.Value == "SeqValue").Delete();
|
|
|
77 db.Insert(new PostgreSQLSpecific.SequenceTest3 { Value = "SeqValue" });
|
|
|
78
|
|
|
79 var id = db.GetTable<PostgreSQLSpecific.SequenceTest3>().Single(_ => _.Value == "SeqValue").ID;
|
|
|
80
|
|
|
81 db.GetTable<PostgreSQLSpecific.SequenceTest3>().Where(_ => _.ID == id).Delete();
|
|
|
82
|
|
|
83 Assert.AreEqual(0, db.GetTable<PostgreSQLSpecific.SequenceTest3>().Count(_ => _.Value == "SeqValue"));
|
|
|
84 }
|
|
|
85 }
|
|
|
86
|
|
|
87 [Test]
|
|
|
88 public void SequenceInsertWithIdentity1([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
89 {
|
|
|
90 using (var db = new TestDbManager(context))
|
|
|
91 {
|
|
|
92 db.GetTable<PostgreSQLSpecific.SequenceTest1>().Where(_ => _.Value == "SeqValue").Delete();
|
|
|
93
|
|
|
94 var id1 = Convert.ToInt32(db.InsertWithIdentity(new PostgreSQLSpecific.SequenceTest1 { Value = "SeqValue" }));
|
|
|
95 var id2 = db.GetTable<PostgreSQLSpecific.SequenceTest1>().Single(_ => _.Value == "SeqValue").ID;
|
|
|
96
|
|
|
97 Assert.AreEqual(id1, id2);
|
|
|
98
|
|
|
99 db.GetTable<PostgreSQLSpecific.SequenceTest1>().Where(_ => _.ID == id1).Delete();
|
|
|
100
|
|
|
101 Assert.AreEqual(0, db.GetTable<PostgreSQLSpecific.SequenceTest1>().Count(_ => _.Value == "SeqValue"));
|
|
|
102 }
|
|
|
103 }
|
|
|
104
|
|
|
105 [Test]
|
|
|
106 public void SequenceInsertWithIdentity2([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
107 {
|
|
|
108 using (var db = new TestDbManager(context))
|
|
|
109 {
|
|
|
110 db.GetTable<PostgreSQLSpecific.SequenceTest2>().Where(_ => _.Value == "SeqValue").Delete();
|
|
|
111
|
|
|
112 var id1 = Convert.ToInt32(db.InsertWithIdentity(new PostgreSQLSpecific.SequenceTest2 { Value = "SeqValue" }));
|
|
|
113 var id2 = db.GetTable<PostgreSQLSpecific.SequenceTest2>().Single(_ => _.Value == "SeqValue").ID;
|
|
|
114
|
|
|
115 Assert.AreEqual(id1, id2);
|
|
|
116
|
|
|
117 db.GetTable<PostgreSQLSpecific.SequenceTest2>().Where(_ => _.ID == id1).Delete();
|
|
|
118
|
|
|
119 Assert.AreEqual(0, db.GetTable<PostgreSQLSpecific.SequenceTest2>().Count(_ => _.Value == "SeqValue"));
|
|
|
120 }
|
|
|
121 }
|
|
|
122
|
|
|
123 [Test]
|
|
|
124 public void SequenceInsertWithIdentity3([IncludeDataContexts(ProviderName.PostgreSQL)] string context)
|
|
|
125 {
|
|
|
126 using (var db = new TestDbManager(context))
|
|
|
127 {
|
|
|
128 db.GetTable<PostgreSQLSpecific.SequenceTest3>().Where(_ => _.Value == "SeqValue").Delete();
|
|
|
129
|
|
|
130 var id1 = Convert.ToInt32(db.InsertWithIdentity(new PostgreSQLSpecific.SequenceTest3 { Value = "SeqValue" }));
|
|
|
131 var id2 = db.GetTable<PostgreSQLSpecific.SequenceTest3>().Single(_ => _.Value == "SeqValue").ID;
|
|
|
132
|
|
|
133 Assert.AreEqual(id1, id2);
|
|
|
134
|
|
|
135 db.GetTable<PostgreSQLSpecific.SequenceTest3>().Where(_ => _.ID == id1).Delete();
|
|
|
136
|
|
|
137 Assert.AreEqual(0, db.GetTable<PostgreSQLSpecific.SequenceTest3>().Count(_ => _.Value == "SeqValue"));
|
|
|
138 }
|
|
|
139 }
|
|
|
140 }
|
|
|
141 }
|
