From e748d11bfd2232b77aeb5dae0d1e76ebb2988afb Mon Sep 17 00:00:00 2001
From: neodarz <neodarz@neodarz.net>
Date: Thu, 9 Feb 2017 14:07:40 +0100
Subject: Update the column name transcrib_file to audio_name

---
 web/controllers/audio_file_controller.ex | 23 ++++++++++++++++-------
 1 file changed, 16 insertions(+), 7 deletions(-)

(limited to 'web/controllers/audio_file_controller.ex')

diff --git a/web/controllers/audio_file_controller.ex b/web/controllers/audio_file_controller.ex
index 1c2acb9..42aa7e7 100644
--- a/web/controllers/audio_file_controller.ex
+++ b/web/controllers/audio_file_controller.ex
@@ -13,14 +13,22 @@ defmodule TheTranscriberBackend.AudioFileController do
     render(conn, "new.html", changeset: changeset)
   end
 
-  def create(conn, %{"audio_file" => %{"audio_duration" => audio_duration, "audio_path" => upload, "transcription_file_path" => transcription_file_path}}) do
+  def create(conn, %{"audio_file" => %{"audio_duration" => audio_duration, "audio_path" => upload, "audio_name" => audio_name}}) do
 
-    path = "/media/phoenix_test/#{upload.filename}"
+    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 :)
+
+    path = "/media/phoenix_test/#{repo_last_id}_#{upload.filename}"
     File.cp(upload.path, path)
 
     changeset = AudioFile.changeset(%AudioFile{},
       %{audio_path: path,
-        transcription_file_path: transcription_file_path,
+        audio_name: audio_name,
         audio_duration: audio_duration})
 
     case Repo.insert(changeset) do
@@ -35,7 +43,7 @@ defmodule TheTranscriberBackend.AudioFileController do
 
 
 
-#  def create(conn, %{"audio_file" => %{"audio_duration" => audio_duration, "transcription_file_path" => transcription_file_path}}) do
+#  def create(conn, %{"audio_file" => %{"audio_duration" => audio_duration, "audio_name" => audio_name}}) do
 #
 #    ## Do something here if no file has been uploaded
 #  end
@@ -51,9 +59,10 @@ defmodule TheTranscriberBackend.AudioFileController do
     render(conn, "edit.html", audio_file: audio_file, changeset: changeset)
   end
 
-  def update(conn, %{"id" => id, "audio_file" => %{"audio_duration" => audio_duration, "audio_path" => upload, "transcription_file_path" => transcription_file_path}}) do
+  def update(conn, %{"id" => id, "audio_file" => %{"audio_duration" => audio_duration, "audio_path" => upload, "audio_name" => audio_name}}) do
+
+    path = "/media/phoenix_test/#{id}_#{upload.filename}"
 
-    path = "/media/phoenix_test/#{upload.filename}"
     File.cp(upload.path, path)
 
     audio_file = Repo.get!(AudioFile, id)
@@ -61,7 +70,7 @@ defmodule TheTranscriberBackend.AudioFileController do
 
     changeset = AudioFile.changeset(audio_file,
       %{audio_path: path,
-        transcription_file_path: transcription_file_path,
+        audio_name: audio_name,
         audio_duration: audio_duration})
 
     case Repo.update(changeset) do
-- 
cgit v1.2.1