Examples of VisitStats

Examples of com.salas.bb.persistence.domain.VisitStats

2975
2976
2977
2978
2979
2980
2981
2982
2983
2984
2985
                rs = stmt.executeQuery();

                stats = new LinkedList<VisitStats>();
                while (rs.next())
                {
                    stats.add(new VisitStats(
                        rs.getInt("GUIDEID"),
                        rs.getString("TITLE"),
                        rs.getLong("COUNT_TOTAL"),
                        rs.getLong("COUNT_RESET"),
                        rs.getLong("INIT_TIME"),
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

3036
3037
3038
3039
3040
3041
3042
3043
3044
3045
3046
                rs = stmt.executeQuery();

                stats = new LinkedList<VisitStats>();
                while (rs.next())
                {
                    stats.add(new VisitStats(
                        rs.getInt("FEEDID"),
                        rs.getString("TITLE"),
                        rs.getLong("COUNT_TOTAL"),
                        rs.getLong("COUNT_RESET"),
                        rs.getLong("INIT_TIME"),
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

81
82
83
84
85
86
87
88
89
90
91
92
93
94
     */
    public void testAddGuide()
        throws PersistenceException, SQLException
    {
        // Check if the row is there
        VisitStats stats = getGuideVisitStats(guide.getID());
        assertNotNull(stats);
        assertEquals(0, stats.getCountTotal());
        assertEquals(0, stats.getCountReset());
        assertTrue("Failed range check. initTime = " + stats.getInitTime() + ", now=" + creationTime,
            Math.abs(stats.getInitTime() - creationTime) < MS_RANGE);
        assertTrue("Failed range check. resetTime = " + stats.getResetTime() + ", now=" + creationTime,
            Math.abs(stats.getResetTime() - creationTime) < MS_RANGE);
    }
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

101
102
103
104
105
106
107
108
109
110
111
112
113
114
     */
    public void testAddFeed()
        throws PersistenceException, SQLException
    {
        // Check if the row is there
        VisitStats stats = getFeedVisitStats(feed.getID());
        assertNotNull(stats);
        assertEquals(0, stats.getCountTotal());
        assertEquals(0, stats.getCountReset());
        assertTrue("Failed range check. initTime = " + stats.getInitTime() + ", now=" + creationTime,
            Math.abs(stats.getInitTime() - creationTime) < MS_RANGE);
        assertTrue("Failed range check. resetTime = " + stats.getResetTime() + ", now=" + creationTime,
            Math.abs(stats.getResetTime() - creationTime) < MS_RANGE);
    }
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

118
119
120
121
122
123
124
125
126
127
    {
        // Visit a guide
        pm.guideVisited(guide);

        // Check
        VisitStats stats = getGuideVisitStats(guide.getID());
        assertEquals(guide.getTitle(), stats.getObjectTitle());
        assertEquals(1, stats.getCountTotal());
        assertEquals(1, stats.getCountReset());
    }
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

142
143
144
145
146
147
148
149
150
151
    {
        // Visit a feed
        pm.feedVisited(feed);

        // Check
        VisitStats stats = getFeedVisitStats(feed.getID());
        assertEquals(feed.getTitle(), stats.getObjectTitle());
        assertEquals(1, stats.getCountTotal());
        assertEquals(1, stats.getCountReset());
    }
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
     *
     * @return stats or <code>NULL</code> if row isn't there.
     */
    private VisitStats getGuideVisitStats(long id)
    {
        VisitStats stats = null;

        try
        {
            Statement stmt = pm.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery(
                "SELECT GS.*, G.TITLE TITLE " +
                "FROM GUIDESTATS GS, GUIDES G " +
                "WHERE G.ID=GUIDEID AND GUIDEID = " + id);
            if (rs.next())
            {
                stats = new VisitStats((int)id,
                    rs.getString("TITLE"),
                    rs.getLong("COUNT_TOTAL"),
                    rs.getLong("COUNT_RESET"),
                    rs.getLong("INIT_TIME"),
                    rs.getLong("RESET_TIME"));
View Full Code Here

Examples of com.salas.bb.persistence.domain.VisitStats

394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
     *
     * @return stats or <code>NULL</code> if row isn't there.
     */
    private VisitStats getFeedVisitStats(long id)
    {
        VisitStats stats = null;

        try
        {
            Statement stmt = pm.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery(
                "SELECT FS.*, COALESCE(DF.TITLE, DF.XMLURL, QF.TITLE, SF.TITLE) TITLE " +
                "FROM FEEDSTATS FS LEFT JOIN DIRECTFEEDS DF ON DF.FEEDID=FS.FEEDID " +
                    "LEFT JOIN QUERYFEEDS QF ON QF.FEEDID=FS.FEEDID " +
                    "LEFT JOIN SEARCHFEEDS SF ON SF.FEEDID=FS.FEEDID " +
                "WHERE FEEDID = " + id);
            if (rs.next())
            {
                stats = new VisitStats((int)id,
                    rs.getString("TITLE"),
                    rs.getLong("COUNT_TOTAL"),
                    rs.getLong("COUNT_RESET"),
                    rs.getLong("INIT_TIME"),
                    rs.getLong("RESET_TIME"));
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.