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_changes` column is using the `json` type supported by PostgreSQL.
-
#object_col_is_json? ⇒ Boolean
Returns whether the ‘object` column is using the `json` type 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.objects` column.
-
#where_object_changes(args = {}) ⇒ Object
Given a hash of attributes like ‘name: ’Joan’‘, query the `versions.objects_changes` column.
- #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 |