Package com.nurkiewicz.jdbcrepository

Examples of com.nurkiewicz.jdbcrepository.TableDescription

62
63
64
65
66
67
68
69
            mapping.put("FAVOURITE_COUNT", comment.getFavouriteCount());
            return mapping;
          }
        },
        new CommentWithUserMssqlGenerator(),
        new TableDescription("COMMENTS", "COMMENTS c JOIN USERS u ON c.USER_NAME = u.USER_NAME", "ID")
    );
  }
View Full Code Here
58
59
60
61
62
63
64
65
            mapping.put("FAVOURITE_COUNT", comment.getFavouriteCount());
            return mapping;
          }
        },
        new CommentWithUserDerbySqlGenerator(),
        new TableDescription("COMMENTS", "COMMENTS c JOIN USERS u ON c.USER_NAME = u.USER_NAME", "ID")
    );
  }
View Full Code Here
18
19
20
21
22
23
24
25
  public BoardingPassRepository() {
    this("BOARDING_PASS");
  }

  public BoardingPassRepository(String tableName) {
    super(MAPPER, UNMAPPER, new TableDescription(tableName, null, "flight_no", "seq_no")
    );
  }
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
  private final SqlGenerator sqlGenerator = new SqlGenerator();

  @Test
  public void buildSqlForSelectByIdsWhenSingleIdColumnAndNoId() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", "num");

    //when
    final String sql = sqlGenerator.selectByIds(table, 0);

    //then
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
  }

  @Test
  public void buildSqlForSelectByIdsWhenSingleIdColumnAndOneId() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", "num");

    //when
    final String sql = sqlGenerator.selectByIds(table, 1);

    //then
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
  }

  @Test
  public void buildSqlForSelectByIdsWhenSingleIdColumnAndTwoIds() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", "num");

    //when
    final String sql = sqlGenerator.selectByIds(table, 2);

    //then
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
  }

  @Test
  public void buildSqlForSelectByIdsWhenSingleIdColumnAndSeveralIds() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", "num");

    //when
    final String sql = sqlGenerator.selectByIds(table, 4);

    //then
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
  }

  @Test
  public void buildSqlForSelectByIdsWhenMultipleIdColumnsAndNoId() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", null, "num1", "num2", "num3");

    //when
    final String sql = sqlGenerator.selectByIds(table, 0);

    //then
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
  }

  @Test
  public void buildSqlForSelectByIdsWhenMultipleIdColumnsAndOneId() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", null, "num1", "num2", "num3");

    //when
    final String sql = sqlGenerator.selectByIds(table, 1);

    //then
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
  }

  @Test
  public void buildSqlForSelectByIdsWhenMultipleIdColumnsAndTwoIds() throws Exception {
    //given
    final TableDescription table = new TableDescription("table", null, "num1", "num2", "num3");

    //when
    final String sql = sqlGenerator.selectByIds(table, 2);

    //then
View Full Code Here
TOP

Related Classes of com.nurkiewicz.jdbcrepository.TableDescription

  • com.nurkiewicz.jdbcrepository.derby.JdbcRepositoryTestDerbyConfig
  • com.nurkiewicz.jdbcrepository.mssql.JdbcRepositoryTestMssqlConfig
  • com.nurkiewicz.jdbcrepository.mssql2012.JdbcRepositoryTestMssql2012Config
  • com.nurkiewicz.jdbcrepository.repositories.BoardingPassRepository
  • com.nurkiewicz.jdbcrepository.sql.SqlGeneratorTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.