View source for How to Create Database Seed Data in Elixir Phoenix

{{In progress}}

'''Before you Begin'''
{{Phoenix-Installation-Required}}

==Getting Started==
This article demonstrates how to seed PostgreSQL table data in Elixir Phoenix. Seed data is useful when experimenting with Elixir database commands. To begin, you must first create a basic phoenix application.


Select a directory to create you app:
Run the command <source>mix phx.new app</source>

The command line prompts you to install dependencies. Select Y for yes.

== Create a Database ==

To create a database you run the mix ecto.create command. Before you execute the command, your Phoenix app needs to be configured to communicate with your database. The default database that Phoenix uses is PostgreSQL. 

The following code in <pre> app/config/dev.exs </pre> contains the basic configuration values needed to interact with the database. The database field contains the name of the database and if it doesn't exist Phoenix will create it.

<source>

config :app, App.Repo,
  username: "postgres",
  password: "postgres",
  hostname: "localhost",
  database: "app_dev",

</source>

To create the database run this:

<source>
mix ecto.create
</source>

When the command is done executing you can create a table using the following code:


<source>

mix phx.gen.context Todos Todo todos title:string done:boolean

</source>

When complete you are prompted to run mix.ecto.migrate. Do that now.

<source>
mix ecto.migrate
</source>