Skip to content

Latest commit

 

History

History
9 lines (6 loc) · 600 Bytes

README.md

File metadata and controls

9 lines (6 loc) · 600 Bytes

Generating SQL

Okay, typing out SQL is really tedious. Let's do better.

  • Connect to the provided db.sqlite3 database. How many users are in the users table?
  • What is the SQL command to add a new user to the database? Add yourself using the sqlite console.
  • We have a list of new users to add to the database in new_users.csv. Look at script.rb and finish it so that it inserts the users from the file. How many users are there after running the script?

N.B.: under normal circumstances, it's a bad idea to check your database file in to git. Please don't take this as an example.