abadongutierrez

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

abadongutierrez

SELECT department_id, name FROM department

abadongutierrez

Repo.all(from d in "department")

abadongutierrez

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

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.update_all(from(e in "employee",
                where: e.first_name == "Steve"),
                set: [department_id: 2])

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.delete_all(from e in "employee",
                where: e.last_name == "Wayne")

abadongutierrez

Repo.all(from e in "employee",
         select: [e.employee_id, e.first_name, e.last_name])

abadongutierrez

defmodule Ecto101MigrationsSchemas.Repo.Migrations.DepartmentTable do
  use Ecto.Migration

  def change do
    create table(:department) do
      add :name, :text, null: false

      timestamps()
    end
  end