require 'lib/file_db'

db = FileDb::Database.new("fixtures/data.json")

db.table_names
# => ["movies", "directors"]

movies = db.table("movies")
# => FileDb::Table

movies.select
# => [{ ... },{ ... }, ...] # tous les movies

movies.select(where: { id: 1 })
# => [{ id: 1, title: "The Gold Rush", year:1925, director_id:1 }]

movies.select(where: { director_id: 1 })
# => [{ id: 1, ..., director_id: 1 }, { id: 2, ..., director_id: 1 }, { id: 4, ..., director_id: 1 }, ]

table.insert({ title: "Birds", year: 1962, director_id: 2 })
# => { id: 7, title: "Birds", year: 1962, director_id: 2 } (id 7 est auto incrémenté)

table.update(where: { id: 7 }, values: { year: 1963 })
# => { id: 7, title: "Birds", year: 1963, director_id: 2 }

table.delete(where: { id: 7 })
# => { id: 7, title: "Birds", year: 1963, director_id: 2 }