abadongutierrez

Repo.delete_all(from e in "employee",
                where: e.last_name == "Wayne")

abadongutierrez

Repo.all(from e in "employee",
         join: d in "department", on: e.department_id == d.department_id,
         where: d.department_id == 2,
         select: [e.first_name, e.last_name, d.name])

abadongutierrez

Repo.update_all(from(e in "employee",
                where: e.first_name == "Steve"),
                set: [department_id: 2])

abadongutierrez

Repo.insert_all("employee", [[first_name: "Steve", last_name: "Jobs", hire_date: {1976, 1, 4}, department_id: 1]])

Repo.insert_all("employee", [[first_name: "Steve", last_name: "Wozniak", hire_date: {1976, 1, 4}, department_id: 1]])

Repo.insert_all("employee", [[first_name: "Ronald", last_name: "Wayne", hire_date: {1976, 1, 4}, department_id: 1]])

Repo.insert_all("department", [[name: "R&D"]])

abadongutierrez

Repo.insert_all("department", [[name: "Human Resources"]])

abadongutierrez

Repo.all(from d in "department")

abadongutierrez

SELECT department_id, name FROM department

abadongutierrez

Repo.all(from d in "department", select: [d.department_id, d.name])

abadongutierrez

alias EctoTest.Repo

import Ecto.Query

Repo.all(from d in "department", select: [d.department_id, d.name])

abadongutierrez

iex -S mix