sergio
How to execute .sql file script in Phoenix?
I executed a pg dump of my existing database to get it’s schema. I would like to run this .sql script against whatever Postgresql database defined in my test.exs file.
How can I do that with Phoenix and Ecto?
Marked As Solved
kip
You can create a migration to run your .sql file as long as the database exists. Something like:
Create your migration:
iex> mix ecto.gen.migration my_database_structure_migration
Then edit the migration in priv/repo/migrations/2017xxxxxxxxxxx_my_database_structure_migration.exs to be something like the following:
defmodule My.Database.Structure.Migration do
use Ecto.Migration
def up do
execute File.read!("/path/to/sql_dump.sql")
end
def down do
end
end
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Develop your skills with books, videos, and courses.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #javascript
- #code-sync
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"