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
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
|
/* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*-
* vim: sw=2 ts=2 et lcs=trail\:.,tab\:>~ :
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/. */
#include "storage_test_harness.h"
#include "mozStorageHelper.h"
#include "mozStorageConnection.h"
using namespace mozilla;
using namespace mozilla::storage;
bool has_transaction(mozIStorageConnection* aDB) {
return !(static_cast<Connection *>(aDB)->getAutocommit());
}
/**
* This file test our Transaction helper in mozStorageHelper.h.
*/
void
test_Commit()
{
nsCOMPtr<mozIStorageConnection> db(getMemoryDatabase());
// Create a table in a transaction, call Commit, and make sure that it does
// exists after the transaction falls out of scope.
{
mozStorageTransaction transaction(db, false);
do_check_true(has_transaction(db));
(void)db->ExecuteSimpleSQL(NS_LITERAL_CSTRING(
"CREATE TABLE test (id INTEGER PRIMARY KEY)"
));
(void)transaction.Commit();
}
do_check_false(has_transaction(db));
bool exists = false;
(void)db->TableExists(NS_LITERAL_CSTRING("test"), &exists);
do_check_true(exists);
}
void
test_Rollback()
{
nsCOMPtr<mozIStorageConnection> db(getMemoryDatabase());
// Create a table in a transaction, call Rollback, and make sure that it does
// not exists after the transaction falls out of scope.
{
mozStorageTransaction transaction(db, true);
do_check_true(has_transaction(db));
(void)db->ExecuteSimpleSQL(NS_LITERAL_CSTRING(
"CREATE TABLE test (id INTEGER PRIMARY KEY)"
));
(void)transaction.Rollback();
}
do_check_false(has_transaction(db));
bool exists = true;
(void)db->TableExists(NS_LITERAL_CSTRING("test"), &exists);
do_check_false(exists);
}
void
test_AutoCommit()
{
nsCOMPtr<mozIStorageConnection> db(getMemoryDatabase());
// Create a table in a transaction, and make sure that it exists after the
// transaction falls out of scope. This means the Commit was successful.
{
mozStorageTransaction transaction(db, true);
do_check_true(has_transaction(db));
(void)db->ExecuteSimpleSQL(NS_LITERAL_CSTRING(
"CREATE TABLE test (id INTEGER PRIMARY KEY)"
));
}
do_check_false(has_transaction(db));
bool exists = false;
(void)db->TableExists(NS_LITERAL_CSTRING("test"), &exists);
do_check_true(exists);
}
void
test_AutoRollback()
{
nsCOMPtr<mozIStorageConnection> db(getMemoryDatabase());
// Create a table in a transaction, and make sure that it does not exists
// after the transaction falls out of scope. This means the Rollback was
// successful.
{
mozStorageTransaction transaction(db, false);
do_check_true(has_transaction(db));
(void)db->ExecuteSimpleSQL(NS_LITERAL_CSTRING(
"CREATE TABLE test (id INTEGER PRIMARY KEY)"
));
}
do_check_false(has_transaction(db));
bool exists = true;
(void)db->TableExists(NS_LITERAL_CSTRING("test"), &exists);
do_check_false(exists);
}
void
test_null_database_connection()
{
// We permit the use of the Transaction helper when passing a null database
// in, so we need to make sure this still works without crashing.
mozStorageTransaction transaction(nullptr, false);
do_check_true(NS_SUCCEEDED(transaction.Commit()));
do_check_true(NS_SUCCEEDED(transaction.Rollback()));
}
void
test_async_Commit()
{
// note this will be active for any following test.
hook_sqlite_mutex();
nsCOMPtr<mozIStorageConnection> db(getMemoryDatabase());
// -- wedge the thread
nsCOMPtr<nsIThread> target(get_conn_async_thread(db));
do_check_true(target);
RefPtr<ThreadWedger> wedger (new ThreadWedger(target));
{
mozStorageTransaction transaction(db, false,
mozIStorageConnection::TRANSACTION_DEFERRED,
true);
do_check_true(has_transaction(db));
(void)db->ExecuteSimpleSQL(NS_LITERAL_CSTRING(
"CREATE TABLE test (id INTEGER PRIMARY KEY)"
));
(void)transaction.Commit();
}
do_check_true(has_transaction(db));
// -- unwedge the async thread
wedger->unwedge();
// Ensure the transaction has done its job by enqueueing an async execution.
nsCOMPtr<mozIStorageAsyncStatement> stmt;
(void)db->CreateAsyncStatement(NS_LITERAL_CSTRING(
"SELECT NULL"
), getter_AddRefs(stmt));
blocking_async_execute(stmt);
stmt->Finalize();
do_check_false(has_transaction(db));
bool exists = false;
(void)db->TableExists(NS_LITERAL_CSTRING("test"), &exists);
do_check_true(exists);
blocking_async_close(db);
}
void (*gTests[])(void) = {
test_Commit,
test_Rollback,
test_AutoCommit,
test_AutoRollback,
test_null_database_connection,
test_async_Commit,
};
const char *file = __FILE__;
#define TEST_NAME "transaction helper"
#define TEST_FILE file
#include "storage_test_harness_tail.h"
|
