+ // Load notebooks from the database\r
+ public LinkedNotebook getNotebook(String guid) {\r
+ LinkedNotebook tempNotebook;\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("Select guid, shareName, username, shardID, shareKey, uri " +\r
+ " from LinkedNotebook where guid=:guid");\r
+ if (!check)\r
+ logger.log(logger.EXTREME, "Notebook SQL retrieve notebook prepare has failed.");\r
+ query.bindValue(":guid", guid);\r
+ query.exec();\r
+ while (query.next()) {\r
+ tempNotebook = new LinkedNotebook();\r
+ tempNotebook.setGuid(query.valueString(0));\r
+ tempNotebook.setShareName(query.valueString(1));\r
+ tempNotebook.setUsername(query.valueString(2));\r
+ tempNotebook.setShardId(query.valueString(3));\r
+ tempNotebook.setShareKey(query.valueString(4));\r
+ tempNotebook.setUri(query.valueString(5));\r
+ return tempNotebook;\r
+ } \r
+ return null;\r
+ } \r
+ // Load notebooks from the database\r
+ public LinkedNotebook getByNotebookGuid(String guid) {\r
+ LinkedNotebook tempNotebook;\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("Select guid, shareName, username, shardID, shareKey, uri " +\r
+ " from LinkedNotebook where notebookguid=:guid");\r
+ if (!check)\r
+ logger.log(logger.EXTREME, "Notebook SQL retrieve notebook prepare has failed.");\r
+ query.bindValue(":guid", guid);\r
+ query.exec();\r
+ while (query.next()) {\r
+ tempNotebook = new LinkedNotebook();\r
+ tempNotebook.setGuid(query.valueString(0));\r
+ tempNotebook.setShareName(query.valueString(1));\r
+ tempNotebook.setUsername(query.valueString(2));\r
+ tempNotebook.setShardId(query.valueString(3));\r
+ tempNotebook.setShareKey(query.valueString(4));\r
+ tempNotebook.setUri(query.valueString(5));\r
+ return tempNotebook;\r
+ } \r
+ return null;\r
+ }\r
+ // Get last sequence date for the notebook\r
+ public long getLastSequenceDate(String guid) {\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("Select LastSequenceDate " \r
+ +"from LinkedNotebook where guid=:guid");\r
+ query.bindValue(":guid", guid);\r
+ check = query.exec();\r
+ if (!check)\r
+ logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve last sequence date has failed.");\r
+ if (query.next()) {\r
+ return query.valueLong(0);\r
+ } \r
+ return 0;\r
+ } \r
+ // Get a guid by uri\r
+ public String getNotebookGuid(String guid) {\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("Select notebookGuid " \r
+ +"from LinkedNotebook where guid=:guid");\r
+ query.bindValue(":guid", guid);\r
+ check = query.exec();\r
+ if (!check)\r
+ logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve of notebookguid by guidhas failed.");\r
+ if (query.next()) {\r
+ return query.valueString(0);\r
+ } \r
+ return null;\r
+ } \r
+ // get last sequence numeber\r
+ public int getLastSequenceNumber(String guid) {\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("Select LastSequenceNumber " \r
+ +"from LinkedNotebook where guid=:guid");\r
+ query.bindValue(":guid", guid);\r
+ check = query.exec();\r
+ if (!check)\r
+ logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");\r
+ while (query.next()) {\r
+ return query.valueInteger(0);\r
+ } \r
+ return 0;\r
+ } \r