3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# File 'lib/care/seed.rb', line 3
def self.execute
Dir[File.join(Rails.root, "db", "seeds", "*.json")].sort.each do |path|
table_name = path.split("/").last.gsub(".json", "").gsub(/^\d*_/, "")
puts "*** Преднаполнение таблицы #{table_name} ***"
items = ActiveSupport::JSON.decode(File.read(path))
table_name = table_name.gsub('dictionary_', 'dictionary/') || table_name
if (items_class = table_name.classify.safe_constantize)
items_class.import(items, on_duplicate_key_update: :all)
else
keys = items[0].keys
v_keys = keys.join(",")
values = items.map { |i| "(#{i.values.map { |v| "'#{v}'" }.join(",")})" }.join(",")
set_keys = keys.map{|k| "#{k} = excluded.#{k}"}.join(", ")
sql = "insert into #{table_name}(#{v_keys}) values #{values} on conflict (id) do update set #{set_keys}"
puts sql
ActiveRecord::Base.connection.execute sql
end
end
end
|