src/cx/fbn/nevernote/sql/WatchFolderTable.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 java.util.List;\r
  24 \r
  25 import cx.fbn.nevernote.Global;\r
  26 import cx.fbn.nevernote.sql.requests.WatchFolderRequest;\r
  27 import cx.fbn.nevernote.sql.runners.WatchFolderRecord;\r
  28 import cx.fbn.nevernote.utilities.ListManager;\r
  29 \r
  30 public class WatchFolderTable {\r
  31         ListManager parent;\r
  32         int id;\r
  33         \r
  34         // Constructor\r
  35         public WatchFolderTable(int i) {\r
  36                 id = i;\r
  37         }\r
  38         // Create the table\r
  39         public void createTable() {\r
  40                 WatchFolderRequest request = new WatchFolderRequest();\r
  41                 request.requestor_id = id;\r
  42                 request.type = WatchFolderRequest.Create_Tables;\r
  43                 Global.dbRunner.addWork(request);\r
  44         }\r
  45         // Drop the table\r
  46         public void dropTable() {\r
  47                 WatchFolderRequest request = new WatchFolderRequest();\r
  48                 request.requestor_id = id;\r
  49                 request.type = WatchFolderRequest.Drop_Tables;\r
  50                 Global.dbRunner.addWork(request);\r
  51         }\r
  52         // Add an item to the deleted table\r
  53         public void addWatchFolder(String folder, String notebook, boolean keep, int depth) {\r
  54                 WatchFolderRequest request = new WatchFolderRequest();\r
  55                 request.requestor_id = id;\r
  56                 request.string1 = folder;\r
  57                 request.string2 = notebook;\r
  58                 request.bool1 = keep;\r
  59                 request.int1 = depth;\r
  60                 request.type = WatchFolderRequest.Add_Watch_Folder;\r
  61                 Global.dbRunner.addWork(request);\r
  62         }\r
  63         public List<WatchFolderRecord> getAll() {\r
  64                 WatchFolderRequest request = new WatchFolderRequest();\r
  65                 request.requestor_id = id;\r
  66                 request.type = WatchFolderRequest.Get_All;\r
  67                 Global.dbRunner.addWork(request);\r
  68                 Global.dbClientWait(id);\r
  69                 WatchFolderRequest req = Global.dbRunner.watchFolderResponse.get(id).copy();\r
  70                 return req.responseWatchFolders;\r
  71         }\r
  72         public void expungeFolder(String folder) {\r
  73                 WatchFolderRequest request = new WatchFolderRequest();\r
  74                 request.requestor_id = id;\r
  75                 request.string1 = folder;\r
  76                 request.type = WatchFolderRequest.Expunge_Folder;\r
  77                 Global.dbRunner.addWork(request);\r
  78         }\r
  79         public void expungeAll() {\r
  80                 WatchFolderRequest request = new WatchFolderRequest();\r
  81                 request.requestor_id = id;\r
  82                 request.type = WatchFolderRequest.Expunge_All;\r
  83                 Global.dbRunner.addWork(request);\r
  84         }\r
  85         public String getNotebook(String dir) {\r
  86                 WatchFolderRequest request = new WatchFolderRequest();\r
  87                 request.requestor_id = id;\r
  88                 request.type = WatchFolderRequest.Get_Notebook;\r
  89                 request.string1 = dir;\r
  90                 Global.dbRunner.addWork(request);\r
  91                 Global.dbClientWait(id);\r
  92                 WatchFolderRequest req = Global.dbRunner.watchFolderResponse.get(id).copy();\r
  93                 return req.responseString;\r
  94         }\r
  95 \r
  96 }\r