Databases
StackOverflow2013
Postsdbo
POruby on rails looping through a list of key value elements
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POruby on rails looping through a list of key value elements
    primarykey
    data
    text
    <p>I have a list of key value pairs like this. </p> <pre><code> PERSON_SUMMARY = { first_names: %w(Mike Tim Jim kevin Alan Sara John Sammy t'Renée), last_names: %w(Robinson Jackson Fox Terry Ali Brits Tyson Willis-St.\ Paul), offenses: [ { offense_name:'Speeding', penalties: [ { penalty_name: 'Prison', severity: 'Medium' }, { penalty_name: 'Ticket', severity: 'Low' } ] }, { offense_name:'Shoplifting', penalties: [ { penalty_name: 'Prison', severity: 'Medium' }, { penalty_name: 'Fine', severity: 'Low' } ] } ] } </code></pre> <p>I want to store and print only <strong>offense_name</strong>,**penalty_name** and <strong>severity</strong> one by one , but I am not able to get the right syntax.</p> <p>Here is what I have tried so far:</p> <pre><code>PERSON_SUMMARY[:offenses].each do |offense| offense_name = offense[:offense_name] offense[:penalties].each do |penalty| penalty_name = penalty[:penalty_name] severity_val = penalty[:severity] end end </code></pre> <p>EDIT: Eventually I need to insert it into the database table through this function:</p> <pre><code>PersonOffense.where(person_id: person.id).first_or_create( name: offense_name, penalty: penalty_name , severity: severity_val end </code></pre> <p>But I notice an issue, there are multiple penalty names above. Not sure how to insert them.</p> <p>For example, I need to insert offense_name twice in my table so that there are 2 entries in the table.</p> <pre><code>Speeding Prison Medium Speeding Ticket Low </code></pre> <p>EDIT: I like Jesse's answer below. How can I use it to insert it in the same order to my method above (inserting offense_name,penalty_name and severity with the result of the answer given below by Jesse.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStackleberry
    1. USnewbie
    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
    1. VO
      singulars
      1. POruby on rails looping through a list of key value elements
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COwhat is not working with your solution? what are you trying to achieve?
      singulars
      1. POruby on rails looping through a list of key value elements
      1. USdoesterr
    2. COLike i mentioned above I am trying to store and print offense_name, penalty_name and severity. I am getting this error syntax error, unexpected keyword_end, expecting ')' on the last line above
      singulars
      1. POruby on rails looping through a list of key value elements
      1. USnewbie
    3. COhmm, your solution runs fine for me (except for the é character in Renée)
      singulars
      1. POruby on rails looping through a list of key value elements
      1. USdoesterr
 

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