Package jodd.db.oom.sqlgen

Examples of jodd.db.oom.sqlgen.DbSqlBuilder.generateQuery()

229
230
231
232
233
234
235
236
237
238
239
    assertEquals(3, dbc.getQueryParameters().size());

    BadBoy bb = new BadBoy();

    dbc = sql().set("b", bb).table("BadBoy", "b");
    assertEquals("set BOY b", dbc.generateQuery());

    dbc = sql().set("BadBoy", bb).table("BadBoy", null);
    assertEquals("set BOY", dbc.generateQuery());

    dbc = sql().setAll("b", bb).table("BadBoy", "b");
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
    dbc = sql().set("b", bb).table("BadBoy", "b");
    assertEquals("set BOY b", dbc.generateQuery());

    dbc = sql().set("BadBoy", bb).table("BadBoy", null);
    assertEquals("set BOY", dbc.generateQuery());

    dbc = sql().setAll("b", bb).table("BadBoy", "b");
    assertEquals("set ID=:badBoy.ajdi, GIRL_ID=:badBoy.girlId, NAME=:badBoy.nejm BOY b", dbc.generateQuery());
  }
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
    dbc = sql().set("BadBoy", bb).table("BadBoy", null);
    assertEquals("set BOY", dbc.generateQuery());

    dbc = sql().setAll("b", bb).table("BadBoy", "b");
    assertEquals("set ID=:badBoy.ajdi, GIRL_ID=:badBoy.girlId, NAME=:badBoy.nejm BOY b", dbc.generateQuery());
  }

  @Test
  public void testStrings() {
    DbSqlBuilder dbc = sql()._("123")._("xxx");
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
  }

  @Test
  public void testStrings() {
    DbSqlBuilder dbc = sql()._("123")._("xxx");
    assertEquals("123xxx", dbc.generateQuery());
  }

  @Test
  public void testWhere() {
    {
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
    {
      Boy b = new Boy();
      b.id = 1;
      b.girlId = 2;
      DbSqlBuilder dbc = sql().match("Boy", b)._(" ").table(b, null);
      assertEquals("(BOY.GIRL_ID=:boy.girlId and BOY.ID=:boy.id) BOY", dbc.generateQuery());
      dbc = sql().match("b", b)._(" ").table(b, "b");
      assertEquals("(b.GIRL_ID=:boy.girlId and b.ID=:boy.id) BOY b", dbc.generateQuery());
    }
    {
      BadBoy bb = new BadBoy();
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
      b.id = 1;
      b.girlId = 2;
      DbSqlBuilder dbc = sql().match("Boy", b)._(" ").table(b, null);
      assertEquals("(BOY.GIRL_ID=:boy.girlId and BOY.ID=:boy.id) BOY", dbc.generateQuery());
      dbc = sql().match("b", b)._(" ").table(b, "b");
      assertEquals("(b.GIRL_ID=:boy.girlId and b.ID=:boy.id) BOY b", dbc.generateQuery());
    }
    {
      BadBoy bb = new BadBoy();
      DbSqlBuilder dbc = sql().match("BadBoy", bb).table(bb, null);
      assertEquals("(1=1) BOY", dbc.generateQuery());
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
      assertEquals("(b.GIRL_ID=:boy.girlId and b.ID=:boy.id) BOY b", dbc.generateQuery());
    }
    {
      BadBoy bb = new BadBoy();
      DbSqlBuilder dbc = sql().match("BadBoy", bb).table(bb, null);
      assertEquals("(1=1) BOY", dbc.generateQuery());
      dbc = sql().match("b", bb).table(bb, "b");
      assertEquals("(1=1) BOY b", dbc.generateQuery());
    }
    {
      BadBoy bb = new BadBoy();
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
    {
      BadBoy bb = new BadBoy();
      DbSqlBuilder dbc = sql().match("BadBoy", bb).table(bb, null);
      assertEquals("(1=1) BOY", dbc.generateQuery());
      dbc = sql().match("b", bb).table(bb, "b");
      assertEquals("(1=1) BOY b", dbc.generateQuery());
    }
    {
      BadBoy bb = new BadBoy();
      DbSqlBuilder dbc = sql()._("where ").match("BadBoy", bb)._(" ").table(bb, null);
      assertEquals("where (1=1) BOY", dbc.generateQuery());
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
      assertEquals("(1=1) BOY b", dbc.generateQuery());
    }
    {
      BadBoy bb = new BadBoy();
      DbSqlBuilder dbc = sql()._("where ").match("BadBoy", bb)._(" ").table(bb, null);
      assertEquals("where (1=1) BOY", dbc.generateQuery());
      dbc = sql()._("where")._().match("b", bb)._(" ").table(bb, "b");
      assertEquals("where (1=1) BOY b", dbc.generateQuery());

      dbc = sql()._("where")._().match("BadBoy", bb).table(bb, null);
      assertEquals("where (1=1) BOY", dbc.generateQuery());
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
    {
      BadBoy bb = new BadBoy();
      DbSqlBuilder dbc = sql()._("where ").match("BadBoy", bb)._(" ").table(bb, null);
      assertEquals("where (1=1) BOY", dbc.generateQuery());
      dbc = sql()._("where")._().match("b", bb)._(" ").table(bb, "b");
      assertEquals("where (1=1) BOY b", dbc.generateQuery());

      dbc = sql()._("where")._().match("BadBoy", bb).table(bb, null);
      assertEquals("where (1=1) BOY", dbc.generateQuery());
      dbc = sql()._("where ").match("b", bb).table(bb, "b");
      assertEquals("where (1=1) BOY b", dbc.generateQuery());
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.