Examples of ReportInstance

Examples of com.javaeye.jert.domain.ReportInstance

27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
    private static final String CREATE_TABLE = "DROP TABLE USER IF EXISTS; CREATE TABLE USER (USER_NAME varchar(255), EMAIL varchar(255));";
   
    public void testGenerateStaticQueryReport() {
        ReportDefinition rd = getReportDefinition();

        ReportInstance instance = new ReportInstance(2);
        instance.setReportDefinition(rd);
        instance.generateItems(null);
        ResultSetOutput output = instance.getResultSetOutput();
        assertEquals(5, instance.getTotalCount());
        assertEquals(2, output.getColumns().size());
       
        assertEquals("USER_NAME", output.getHeaderNames()[0]);
        assertEquals("EMAIL", output.getHeaderNames()[1]);
       
View Full Code Here

Examples of com.javaeye.jert.domain.ReportInstance

51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
    }

    public void testGenerateReportStartIndex() {
        ReportDefinition rd = getReportDefinition();
       
        ReportInstance instance = new ReportInstance(2);
        instance.setReportDefinition(rd);
        instance.setStartIndex(2);
        instance.generateItems(null);
       
        ResultSetOutput output = instance.getResultSetOutput();
        assertEquals(5, instance.getTotalCount());
        assertEquals(2, output.getColumns().size());
        Object[] user3 = (Object[]) output.getColumns().get(0);
        assertEquals("user3", user3[0]);
        assertEquals("user3@javaeye.com", user3[1]);
    }
View Full Code Here

Examples of com.javaeye.jert.domain.ReportInstance

83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
        rd.setDatabase(db);
        rd.setSql("select * from user where user_name = #name#");
        rd.setQueryType(QueryBuilder.QUERY_TYPE_SIMPLE_PARAMETER);
        rd.setupDefaultParameterDefinition();
       
        ReportInstance instance = new ReportInstance();
        instance.setReportDefinition(rd);
        QueryParameter[] parameters = rd.getDefaultQueryParameters();
        parameters[0].setValue("user1");
       
        instance.generateItems(parameters);
        assertEquals(1, instance.getTotalCount());
       
        ResultSetOutput output = instance.getResultSetOutput();
        Object[] user1 = (Object[]) output.getColumns().get(0);
        assertEquals("user1", user1[0]);
        assertEquals("user1@javaeye.com", user1[1]);       
    }
View Full Code Here

Examples of com.javaeye.jert.domain.ReportInstance

107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
                + "<dynamic type=\"isNotEmpty\" append-before=\"and user_name = \" parameter-name=\"name\"/>"
                + "<dynamic type=\"isNotEmpty\" append-before=\"and email = \" parameter-name=\"email\"/>");
        rd.setQueryType(QueryBuilder.QUERY_TYPE_DYNAMIC_PARAMETER);
        rd.setupDefaultParameterDefinition();

        ReportInstance instance = new ReportInstance();
        instance.setReportDefinition(rd);
        QueryParameter[] parameters = rd.getDefaultQueryParameters();
        instance.generateItems(parameters);
        assertEquals(5, instance.getTotalCount());

        parameters = rd.getDefaultQueryParameters();
        parameters[0].setValue("user1");
        instance.generateItems(parameters);
        assertEquals(1, instance.getTotalCount());
       
        parameters = rd.getDefaultQueryParameters();
        parameters[0].setValue("user1");
        parameters[1].setValue("user2@javaeye.com");
        instance.generateItems(parameters);
        assertEquals(0, instance.getTotalCount());       
    }
View Full Code Here

Examples of com.serotonin.m2m2.reports.vo.ReportInstance

33
34
35
36
37
38
39
40
41
42
43
        // Get the report instance id
        int instanceId = Integer.parseInt(request.getParameter("instanceId"));

        // Get the report instance
        ReportDao reportDao = new ReportDao();
        ReportInstance instance = reportDao.getReportInstance(instanceId);

        // Ensure the user is allowed access.
        ReportCommon.ensureReportInstancePermission(Common.getUser(request), instance);

        // Stream the content.
View Full Code Here

Examples of com.serotonin.m2m2.reports.vo.ReportInstance

24
25
26
27
28
29
30
31
32
33
34
    @Override
    public View handleRequest(HttpServletRequest request, HttpServletResponse response, Map<String, Object> model)
            throws Exception {
        int instanceId = Integer.parseInt(request.getParameter("instanceId"));
        ReportDao reportDao = new ReportDao();
        ReportInstance instance = reportDao.getReportInstance(instanceId);

        User user = Common.getUser(request);
        ReportCommon.ensureReportInstancePermission(user, instance);

        ReportChartCreator creator = new ReportChartCreator(ControllerUtils.getTranslations(request),
View Full Code Here

Examples of com.serotonin.m2m2.reports.vo.ReportInstance

72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
        // User is ok. Continue...
        ReportWorkItem item = new ReportWorkItem();

        // Create the database record in process.
        item.reportConfig = report;
        ReportInstance reportInstance = new ReportInstance(report);

        item.user = user;
        item.reportDao = new ReportDao();
        item.reportDao.saveReportInstance(reportInstance);

        // Start the report work item out of process.
        item.reportInstance = reportInstance;
        Common.backgroundProcessing.addWorkItem(item);

        LOG.debug("Queued report with id " + report.getId() + ", instance id " + reportInstance.getId());
    }
View Full Code Here

Examples of com.serotonin.m2m2.reports.vo.ReportInstance

149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
   
    class ReportInstanceRowMapper implements RowMapper<ReportInstance> {
        @Override
        public ReportInstance mapRow(ResultSet rs, int rowNum) throws SQLException {
            int i = 0;
            ReportInstance ri = new ReportInstance();
            ri.setId(rs.getInt(++i));
            ri.setUserId(rs.getInt(++i));
            ri.setReportId(rs.getInt(++i));
            ri.setName(rs.getString(++i));
            ri.setTemplateFile(rs.getString(++i));
            ri.setIncludeEvents(rs.getInt(++i));
            ri.setIncludeUserComments(charToBool(rs.getString(++i)));
            ri.setReportStartTime(rs.getLong(++i));
            ri.setReportEndTime(rs.getLong(++i));
            ri.setRunStartTime(rs.getLong(++i));
            ri.setRunEndTime(rs.getLong(++i));
            ri.setRecordCount(rs.getInt(++i));
            ri.setPreventPurge(charToBool(rs.getString(++i)));
            ri.setXidMap((Map<String, String>)SerializationHelper.readObjectInContext(rs.getBlob(++i).getBinaryStream()));
            return ri;
        }
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.