generate some mock data

gistfile1.txt

--------r u b y


require 'csv'
require 'faker'

CSV.open("./users.csv", 'a+', write_headers: false) do |csv|
  50_000.times do |n|
    csv << [n, Faker::FunnyName.two_word_name, Faker::Internet.email, Faker::Address.city]
  end
end


--------s q l


CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(60),
  email VARCHAR(120),
  city VARCHAR(60)
);

COPY users (
  id,
  name,
  email,
  city
)
FROM './users.csv'
DELIMITER ',';