Login | Register
My pages Projects Community openCollabNet

Discussions > cvs > CVS update: /openpsa/addons/FunambolOpenPSAConnector_Maven2_Eclipse/src/java/org/openpsa/sync4j/CalendarSyncSource.java

openpsa
Discussion topic

Back to topic list

CVS update: /openpsa/addons/FunambolOpenPSAConnector_Maven2_Eclipse/src/java/org/openpsa/sync4j/CalendarSyncSource.java

Author juhana
Full name Juhana Hirvilahti
Date 2007-04-13 05:58:12 PDT
Message User: juhana
Date: 2007-04-13 05:58:12-0700
Log:
 Tried to fix getNewGuids() to check event start rather that eventmember metadata_created

File Changes:

Directory: /openpsa/addons/Funa​mbolOpenPSAConnector​_Maven2_Eclipse/src/​java/org/openpsa/syn​c4j/
====================​====================​====================​====================​===============

File [changed]: CalendarSyncSource.java
Url: http://openpsa.tigri​s.org/source/browse/​openpsa/addons/Funam​bolOpenPSAConnector_​Maven2_Eclipse/src/j​ava/org/openpsa/sync​4j/CalendarSyncSourc​e.java?r1=1.2&r2​=1.3
Delta lines: +8 -1
-------------------
--- CalendarSyncSource.java 2007-03-07 02:37:52-0700 1.2
+++ CalendarSyncSource.java 2007-04-13 05:58:10-0700 1.3
@@ -123,10 +123,17 @@
     protected Set getNewGuids(MidgardUser user, Date since)
             throws SyncSourceException, SQLException {
         logger.debug("getNewGuids({})", user);
+ String sql = "select distinct e.guid"
+ + "from eventmember as m, event as e"
+ + "where e.metadata_deleted=0 and m.metadata_deleted=0"
+ + "and m.uid=? and m.eid=e.id"
+ + "and e.start > ?";
+ /*
         String sql = "SELECT DISTINCT r.guid"
             + " FROM eventmember AS m, repligard AS r"
             + " WHERE m.metadata_deleted=0 AND m.uid = ? AND m.eid = r.id AND r.realm = 'event'"
             + " AND m.metadata_created > ?";
+ */
         PreparedStatement ps = prepare(sql);
         try {
             
@@ -322,7 +329,7 @@
                     + " tentative = 0, externalGuid = '',"
                     + " vCalSerialized = 'a:0:{}',"
                     + " orgOpenpsaObtype = 0, orgOpenpsaWgtype = 0,"
- + " orgOpenpsaAccesstype = 102, orgOpenpsaOwnerwg = ''"
+ + " orgOpenpsaOwnerwg = ''"
                     + " WHERE id = ?";
                 PreparedStatement update = prepare(sql);
                 try {

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

CVS update: /openpsa/addons/FunambolOpenPSAConnector_Maven2_Eclipse/src/java/org/openpsa/sync4j/CalendarSyncSource.java juhana Juhana Hirvilahti 2007-04-13 05:58:12 PDT
Messages per page: