jgomo3 · July 11, 2018 13:34 · Dec 7, 2013
diff --git a/seeds.rb b/seeds.rb
@@ -0,0 +1,16 @@
+unless Rails.env.production?
+  connection = ActiveRecord::Base.connection
+  connection.tables.each do |table|
+    connection.execute("TRUNCATE #{table}") unless table == "schema_migrations"
+  end
+
+  sql = File.read('db/import.sql')
+  statements = sql.split(/;$/)
+  statements.pop
+
+  ActiveRecord::Base.transaction do
+    statements.each do |statement|
+      connection.execute(statement)
+    end
+  end
+end