aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--dbstore/sql/feed/insert-assigner.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/dbstore/sql/feed/insert-assigner.sql b/dbstore/sql/feed/insert-assigner.sql
new file mode 100644
index 0000000..c21f51d
--- /dev/null
+++ b/dbstore/sql/feed/insert-assigner.sql
@@ -0,0 +1,13 @@
+-- add assigner, unless they are already in the database
+--
+-- NOTE: might be able to do this more gracefully with an UPSERT in
+-- sqlite?
+INSERT INTO assigners(assigner)
+ SELECT :assigner
+
+ EXCEPT
+
+ -- exclude existing assigners
+ SELECT assigner
+ FROM assigners
+ WHERE assigner = :assigner;