Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Edit:</p> <p>I keep coming back to this code to use it in projects I'm in. Here's the latest which is useful for deeply nested structures and based on Pete's code above. I usually drop it in config/initializers/core_ext.rb (in a Rails project):</p> <pre><code>class Hash def deep_diff(other) (self.keys + other.keys).uniq.inject({}) do |memo, key| left = self[key] right = other[key] next memo if left == right if left.respond_to?(:deep_diff) &amp;&amp; right.respond_to?(:deep_diff) memo[key] = left.deep_diff(right) else memo[key] = [left, right] end memo end end end class Array def deep_diff(array) largest = [self.count, array.count].max memo = {} 0.upto(largest - 1) do |index| left = self[index] right = array[index] next if left == right if left.respond_to?(:deep_diff) &amp;&amp; right.respond_to?(:deep_diff) memo[index] = left.deep_diff(right) else memo[index] = [left, right] end end memo end end </code></pre> <p>Here's a small demo:</p> <pre><code>&gt; {a: [{b: "c", d: "e"}, {b: "c", f: "g"}]}.deep_diff({a: [{b: "c", d: "e"}, {b: "d", f: "g"}]}) =&gt; {:a=&gt;{1=&gt;{:b=&gt;["c", "d"]}}} </code></pre> <p>Older response:</p> <p>I have found Rails' Hash diff method to not actually tell me what was on the left side and right side (which is far more useful). There was a plugin call "Riff", that has since disappeared, which would let you diff two ActiveRecord objects. Essentially:</p> <pre><code>class Hash def diff(other) self.keys.inject({}) do |memo, key| unless self[key] == other[key] memo[key] = [self[key], other[key]] end memo end end end </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POComparing ruby hashes
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USColin Curtin
    1. USColin Curtin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COFor my purpose I don't especially care since I really just need to know which fields have changed. If I were using AR this wouldn't be an issue, but everything is being abstracted through a data layer to CouchDB so I find myself needing to reinvent the wheel, so to speak, for some functionality. Thanks for the suggestion though.
      singulars
      1. PO
      1. USChelsea
    2. COWhich of course corresponds to your "brute force" comment, but I feel it's useful and not so awful or inelegant.
      singulars
      1. PO
      1. USColin Curtin
    3. COThis method won't notice additional keys in `other` hash neither would it be able to tell key absence from value being `nil`, for improved version check http://stackoverflow.com/a/19184270/54247
      singulars
      1. PO
      1. USdolzenko
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload