Package co.nubetech.crux.model

Examples of co.nubetech.crux.model.GroupBys

60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
      stmt.executeUpdate("insert into groupBy(id, groupBysId, rowAliasId, position) values(2,1,19999,2)");
     
      dao = new GroupBysDAO();
      dao.session = com.googlecode.s2hibernate.struts2.plugin.util.HibernateSessionFactory
          .getNewSession();
      GroupBys groupBys = dao.findById(1l);
     
      assertEquals(1, groupBys.getId());
      assertEquals(99999, groupBys.getReport().getId());
      assertEquals("reportTest", groupBys.getReport().getName());
      //for (GroupBy groupBy: groupBys.getGroupBy()) {
      assertEquals(2, groupBys.getGroupBy().size());
      //System.out.println("Groupby is " + groupBy);
      //}
    }
    catch (CruxException e) {
      // TODO Auto-generated catch block
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
     
      dao = new GroupBysDAO();
      dao.session = com.googlecode.s2hibernate.struts2.plugin.util.HibernateSessionFactory
          .getNewSession();
      dao.transaction = dao.session.getTransaction();
      GroupBys groupBys = dao.findById(1l);
     
      assertEquals(1, groupBys.getId());
      assertEquals(99999, groupBys.getReport().getId());
      assertEquals("reportTest", groupBys.getReport().getName());
      assertEquals(2, groupBys.getGroupBy().size());
      dao.delete(groupBys);
     
      ResultSet rs = stmt.executeQuery("select id from groupBys");
      if (rs!= null  && rs.first()) {
        System.out.println(rs.getLong(0));
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
      groupByList.add(groupBy1);
     
      Report report = new Report();
      report.setId(99999);
     
      GroupBys groupBys = new GroupBys();
      groupBys.setGroupBy(groupByList);
      groupBys.setReport(report);
     
      long id = dao.save(groupBys);
           
      assertEquals(id, groupBys.getId());
      //assertEquals(99999, groupBys.getReport().getId());
//      /assertEquals("reportTest", groupBys.getReport().getName());
     
      ResultSet rs = stmt.executeQuery("select id, reportId from groupBys");
      if (rs!= null  && rs.first()) {
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
      dao = new GroupBysDAO();
      dao.session = com.googlecode.s2hibernate.struts2.plugin.util.HibernateSessionFactory
          .getNewSession();
      dao.transaction = dao.session.getTransaction();
     
      GroupBys groupBys = dao.findById(1l);
      groupBys.getGroupBy().remove(0);
      groupBys.getGroupBy().get(0).setPosition(1);
     
      long id = dao.save(groupBys);
           
      assertEquals(id, groupBys.getId());
      assertEquals(1, groupBys.getId());
      //assertEquals(99999, groupBys.getReport().getId());
//      /assertEquals("reportTest", groupBys.getReport().getName());
     
      ResultSet rs = stmt.executeQuery("select id, reportId from groupBys");
      if (rs!= null  && rs.first()) {
        assertEquals(id, rs.getLong(1));
        assertEquals(99999, rs.getLong(2));
        rs.close();
      }
      else {
        fail("GroupBys not modified");
      }
      ResultSet rs1 = stmt.executeQuery("select id, groupBysId,rowAliasId, position from groupBy");
      if (rs1 != null && rs1.first()) {
        assertNotNull(rs1.getLong(1));
        assertEquals(id, rs1.getLong(2));
        assertEquals(19999, rs1.getLong(3));
        assertEquals(1, rs1.getInt(4));
        assertFalse(rs1.next());       
      }
      else {       
        fail("Groupbys should have modified groupBy");
      }
     
      RowAlias alias = new RowAlias();
      alias.setId(99999);
     
      GroupBy groupBy1 = createGroupBy(2, alias);
     
      groupBys.getGroupBy().add(groupBy1);
      id = dao.save(groupBys);
     
      assertEquals(id, groupBys.getId());
      assertEquals(1, groupBys.getId());
     
      rs = stmt.executeQuery("select id, reportId from groupBys");
      if (rs!= null  && rs.first()) {
        assertEquals(id, rs.getLong(1));
        assertEquals(99999, rs.getLong(2));
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
37
  private final static Logger logger = Logger
      .getLogger(GroupBysDAO.class);

 
  public GroupBys findById(Long id) throws CruxException {
    GroupBys groupBys = null;
    try {
      groupBys = (GroupBys) session.get(GroupBys.class, id);
      groupBys.getId();
    }
    catch (NullPointerException e) {
      throw new CruxException(
          "Selected GroupBys does not exist in the database.", e);
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
      e.printStackTrace();
    }
  }
 
  public List<List> getAggregates() throws CruxException{
    GroupBys groupBys = report.getGroupBys();
    if (groupBys == null) {
      List returnList = new ArrayList();
      returnList.add(FunctionUtil.getAggregatedFunctionValueList(report, functions));
      return returnList;
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
   
   
    Report report = new Report();
    report.setId(1234l);
   
    GroupBys groupBys = new GroupBys();
    groupBys.setGroupBy(groupByList);
    groupBys.setReport(report);
    groupBys.setId(1l);
    report.setGroupBys(groupBys);
   
    SaveReportAction saveReportAction = new SaveReportAction();
    saveReportAction.populateGroupBys(rowAliasMap);
    saveReportAction.setReport(report);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
      //for each design
      //get the col or row alias and the function to be applied.
      //create list of functions to be applied.
      Collection<ReportDesign> designs = report.getDesigns();
      List<Stack<CruxFunction>> functions = report.getFunctions();   
      GroupBys groupBys = report.getGroupBys();
      //open the scan
      //get values of data for each group by
      //put in hash
      //hash key group by objects, hash value List of function applied values.
      //we are keeping everything in memory, as we are assuming that final report holds less data
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
    ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
    designs.add(design);
    report.setDesigns(designs);
   
    GroupBys groupBys = new GroupBys();
   
    RowAlias alias = new RowAlias();
    alias.setId(99999);
   
    RowAlias alias1 = new RowAlias();
    alias1.setId(19999);
   
    List<GroupBy> groupByList = new ArrayList<GroupBy>();
    GroupBy groupBy = new GroupBy();
   
    groupBy.setRowAlias(alias);
    groupBy.setPosition(1);
   
    GroupBy groupBy1 = new GroupBy();
   
    groupBy1.setRowAlias(alias1);
    groupBy1.setPosition(2);
   
    groupByList.add(groupBy);
    groupByList.add(groupBy1);
    groupBys.setGroupBy(groupByList);
    groupBys.setReport(report);
    report.setGroupBys(groupBys);

    reportDAO.session = session;
    reportDAO.transaction = reportDAO.session.getTransaction();
    long reportId = reportDAO.save(report);
View Full Code Here
TOP

Related Classes of co.nubetech.crux.model.GroupBys

  • co.nubetech.crux.action.TestSaveReportAction
  • co.nubetech.crux.dao.GroupBysDAO
  • co.nubetech.crux.dao.TestGroupBysDAO
  • co.nubetech.crux.dao.TestReportDAO
  • co.nubetech.crux.server.aggregate.GroupingAggregationBatchCallback
  • co.nubetech.crux.server.aggregate.GroupingAggregationImpl
    • 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.