src/cx/fbn/nevernote/sql/SyncTable.java

   1 /*\r
   2  * This file is part of NeverNote \r
   3  * Copyright 2009 Randy Baumgarte\r
   4  * \r
   5  * This file may be licensed under the terms of of the\r
   6  * GNU General Public License Version 2 (the ``GPL'').\r
   7  *\r
   8  * Software distributed under the License is distributed\r
   9  * on an ``AS IS'' basis, WITHOUT WARRANTY OF ANY KIND, either\r
  10  * express or implied. See the GPL for the specific language\r
  11  * governing rights and limitations.\r
  12  *\r
  13  * You should have received a copy of the GPL along with this\r
  14  * program. If not, go to http://www.gnu.org/licenses/gpl.html\r
  15  * or write to the Free Software Foundation, Inc.,\r
  16  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.\r
  17  *\r
  18 */\r
  19 \r
  20 \r
  21 package cx.fbn.nevernote.sql;\r
  22 \r
  23 import cx.fbn.nevernote.Global;\r
  24 import cx.fbn.nevernote.sql.requests.SyncRequest;\r
  25 \r
  26 public class SyncTable {\r
  27         int id;\r
  28         \r
  29         // Constructor\r
  30         public SyncTable(int i) {\r
  31                 id = i;\r
  32         }\r
  33         // Create the table\r
  34         public void createTable() {\r
  35                 SyncRequest request = new SyncRequest();\r
  36                 request.requestor_id = id;\r
  37                 request.type = SyncRequest.Create_Table;\r
  38                 Global.dbRunner.addWork(request);\r
  39         }\r
  40         // Drop the table\r
  41         public void dropTable() {\r
  42                 SyncRequest request = new SyncRequest();\r
  43                 request.requestor_id = id;\r
  44                 request.type = SyncRequest.Drop_Table;\r
  45                 Global.dbRunner.addWork(request);\r
  46         }\r
  47         // Set the last sequence date\r
  48         public void setLastSequenceDate(long date) {\r
  49                 SyncRequest request = new SyncRequest();\r
  50                 request.requestor_id = id;\r
  51                 request.type = SyncRequest.Set_Record;\r
  52                 request.key = "LastSequenceDate";\r
  53                 request.value = new Long(date).toString();\r
  54                 Global.dbRunner.addWork(request);\r
  55         }\r
  56         // Set the last sequence date\r
  57         public void setUpdateSequenceNumber(int number) {\r
  58                 SyncRequest request = new SyncRequest();\r
  59                 request.requestor_id = id;\r
  60                 request.type = SyncRequest.Set_Record;\r
  61                 request.key = "UpdateSequenceNumber";\r
  62                 request.value = new Integer(number).toString();\r
  63                 Global.dbRunner.addWork(request);\r
  64         }\r
  65         // get last sequence date\r
  66         public long getLastSequenceDate() {\r
  67                 SyncRequest request = new SyncRequest();\r
  68                 request.requestor_id = id;\r
  69                 request.type = SyncRequest.Get_Record;\r
  70                 request.key = "LastSequenceDate";\r
  71                 Global.dbRunner.addWork(request);\r
  72                 Global.dbClientWait(id);\r
  73                 SyncRequest req = Global.dbRunner.syncResponse.get(id).copy();\r
  74                 Long date = new Long(req.responseValue);\r
  75                 return date;\r
  76         }\r
  77         // Get invalid attributes for a given element\r
  78         public int getUpdateSequenceNumber() {\r
  79                 SyncRequest request = new SyncRequest();\r
  80                 request.requestor_id = id;\r
  81                 request.type = SyncRequest.Get_Record;\r
  82                 request.key = "UpdateSequenceNumber";\r
  83                 Global.dbRunner.addWork(request);\r
  84                 Global.dbClientWait(id);\r
  85                 SyncRequest req = Global.dbRunner.syncResponse.get(id).copy();\r
  86                 Integer number = new Integer(req.responseValue);\r
  87                 return number;\r
  88         }\r
  89 \r
  90         \r
  91         \r
  92 \r
  93 }\r