/
ColumnSerializerTests.groovy
122 lines (102 loc) · 3.9 KB
/
ColumnSerializerTests.groovy
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
/*
* Copyright 2011 Tim Berglund
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.augusttechgroup.liquibase.serialize
import org.junit.Test
import liquibase.change.ColumnConfig
import static org.junit.Assert.*
import liquibase.change.ConstraintsConfig
/**
* <p></p>
*
* @author Tim Berglund
*/
class ColumnSerializerTests
extends SerializerTests
{
@Test
void buildSimpleStringColumn() {
def columnConfig = new ColumnConfig()
columnConfig.name = 'column-name'
columnConfig.type = 'varchar'
columnConfig.value = 'value'
columnConfig.defaultValue = 'default-string-value'
columnConfig.remarks = 'No comment'
def serializedText = serializer.serialize(columnConfig)
def expectedText = "column(name: 'column-name', type: 'varchar', value: 'value', defaultValue: 'default-string-value', remarks: 'No comment')"
assertEquals expectedText, serializedText
}
@Test
void buildSimpleNumericColumn() {
def columnConfig = new ColumnConfig()
columnConfig.name = 'column-name'
columnConfig.type = 'int'
columnConfig.valueNumeric = 3
columnConfig.defaultValueNumeric = 42
columnConfig.autoIncrement = false
def serializedText = serializer.serialize(columnConfig)
def expectedText = "column(name: 'column-name', type: 'int', valueNumeric: 3, defaultValueNumeric: 42, autoIncrement: false)"
assertEquals expectedText, serializedText
}
@Test
void buildSimpleDateColumn() {
def now = "2010-11-02T07:52:04.0"
def then = "2010-11-28T22:09:43.0"
def sqlNow = parseSqlTimestamp(now)
def sqlThen = parseSqlTimestamp(then)
def columnConfig = new ColumnConfig()
columnConfig.name = 'column-name'
columnConfig.type = 'datetime'
columnConfig.valueDate = now
columnConfig.defaultValueDate = then
columnConfig.remarks = 'No date comment'
def serializedText = serializer.serialize(columnConfig)
def expectedText = "column(name: 'column-name', type: 'datetime', valueDate: '${now}', defaultValueDate: '${then}', remarks: 'No date comment')"
assertEquals expectedText as String, serializedText
}
@Test
void buildSimpleBooleanColumn() {
def columnConfig = new ColumnConfig()
columnConfig.name = 'column-name'
columnConfig.type = 'bit'
columnConfig.valueBoolean = true
columnConfig.defaultValueBoolean = false
columnConfig.remarks = 'No boolean comment'
def serializedText = serializer.serialize(columnConfig)
def expectedText = "column(name: 'column-name', type: 'bit', valueBoolean: true, defaultValueBoolean: false, remarks: 'No boolean comment')"
}
@Test
void buildStringColumnWithConstraintsInMap() {
// This is an unprofessional comment, but: Groovy is *awesome*
def columnConfig = [
name: 'column-name',
type: 'varchar',
value: 'value',
defaultValue: 'default-string-value',
remarks: 'No comment',
constraints: [
nullable: false,
unique: true,
uniqueConstraintName: 'unique_monkey_constraint'
] as ConstraintsConfig
] as ColumnConfig
def serializedText = serializer.serialize(columnConfig)
def expectedText = """\
column(name: 'column-name', type: 'varchar', value: 'value', defaultValue: 'default-string-value', remarks: 'No comment') {
constraints(nullable: false, unique: true, uniqueConstraintName: 'unique_monkey_constraint')
}"""
assertEquals expectedText, serializedText
}
}