adipurnama

adipurnama

Phoenix - Seeding database from json file

I’m trying to seed data to phoenix database using json file.
Let’s say I have at priv/repo/seeds/some_file.json in my phoenix directory.

# priv/repo/seeds.exs
json_file = "#{__DIR__}/seeds/some_file.json"

with {:ok, body} <- File.read(json_file),
     {:ok, json} <- Jason.decode(body, keys: :atom) do
  # insert to db
else
  err ->
      IO.inspect(err)
end

But i got the following error when running the script :

(UndefinedFunctionError) function Jason.decode/2 is undefined (module Jason is not available)

I can see Jason dependency in my mix.exs file but it doesn’t seem to be working inside priv/repo/seeds.exs file. Or is there any other way / common patterns to seed phoenix app database from external file (json/csv) ?

Marked As Solved

axelson

axelson

Scenic Core Team

How are executing the seeds file? Is it with mix run priv/repo/seeds.exs?

Also Liked

adipurnama

adipurnama

@axelson Actually yes, this is definitely the issue on my case.
Silly me, I was previously using elixir ./priv/repo/seeds.exs.

Thank you.

axelson

axelson

Scenic Core Team

Yup, that would do it! Glad you got it resolved :slight_smile:

Last Post!

axelson

axelson

Scenic Core Team

Yup, that would do it! Glad you got it resolved :slight_smile:

Where Next?

Popular in Questions Top

rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list. ...
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
jerry
Good day to you all. I have been struggling to get a query involving like and ilike to work. Can anyone assist me on this, please? pro...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New

Other popular topics Top

Qqwy
Update: How to use the Blogs &amp; Podcasts section You can post links to your blog posts or podcasts either in one of the Official Blog...
3271 130286 1222
New
vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
grych
Hi folks, Few months ago I have announced the proof-of-concept of the library to manipulate the browsers DOM objects directly from Elixi...
639 54006 488
New
jononomo
I am trying to figure out how Mix knows whether the environment is test, dev, or prod – where is this set? Thanks.
New
nsuchy
Hi. I’ve noticed that Windows Powershell has it’s own IEX command and you cannot access Elixir’s IEX due to the conflict. This isn’t a cr...
New
gshaw
What is the idiomatic way of matching for not nil in Elixir? E.g., First way: defp halt_if_not_signed_in(conn, signed_in_account) when...
New

We're in Beta

About us Mission Statement