Package com.avaje.ebean

Examples of com.avaje.ebean.RawSql$ColumnMapping$Column

18
19
20
21
22
23
24
25
26
27
28
  @Test
  public void test() {

    ResetBasicData.reset();

    RawSql rawSql = RawSqlBuilder
        .parse("select r.id, r.name from o_customer r where r.id > :id and r.name like :name")
        .columnMapping("r.id", "id").columnMapping("r.name", "name").create();

    Query<Customer> query = Ebean.find(Customer.class);
    query.setRawSql(rawSql);
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
    ResetBasicData.reset();

    String sql = " select order_id, 'ignoreMe', sum(d.order_qty*d.unit_price) as totalAmount "
        + " from o_order_detail d" + " group by order_id ";

    RawSql rawSql = RawSqlBuilder.parse(sql).columnMapping("order_id", "order.id")
        .columnMappingIgnore("'ignoreMe'")
        // don't need this when using column alias
        // .columnMapping("sum(d.order_qty*d.unit_price)", "totalAmount")
        .create();

View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
  @Test
  public void test() {

    ResetBasicData.reset();

    RawSql rawSql = RawSqlBuilder.parse("select r.id, r.name from o_customer r ")
        .columnMapping("r.id", "id")
        .columnMapping("r.name", "name").create();

    Query<Customer> query = Ebean.find(Customer.class);
    query.setRawSql(rawSql);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
  @Test
  public void testFirstRowsMaxRows() throws InterruptedException, ExecutionException {
   
    ResetBasicData.reset();
   
    RawSql rawSql =
        RawSqlBuilder
            .parse("select r.id, r.name from o_customer r ")
            .columnMapping("r.id", "id")
            .columnMapping("r.name", "name")
            .create();
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  @Test
  public void testPaging() {

    ResetBasicData.reset();

    RawSql rawSql = RawSqlBuilder.parse("select r.id, r.name from o_customer r ")
        .columnMapping("r.id", "id")
        .columnMapping("r.name", "name")
        .create();

    Query<Customer> query = Ebean.find(Customer.class);
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
   
   
    String sql = "select dtype, id, license_number from vehicle where id = :id";
    RawSqlBuilder rawSqlBuilder = RawSqlBuilder.parse(sql);
   
    RawSql rawSql = rawSqlBuilder.create();
   
    List<Vehicle> list = Ebean.find(Vehicle.class)
        .setRawSql(rawSql)
        .setParameter("id", truck.getId())
        .findList();
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
        String sql
            = " select order_id, sum(order_qty*unit_price) as totalAmount"
            + " from o_order_detail "
            + " group by order_id";

        RawSql rawSql = RawSqlBuilder
            .parse(sql)
            .columnMapping("order_id","order.id")
            //.columnMapping("sum(order_qty*unit_price)","totalAmount")
            .create();
           
        Sql rs = rawSql.getSql();
       
        String s = rs.toString();
        System.out.println(s);
        assertTrue(s, s.contains("[order_id, sum"));
       
View Full Code Here
564
565
566
567
568
569
570
571
                .orderBy("user.name ASC")
                .findList();
    }

    private static com.avaje.ebean.Query<User> createUserSearchQueryWithRawSql(String sql) {
        RawSql rawSql = RawSqlBuilder.parse(sql).columnMapping("user.login_id", "loginId").create();
        return User.find.setRawSql(rawSql);
    }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
        return Post.<Post>find("tags.name=?",tag).findList();
    }
   
    public static List<Post> findTaggedWith(String... tags) {
       
          RawSql rawSql =
            RawSqlBuilder
            .parse("select p.id id from post p inner join post_tag pt on p.id=pt.post_id inner join tag t on pt.tag_id=t.id group by p.id")
            // map result columns to bean properties
//           .columnMapping("p.id", "post.id")
//           .columnMapping("o.status", "order.status")
View Full Code Here
TOP

Related Classes of com.avaje.ebean.RawSql$ColumnMapping$Column

  • com.avaje.ebeaninternal.server.deploy.BeanDescriptorManager
  • com.avaje.ebeaninternal.server.query.CQueryBuilder
  • com.avaje.ebeaninternal.server.rawsql.TestRawSqlParsing
  • com.avaje.tests.inheritance.TestInheritanceRawSql
  • com.avaje.tests.rawsql.TestRawSqlAsKeyword
  • com.avaje.tests.rawsql.TestRawSqlCustomerAggregate
  • com.avaje.tests.rawsql.TestRawSqlNamedParams
  • com.avaje.tests.rawsql.TestRawSqlOrmQuery
  • com.avaje.tests.rawsql.TestRawSqlOrmQueryDistinct
  • com.avaje.tests.rawsql.TestRawSqlOrmWrapper
    • 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.