-
Notifications
You must be signed in to change notification settings - Fork 2.3k
/
CompositeUniquenessConstraintAcceptanceTest.scala
70 lines (57 loc) · 2.66 KB
/
CompositeUniquenessConstraintAcceptanceTest.scala
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
/*
* Copyright (c) 2002-2018 "Neo4j,"
* Neo4j Sweden AB [http://neo4j.com]
*
* This file is part of Neo4j Enterprise Edition. The included source
* code can be redistributed and/or modified under the terms of the
* GNU AFFERO GENERAL PUBLIC LICENSE Version 3
* (http://www.fsf.org/licensing/licenses/agpl-3.0.html) with the
* Commons Clause, as found in the associated LICENSE.txt file.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* Neo4j object code can be licensed independently from the source
* under separate terms from the AGPL. Inquiries can be directed to:
* licensing@neo4j.com
*
* More information is also available at:
* https://neo4j.com/licensing/
*/
package org.neo4j.internal.cypher.acceptance
import org.neo4j.cypher._
import org.neo4j.internal.cypher.acceptance.CypherComparisonSupport.Versions.{Default, V3_4, v3_5}
import org.neo4j.internal.cypher.acceptance.CypherComparisonSupport._
class CompositeUniquenessConstraintAcceptanceTest extends ExecutionEngineFunSuite with CypherComparisonSupport {
test("should be able to create and remove single property uniqueness constraint") {
val testconfiguration = Configs.Procs
// When
executeWith(testconfiguration, "CREATE CONSTRAINT ON (n:Person) ASSERT (n.email) IS UNIQUE")
// Then
graph should haveConstraints("UNIQUENESS:Person(email)")
// When
executeWith(testconfiguration, "DROP CONSTRAINT ON (n:Person) ASSERT (n.email) IS UNIQUE")
// Then
graph should not(haveConstraints("UNIQUENESS:Person(email)"))
}
val singlePropertyUniquenessFailConf =
TestConfiguration(Versions(v3_5, V3_4, Default), Planners(Planners.Default, Planners.Cost), Runtimes.all)
test("should fail to to create composite uniqueness constraints") {
// When
failWithError(singlePropertyUniquenessFailConf + Configs.Morsel,
"CREATE CONSTRAINT ON (n:Person) ASSERT (n.firstname,n.lastname) IS UNIQUE",
List("Only single property uniqueness constraints are supported"))
// Then
graph should not(haveConstraints("UNIQUENESS:Person(firstname,lastname)"))
}
test("should fail to to drop composite uniqueness constraints") {
// When
failWithError(singlePropertyUniquenessFailConf + Configs.Morsel + Configs.Procs,
"DROP CONSTRAINT ON (n:Person) ASSERT (n.firstname,n.lastname) IS UNIQUE",
List("Only single property uniqueness constraints are supported"))
// Then
graph should not(haveConstraints("UNIQUENESS:Person(firstname,lastname)"))
}
}