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
|
require "helper"
module SQLite3
class TestPragmas < SQLite3::TestCase
BIGENDIAN = ([1].pack("I") == [1].pack("N"))
class DatabaseTracker < SQLite3::Database
attr_reader :test_statements
def initialize(...)
@test_statements = []
super
end
def execute(sql, bind_vars = [], &block)
@test_statements << sql
super
end
end
def setup
super
@db = DatabaseTracker.new(":memory:")
end
def teardown
@db.close
end
def test_temp_store_mode
@db.temp_store = "memory"
assert_equal 2, @db.temp_store
@db.temp_store = 1
assert_equal 1, @db.temp_store
end
def test_encoding
@db.encoding = "utf-16le"
assert_equal Encoding.find("utf-16le"), @db.encoding
end
def test_pragma_errors
assert_raises(SQLite3::Exception) do
@db.set_enum_pragma("foo", "bar", [])
end
assert_raises(SQLite3::Exception) do
@db.set_boolean_pragma("read_uncommitted", "foo")
end
assert_raises(SQLite3::Exception) do
@db.set_boolean_pragma("read_uncommitted", 42)
end
end
def test_invalid_pragma
assert_raises(SQLite3::Exception) do
@db.journal_mode = 0
end
end
def test_get_boolean_pragma
refute(@db.get_boolean_pragma("read_uncommitted"))
end
def test_set_boolean_pragma
@db.set_boolean_pragma("read_uncommitted", 1)
assert(@db.get_boolean_pragma("read_uncommitted"))
ensure
@db.set_boolean_pragma("read_uncommitted", 0)
end
def test_optimize_with_no_args
@db.optimize
assert_equal(["PRAGMA optimize"], @db.test_statements)
end
def test_optimize_with_args
@db.optimize(Constants::Optimize::DEFAULT)
@db.optimize(Constants::Optimize::ANALYZE_TABLES | Constants::Optimize::LIMIT_ANALYZE)
@db.optimize(Constants::Optimize::ANALYZE_TABLES | Constants::Optimize::DEBUG)
@db.optimize(Constants::Optimize::DEFAULT | Constants::Optimize::CHECK_ALL_TABLES)
assert_equal(
[
"PRAGMA optimize=18",
"PRAGMA optimize=18",
"PRAGMA optimize=3",
"PRAGMA optimize=65554"
],
@db.test_statements
)
end
def test_encoding_uppercase
assert_equal(Encoding::UTF_8, @db.encoding)
@db.encoding = "UTF-16"
native = BIGENDIAN ? Encoding::UTF_16BE : Encoding::UTF_16LE
assert_equal(native, @db.encoding)
@db.encoding = "UTF-16LE"
assert_equal(Encoding::UTF_16LE, @db.encoding)
@db.encoding = "UTF-16BE"
assert_equal(Encoding::UTF_16BE, @db.encoding)
@db.encoding = "UTF-8"
assert_equal(Encoding::UTF_8, @db.encoding)
end
def test_encoding_lowercase
assert_equal(Encoding::UTF_8, @db.encoding)
@db.encoding = "utf-16"
native = BIGENDIAN ? Encoding::UTF_16BE : Encoding::UTF_16LE
assert_equal(native, @db.encoding)
@db.encoding = "utf-16le"
assert_equal(Encoding::UTF_16LE, @db.encoding)
@db.encoding = "utf-16be"
assert_equal(Encoding::UTF_16BE, @db.encoding)
@db.encoding = "utf-8"
assert_equal(Encoding::UTF_8, @db.encoding)
end
def test_encoding_objects
assert_equal(Encoding::UTF_8, @db.encoding)
@db.encoding = Encoding::UTF_16
native = BIGENDIAN ? Encoding::UTF_16BE : Encoding::UTF_16LE
assert_equal(native, @db.encoding)
@db.encoding = Encoding::UTF_16LE
assert_equal(Encoding::UTF_16LE, @db.encoding)
@db.encoding = Encoding::UTF_16BE
assert_equal(Encoding::UTF_16BE, @db.encoding)
@db.encoding = Encoding::UTF_8
assert_equal(Encoding::UTF_8, @db.encoding)
end
end
end
|
