Module: PaperTrail::VersionConcern::ClassMethods
- Defined in:
- lib/mongo_trails/version_concern.rb
Overview
:nodoc:
Instance Method Summary collapse
- #between(start_time, end_time) ⇒ Object
- #creates ⇒ Object
- #destroys ⇒ Object
- #item_subtype_column_present? ⇒ Boolean
- #not_creates ⇒ Object
-
#object_changes_col_is_json? ⇒ Boolean
Returns whether the
object_changescolumn is using thejsontype supported by PostgreSQL. -
#object_col_is_json? ⇒ Boolean
Returns whether the
objectcolumn is using thejsontype supported by PostgreSQL. -
#preceding(obj, timestamp_arg = false) ⇒ Object
Returns versions before
obj. - #primary_key_is_int? ⇒ Boolean
-
#subsequent(obj, timestamp_arg = false) ⇒ Object
Returns versions after
obj. -
#timestamp_sort_order(direction = "asc") ⇒ Object
Defaults to using the primary key as the secondary sort order if possible.
- #updates ⇒ Object
-
#where_object(args = {}) ⇒ Object
Given a hash of attributes like ‘name: ’Joan’‘, query the
versions.objectscolumn. -
#where_object_changes(args = {}) ⇒ Object
Given a hash of attributes like ‘name: ’Joan’‘, query the
versions.objects_changescolumn. - #with_item_keys(item_type, item_id) ⇒ Object
Instance Method Details
#between(start_time, end_time) ⇒ Object
41 42 43 |
# File 'lib/mongo_trails/version_concern.rb', line 41 def between(start_time, end_time) where(:created_at.gt => start_time).and(:created_at.lt => end_time).order() end |
#creates ⇒ Object
25 26 27 |
# File 'lib/mongo_trails/version_concern.rb', line 25 def creates where event: "create" end |
#destroys ⇒ Object
33 34 35 |
# File 'lib/mongo_trails/version_concern.rb', line 33 def destroys where event: "destroy" end |
#item_subtype_column_present? ⇒ Boolean
17 18 19 |
# File 'lib/mongo_trails/version_concern.rb', line 17 def item_subtype_column_present? column_names.include?("item_subtype") end |
#not_creates ⇒ Object
37 38 39 |
# File 'lib/mongo_trails/version_concern.rb', line 37 def not_creates where "event <> ?", "create" end |
#object_changes_col_is_json? ⇒ Boolean
Returns whether the object_changes column is using the json type supported by PostgreSQL.
122 123 124 125 |
# File 'lib/mongo_trails/version_concern.rb', line 122 def object_changes_col_is_json? # %i[json jsonb].include?(columns_hash["object_changes"].try(:type)) true end |
#object_col_is_json? ⇒ Boolean
Returns whether the object column is using the json type supported by PostgreSQL.
115 116 117 118 |
# File 'lib/mongo_trails/version_concern.rb', line 115 def object_col_is_json? # %i[json jsonb].include?(columns_hash["object"].type) true end |
#preceding(obj, timestamp_arg = false) ⇒ Object
Returns versions before obj.
134 135 136 137 138 139 140 |
# File 'lib/mongo_trails/version_concern.rb', line 134 def preceding(obj, = false) if != true && primary_key_is_int? preceding_by_id(obj) else (obj) end end |
#primary_key_is_int? ⇒ Boolean
107 108 109 110 111 |
# File 'lib/mongo_trails/version_concern.rb', line 107 def primary_key_is_int? @primary_key_is_int ||= columns_hash[primary_key].type == :integer rescue StandardError # TODO: Rescue something more specific true end |
#subsequent(obj, timestamp_arg = false) ⇒ Object
Returns versions after obj.
149 150 151 152 153 154 155 |
# File 'lib/mongo_trails/version_concern.rb', line 149 def subsequent(obj, = false) if != true && primary_key_is_int? subsequent_by_id(obj) else (obj) end end |
#timestamp_sort_order(direction = "asc") ⇒ Object
Defaults to using the primary key as the secondary sort order if possible.
47 48 49 |
# File 'lib/mongo_trails/version_concern.rb', line 47 def (direction = "asc") { created_at: direction.downcase } end |
#updates ⇒ Object
29 30 31 |
# File 'lib/mongo_trails/version_concern.rb', line 29 def updates where event: "update" end |
#where_object(args = {}) ⇒ Object
Given a hash of attributes like ‘name: ’Joan’‘, query the versions.objects column.
“‘ SELECT “versions”.* FROM “versions” WHERE (“versions”.“object” LIKE ’% name: Joan %‘) “`
This is useful for finding versions where a given attribute had a given value. Imagine, in the example above, that Joan had changed her name and we wanted to find the versions before that change.
Based on the data type of the object column, the appropriate SQL operator is used. For example, a text column will use like, and a jsonb column will use ‘@>`.
71 72 73 74 |
# File 'lib/mongo_trails/version_concern.rb', line 71 def where_object(args = {}) raise ArgumentError, "expected to receive a Hash" unless args.is_a?(Hash) Queries::Versions::WhereObject.new(self, args).execute end |
#where_object_changes(args = {}) ⇒ Object
Given a hash of attributes like ‘name: ’Joan’‘, query the versions.objects_changes column.
“‘ SELECT “versions”.* FROM “versions” WHERE .. (“versions”.“object_changes” LIKE ’% name:
-
Joan
%‘ OR “versions”.“object_changes” LIKE ’% name: -%
-
Joan
%‘) “`
This is useful for finding versions immediately before and after a given attribute had a given value. Imagine, in the example above, that someone changed their name to Joan and we wanted to find the versions immediately before and after that change.
Based on the data type of the object column, the appropriate SQL operator is used. For example, a text column will use like, and a jsonb column will use ‘@>`.
102 103 104 105 |
# File 'lib/mongo_trails/version_concern.rb', line 102 def where_object_changes(args = {}) raise ArgumentError, "expected to receive a Hash" unless args.is_a?(Hash) Queries::Versions::WhereObjectChanges.new(self, args).execute end |
#with_item_keys(item_type, item_id) ⇒ Object
21 22 23 |
# File 'lib/mongo_trails/version_concern.rb', line 21 def with_item_keys(item_type, item_id) where(item_type: item_type).and(item_id: item_id) end |