Export local db to JSON

gistfile1.rb

Rails.application.eager_load!
exclude_tables = ["sessions"]
row_limit_per_table = nil
tables = []
ApplicationRecord.descendants.each do |model|
  next if exclude_tables.any?{ |skip_table| skip_table == model.table_name }
  next if tables.include?(model.table_name) # This covers STI

  puts "Exporting: #{model.table_name}"
  
  filename = File.join(Rails.root, "db", "export", "#{model.table_name}.json")
  file = File.open(filename, 'w')
  file.write "["

  find_each_opts = {}
  find_each_opts[:finish] = row_limit_per_table if row_limit_per_table.present?
  model.find_each(find_each_opts) do |obj|  
    file.write obj.attributes.to_json 
    file.write ","
  end

  tables << model.table_name
  
  file.write "]"
  file.close

  `sed -i.bak 's/\,\]/\]/' #{filename}`
end

`rm db/export/*.bak`

What version of rails?

6.1

That's probably it. I wrote the above on 5.x. We're in the process of migrating our app to 6.x, but can't help until that's complete. Let me know if you find the cause!