neo4j-clj.joplin.migration-file.clj

(ns myproject.neo4j.migrations.20171024T112338Z-unique-org-unit-id
  (:require [joplin.neo4j.database :refer [with-connection]]
            [neo4j-clj.core :refer [defquery]]))

(defquery create-org-unit-id-exists-constraint
  "CREATE CONSTRAINT ON (u:OrgUnit) ASSERT exists(u.id)")

(defquery drop-org-unit-id-exists-constraint
  "DROP CONSTRAINT ON (u:OrgUnit) ASSERT exists(u.id)")

(defquery create-unique-org-unit-id-constraint
  "CREATE CONSTRAINT ON (u:OrgUnit) ASSERT u.id IS UNIQUE")

(defquery drop-unique-org-unit-id-constraint
  "DROP CONSTRAINT ON (u:OrgUnit)  u.id IS UNIQUE")

(defn up [db]
  (with-connection db session
    (create-org-unit-id-exists-constraint session)
    (create-unique-org-unit-id-constraint session)))

(defn down [db]
  (with-connection db session
    (drop-org-unit-id-exists-constraint session)
    (drop-unique-org-unit-id-constraint session)))