Package com.bleujin.dbfs.common

Examples of com.bleujin.dbfs.common.QueryObj.execute()

18
19
20
21
22
23
24
25
26
27
28
    "             page:{listnum:10, pageno:1} }}";
   
    JSONObject jo = JSONObject.fromObject(form.getQuery());
   
    QueryObj query = new JSONParser(getDBController()).parseToQueryable(jo);
    JSONObject result = query.execute() ;
   
    request.setAttribute("result", result) ;
  }

  @Override
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
    assertEquals(dc.getLimitedRows(), cmd.getPage().getListNum()) ;
    assertEquals(1, cmd.getPage().getPageNo()) ;
   
    assertEquals(0, cmd.getParams().size()) ;
   
    JSONObject result = cmd.execute() ;
    assertEquals(2, result.getJSONObject("RESULT").getJSONArray("ROWS").size() ) ;
   
  }
 
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
    assertEquals(1, page.getPageNo()) ;
   
    // param
    assertEquals(0, cmd.getParams().size()) ;
   
    JSONObject result = cmd.execute() ;
    assertEquals(5, result.getJSONObject("RESULT").getJSONArray("ROWS").size() ) ;
  }
 
  public void testInsert() throws Exception {
    dc.execUpdate("delete from update_sample") ;
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
    QueryObj query = new JSONParser(dc).parseToQueryable(jo);
   
    assertEquals(QueryType.USER_COMMAND, query.getQueryType());
    assertEquals(IQueryable.UPDATE_COMMAND, query.getCommandType());
   
    JSONObject result = query.execute() ;
    assertEquals(1, result.getJSONObject("RESULT").getInt("ROWCOUNT")) ;
  }
 
  public void testUserProceduresSelect() throws Exception {
    String json = "{query:{name:'upts', type:'userprocedures', ctype:'select', " +
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
   
    assertEquals("upts", query.getProcSQL()) ;
    assertEquals("select count(*) cnt from copy_tblc", query.getQueryObj(0).getProcSQL()) ;
    assertEquals("select * from copy_tblc", query.getQueryObj(1).getProcSQL()) ;
   
    JSONObject result = query.execute() ;
    Debug.debug(result) ;
  }
 
  public void testUserProceduresInsert() throws Exception {
    dc.execUpdate("delete from update_sample") ;
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
        "                        {query:{command:\"update update_sample set b = '3' where a = 1\"}}]" +
        "}}" ;
    JSONObject jo = JSONObject.fromObject(json);
    QueryObj query = new JSONParser(dc).parseToQueryable(jo);
   
    JSONObject result = query.execute() ;
    assertEquals(2, result.getJSONObject("RESULT").getInt("ROWCOUNT")) ;
  } 
}

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.