More than 5 years have passed since last update.

直接SQLでconfig指定以外のDBアクセスをする

Elixir

Last updated at 2018-05-20Posted at 2018-01-25

config/*.exsに指定する接続先DB以外のDBも、普通にselectできる

	def a(), do: "select * from a.users" |> query
	def b(), do: "select * from b.users" |> query
	def query( sql ) when sql != "" do
		{ :ok, result } = Ecto.Adapters.SQL.query( Livery.Repo, sql, [] )
		result
	end

なので、こんな感じでDB指定する関数化もできる

	def users( db ), do: "select * from #{ db }.users" |> query
	def query( sql ) when sql != "" do
		{ :ok, result } = Ecto.Adapters.SQL.query( Livery.Repo, sql, [] )
		result
	end

これとマルチプロセスやFlowをうまく組み合わせると、簡単な並行DBアクセスくらいは作れそう

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up