Package com.nurkiewicz.jdbcrepository

Examples of com.nurkiewicz.jdbcrepository.TableDescription

99
100
101
102
103
104
105
106
107
108
109
  }

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

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

    //then
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
  }

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

    //when
    final String sql = sqlGenerator.deleteById(table);

    //then
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
  }

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

    //when
    final String sql = sqlGenerator.deleteById(table);

    //then
View Full Code Here
63
64
65
66
67
68
69
70
            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
137
138
139
140
141
142
143
144
145
146
147
  @Test
  public void buildSqlForUpdateWithSingleIdColumn() throws Exception {
    //given
    final Object ANY = new Object();
    final TableDescription table = new TableDescription("table", "num");

    //when
    final String sql = sqlGenerator.update(table, ImmutableMap.of("x", ANY, "y", ANY, "z", ANY));

    //then
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
  @Test
  public void buildSqlForUpdateWithMultipleIdColumns() throws Exception {
    //given
    final Object ANY = new Object();
    final TableDescription table = new TableDescription("table", null, "num1", "num2");

    //when
    final String sql = sqlGenerator.update(table, ImmutableMap.of("x", ANY, "y", ANY, "z", ANY));

    //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.