Guest User

Untitled

a guest
Apr 21st, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. --------r u b y
  2.  
  3.  
  4. require 'csv'
  5. require 'faker'
  6.  
  7. CSV.open("./users.csv", 'a+', write_headers: false) do |csv|
  8. 50_000.times do |n|
  9. csv << [n, Faker::FunnyName.two_word_name, Faker::Internet.email, Faker::Address.city]
  10. end
  11. end
  12.  
  13.  
  14. --------s q l
  15.  
  16.  
  17. CREATE TABLE users (
  18. id INT PRIMARY KEY,
  19. name VARCHAR(60),
  20. email VARCHAR(120),
  21. city VARCHAR(60)
  22. );
  23.  
  24. COPY users (
  25. id,
  26. name,
  27. email,
  28. city
  29. )
  30. FROM './users.csv'
  31. DELIMITER ',';
Add Comment
Please, Sign In to add comment