Package com.salas.bb.persistence.domain

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
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
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
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
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
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
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
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

Related Classes of com.salas.bb.persistence.domain.VisitStats

  • com.salas.bb.persistence.backend.HsqlPersistenceManager
  • com.salas.bb.persistence.backend.TestHsqlPersistenceManagerStats
    • 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.