Newer
Older
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
package com.ic.er.mapper;
import com.ic.er.ER;
import com.ic.er.bean.entity.AttributeDO;
import com.ic.er.bean.entity.EntityDO;
import com.ic.er.common.DataType;
import com.ic.er.dao.AttributeMapper;
import com.ic.er.dao.EntityMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import java.sql.SQLException;
import java.util.Date;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.List;
/**
*
* @author jie
* @data 18/10/2022
*
*
*/
public class attributeMapperTest {
@Before
public void init() throws IOException {
try {
ER.connectDB();
ER.createTables();
} catch (SQLException e) {
System.out.println(e);
throw new RuntimeException(e);
}
}
@Test
public void insertAttribute() {
Long entityId = Long.valueOf(456);
Long viewId = Long.valueOf(789);
String name = "a";
String dataType = "int";
int isPrimary = 0;
int isForeign = 1;
int isDelete = 0;
Date gmtCreate = new Date();
Date gmtModified = new Date();
AttributeDO attributeDO = new AttributeDO(0L, entityId, viewId, name, DataType.INTEGER, isPrimary, isForeign, isDelete, gmtCreate, gmtModified);
AttributeDO attributeDO2 = new AttributeDO(0L, entityId, viewId, name, DataType.INTEGER, isPrimary, isForeign, isDelete, gmtCreate, gmtModified);
AttributeDO attributeDO3 = new AttributeDO(0L, entityId, viewId, name, DataType.INTEGER, isPrimary, isForeign, isDelete, gmtCreate, gmtModified);
int ret = ER.attributeMapper.insert(attributeDO);
int ret2 = ER.attributeMapper.insert(attributeDO2);
int ret3 = ER.attributeMapper.insert(attributeDO3);
System.out.printf("ret: %d, ID: %d\n", ret, attributeDO.getId());
System.out.printf("ret2: %d, ID: %d\n", ret2, attributeDO2.getId());
System.out.printf("ret3: %d, ID: %d\n", ret3, attributeDO3.getId());
}
@Test
public void selectByAttributeTest() {
Long entityId = 456L;
AttributeDO attributeDO = new AttributeDO(0L, entityId, 789L, "abc", DataType.VARCHAR, 1, 1, 0, null, null);
int ret = ER.attributeMapper.insert(attributeDO);
Assert.assertEquals(ret, 1);
List<AttributeDO> attributeDOList = ER.attributeMapper.selectByAttribute(attributeDO);
Assert.assertEquals(attributeDOList.size(), 1);
Assert.assertEquals(attributeDOList.get(0).getEntityId(), entityId);
attributeDOList = ER.attributeMapper.selectByAttribute(new AttributeDO(attributeDO.getId()));
Assert.assertEquals(attributeDOList.size(), 1);
Assert.assertEquals(attributeDOList.get(0).getEntityId(), entityId);
}
@Test
public void selectByIdTest(){
Long entityID = 456L;
Long newEntityID = 789L;
// create
AttributeDO attributeDO = new AttributeDO(0L, entityID, 789L, "abc", DataType.VARCHAR, 1, 1, 0, null, null);
int ret = ER.attributeMapper.insert(attributeDO);
Assert.assertEquals(ret, 1);
Assert.assertEquals(attributeDO.getEntityId(), entityID);
AttributeDO aDo = ER.attributeMapper.selectById(attributeDO.getId());
Assert.assertNotNull(aDo);
}
@Test
public void updateByIdTest(){
Long entityID = 456L;
Long newEntityID = 789L;
// create
AttributeDO attributeDO = new AttributeDO(0L, entityID, 789L, "abc", DataType.VARCHAR, 1, 1, 0, null, null);
int ret = ER.attributeMapper.insert(attributeDO);
Assert.assertEquals(ret, 1);
Assert.assertEquals(attributeDO.getEntityId(), entityID);
// update
attributeDO.setEntityId(newEntityID);
ER.attributeMapper.updateById(attributeDO);
// query
List<AttributeDO> attributeDOList = ER.attributeMapper.selectByAttribute(attributeDO);
Assert.assertEquals(attributeDOList.size(), 1);
Assert.assertEquals(attributeDOList.get(0).getEntityId(), newEntityID);
}
@Test
public void deleteByIdTest(){
Long entityID = 456L;
// create
AttributeDO attributeDO = new AttributeDO(0L, entityID, 789L, "abc", DataType.VARCHAR, 1, 1, 0, null, null);
int ret = ER.attributeMapper.insert(attributeDO);
Assert.assertEquals(ret, 1);
Assert.assertEquals(attributeDO.getEntityId(), entityID);
// delete
ER.attributeMapper.deleteById(attributeDO.getId());
// query to verify
List<AttributeDO> attributeDOList = ER.attributeMapper.selectByAttribute(attributeDO);
Assert.assertEquals(attributeDOList.size(), 0);
}
}