FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
DirectSQL/TestSqlLiteDatabase/TransactionTest.cs at main · DirectSQL/DirectSQL · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
DirectSQL
/
DirectSQL
Public
Notifications
You must be signed in to change notification settings
Fork
4
Star
15
Code
Issues
0
Pull requests
0
Discussions
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Discussions
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
DirectSQL
/
TestSqlLiteDatabase
/
TransactionTest.cs
Copy path
More file actions
More file actions
Latest commit
History
History
History
148 lines (132 loc) · 4.16 KB
Breadcrumbs
DirectSQL
/
TestSqlLiteDatabase
/
TransactionTest.cs
Copy path
File metadata and controls
148 lines (132 loc) · 4.16 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
135
136
137
138
139
140
141
142
143
144
145
146
147
148
using
Microsoft
.
VisualStudio
.
TestTools
.
UnitTesting
;
using
System
;
using
System
.
Collections
.
Generic
;
using
System
.
Text
;
using
System
.
Data
;
using
DirectSQL
;
using
DirectSQL
.
SqlLite
;
using
System
.
Threading
.
Tasks
;
using
System
.
Data
.
SQLite
;
using
System
.
Transactions
;
namespace
TestSqlLiteDatabase
{
[
TestClass
]
public
class
TransactionTest
{
[
TestMethod
]
public
void
TestTransaction
(
)
{
SqlLiteDatabase
db
=
new
SqlLiteDatabase
(
RandomNameMemDbConnectionString
(
)
)
;
db
.
Process
(
CreateTableForTest
)
;
try
{
using
(
var
scope
=
new
TransactionScope
(
)
)
{
db
.
Process
(
InsertDataForTest
)
;
}
}
catch
(
TransactionAbortedException
)
{
//Ignore here
}
using
(
var
scope
=
new
TransactionScope
(
)
)
{
db
.
Process
(
(
conn
)
=>
{
AssertDataCount
(
0
,
conn
)
;
InsertDataForTest
(
conn
)
;
AssertDataCount
(
1
,
conn
)
;
}
)
;
scope
.
Complete
(
)
;
}
db
.
Process
(
(
conn
)
=>
{
AssertDataCount
(
1
,
conn
)
;
}
)
;
}
[
TestMethod
]
public
async
Task
TestTransactionAsync
(
)
{
SqlLiteDatabase
db
=
new
SqlLiteDatabase
(
RandomNameMemDbConnectionString
(
)
)
;
await
db
.
ProcessAsync
(
async
(
connection
)
=>
{
await
Task
.
Delay
(
1
)
;
CreateTableForTest
(
connection
)
;
}
)
;
try
{
using
(
var
scope
=
new
TransactionScope
(
TransactionScopeAsyncFlowOption
.
Enabled
)
)
{
await
db
.
ProcessAsync
(
async
(
conn
)
=>
{
await
Task
.
Run
(
(
)
=>
{
InsertDataForTest
(
conn
)
;
}
)
;
}
)
;
}
}
catch
(
TransactionAbortedException
)
{
//Ignore
}
using
(
var
scope
=
new
TransactionScope
(
TransactionScopeAsyncFlowOption
.
Enabled
)
)
{
await
db
.
ProcessAsync
(
async
(
conn
)
=>
{
await
Task
.
Run
(
(
)
=>
{
AssertDataCount
(
0
,
conn
)
;
InsertDataForTest
(
conn
)
;
AssertDataCount
(
1
,
conn
)
;
}
)
;
}
)
;
scope
.
Complete
(
)
;
}
await
db
.
ProcessAsync
(
async
(
conn
)
=>
{
await
Task
.
Run
(
(
)
=>
{
AssertDataCount
(
1
,
conn
)
;
}
)
;
}
)
;
}
private
static
void
AssertDataCount
(
long
expectedCount
,
SQLiteConnection
conn
)
{
Assert
.
AreEqual
(
SqlLiteDatabase
.
ExecuteScalar
(
"select count(*) from TEST_TABLE"
,
conn
)
,
expectedCount
)
;
}
private
static
void
CreateTableForTest
(
IDbConnection
connection
)
{
using
(
var
command
=
connection
.
CreateCommand
(
)
)
{
command
.
CommandText
=
"create table "
+
"TEST_TABLE("
+
"TEST_COL1 text"
+
")"
;
command
.
ExecuteNonQuery
(
)
;
}
}
private
static
void
InsertDataForTest
(
SQLiteConnection
conn
)
{
SqlLiteDatabase
.
ExecuteNonQuery
(
"insert into TEST_TABLE(TEST_COL1) "
+
"VALUES(@testVal1)"
,
new
(
string
,
object
)
[
]
{
(
"@testVal1"
,
"testValue"
)
}
,
conn
)
;
}
internal
static
string
RandomNameMemDbConnectionString
(
)
{
return
$
"DataSource=file:
{
Guid
.
NewGuid
(
)
}
?mode=memory&cache=shared"
;
}
}
}
Back
|
FazBrowse Home
|
New Git URL