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
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
|
# frozen_string_literal: true
require "cases/helper"
require "models/book"
require "models/clothing_item"
module ActiveRecord
class InstrumentationTest < ActiveRecord::TestCase
def setup
ActiveRecord::Base.schema_cache.add(Book.table_name)
end
def test_payload_name_on_load
Book.create(name: "test book")
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal "Book Load", payload[:name]
end
end
Book.first
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_create
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("INSERT")
assert_equal "Book Create", payload[:name]
end
end
Book.create(name: "test book")
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_update
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("UPDATE")
assert_equal "Book Update", payload[:name]
end
end
book = Book.create(name: "test book", format: "paperback")
book.update_attribute(:format, "ebook")
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_update_all
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("UPDATE")
assert_equal "Book Update All", payload[:name]
end
end
Book.update_all(format: "ebook")
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_destroy
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("DELETE")
assert_equal "Book Destroy", payload[:name]
end
end
book = Book.create(name: "test book")
book.destroy
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_delete_all
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("DELETE")
assert_equal "Book Delete All", payload[:name]
end
end
Book.delete_all
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_pluck
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal "Book Pluck", payload[:name]
end
end
Book.pluck(:name)
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_count
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal "Book Count", payload[:name]
end
end
Book.count
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_name_on_grouped_count
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal "Book Count", payload[:name]
end
end
Book.group(:status).count
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_row_count_on_select_all
10.times { Book.create(name: "row count book 1") }
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal 10, payload[:row_count]
end
end
Book.where(name: "row count book 1").to_a
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_row_count_on_pluck
10.times { Book.create(name: "row count book 2") }
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal 10, payload[:row_count]
end
end
Book.where(name: "row count book 2").pluck(:name)
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_row_count_on_raw_sql
10.times { Book.create(name: "row count book 3") }
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
if payload[:sql].match?("SELECT")
assert_equal 10, payload[:row_count]
end
end
ActiveRecord::Base.lease_connection.execute("SELECT * FROM books WHERE name='row count book 3';")
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_connection_with_query_cache_disabled
connection = ClothingItem.lease_connection
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
assert_equal connection, payload[:connection]
end
Book.first
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
def test_payload_connection_with_query_cache_enabled
connection = ClothingItem.lease_connection
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |_, _, _, _, payload|
assert_equal connection, payload[:connection]
end
Book.cache do
Book.first
Book.first
end
ensure
ActiveSupport::Notifications.unsubscribe(subscriber) if subscriber
end
end
module TransactionInSqlActiveRecordPayloadTests
def test_payload_without_an_open_transaction
asserted = false
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |event|
if event.payload.fetch(:name) == "Book Count"
assert_nil event.payload.fetch(:transaction)
asserted = true
end
end
Book.count
assert asserted
ensure
ActiveSupport::Notifications.unsubscribe(subscriber)
end
def test_payload_with_an_open_transaction
asserted = false
expected_transaction = nil
subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |event|
if event.payload.fetch(:name) == "Book Count"
assert_same expected_transaction, event.payload.fetch(:transaction)
asserted = true
end
end
Book.transaction do |transaction|
expected_transaction = transaction
Book.count
end
assert asserted
ensure
ActiveSupport::Notifications.unsubscribe(subscriber)
end
end
class TransactionInSqlActiveRecordPayloadTest < ActiveRecord::TestCase
include TransactionInSqlActiveRecordPayloadTests
end
class TransactionInSqlActiveRecordPayloadNonTransactionalTest < ActiveRecord::TestCase
include TransactionInSqlActiveRecordPayloadTests
self.use_transactional_tests = false
end
end
|
