Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------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 ',';
Add Comment
Please, Sign In to add comment