From baee9be0edae229e46a3b8f438b7b4a3022a84f3 Mon Sep 17 00:00:00 2001 From: neodarz Date: Thu, 9 Feb 2017 14:12:24 +0100 Subject: Fix error when the table is empty --- web/controllers/audio_file_controller.ex | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) diff --git a/web/controllers/audio_file_controller.ex b/web/controllers/audio_file_controller.ex index 42aa7e7..ef9d46c 100644 --- a/web/controllers/audio_file_controller.ex +++ b/web/controllers/audio_file_controller.ex @@ -15,13 +15,9 @@ defmodule TheTranscriberBackend.AudioFileController do def create(conn, %{"audio_file" => %{"audio_duration" => audio_duration, "audio_path" => upload, "audio_name" => audio_name}}) do - repo_last_id = Repo.one(from x in AudioFile, order_by: [desc: x.id], limit: 1) - - #query = "select nextval('audio_file_id_seq')" - - #result = Ecto.Adapters.SQL.query!(Repo, query, []) - - #[[repo_last_id]] = result.rows # A beautiful pattern match :) + query = "select nextval('audio_file_id_seq')" + result = Ecto.Adapters.SQL.query!(Repo, query, []) + [[repo_last_id]] = result.rows # A beautiful pattern match :) path = "/media/phoenix_test/#{repo_last_id}_#{upload.filename}" File.cp(upload.path, path) -- cgit v1.2.1