Databases
StackOverflow2013
Postsdbo
PODynamic hash - Ruby on Rails
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODynamic hash - Ruby on Rails
    primarykey
    data
    text
    <p>the code so far:</p> <pre><code>def queryConnect ... count = 0 #clients is an array of hashes. #channels is an array of hashes. channel_array = [] channels.each do |channel| begin if clients[count]["cid"].to_i == channel["cid"].to_i channel_array &lt;&lt; { "cname" =&gt; channel["channel_name"].transform_escape, "name" =&gt; clients[count]["client_nickname"].transform_escape } count = count + 1 else channel_array &lt;&lt; { "cname" =&gt; channel["channel_name"].transform_escape } end rescue #transform_escape -&gt; some elements are not type string. end end count = 0 channel_array end </code></pre> <p>channels sample input: <code>[{"channel_name" =&gt; "game1", "cid" =&gt; 1}, {"channel_name" =&gt; "game2", "cid" =&gt; 2}, {"channel_name" =&gt; "game3", "cid" =&gt; 3}]</code></p> <p>clients sample input: <code>[{"client_nickname" =&gt; "greg", "cid" =&gt; 1}, {"client_nickname" =&gt; "bob", "cid" =&gt; 1}, {"client_nickname" =&gt; "george", "cid" =&gt; 3}]</code></p> <p>expected output:<code>[{"cname" =&gt; "game1", "name" =&gt; ["greg", "bob"]}]</code></p> <p>The problem: I'm trying to loop through all the channels, if the client's channel id and channel's channel id (cid) match I want to create a hash with the channel name and client name(s) and then push it onto the <code>channel_array</code>. </p> <p>The only issue I'm having now is when there are multiple clients in a channel... How can I dynamically add a key, value pair by iterating through the clients array and still maintaining the condition to see if the channel ids match?</p> <p>I've been beating my head against my text editor for two days on this problem any help is appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSnarf
    1. USSnarf
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODynamic hash - Ruby on Rails
      1. This table or related slice is empty.
      1. VTClose
    2. VO
      singulars
      1. PODynamic hash - Ruby on Rails
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PODynamic hash - Ruby on Rails
      1. This table or related slice is empty.
      1. VTClose
    1. COCan you give us some sample input and expected output? It's really not that clear what you're trying to do.
      singulars
      1. PODynamic hash - Ruby on Rails
      1. USmeagar
    2. COSample input and expected output added.
      singulars
      1. PODynamic hash - Ruby on Rails
      1. USSnarf
    3. COi think this hash doc can help u a bit.http://ruby-doc.org/core-2.0/Hash.html#method-i-update
      singulars
      1. PODynamic hash - Ruby on Rails
      1. USNich
 

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