-- 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;