Databases
StackOverflow2013
Postsdbo
POWhy is rake db:seed not behaving as expected?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy is rake db:seed not behaving as expected?
    primarykey
    data
    text
    <p>I am trying to seed my database in a very particular manner. Here is my /db/seeds.rb file:</p> <pre><code># creates a school in a local database. test_school = School.find_or_create_by_email(school_name: "Test School One", client_user_name: 'admin', client_password: 'Secretz1', fname: 'John', lname: 'doe', client_short_code: "72727", email: 'testemail@testemail.com') # creates a user in local database test_user = User.find_or_create_by_email(email: test_school.email, password: test_school.client_password, full_name: test_school.full_name, user_role: 'admin', school_id: test_school.id ) # creaate school via API results = School.create_via_api test_school if results[0].to_i == 0 test_school.update_attribute :client_number, results[2].split(" ").first SchoolMailer.registration_confirmation(test_user, test_school).deliver else test_school.destroy test_user.destroy end # an array of keyword topics keywords_ary = ["lunch", "schoolout?", "thenews", "holidays", "buses", "help"] # create a keyword object for each topic in the above array keywords_ary.each do |n| message = "" Array(1..5).each do |i| message += "#{i}. Test for @ts#{n}\n" end Keyword.find_or_create_by_user_id( name: "@ts#{n} test", keyword: "@ts#{n}", message1: message, user_id: test_user.id ) end # create each of the keywords via API test_user.keywords.each do |keyword| results = Keyword.create_on_avid keyword, test_user if results[0].to_i == 0 #save the api id to the local database keyword.update_attribute :keyword_id, results[2] else keyword.destroy end end </code></pre> <p>So what's the problem? Well, when I check my database only the very first keyword is created, and the message1 field for the keyword looks like this:</p> <pre><code> --- - 1 - 2 - 3 - 4 - 5 </code></pre> <p>when it should look like this:</p> <pre><code>1. this is a test for @tslunch 2. this is a test for @tslunch 3. this is a test for @tslunch 4. this is a test for @tslunch 5. this is a test for @tslunch </code></pre> <p>Am I doing something wrong?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USE.E.33
    1. USE.E.33
    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. This table or related slice is empty.
    1. COOut of interest: why is everything double spaced?
      singulars
      1. POWhy is rake db:seed not behaving as expected?
      1. USRyan Bigg
    2. COI don't know, it isn't in my editor. I copied and pasted, but didn't really pay attention to the spacing.
      singulars
      1. POWhy is rake db:seed not behaving as expected?
      1. USE.E.33
    3. COOk. I fixed it up for you. Where are you seeing this message1 field? How are you retrieving that value from the database?
      singulars
      1. POWhy is rake db:seed not behaving as expected?
      1. USRyan Bigg
 

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