From 953a7e99079a45ba803652eee19227b96d0d4488 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 23 May 2018 23:40:30 -0700 Subject: fix release insert SQL --- rust/src/api_server.rs | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'rust') diff --git a/rust/src/api_server.rs b/rust/src/api_server.rs index 9bb7f155..3016b92b 100644 --- a/rust/src/api_server.rs +++ b/rust/src/api_server.rs @@ -632,13 +632,13 @@ impl Api for Server { }; let edit: ReleaseEditRow = diesel::sql_query( - "WITH rev AS ( INSERT INTO container_rev (title, release_type, doi, volume, pages, issue, work_ident_id) + "WITH rev AS ( INSERT INTO release_rev (title, release_type, doi, volume, pages, issue, work_ident_id) VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING id ), - ident AS ( INSERT INTO container_ident (rev_id) + ident AS ( INSERT INTO release_ident (rev_id) VALUES ((SELECT rev.id FROM rev)) RETURNING id ) - INSERT INTO container_edit (editgroup_id, ident_id, rev_id) VALUES + INSERT INTO release_edit (editgroup_id, ident_id, rev_id) VALUES ($8, (SELECT ident.id FROM ident), (SELECT rev.id FROM rev)) RETURNING *", ).bind::(body.title) -- cgit v1.2.3