Package co.nubetech.crux.model

Examples of co.nubetech.crux.model.ReportDesign


    report.setName("reportTest");
    report.setUser(user.findById(1l));
    report.setDashboard(dashboard);
    report.setNumRecordsPerPage(25);

    ReportDesign design = new ReportDesign();
    design.setMappingAxis("x");
    design.setColumnAlias(detail.findById(99999l));
    design.setReport(report);
    report.setReportType(type.findById(1l));

    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);
    long designId = design.getId();

    ResultSet rs = stmt.executeQuery("select * from report where id="
        + reportId);

    while (rs.next()) {
View Full Code Here


    ReportDAO reportDAO = new ReportDAO();
    Report report = new Report();
    report.setName(null);
    report.setUser(user.findById(1l));

    ReportDesign design = new ReportDesign();
    design.setMappingAxis("x");
    design.setColumnAlias(detail.findById(99999l));
    design.setReport(report);
    report.setReportType(type.findById(1l));

    ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
    designs.add(design);
    report.setDesigns(designs);
View Full Code Here

    ReportDAO reportDAO = new ReportDAO();
    Report report = new Report();
    report.setName("reportTest");
    report.setUser(user.findById(1l));

    ReportDesign design = new ReportDesign();
    design.setMappingAxis("x");
    design.setColumnAlias(detail.findById(99999l));
    design.setReport(report);
    report.setReportType(type.findById(1l));

    ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
    designs.add(design);
    report.setDesigns(designs);
View Full Code Here

    ColumnAliasDAO detail = new ColumnAliasDAO();
    detail.session = session;

    Report resultRep = reportDAO.findById(99999l);
    ReportDesign design = new ReportDesign(resultRep,
        detail.findById(99998l), "y",null);
    resultRep.addDesign(design);

    reportDAO.transaction = reportDAO.session.getTransaction();

    long reportId = reportDAO.save(resultRep);

    long designId = design.getId();

    assertEquals(reportId, 99999l);

    ResultSet rs = stmt.executeQuery("select * from report where id=99999");

View Full Code Here

    ReportDAO reportDAO = new ReportDAO();
    Report report = new Report();
    report.setName("reportTest");
    report.setUser(user.findById(1l));

    ReportDesign design = new ReportDesign();
    design.setMappingAxis("x");
    design.setColumnAlias(columnAlias.findById(99999l));
    design.setReport(report);
    report.setReportType(type.findById(1l));

    ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
    designs.add(design);
    report.setDesigns(designs);

    RowAliasFilter rowAliasFilter = new RowAliasFilter();
    rowAliasFilter.setReport(report);
    rowAliasFilter.setRowAlias(rowAlias.findById(99999l));
    rowAliasFilter.setFilterType(filterType.findById(1l));
    rowAliasFilter.setValue("rowFilter");

    ArrayList<RowAliasFilter> rowFilters = new ArrayList<RowAliasFilter>();
    rowFilters.add(rowAliasFilter);
    report.setRowAliasFilters(rowFilters);

    ColumnFilter columnFilter = new ColumnFilter();
    columnFilter.setColumnAlias(columnAlias.findById(99999l));
    columnFilter.setFilterType(filterType.findById(1l));
    columnFilter.setReport(report);
    columnFilter.setValue("columnFilter");

    ArrayList<ColumnFilter> columnFilters = new ArrayList<ColumnFilter>();
    columnFilters.add(columnFilter);
    report.setColumnFilters(columnFilters);

    reportDAO.session = session;
    reportDAO.transaction = reportDAO.session.getTransaction();
    long reportId = reportDAO.save(report);
    long designId = design.getId();
    long rowAliasFilterId = rowAliasFilter.getId();
    long columnFilterId = columnFilter.getId();

    ResultSet rs1 = stmt.executeQuery("select * from rowFilter where id="
        + rowAliasFilterId);
View Full Code Here

    Report report = new Report();
    report.setName("reportTest");
    report.setUser(user.findById(1l));
    report.setDashboard(dashboard);

    ReportDesign design = new ReportDesign();
    design.setMappingAxis("x");
    design.setColumnAlias(detail.findById(99999l));
    design.setReport(report);
    report.setReportType(type.findById(1l));

    ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
    designs.add(design);
    report.setDesigns(designs);

    reportDAO.session = session;
    reportDAO.transaction = reportDAO.session.getTransaction();
    long reportId = reportDAO.save(report);
    long designId = design.getId();

    ResultSet rs = stmt.executeQuery("select * from report where id="
        + reportId);

    while (rs.next()) {
View Full Code Here

    Report report = new Report();
    report.setName("reportTest");
    report.setUser(user.findById(1l));
    report.setDashboard(null);

    ReportDesign design = new ReportDesign();
    design.setMappingAxis("x");
    design.setColumnAlias(detail.findById(99999l));
    design.setReport(report);
    report.setReportType(type.findById(1l));

    ArrayList<ReportDesign> designs = new ArrayList<ReportDesign>();
    designs.add(design);
    report.setDesigns(designs);
    long reportId =0;
    long designId = 0;
   
    try{

    reportDAO.session = session;
    reportDAO.transaction = reportDAO.session.getTransaction();
    reportId = reportDAO.save(report);
    designId = design.getId();

    ResultSet rs = stmt.executeQuery("select * from report where id="
        + reportId);

    while (rs.next()) {
View Full Code Here

TOP

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

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.