person.sql.erb

-- erb -r ffaker -r date person.sql.erb
insert into person(first_name, last_name, sex, birth_date, weight, height, update_time) values
<% 10_000.times do |n| %><%= "," unless n==0 %>('<%= Faker::Name.first_name.gsub("'", "''") %>', '<%= Faker::Name.last_name.gsub("'", "''") %>', '<%= %w[male female].sample %>', '<%= Date.today - rand(10_000) %>', <%= 5 + rand(400) %>, <%= 20 + rand(60) %>, '<%= (Time.now - rand(1_000_000_000)).strftime("%Y-%m-%d %H:%M:%S") %>')
<% end %>;