Package br.com.objectos.comuns.relational.search

Examples of br.com.objectos.comuns.relational.search.Join

70
71
72
73
74
75
76
77
78
79
80
81
  public void restrict_on_related_entity() {
    Sql sql = sqlProvider.get();
    sql.select("*").from("COMUNS_RELATIONAL.OTHER").as("O").andLoadWith(loader);

    Join _simple = sql.join("SIMPLE", "S").on("O.SIMPLE_ID = S.ID");
    _simple.where("STRING").equalTo("BCD");

    List<Other> result = sql.list();
    List<String> strings = transform(result, Functions.toStringFunction());
    assertThat(strings.size(), equalTo(1));
    assertThat(strings.get(0), equalTo("Other{id=2, value=BCDCB}"));
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
    DeleteDeprecated op = deleteProvider.get();
    op.delete("DEL") //
        .from("COMUNS_RELATIONAL.DEL") //
        .as("DEL");

    Join _simple = op.join("COMUNS_RELATIONAL.SIMPLE", "SIMPLE") //
        .on("DEL.SIMPLE_ID = SIMPLE.ID");
    _simple.where("ID").equalTo(2);

    int rows = op.execute();
    assertThat(rows, equalTo(3));

    List<Del> after = findDel.all();
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
  private void recurseJoins(List<Join> cache, HasElements hasJoins) {
    Collection<Element> els = hasJoins.getElements(Join.class);
    if (els != null) {
      for (Element el : els) {
        Join join = (Join) el;
        cache.add(join);
        recurseJoins(cache, join);
      }
    }
  }
View Full Code Here
41
42
43
44
45
46
47
48
49
    elements.removeAll(OrderProperty.class);
  }

  @Override
  public final Join join(String relationship, String alias) {
    Join join = newJoin(JoinType.INNER, relationship, alias);
    elements.put(Join.class, join);
    return join;
  }
View Full Code Here
48
49
50
51
52
53
54
55
56
    return join;
  }

  @Override
  public final Join leftJoin(String relationship, String alias) {
    Join join = newJoin(JoinType.LEFT, relationship, alias);
    elements.put(Join.class, join);
    return join;
  }
View Full Code Here
TOP

Related Classes of br.com.objectos.comuns.relational.search.Join

  • br.com.objectos.comuns.relational.jdbc.AbstractJdbcSQLFunction
  • br.com.objectos.comuns.relational.jdbc.JdbcConfigure
  • br.com.objectos.comuns.relational.jdbc.MysqlDeleteTest
  • br.com.objectos.comuns.relational.jdbc.MysqlSQLBuilderJoinTest
    • 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.