Cody Fitzpatrick CodyFitzpatrick
🖥️
CodyFitzpatrick
/ seeds_with_sql_import.rb
Last active
November 14, 2022 11:17
Ruby on Rails - Import Data via SQL in seeds.rb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Creation of other records in Ruby above ... | |
| connection = ActiveRecord::Base.connection | |
| sql = File.read('db/import.sql') # Change path and filename as necessary | |
| statements = sql.split(/;$/) | |
| statements.pop | |
| ActiveRecord::Base.transaction do | |
| statements.each do |statement| |