add_to_db.exs

File.stream!("priv/repo/data/MCI_SECRET_prepaid/postpaid_Table.csv")
|> CSV.decode()
|> Enum.take(1)
|> Enum.map(fn row ->
  {:ok, [state, city, _, num]} = row

  changeset =
    Red9.MSID.changeset(
      %Red9.MSID{},
      %{
        is_prepaid: false,
        state:
          case state do
            "" ->
              "FLAT"

            state ->
              state
          end,
        city:
          case city do
            "" ->
              "FLAT"

            city ->
              city
          end,
        num: num
      }
    )

  if changeset.valid? == true do
    changeset |> Red9.Repo.insert()
  end
end)