Cacher is the code snippet organizer for pro developers

require 'sequel'

DB = Sequel.sqlite('app.sqlite3')

DB.drop_table?(:user)
DB.drop_table?(:exercise)

DB.create_table? :user do
  primary_key :id
  String :name
  Integer :age
end

DB.create_table? :exercise do
  primary_key :id
  INTEGER :number
  INTEGER :user_id
  INTEGER :score
end

users = DB[:user]
exercises = DB[:exercise]

users.insert(name: 'Pole', age: 23)
users.insert(name: 'Anna', age: 22)
users.insert(name: 'Mary', age: 19)
users.insert(name: 'Bob', age: 38)
users.insert(name: 'Taro', age: 33)
users.insert(name: 'Tom', age: 17)
users.insert(name: 'Sara', age: 44)
users.insert(name: 'Mike', age: 26)

exercises.insert(number: 1, user_id: 1, score: 100)
exercises.insert(number: 1, user_id: 2, score: 90)
exercises.insert(number: 1, user_id: 3, score: 50)
exercises.insert(number: 1, user_id: 4, score: 90)
exercises.insert(number: 1, user_id: 5, score: 80)
exercises.insert(number: 1, user_id: 6, score: 20)
exercises.insert(number: 1, user_id: 7, score: 20)
exercises.insert(number: 1, user_id: 8, score: 60)
exercises.insert(number: 2, user_id: 1, score: 90)
exercises.insert(number: 2, user_id: 2, score: 30)
exercises.insert(number: 2, user_id: 3, score: 100)
exercises.insert(number: 2, user_id: 4, score: 50)
exercises.insert(number: 2, user_id: 5, score: 10)
exercises.insert(number: 2, user_id: 6, score: 60)
exercises.insert(number: 2, user_id: 7, score: 80)
exercises.insert(number: 2, user_id: 8, score: 100)
exercises.insert(number: 3, user_id: 3, score: 50)
exercises.insert(number: 3, user_id: 1, score: 20)