Pattern

    <p :if={@pattern_row_clicked}>Row clicked: {@pattern_row_clicked}</p>
<p :if={is_nil(@pattern_row_clicked)}>Click a row (not the action button).</p>
<.data_table
  class="data-table max-w-none"
  rows={@pattern_row_click_rows}
  row_click={fn row -> JS.push("row_click", value: %{id: row.id, name: row.name}) end}
>
  <:col :let={row} label="ID">{row.id}</:col>
  <:col :let={row} label="Name">{row.name}</:col>
  <:action :let={row}>
    <.action class="button ui-size-sm ui-trigger--square" aria-label={"Edit #{row.name}"}>
      <.heroicon name="hero-pencil-square" />
    </.action>
  </:action>
</.data_table>

  

    @pattern_row_click_rows [
  %{id: 1, name: "Alice", role: "Admin", email: "alice@example.com"},
  %{id: 2, name: "Bob", role: "User", email: "bob@example.com"}
]

def mount(_params, _session, socket) do
  {:ok,
   socket
   |> assign(:pattern_row_clicked, nil)
   |> assign(:pattern_row_click_rows, @pattern_row_click_rows)}
end

def handle_event("row_click", %{"id" => id, "name" => name}, socket) do
  {:noreply, assign(socket, :pattern_row_clicked, "#{name} (##{id})")}
end

  

    <.data_table class="data-table max-w-none" rows={@streams.pattern_stream}>
  <:col :let={{_id, row}} label="ID">{row.id}</:col>
  <:col :let={{_id, row}} label="Name">{row.name}</:col>
  <:col :let={{_id, row}} label="Category">{row.category}</:col>
  <:empty>
    <p>No items</p>
  </:empty>
  <:action :let={{dom_id, row}}>
    <.action
      phx-click="pattern_stream_delete"
      phx-value-dom_id={dom_id}
      class="button ui-size-sm ui-alert"
      aria-label={"Delete #{row.name}"}
    >
      <.heroicon name="hero-trash" />
    </.action>
  </:action>
</.data_table>

  

    @stream_items [
  %{id: "1", name: "Apple", category: "Fruit"},
  %{id: "2", name: "Banana", category: "Fruit"}
]

def mount(_params, _session, socket) do
  {:ok,
   socket
   |> stream(:pattern_stream, @stream_items)
   |> assign(:pattern_stream_next_id, 3)}
end

def handle_event("pattern_stream_add", _params, socket) do
  id = to_string(socket.assigns.pattern_stream_next_id)
  item = %{id: id, name: "New", category: "Misc"}
  {:noreply,
   socket
   |> stream_insert(:pattern_stream, item)
   |> assign(:pattern_stream_next_id, socket.assigns.pattern_stream_next_id + 1)}
end

def handle_event("pattern_stream_delete", %{"dom_id" => dom_id}, socket) do
  {:noreply, stream_delete_by_dom_id(socket, :pattern_stream, dom_id)}
end

  

    <.data_table
  id="pattern-sort-table"
  class="data-table max-w-none"
  rows={@pattern_sort_rows}
  sort_by={@sort_by}
  sort_order={@sort_order}
  on_sort="pattern_sort"
>
  <:sort_icon :let={%{direction: direction}}>
    <.heroicon name={
      case direction do
        :asc -> "hero-chevron-up"
        :desc -> "hero-chevron-down"
        :none -> "hero-chevron-up-down"
      end
    } />
  </:sort_icon>
  <:col :let={row} label="ID" name={:id}>{row.id}</:col>
  <:col :let={row} label="Name" name={:name}>{row.name}</:col>
  <:col :let={row} label="Email" name={:email}>{row.email}</:col>
  <:col :let={row} label="Role" name={:role}>{row.role}</:col>
  <:col :let={row} label="Status" name={:status}>{row.status}</:col>
</.data_table>

  

    @pattern_users [
  %{id: 1, name: "Alice", email: "alice@example.com", role: "Admin", status: "Active"},
  %{id: 2, name: "Bob", email: "bob@example.com", role: "User", status: "Inactive"},
  %{id: 3, name: "Charlie", email: "charlie@example.com", role: "User", status: "Active"},
  %{id: 4, name: "Diana", email: "diana@example.com", role: "Manager", status: "Active"},
  %{id: 5, name: "Eve", email: "eve@example.com", role: "Admin", status: "Inactive"}
]

@pattern_sort_columns [:id, :name, :email, :role, :status]

def mount(_params, _session, socket) do
  {:ok,
   socket
   |> assign(:pattern_sort_rows, @pattern_users)
   |> Corex.DataTable.Sort.assign_for_sort(:pattern_sort_rows,
     default_sort_by: :id,
     default_sort_order: :asc,
     sort_columns: @pattern_sort_columns
   )}
end

def handle_event("pattern_sort", params, socket) do
  {:noreply, Corex.DataTable.Sort.handle_sort(socket, params, :pattern_sort_rows)}
end

  

    <.data_table
  id="pattern-select-table"
  class="data-table max-w-none"
  rows={@pattern_select_rows}
  row_id={&"pselect-#{&1.id}"}
  selectable
  selected={@selected}
  on_select="pattern_select"
  on_select_all="pattern_select_all"
  checkbox_class="checkbox"
>
  <:checkbox_indicator>
    <.heroicon name="hero-check" />
  </:checkbox_indicator>
  <:col :let={row} label="ID" name={:id}>{row.id}</:col>
  <:col :let={row} label="Name" name={:name}>{row.name}</:col>
  <:col :let={row} label="Email" name={:email}>{row.email}</:col>
  <:col :let={row} label="Role" name={:role}>{row.role}</:col>
  <:col :let={row} label="Status" name={:status}>{row.status}</:col>
</.data_table>

  

    @pattern_users [
  %{id: 1, name: "Alice", email: "alice@example.com", role: "Admin", status: "Active"},
  %{id: 2, name: "Bob", email: "bob@example.com", role: "User", status: "Inactive"},
  %{id: 3, name: "Charlie", email: "charlie@example.com", role: "User", status: "Active"},
  %{id: 4, name: "Diana", email: "diana@example.com", role: "Manager", status: "Active"},
  %{id: 5, name: "Eve", email: "eve@example.com", role: "Admin", status: "Inactive"}
]

def mount(_params, _session, socket) do
  {:ok,
   socket
   |> assign(:pattern_select_rows, @pattern_users)
   |> Corex.DataTable.Selection.assign_for_selection(:pattern_select_rows,
     table_id: "pattern-select-table",
     row_id: &"pselect-#{&1.id}"
   )}
end

def handle_event("pattern_select", params, socket) do
  {:noreply, Corex.DataTable.Selection.handle_select(socket, params, :pattern_select_rows)}
end

def handle_event("pattern_select_all", params, socket) do
  {:noreply, Corex.DataTable.Selection.handle_select_all(socket, params, :pattern_select_rows)}
end

  

    <.data_table
  id="pattern-full-table"
  class="data-table max-w-none"
  rows={@pattern_full_rows}
  row_id={&"pfull-#{&1.id}"}
  sort_by={@sort_by}
  sort_order={@sort_order}
  on_sort="pattern_full_sort"
  selectable
  selected={@selected}
  on_select="pattern_full_select"
  on_select_all="pattern_full_select_all"
  checkbox_class="checkbox"
>
  <:checkbox_indicator>
    <.heroicon name="hero-check" />
  </:checkbox_indicator>
  <:sort_icon :let={%{direction: direction}}>
    <.heroicon name={
      case direction do
        :asc -> "hero-chevron-up"
        :desc -> "hero-chevron-down"
        :none -> "hero-chevron-up-down"
      end
    } />
  </:sort_icon>
  <:col :let={row} label="ID" name={:id}>{row.id}</:col>
  <:col :let={row} label="Name" name={:name}>{row.name}</:col>
  <:col :let={row} label="Email" name={:email}>{row.email}</:col>
  <:col :let={row} label="Role" name={:role}>{row.role}</:col>
  <:col :let={row} label="Status" name={:status}>{row.status}</:col>
  <:action :let={row}>
    <.action class="button ui-size-sm ui-trigger--square" aria-label={"Edit #{row.name}"}>
      <.heroicon name="hero-pencil-square" />
    </.action>
  </:action>
  <:empty>
    <p>No rows</p>
  </:empty>
</.data_table>

  

    @pattern_users [
  %{id: 1, name: "Alice", email: "alice@example.com", role: "Admin", status: "Active"},
  %{id: 2, name: "Bob", email: "bob@example.com", role: "User", status: "Inactive"},
  %{id: 3, name: "Charlie", email: "charlie@example.com", role: "User", status: "Active"},
  %{id: 4, name: "Diana", email: "diana@example.com", role: "Manager", status: "Active"},
  %{id: 5, name: "Eve", email: "eve@example.com", role: "Admin", status: "Inactive"}
]

@pattern_sort_columns [:id, :name, :email, :role, :status]

def mount(_params, _session, socket) do
  {:ok,
   socket
   |> assign(:pattern_full_rows, @pattern_users)
   |> Corex.DataTable.Sort.assign_for_sort(:pattern_full_rows,
     default_sort_by: :id,
     default_sort_order: :asc,
     sort_columns: @pattern_sort_columns
   )
   |> Corex.DataTable.Selection.assign_for_selection(:pattern_full_rows,
     table_id: "pattern-full-table",
     row_id: &"pfull-#{&1.id}"
   )}
end

def handle_event("pattern_full_sort", params, socket) do
  {:noreply, Corex.DataTable.Sort.handle_sort(socket, params, :pattern_full_rows)}
end

def handle_event("pattern_full_select", params, socket) do
  {:noreply, Corex.DataTable.Selection.handle_select(socket, params, :pattern_full_rows)}
end

def handle_event("pattern_full_select_all", params, socket) do
  {:noreply, Corex.DataTable.Selection.handle_select_all(socket, params, :pattern_full_rows)}
end

  

    <.data_table
  class="data-table max-w-none"
  rows={@pattern_db_rows}
  row_id={&"db-#{&1.id}"}
  sort_by={@pattern_db_sort_by}
  sort_order={@pattern_db_sort_order}
  on_sort="pattern_db_sort"
>
  <:sort_icon :let={%{direction: direction}}>
    <.heroicon name={sort_icon_name(direction)} />
  </:sort_icon>
  <:col :let={city} label="Name" name={:name}>{city.name}</:col>
  <:col :let={city} label="IATA" name={:iata_code}>{city.iata_code}</:col>
  <:col :let={city} label="Country" name={:iata_country_code}>{city.iata_country_code}</:col>
</.data_table>

<.pagination
  class="pagination max-w-none mx-auto"
  count={@pattern_db_total}
  page={@pattern_db_page}
  page_size={@pattern_db_page_size}
  controlled
  on_page_change="pattern_db_page"
>
  <:prev_trigger><.heroicon name="hero-chevron-left" /></:prev_trigger>
  <:next_trigger><.heroicon name="hero-chevron-right" /></:next_trigger>
</.pagination>

  

    def mount(_params, _session, socket) do
  {rows, total} =
    MyApp.Place.list_cities_table(page: 1, page_size: 5, order_by: :name, order_dir: :asc)

  {:ok,
   socket
   |> assign(:pattern_db_rows, rows)
   |> assign(:pattern_db_page, 1)
   |> assign(:pattern_db_page_size, 5)
   |> assign(:pattern_db_sort_columns, [:name, :iata_code, :iata_country_code])
   |> assign(:pattern_db_sort_by, :name)
   |> assign(:pattern_db_sort_order, :asc)
   |> assign(:pattern_db_total, total)}
end

def handle_event("pattern_db_sort", %{"sort_by" => sort_by_param}, socket) do
  case Corex.DataTable.Sort.parse_sort_by(sort_by_param, socket.assigns.pattern_db_sort_columns) do
    {:ok, sort_by} ->
      order =
        if socket.assigns.pattern_db_sort_by == sort_by,
          do: toggle(socket.assigns.pattern_db_sort_order),
          else: :asc

      {rows, total} =
        MyApp.Place.list_cities_table(
          page: 1,
          page_size: socket.assigns.pattern_db_page_size,
          order_by: sort_by,
          order_dir: order
        )

      {:noreply,
       socket
       |> assign(:pattern_db_rows, rows)
       |> assign(:pattern_db_page, 1)
       |> assign(:pattern_db_sort_by, sort_by)
       |> assign(:pattern_db_sort_order, order)
       |> assign(:pattern_db_total, total)}

    :error ->
      {:noreply, socket}
  end
end

def handle_event("pattern_db_page", %{"page" => page}, socket) do
  page = String.to_integer(page)

  {rows, total} =
    MyApp.Place.list_cities_table(
      page: page,
      page_size: socket.assigns.pattern_db_page_size,
      order_by: socket.assigns.pattern_db_sort_by,
      order_dir: socket.assigns.pattern_db_sort_order
    )

  {:noreply,
   socket
   |> assign(:pattern_db_rows, rows)
   |> assign(:pattern_db_page, page)
   |> assign(:pattern_db_total, total)}
end

  

    defmodule MyApp.Repo.Migrations.CreateCities do
  use Ecto.Migration

  def change do
    create table(:cities, primary_key: false) do
      add :id, :string, primary_key: true
      add :iata_code, :string
      add :iata_country_code, :string
      add :name, :string
      add :airports, :jsonb, default: "[]"
    end
  end
end

defmodule MyApp.Repo.Migrations.CreateAirports do
  use Ecto.Migration

  def change do
    create table(:airports, primary_key: false) do
      add :id, :string, primary_key: true
      add :name, :string
      add :iata_code, :string
      add :city_name, :string
      add :iata_city_code, :string
      add :iata_country_code, :string
      add :icao_code, :string
      add :latitude, :float
      add :longitude, :float
      add :time_zone, :string
      add :city, :jsonb
    end
  end
end


defmodule MyApp.Place.City do
  use Ecto.Schema
  import Ecto.Changeset

  @primary_key {:id, :string, autogenerate: false}

  schema "cities" do
    field :name, :string
    field :iata_code, :string
    field :iata_country_code, :string
  end

  def changeset(city, attrs) do
    city
    |> cast(attrs, [:id, :name, :iata_code, :iata_country_code])
    |> validate_required([:name, :iata_code, :iata_country_code])
  end
end


defmodule MyApp.Place do
  import Ecto.Query, warn: false
  alias MyApp.Repo
  alias MyApp.Place.City

  @sortable [:name, :iata_code, :iata_country_code]

  def list_cities_table(opts \\ []) do
    page = Keyword.get(opts, :page, 1)
    page_size = Keyword.get(opts, :page_size, 5)
    order_by = Keyword.get(opts, :order_by, :name)
    order_dir = Keyword.get(opts, :order_dir, :asc)

    order_by = if order_by in @sortable, do: order_by, else: :name
    order_dir = if order_dir in [:asc, :desc], do: order_dir, else: :asc

    ordered = from(c in City, order_by: [{^order_dir, field(c, ^order_by)}])
    total_count = Repo.aggregate(ordered, :count)
    offset = max(page - 1, 0) * page_size

    rows =
      ordered
      |> limit(^page_size)
      |> offset(^offset)
      |> Repo.all()

    {rows, total_count}
  end
end


alias MyApp.Place

for {id, name, code, country} <- [
      {"par", "Paris", "PAR", "FR"},
      {"lon", "London", "LON", "GB"},
      {"ber", "Berlin", "BER", "DE"},
      {"mad", "Madrid", "MAD", "ES"},
      {"rom", "Rome", "ROM", "IT"},
      {"ams", "Amsterdam", "AMS", "NL"},
      {"vie", "Vienna", "VIE", "AT"},
      {"lis", "Lisbon", "LIS", "PT"},
      {"dub", "Dublin", "DUB", "IE"},
      {"bru", "Brussels", "BRU", "BE"},
      {"zrh", "Zurich", "ZRH", "CH"},
      {"osl", "Oslo", "OSL", "NO"},
      {"cph", "Copenhagen", "CPH", "DK"},
      {"ath", "Athens", "ATH", "GR"}
    ] do
  Place.create_city(%{
    id: id,
    name: name,
    iata_code: code,
    iata_country_code: country
  })
end