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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
// Copyright (c) Microsoft Open Technologies, Inc. All rights reserved. See License.txt in the project root for license information.
namespace System.Data.Entity.Migrations.Model
{
using System.Linq;
using Xunit;
public class AddForeignKeyOperationTests
{
[Fact]
public void Can_get_and_set_properties()
{
var addForeignKeyOperation = new AddForeignKeyOperation
{
PrincipalTable = "P",
DependentTable = "D",
CascadeDelete = true,
Name = "Foo"
};
addForeignKeyOperation.PrincipalColumns.Add("pk");
addForeignKeyOperation.DependentColumns.Add("fk");
Assert.Equal("P", addForeignKeyOperation.PrincipalTable);
Assert.Equal("D", addForeignKeyOperation.DependentTable);
Assert.Equal("pk", addForeignKeyOperation.PrincipalColumns.Single());
Assert.Equal("fk", addForeignKeyOperation.DependentColumns.Single());
Assert.True(addForeignKeyOperation.CascadeDelete);
Assert.Equal("Foo", addForeignKeyOperation.Name);
Assert.Equal("FK_D_P_fk", addForeignKeyOperation.DefaultName);
Assert.False(addForeignKeyOperation.HasDefaultName);
}
[Fact]
public void DefaultName_is_restricted_to_128_chars()
{
var addForeignKeyOperation = new AddForeignKeyOperation
{
PrincipalTable = "P",
DependentTable = "D"
};
addForeignKeyOperation.DependentColumns.Add(new string('c', 150));
Assert.Equal(128, addForeignKeyOperation.DefaultName.Length);
}
[Fact]
public void Inverse_should_produce_drop_foreign_key_operation()
{
var addForeignKeyOperation = new AddForeignKeyOperation
{
PrincipalTable = "P",
DependentTable = "D",
Name = "Foo",
IsSystem = true
};
addForeignKeyOperation.PrincipalColumns.Add("pk");
addForeignKeyOperation.DependentColumns.Add("fk");
var dropForeignKeyOperation = (DropForeignKeyOperation)addForeignKeyOperation.Inverse;
Assert.Equal("P", dropForeignKeyOperation.PrincipalTable);
Assert.Equal("D", dropForeignKeyOperation.DependentTable);
Assert.Equal("fk", dropForeignKeyOperation.DependentColumns.Single());
Assert.Equal("Foo", dropForeignKeyOperation.Name);
Assert.Equal("FK_D_P_fk", dropForeignKeyOperation.DefaultName);
Assert.True(dropForeignKeyOperation.IsSystem);
}
[Fact]
public void CreateCreateIndexOperation_should_return_corresponding_create_index_operation()
{
var addForeignKeyOperation = new AddForeignKeyOperation
{
PrincipalTable = "P",
DependentTable = "D",
Name = "Foo"
};
addForeignKeyOperation.DependentColumns.Add("fk");
var createIndexOperation = addForeignKeyOperation.CreateCreateIndexOperation();
Assert.Equal(createIndexOperation.DefaultName, createIndexOperation.Name);
Assert.Equal("D", createIndexOperation.Table);
Assert.Equal("fk", createIndexOperation.Columns.Single());
}
}
}
|
