Package javax.persistence

Examples of javax.persistence.Query.executeUpdate()

639
640
641
642
643
644
645
646
647
648
649
    }

    protected void clearDayHitsByWebsite(Weblog website) throws WebloggerException {
        Query query = strategy.getNamedUpdate("WeblogReferrer.clearDayHitsByWebsite");
        query.setParameter(1, website);
        query.executeUpdate();
    }

    protected List getBlackListedReferer(String[] blacklist) throws
            WebloggerException {
        StringBuffer queryString = getQueryStringForBlackList(blacklist);
View Full Code Here
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
       
        // delete all bad counts
        Query removeq = strategy.getNamedUpdate(
                "WeblogEntryTagAggregate.removeByTotalLessEqual");
        removeq.setParameter(1, new Integer(0));
        removeq.executeUpdate();
    }
   
    /**
     * @inheritDoc
     */
 
View Full Code Here
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
    /**
     * @inheritDoc
     */
    public void resetAllHitCounts() throws WebloggerException {      
        Query q = strategy.getNamedUpdate("WeblogHitCount.updateDailyHitCountZero");
        q.executeUpdate();
    }
   
    /**
     * @inheritDoc
     */
 
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
    public void removeAutoPing(PingTarget pingTarget, Weblog website) throws WebloggerException {
        Query q = strategy.getNamedUpdate("AutoPing.removeByPingTarget&Website");
        q.setParameter(1, pingTarget);
        q.setParameter(2, website);
        q.executeUpdate();
    }

    public void removeAutoPings(Collection autopings) throws WebloggerException {
        strategy.removeAll(autopings);
    }
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
       
        // delete all weblog tag aggregates
        Query removeAggs= strategy.getNamedUpdate(
                "WeblogEntryTagAggregate.removeByWeblog");
        removeAggs.setParameter(1, website);
        removeAggs.executeUpdate();
       
        // delete all bad counts
        Query removeCounts = strategy.getNamedUpdate(
                "WeblogEntryTagAggregate.removeByTotalLessEqual");
        removeCounts.setParameter(1, new Integer(0));
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
       
        // delete all bad counts
        Query removeCounts = strategy.getNamedUpdate(
                "WeblogEntryTagAggregate.removeByTotalLessEqual");
        removeCounts.setParameter(1, new Integer(0));
        removeCounts.executeUpdate();
       
       
        // Remove the website's ping queue entries
        Query q = strategy.getNamedQuery("PingQueueEntry.getByWebsite");
        q.setParameter(1, website);
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
                    entityManager.remove(pair);
            } else {
                // delete all entities
                Query query = entityManager.createQuery("DELETE FROM KVPair k");

                query.executeUpdate();
            }
        } else if (keyIsValid) {
            KVPair pair = entityManager.find(KVPair.class, key);

            if (pair == null) {
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
  }

  private static void deleteAllExistingData(EntityManager em) {
    log.info("Deleting existing books");
    Query bookQuery = em.createQuery("delete from Book");
    bookQuery.executeUpdate();
   
    Query authorQuery = em.createQuery("delete from Author");
    authorQuery.executeUpdate();
   
    log.info("Deleting existing authors");
View Full Code Here
103
104
105
106
107
108
109
110
111
112
    log.info("Deleting existing books");
    Query bookQuery = em.createQuery("delete from Book");
    bookQuery.executeUpdate();
   
    Query authorQuery = em.createQuery("delete from Author");
    authorQuery.executeUpdate();
   
    log.info("Deleting existing authors");
  } 
}
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
            update = "update Employee a set a.hireTimestamp = {ts '2009-08-25 00:00:00.123'} where a.empId = 1";
        } else {
            update = "update Employee a set a.hireTimestamp = {ts '2009-08-25 00:00:00.123456'} where a.empId = 1";
        }
        Query q = em.createQuery(update);
        int updateCnt = q.executeUpdate();
        em.getTransaction().commit();
        Assert.assertEquals(1, updateCnt);
        em.close();
    }
   
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.