mybatis-dynamic-sql/src/test/java/examples/simple/PersonDynamicSqlSupport.java at master · mybatis/mybatis-dynamic-sql · GitHub

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
/*
 *    Copyright 2016-2026 the original author or authors.
 *
 *    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
 *
 *       https://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 examples.simple;

import java.sql.JDBCType;
import java.util.Date;

import org.mybatis.dynamic.sql.SqlColumn;
import org.mybatis.dynamic.sql.SqlTable;

public final class PersonDynamicSqlSupport {
    public static final Person person = new Person();
    public static final PrimaryKeyColumn<Integer> id = person.id;
    public static final SqlColumn<String> firstName = person.firstName;
    public static final SqlColumn<LastName> lastName = person.lastName;
    public static final SqlColumn<Date> birthDate = person.birthDate;
    public static final SqlColumn<Boolean> employed = person.employed;
    public static final SqlColumn<String> occupation = person.occupation;
    public static final SqlColumn<Integer> addressId = person.addressId;

    public static final class Person extends SqlTable {
        public final PrimaryKeyColumn<Integer> id = new PrimaryKeyColumn.Builder<Integer>()
                .withTable(this)
                .withName("id")
                .withJdbcType(JDBCType.INTEGER)
                .withJavaProperty("id")
                .isPrimaryKeyColumn(true)
                .build();
        public final SqlColumn<String> firstName = column("first_name", JDBCType.VARCHAR)
                .withJavaProperty("firstName");
        public final SqlColumn<LastName> lastName =
                column("last_name", JDBCType.VARCHAR, "examples.simple.LastNameTypeHandler")
                        .withJavaProperty("lastName");
        public final SqlColumn<Date> birthDate = column("birth_date", JDBCType.DATE)
                .withJavaProperty("birthDate");
        public final SqlColumn<Boolean> employed =
                column("employed", JDBCType.VARCHAR, "examples.simple.YesNoTypeHandler")
                        .withJavaProperty("employed");
        public final SqlColumn<String> occupation = column("occupation", JDBCType.VARCHAR)
                .withJavaProperty("occupation");
        public final SqlColumn<Integer> addressId = column("address_id", JDBCType.INTEGER)
                .withJavaProperty("addressId");

        public Person() {
            super("Person");
        }
    }
}