Skip to content

Instantly share code, notes, and snippets.

@jgomo3
Forked from seyhunak/seeds.rb
Created July 11, 2018 13:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jgomo3/b4b754a2c7794f55cf62738afa7fef47 to your computer and use it in GitHub Desktop.
Save jgomo3/b4b754a2c7794f55cf62738afa7fef47 to your computer and use it in GitHub Desktop.
Rails - Import SQL file as seed
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment