Fixing seed data formatting

Ada-C8 · marisamorris · Oct 17, 2017 · Oct 18, 2017 · Oct 18, 2017 · Oct 18, 2017
commit 3b150571f0f8dff8b2c4ef914470f303ce8972d4
diff --git a/app/controllers/product_controller.rb b/app/controllers/product_controller.rb
@@ -4,6 +4,7 @@ def index
   end
 
   def show
+    @product = Product.find(params[:id].to_i)
   end
 
   def edit

diff --git a/app/views/products/index.html.erb b/app/views/products/index.html.erb
@@ -1,2 +1,20 @@
 <h1>Products#index</h1>
 <p>Find me in app/views/products/index.html.erb</p>
+
+<section class="products">
+
+<% @products.each do |product| %>
+  <article class="product_details">
+    <ul>
+      <li>
+        <%= product.name %>
+        <%= product.price %>
+        <%= product.description %>
+        <%= product.user %>
+      </li>
+    </ul>
+  <% end %>
+  </article>
+
+
+</section>
diff --git a/config/routes.rb b/config/routes.rb
@@ -11,7 +11,7 @@
   resources :orders
 
   resources :billing_data
-  resources :product
+  resources :products
 
 
   # get 'items/index'

diff --git a/db/billing_data_seeds.csv b/db/billing_data_seeds.csv
@@ -1 +1,2 @@
-billing_data_id,user_id,username,email,mailing_address,credit_card_name,credit_card_number,credit_card_CVV,billing_zip_code1,2, sage_elliot,selliot@gmail.com,"123 Yesler Way, Seattle, WA",Sage Elliot,7777 5555 4444 2222,444,98101
+billing_data_id,user_id,username,email,mailing_address,credit_card_name,credit_card_number,credit_card_CVV,billing_zip_code
+1,2, sage_elliot,selliot@gmail.com,"123 Yesler Way, Seattle, WA",Sage Elliot,7777 5555 4444 2222,444,98101
diff --git a/db/category_seeds.csv b/db/category_seeds.csv
@@ -1 +1,8 @@
-category_id,category1,clothing2,tour3,class4,collectible5,cabin gear6,music7,dog gear
+category_id,category
+1,clothing,
+2,tour,
+3,class,
+4,collectible,
+5,cabin gear,
+6,music,
+7,dog gear

diff --git a/db/items_seeds.csv b/db/items_seeds.csv
@@ -1 +1,49 @@
-item_id,product_id,purchase_status,shipping_status1,1,FALSE,FALSE2,1,FALSE,FALSE3,1,FALSE,FALSE4,1,FALSE,FALSE5,1,FALSE,FALSE6,2,FALSE,FALSE7,2,FALSE,FALSE8,2,FALSE,FALSE9,2,FALSE,FALSE10,2,FALSE,FALSE11,2,FALSE,FALSE12,2,FALSE,FALSE13,2,FALSE,FALSE14,2,FALSE,FALSE15,3,FALSE,FALSE16,3,FALSE,FALSE17,3,FALSE,FALSE18,3,FALSE,FALSE19,3,FALSE,FALSE20,3,FALSE,FALSE21,4,FALSE,FALSE22,4,FALSE,FALSE23,4,FALSE,FALSE24,4,FALSE,FALSE25,5,FALSE,FALSE26,5,FALSE,FALSE27,5,FALSE,FALSE28,5,FALSE,FALSE29,6,FALSE,FALSE30,6,FALSE,FALSE31,7,FALSE,FALSE32,7,FALSE,FALSE33,7,FALSE,FALSE34,7,FALSE,FALSE35,8,FALSE,FALSE36,8,FALSE,FALSE37,9,TRUE,FALSE38,10,FALSE,FALSE39,10,FALSE,FALSE40,10,FALSE,FALSE41,10,FALSE,FALSE42,10,FALSE,FALSE43,10,FALSE,FALSE44,10,FALSE,FALSE45,10,FALSE,FALSE46,10,FALSE,FALSE47,10,FALSE,FALSE48,10,FALSE,FALSE
+item_id,product_id,purchase_status,shipping_status
+1,1,FALSE,FALSE,
+2,1,FALSE,FALSE,
+3,1,FALSE,FALSE,
+4,1,FALSE,FALSE,
+5,1,FALSE,FALSE,
+6,2,FALSE,FALSE,
+7,2,FALSE,FALSE,
+8,2,FALSE,FALSE,
+9,2,FALSE,FALSE,
+10,2,FALSE,FALSE,
+11,2,FALSE,FALSE,
+12,2,FALSE,FALSE,
+13,2,FALSE,FALSE,
+14,2,FALSE,FALSE,
+15,3,FALSE,FALSE,
+16,3,FALSE,FALSE,
+17,3,FALSE,FALSE,
+18,3,FALSE,FALSE,
+19,3,FALSE,FALSE,
+20,3,FALSE,FALSE,
+21,4,FALSE,FALSE,
+22,4,FALSE,FALSE,
+23,4,FALSE,FALSE,
+24,4,FALSE,FALSE,
+25,5,FALSE,FALSE,
+26,5,FALSE,FALSE,
+27,5,FALSE,FALSE,
+28,5,FALSE,FALSE,
+29,6,FALSE,FALSE,
+30,6,FALSE,FALSE,
+31,7,FALSE,FALSE,
+32,7,FALSE,FALSE,
+33,7,FALSE,FALSE,
+34,7,FALSE,FALSE,
+35,8,FALSE,FALSE,
+36,8,FALSE,FALSE,
+37,9,TRUE,FALSE,
+38,10,FALSE,FALSE,
+39,10,FALSE,FALSE,
+40,10,FALSE,FALSE,
+41,10,FALSE,FALSE,
+42,10,FALSE,FALSE,
+43,10,FALSE,FALSE,
+44,10,FALSE,FALSE,
+45,10,FALSE,FALSE,
+46,10,FALSE,FALSE,
+47,10,FALSE,FALSE,
+48,10,FALSE,FALSE

diff --git a/db/order_products_seeds.csv b/db/order_products_seeds.csv
@@ -1 +1,9 @@
-order_product_id,order_id,product_id,quantity1,1,1,42,1,2,53,1,3,14,2,4,35,2,5,26,2,6,27,2,7,18,3,9,1
+order_product_id,order_id,product_id,quantity
+1,1,1,4,
+2,1,2,5,
+3,1,3,1,
+4,2,4,3,
+5,2,5,2,
+6,2,6,2,
+7,2,7,1,
+8,3,9,1
diff --git a/db/order_seeds.csv b/db/order_seeds.csv
@@ -1 +1,4 @@
-order_id,session_id,user_id,order_status,billing_data_id1,89,5,pending,2,322,,pending,3,867,2,paid,1
+order_id,session_id,user_id,order_status,billing_data_id
+1,89,5,pending,2,
+2,32,2,pending,3,
+3,867,2,paid,1,

diff --git a/db/product_seeds.csv b/db/product_seeds.csv
@@ -1 +1,11 @@
-product_id,category_id,user_id,name,price,description1,6,1,Mack Daddy,12.99,"Mack Daddy is the third album by Sir Mix-a-Lot, and his first album with a Parental Advisory label. It was released on February 4, 1992, on Def American Recordings. The album is particularly notable for the hit single ""Baby Got Back."""2,6,1,Nevermind,9.95,"Nevermind is the second studio album by American grunge rock band Nirvana, released on September 24, 1991 by DGC Records. Produced by Butch Vig, Nevermind was the band's first release on DGC. It was also their first album to feature drummer Dave Grohl."3,1,2,Red Plaid Shirt- Size S,49.95,"Classic lumberjack shirt that you wear to the bar, of course."4,1,2,Red Plaid Shirt- Size M,49.95,"Classic lumberjack shirt that you wear to the bar, of course."5,1,2,Red Plaid Shirt- Size L,49.95,"Classic lumberjack shirt that you wear to the bar, of course."6,4,7,Framed Bigfoot Sighting Photo,119.5,Proof that Sasquatch is real.7,4,10,Sasquatch Action Figure,14.99,Plastic figurine8,7,8,Red Plaid Dog Bandana,5.25,Every PNW dog needs one of these!9,6,4,Crash,8.5,"Crash is the second studio album by American rock group Dave Matthews Band, released on April 30, 1996. By March 16, 2000, the album had sold seven million copies, and was certified 7_ platinum by the RIAA.[1] This is currently Dave Matthews Band's best-selling album."10,6,4,Live at Red Rocks,15,"Live at Red Rocks 8.15.95 is an album by the Dave Matthews Band, released on October 28, 1997. It was recorded live at Red Rocks Amphitheatre in Morrison, Colorado on August 15, 1995. "
+product_id,category_id,user_id,name,price,description
+1,6,1,Mack Daddy,12.99,"Mack Daddy is the third album by Sir Mix-a-Lot, and his first album with a Parental Advisory label. It was released on February 4, 1992, on Def American Recordings. The album is particularly notable for the hit single ""Baby Got Back.",
+2,6,1,Nevermind,9.95,"Nevermind is the second studio album by American grunge rock band Nirvana, released on September 24, 1991 by DGC Records. Produced by Butch Vig, Nevermind was the band's first release on DGC. It was also their first album to feature drummer Dave Grohl.",
+3,1,2,Red Plaid Shirt- Size S,49.95,"Classic lumberjack shirt that you wear to the bar, of course.",
+4,1,2,Red Plaid Shirt- Size M,49.95,"Classic lumberjack shirt that you wear to the bar, of course.",
+5,1,2,Red Plaid Shirt- Size L,49.95,"Classic lumberjack shirt that you wear to the bar, of course.",
+6,4,7,Framed Bigfoot Sighting Photo,119.5,"Proof that Sasquatch is real.",
+7,4,10,Sasquatch Action Figure,14.99,"Plastic figurine",
+8,7,8,Red Plaid Dog Bandana,5.25,"Every PNW dog needs one of these!",
+9,6,4,Crash,8.5,"Crash is the second studio album by American rock group Dave Matthews Band, released on April 30, 1996. By March 16, 2000, the album had sold seven million copies, and was certified 7_ platinum by the RIAA.[1] This is currently Dave Matthews Band's best-selling album.",
+10,6,4,Live at Red Rocks,15,"Live at Red Rocks 8.15.95 is an album by the Dave Matthews Band, released on October 28, 1997. It was recorded live at Red Rocks Amphitheatre in Morrison, Colorado on August 15, 1995."

diff --git a/db/reviews_seeds.csv b/db/reviews_seeds.csv
@@ -1 +1,7 @@
-review_id,user_id,product_id,text,rating1,1,7,Great to use to make fake bigfoot photos throughout the PNW. It lives on my dashboard!,52,1,5,Fits perfect but wish it had elbow patches.,43,3,7,My daughter broke it within 5 seconds of opening it. Cheap plastic!,14,5,6,Awesome conversation piece.,55,7,10,DMB forever! I see him at the Wallingford QFC all the time.,56,8,8,Fell off my dog all the time because there isn't enough velcro on the clasp. But very cute.,2
+review_id,user_id,product_id,text,rating
+1,1,7,Great to use to make fake bigfoot photos throughout the PNW. It lives on my dashboard!,5,
+2,1,5,Fits perfect but wish it had elbow patches.,4,
+3,3,7,My daughter broke it within 5 seconds of opening it. Cheap plastic!,1,
+4,5,6,Awesome conversation piece.,5,
+5,7,10,DMB forever! I see him at the Wallingford QFC all the time.,5,
+6,8,8,Fell off my dog all the time because there isn't enough velcro on the clasp. But very cute.,2

diff --git a/db/seeds.rb b/db/seeds.rb
@@ -1,43 +1,43 @@
-# # This file should contain all the record creation needed to seed the database with its default values.
-# # The data can then be loaded with the rails db:seed command (or created alongside the database with db:setup).
-# #
-# # Examples:
-# #
-# #   movies = Movie.create([{ name: 'Star Wars' }, { name: 'Lord of the Rings' }])
-# #   Character.create(name: 'Luke', movie: movies.first)
-#
-# # This file should contain all the record creation needed to seed the database with its default values.
-# # The data can then be loaded with the rails db:seed command (or created alongside the database with db:setup).
-# #
-# # Examples:
-# #
-# #   movies = Movie.create([{ name: 'Star Wars' }, { name: 'Lord of the Rings' }])
-# #   Character.create(name: 'Luke', movie: movies.first)
-#
-# require 'csv'
-#
-# PRODUCT_FILE = Rails.root.join('db', 'seed_data', 'product_seeds.csv')
-# puts "Loading raw work data from #{PRODUCT_FILE}"
-#
-# product_failures = []
-# CSV.foreach(PRODUCT_FILE, :headers => true) do |row|
-#   product = Product.new
-#   product.id = row['product_id']
-#   product.category_id = row['category_id']
-#   product.user_id = row['user_id']
-#   product.name = row['name']
-#   product.price = row['price']
-#   product.description = row['description']
-#   puts "Created product: #{product.inspect}"
-#   successful = product.save
-#   if !successful
-#     product_failures << product
-#   end
-# end
-#
-# puts "Added #{Product.count} product records"
-# puts "#{product_failures.length} product failed to save"
-#
+# This file should contain all the record creation needed to seed the database with its default values.
+# The data can then be loaded with the rails db:seed command (or created alongside the database with db:setup).
+#
+# Examples:
+#
+#   movies = Movie.create([{ name: 'Star Wars' }, { name: 'Lord of the Rings' }])
+#   Character.create(name: 'Luke', movie: movies.first)
+
+# This file should contain all the record creation needed to seed the database with its default values.
+# The data can then be loaded with the rails db:seed command (or created alongside the database with db:setup).
+#
+# Examples:
+#
+#   movies = Movie.create([{ name: 'Star Wars' }, { name: 'Lord of the Rings' }])
+#   Character.create(name: 'Luke', movie: movies.first)
+
+require 'csv'
+
+PRODUCT_FILE = Rails.root.join('db', 'seed_data', 'product_seeds.csv')
+puts "Loading raw work data from #{PRODUCT_FILE}"
+
+product_failures = []
+CSV.foreach(PRODUCT_FILE, :headers => true) do |row|
+  product = Product.new
+  product.id = row['product_id']
+  product.category_id = row['category_id']
+  product.user_id = row['user_id']
+  product.name = row['name']
+  product.price = row['price']
+  product.description = row['description']
+  puts "Created product: #{product.inspect}"
+  successful = product.save
+  if !successful
+    product_failures << product
+  end
+end
+
+puts "Added #{Product.count} product records"
+puts "#{product_failures.length} product failed to save"
+
 #
 #
 # USER_FILE = Rails.root.join('db', 'seed_data', 'user_seeds.csv')
@@ -196,14 +196,14 @@
 # puts "Added #{Item.count} item records"
 # puts "#{item_failures.length} item records failed to save"
 #
-#
-# # Since we set the primary key (the ID) manually on each of the
-# # tables, we've got to tell postgres to reload the latest ID
-# # values. Otherwise when we create a new record it will try
-# # to start at ID 1, which will be a conflict.
-# puts "Manually resetting PK sequence on each table"
-# ActiveRecord::Base.connection.tables.each do |t|
-#   ActiveRecord::Base.connection.reset_pk_sequence!(t)
-# end
-#
-# puts "done"
+
+# Since we set the primary key (the ID) manually on each of the
+# tables, we've got to tell postgres to reload the latest ID
+# values. Otherwise when we create a new record it will try
+# to start at ID 1, which will be a conflict.
+puts "Manually resetting PK sequence on each table"
+ActiveRecord::Base.connection.tables.each do |t|
+  ActiveRecord::Base.connection.reset_pk_sequence!(t)
+end
+
+puts "done"
diff --git a/db/user_seeds.csv b/db/user_seeds.csv
@@ -1 +1,11 @@
-user_id,username,email1,sir_mixalot,mixalot@google.com2, sage_elliot,selliot@gmail.com3,jhendrix,hendrix@outlook.com4,dmatthews,dmatthews@google.com5,quincy-jones,qjones@yahoo.com6,KennyG,Kgorelick@hotmail.com7,Jane Pine,janep@gmail.com8,Jack Union,jacku@yahoo.com9,Trey Smith,SmithT@gmail.com10,Amelia Yesler,amelia@hotmail.com
+user_id,username,email
+1,sir_mixalot,mixalot@google.com,
+2,sage_elliot,selliot@gmail.com,
+3,jhendrix,hendrix@outlook.com,
+4,dmatthews,dmatthews@google.com,
+5,quincy-jones,qjones@yahoo.com,
+6,KennyG,Kgorelick@hotmail.com,
+7,Jane Pine,janep@gmail.com,
+8,Jack Union,jacku@yahoo.com,
+9,Trey Smith,SmithT@gmail.com,
+10,Amelia Yesler,amelia@hotmail.com
-Original file line number
+Diff line change
@@ Expand Up / @@ -4,6 +4,7 @@ def index @@
       end
       def show
+        @product = Product.find(params[:id].to_i)
       end
       def edit
@@ Expand Down @@