Module: PactBroker::Pacts::PactPublicationDatasetModule

Defined in:
lib/pact_broker/pacts/pact_publication_dataset_module.rb

Instance Method Summary collapse

Instance Method Details

#consumer_name_like(name) ⇒ Object 



256
257
258
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 256

def consumer_name_like(name)
  where(name_like(Sequel[:consumers][:name], name))
end

#consumer_version_number_like(number) ⇒ Object 



260
261
262
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 260

def consumer_version_number_like(number)
  where(name_like(Sequel[:cv][:number], number))
end

#consumer_version_tag(tag) ⇒ Object 



264
265
266
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 264

def consumer_version_tag(tag)
  where(Sequel[:ct][:name] => tag)
end

#created_after(date) ⇒ Object 



191
192
193
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 191

def created_after date
  where(Sequel.lit("#{first_source_alias}.created_at > ?", date))
end

#delete ⇒ Object 



284
285
286
287
288
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 284

def delete
  require 'pact_broker/webhooks/triggered_webhook'
  PactBroker::Webhooks::TriggeredWebhook.where(pact_publication: self).delete
  super
end

#eager_load_pact_versions ⇒ Object 



243
244
245
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 243

def eager_load_pact_versions
  eager(:pact_versions)
end

#for_consumer(consumer) ⇒ Object 



8
9
10
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 8

def for_consumer consumer
  where(consumer: consumer)
end

#for_provider(provider) ⇒ Object 



4
5
6
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 4

def for_provider provider
  where(provider: provider)
end

#for_provider_and_consumer_version_selector(provider, selector) ⇒ Object 



12
13
14
15
16
17
18
19
20
21
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 12

def for_provider_and_consumer_version_selector provider, selector
  # Does not yet support "all pacts for specified tag" - that code is still in the Pact::Repository
  query = for_provider(provider)
  query = query.for_consumer(PactBroker::Domain::Pacticipant.find_by_name(selector.consumer)) if selector.consumer
  # Do this last so that the provider/consumer criteria get included in the "latest" query before the join, rather than after
  query = query.latest_for_consumer_branch(selector.branch) if selector.latest_for_branch?
  query = query.latest_for_consumer_tag(selector.tag) if selector.latest_for_tag?
  query = query.overall_latest if selector.overall_latest?
  query
end

#join_consumer_version_tags(table_alias = :ct) ⇒ Object 



212
213
214
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 212

def join_consumer_version_tags(table_alias = :ct)
  join(:tags, { Sequel[table_alias][:version_id] => Sequel[:pact_publications][:consumer_version_id]}, { table_alias: table_alias })
end

#join_consumer_version_tags_with_names(consumer_version_tag_names) ⇒ Object 



216
217
218
219
220
221
222
223
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 216

def join_consumer_version_tags_with_names(consumer_version_tag_names)
  join(:tags, {
    Sequel[:ct][:version_id] => Sequel[:pact_publications][:consumer_version_id],
    Sequel[:ct][:name] => consumer_version_tag_names
  }, {
    table_alias: :ct
  })
end

#join_consumer_versions(table_alias = :cv, extra_join_criteria = {}, &block) ⇒ Object 



205
206
207
208
209
210
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 205

def join_consumer_versions(table_alias = :cv, extra_join_criteria = {}, &block)
  versions_join = {
    Sequel[:pact_publications][:consumer_version_id] => Sequel[table_alias][:id]
  }.merge(extra_join_criteria)
  join(:versions, versions_join, { table_alias: table_alias }, &block)
end

#join_consumers(table_alias = :consumers, base_table = :pact_publications, extra_join_criteria = {}) ⇒ Object 



232
233
234
235
236
237
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 232

def join_consumers(table_alias = :consumers, base_table = :pact_publications, extra_join_criteria = {})
  consumer_join = {
    Sequel[base_table][:consumer_id] => Sequel[table_alias][:id]
  }.merge(extra_join_criteria)
  join(:pacticipants, consumer_join, { table_alias: table_alias })
end

#join_pact_versions ⇒ Object 



239
240
241
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 239

def join_pact_versions
  join(:pact_versions, { Sequel[:pact_publications][:pact_version_id] => Sequel[:pact_versions][:id] })
end

#join_providers(table_alias = :providers, base_table = :pact_publications, extra_join_criteria = {}) ⇒ Object 



225
226
227
228
229
230
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 225

def join_providers(table_alias = :providers, base_table = :pact_publications, extra_join_criteria = {})
  provider_join = {
    Sequel[base_table][:provider_id] => Sequel[table_alias][:id]
  }.merge(extra_join_criteria)
  join(:pacticipants, provider_join, { table_alias: table_alias })
end

#latest_by_consumer_branch ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 23

def latest_by_consumer_branch
  versions_join = {
    Sequel[:pact_publications][:consumer_version_id] => Sequel[:cv][:id]
  }

  base_query = join(:versions, versions_join, { table_alias: :cv }) do
    Sequel.lit("cv.branch is not null")
  end

  self_join = {
    Sequel[:pact_publications][:consumer_id] => Sequel[:pp2][:consumer_id],
    Sequel[:cv][:branch] => Sequel[:pp2][:branch]
  }

  if no_columns_selected?
    base_query = base_query.select_all_qualified.select_append(Sequel[:cv][:branch])
  end

  base_query.left_join(base_query.select(:consumer_id, :branch, :order), self_join, { table_alias: :pp2 } ) do
    Sequel[:pp2][:order] > Sequel[:cv][:order]
  end
  .where(Sequel[:pp2][:order] => nil)
  .remove_overridden_revisions_from_complete_query
end

#latest_by_consumer_tag ⇒ Object 



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
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 91

def latest_by_consumer_tag
  tags_join = {
    Sequel[:pact_publications][:consumer_version_id] => Sequel[:tags][:version_id]
  }

  base_query = join(:tags, tags_join)

  if no_columns_selected?
    base_query = base_query.select_all_qualified.select_append(Sequel[:tags][:name].as(:tag_name))
  end

  joined_query = base_query.select(
    Sequel[:pact_publications][:consumer_id],
    Sequel[:tags][:version_order],
    Sequel[:tags][:name].as(:tag_name)
  )

  self_join = {
    Sequel[:pact_publications][:consumer_id] => Sequel[:pp2][:consumer_id],
    Sequel[:tags][:name] => Sequel[:pp2][:tag_name]
  }
  base_query.left_join(joined_query, self_join, { table_alias: :pp2 } ) do
    Sequel[:pp2][:version_order] > Sequel[:tags][:version_order]
  end
  .where(Sequel[:pp2][:version_order] => nil)
  .remove_overridden_revisions_from_complete_query
end

#latest_for_consumer_branch(branch) ⇒ Object 



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
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 65

def latest_for_consumer_branch(branch)
  versions_join = {
    Sequel[:pact_publications][:consumer_version_id] => Sequel[:cv][:id],
    Sequel[:cv][:branch] => branch
  }

  base_query = join(:versions, versions_join, { table_alias: :cv }) do
    Sequel.lit("cv.branch is not null")
  end

  self_join = {
    Sequel[:pact_publications][:consumer_id] => Sequel[:pp2][:consumer_id],
    Sequel[:cv][:branch] => Sequel[:pp2][:branch]
  }

  if no_columns_selected?
    base_query = base_query.select_all_qualified.select_append(Sequel[:cv][:branch])
  end

  base_query.left_join(base_query.select(:consumer_id, :branch, :order), self_join, { table_alias: :pp2 } ) do
    Sequel[:pp2][:order] > Sequel[:cv][:order]
  end
  .where(Sequel[:pp2][:order] => nil)
  .remove_overridden_revisions_from_complete_query
end

#latest_for_consumer_tag(tag_name) ⇒ Object 



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
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 119

def latest_for_consumer_tag(tag_name)
  tags_join = {
    Sequel[:pact_publications][:consumer_version_id] => Sequel[:tags][:version_id],
    Sequel[:tags][:name] => tag_name
  }

  base_query = self
  if no_columns_selected?
    base_query = base_query.select_all_qualified.select_append(Sequel[:tags][:name].as(:tag_name))
  end

  base_query = base_query
    .join(:tags, tags_join)
    .where(Sequel[:tags][:name] => tag_name)

  joined_query = base_query.select(
    Sequel[:pact_publications][:consumer_id],
    Sequel[:tags][:name].as(:tag_name),
    Sequel[:tags][:version_order]
  )

  self_join = {
    Sequel[:pact_publications][:consumer_id] => Sequel[:pp2][:consumer_id],
    Sequel[:tags][:name] => Sequel[:pp2][:tag_name]
  }

  base_query.left_join(joined_query, self_join, { table_alias: :pp2 } ) do
    Sequel[:pp2][:version_order] > Sequel[:tags][:version_order]
  end
  .where(Sequel[:pp2][:version_order] => nil)
  .remove_overridden_revisions_from_complete_query
end

#order_by_consumer_name ⇒ Object 



268
269
270
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 268

def order_by_consumer_name
  order_append_ignore_case(Sequel[:consumers][:name])
end

#order_by_consumer_version_order ⇒ Object 



272
273
274
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 272

def order_by_consumer_version_order
  order_append(Sequel[:cv][:order])
end

#overall_latest ⇒ Object 



48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 48

def overall_latest
  base_query = join_consumer_versions # won't need to do this when we add the order to latest_pact_publication_ids_for_consumer_versions

  self_join = {
    Sequel[:pact_publications][:consumer_id] => Sequel[:pp2][:consumer_id],
    Sequel[:pact_publications][:provider_id] => Sequel[:pp2][:provider_id]
  }

  base_query = base_query.select_all_qualified if no_columns_selected?

  base_query.left_join(base_query.select(:consumer_id, :provider_id, :order), self_join, { table_alias: :pp2 } ) do
    Sequel[:pp2][:order] > Sequel[:cv][:order]
  end
  .where(Sequel[:pp2][:order] => nil)
  .remove_overridden_revisions_from_complete_query
end

#provider_name_like(name) ⇒ Object 



252
253
254
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 252

def provider_name_like(name)
  where(name_like(Sequel[:providers][:name], name))
end

#remove_overridden_revisions(pact_publications_alias = :pact_publications) ⇒ Object 



195
196
197
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 195

def remove_overridden_revisions(pact_publications_alias = :pact_publications)
  join(:latest_pact_publication_ids_for_consumer_versions, { Sequel[:lp][:pact_publication_id] => Sequel[pact_publications_alias][:id] }, { table_alias: :lp})
end

#remove_overridden_revisions_from_complete_query ⇒ Object 



199
200
201
202
203
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 199

def remove_overridden_revisions_from_complete_query
  from_self(alias: :p)
  .select(Sequel[:p].*)
  .remove_overridden_revisions(:p)
end

#successfully_verified_by_provider_branch(provider_id, provider_version_branch) ⇒ Object 



152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 152

def successfully_verified_by_provider_branch(provider_id, provider_version_branch)
  verifications_join = {
    pact_version_id: :pact_version_id,
    Sequel[:verifications][:success] => true,
    Sequel[:verifications][:wip] => false,
    Sequel[:verifications][:provider_id] => provider_id
  }
  versions_join = {
    Sequel[:verifications][:provider_version_id] => Sequel[:provider_versions][:id],
    Sequel[:provider_versions][:branch] => provider_version_branch,
    Sequel[:provider_versions][:pacticipant_id] => provider_id
  }

  from_self(alias: :pp).select(Sequel[:pp].*)
    .join(:verifications, verifications_join)
    .join(:versions, versions_join, { table_alias: :provider_versions } )
    .where(Sequel[:pp][:provider_id] => provider_id)
    .distinct
end

#successfully_verified_by_provider_tag(provider_id, provider_tag) ⇒ Object 



172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 172

def successfully_verified_by_provider_tag(provider_id, provider_tag)
  verifications_join = {
    pact_version_id: :pact_version_id,
    Sequel[:verifications][:success] => true,
    Sequel[:verifications][:wip] => false,
    Sequel[:verifications][:provider_id] => provider_id
  }
  tags_join = {
    Sequel[:verifications][:provider_version_id] => Sequel[:provider_tags][:version_id],
    Sequel[:provider_tags][:name] => provider_tag
  }

  from_self(alias: :pp).select(Sequel[:pp].*)
    .join(:verifications, verifications_join)
    .join(:tags, tags_join, { table_alias: :provider_tags } )
    .where(Sequel[:pp][:provider_id] => provider_id)
    .distinct
end

#tag(tag_name) ⇒ Object 



247
248
249
250
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 247

def tag tag_name
  filter = name_like(Sequel.qualify(:tags, :name), tag_name)
  join(:tags, {version_id: :consumer_version_id}).where(filter)
end

#where_consumer_if_set(consumer) ⇒ Object 



276
277
278
279
280
281
282
 
# File 'lib/pact_broker/pacts/pact_publication_dataset_module.rb', line 276

def where_consumer_if_set(consumer)
  if consumer
    where(consumer: consumer)
  else
    self
  end
end