Packages

ami

0.2.6
0.3.9 0.3.8 retired 0.3.7 retired 0.3.6 retired 0.3.5 retired 0.3.4 retired 0.3.3 retired 0.3.2 retired 0.3.1 retired 0.3.0 retired 0.2.9 retired 0.2.8 retired 0.2.7 retired 0.2.6 retired 0.2.5 retired 0.2.3 retired 0.2.2 retired 0.2.1 retired 0.2.0 retired 0.1.9 retired 0.1.8 retired 0.1.7 retired 0.1.6 retired 0.1.5 retired 0.1.4 retired

Package containing all AMI Models shared between micro-services.

Retired package: Security issue - retiring
HexDocs

Current section

Files

Jump to
Readme
25 Versions
14 Dependencies
Dependants
Files
Activity
ami lib ami city.ex
Raw

lib/ami/city.ex 

defmodule Ami.City do

  use Ecto.Schema



  import Ecto.Query



  alias Ami.{

    Repo,

    Country,

    Profile,

    User

  }



  schema "cities" do

    field(:name, :string)

    field(:iso, :string)



    belongs_to(:country, Country)

    has_many(:profiles, Profile)

  end



  def search_by_name(query) do

    from(c in __MODULE__, where: ilike(c.name, ^"%#{query}%"))

    |> Repo.all()

  end



  def for_select_field() do

    from(

      c in __MODULE__, 

      order_by: [asc: c.name],

      select: [:id, :name]

    )

    |> Repo.all()

  end

end