ChfFqHnW0AA_tqk.jpg600×600 63.1 KB

https://twitter.com/chris_mccord/status/727267197798744064

  def get_available_internal_users do
    user_coll = from(u in User, 
                     select: {u.name, u.role, u.id},
                     where:  u.role != "Client") |> Repo.all

    for {name, role, id} <- user_coll, into: %{}, do: {{name, role}, id}
  end  

Just wrote this function to get all users from my project’s DB which do not have the role of ‘Client’ and put their name, role and id into a map.

Such nice, concise and readable code.

First I was doing a lot of List.first/1 and List.last/1 and Tuple.to_list/1 to get the values into the map. Then it came to me “why not just pattern match the tuple and use the matches to get them into the Map?” and boom… that code came to fruition

Honestly can’t think of any other language that would allow me to query a SQL DB, parse the data and make it all so readable and short. There isn’t a need to write comments really, it reads by itself.

Via @rvirding