From c7e968ac93a332d19d17ae8202b38298728e0c8f Mon Sep 17 00:00:00 2001 From: Jinkun Jang Date: Wed, 13 Mar 2013 01:45:55 +0900 Subject: [PATCH] Tizen 2.1 base --- AUTHORS | 1 + CMakeLists.txt | 98 +++ LICENSE.APLv2 | 202 ++++++ NOTICE.APLv2 | 3 + capi-web-favorites.manifest | 5 + capi-web-favorites.pc.in | 14 + debian/capi-web-favorites-dev.install | 4 + debian/capi-web-favorites-dev.postinst | 1 + debian/capi-web-favorites.install | 1 + debian/capi-web-favorites.postinst | 1 + debian/changelog | 7 + debian/compat | 1 + debian/control | 22 + debian/rules | 71 ++ include/favorites.h | 316 +++++++++ include/favorites_private.h | 133 ++++ packaging/capi-web-favorites.spec | 97 +++ src/favorites_bookmark.c | 1150 ++++++++++++++++++++++++++++++++ src/favorites_history.c | 384 +++++++++++ 19 files changed, 2511 insertions(+) create mode 100644 AUTHORS create mode 100755 CMakeLists.txt create mode 100755 LICENSE.APLv2 create mode 100755 NOTICE.APLv2 create mode 100644 capi-web-favorites.manifest create mode 100755 capi-web-favorites.pc.in create mode 100644 debian/capi-web-favorites-dev.install create mode 100644 debian/capi-web-favorites-dev.postinst create mode 100644 debian/capi-web-favorites.install create mode 100644 debian/capi-web-favorites.postinst create mode 100755 debian/changelog create mode 100755 debian/compat create mode 100644 debian/control create mode 100755 debian/rules create mode 100644 include/favorites.h create mode 100644 include/favorites_private.h create mode 100755 packaging/capi-web-favorites.spec create mode 100644 src/favorites_bookmark.c create mode 100644 src/favorites_history.c diff --git a/AUTHORS b/AUTHORS new file mode 100644 index 0000000..fa388cd --- /dev/null +++ b/AUTHORS @@ -0,0 +1 @@ +Sangpyo Kim diff --git a/CMakeLists.txt b/CMakeLists.txt new file mode 100755 index 0000000..3c93fe5 --- /dev/null +++ b/CMakeLists.txt @@ -0,0 +1,98 @@ +SET_TARGET_PROPERTIES(${fw_name} + PROPERTIES + VERSION ${FULLVER} + SOVERSION ${MAJORVER} + CLEAN_DIRECT_OUTPUT 1 +) + +CMAKE_MINIMUM_REQUIRED(VERSION 2.6) +SET(fw_name "capi-web-favorites") + +PROJECT(${fw_name}) + +SET(CMAKE_INSTALL_PREFIX /usr) +SET(PREFIX ${CMAKE_INSTALL_PREFIX}) + +SET(INC_DIR include) +INCLUDE_DIRECTORIES(${INC_DIR}) + +SET(requires "db-util dlog sqlite3 evas capi-base-common") +SET(pc_requires "capi-base-common") + +INCLUDE(FindPkgConfig) +pkg_check_modules(${fw_name} REQUIRED ${requires}) +FOREACH(flag ${${fw_name}_CFLAGS}) + SET(EXTRA_CFLAGS "${EXTRA_CFLAGS} ${flag}") +ENDFOREACH(flag) + +SET(CMAKE_C_FLAGS "${CMAKE_C_FLAGS} ${EXTRA_CFLAGS} -fPIC -Wall -Werror") +SET(CMAKE_C_FLAGS_DEBUG "-O0 -g") + +IF("${ARCH}" STREQUAL "arm") + ADD_DEFINITIONS("-DTARGET") +ENDIF("${ARCH}" STREQUAL "arm") + +ADD_DEFINITIONS("-DPREFIX=\"${CMAKE_INSTALL_PREFIX}\"") +ADD_DEFINITIONS("-DTIZEN_DEBUG") +ADD_DEFINITIONS( + -DLOG_TAG=\"favorites\" +) + +SET(CMAKE_EXE_LINKER_FLAGS "-Wl,--as-needed -Wl,--rpath=/usr/lib") + +aux_source_directory(src SOURCES) +ADD_LIBRARY(${fw_name} SHARED ${SOURCES}) + +TARGET_LINK_LIBRARIES(${fw_name} ${${fw_name}_LDFLAGS}) + +INSTALL(TARGETS ${fw_name} DESTINATION lib) +INSTALL( + DIRECTORY ${INC_DIR}/ DESTINATION include/web + FILES_MATCHING + PATTERN "*_private.h" EXCLUDE + PATTERN "${INC_DIR}/*.h" + ) + +SET(PC_NAME ${fw_name}) +SET(PC_REQUIRED ${pc_requires}) +SET(PC_LDFLAGS -l${fw_name}) +SET(PC_CFLAGS -I\${includedir}/web) + +CONFIGURE_FILE( + ${fw_name}.pc.in + ${CMAKE_CURRENT_SOURCE_DIR}/${fw_name}.pc + @ONLY +) +INSTALL(FILES ${CMAKE_CURRENT_SOURCE_DIR}/${fw_name}.pc DESTINATION lib/pkgconfig) + +IF(UNIX) + +ADD_CUSTOM_TARGET (distclean @echo cleaning for source distribution) +ADD_CUSTOM_COMMAND( + DEPENDS clean + COMMENT "distribution clean" + COMMAND find + ARGS . + -not -name config.cmake -and \( + -name tester.c -or + -name Testing -or + -name CMakeFiles -or + -name cmake.depends -or + -name cmake.check_depends -or + -name CMakeCache.txt -or + -name cmake.check_cache -or + -name *.cmake -or + -name Makefile -or + -name core -or + -name core.* -or + -name gmon.out -or + -name install_manifest.txt -or + -name *.pc -or + -name *~ \) + | grep -v TC | xargs rm -rf + TARGET distclean + VERBATIM +) + +ENDIF(UNIX) + diff --git a/LICENSE.APLv2 b/LICENSE.APLv2 new file mode 100755 index 0000000..d645695 --- /dev/null +++ b/LICENSE.APLv2 @@ -0,0 +1,202 @@ + + Apache License + Version 2.0, January 2004 + http://www.apache.org/licenses/ + + TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION + + 1. Definitions. + + "License" shall mean the terms and conditions for use, reproduction, + and distribution as defined by Sections 1 through 9 of this document. + + "Licensor" shall mean the copyright owner or entity authorized by + the copyright owner that is granting the License. + + "Legal Entity" shall mean the union of the acting entity and all + other entities that control, are controlled by, or are under common + control with that entity. For the purposes of this definition, + "control" means (i) the power, direct or indirect, to cause the + direction or management of such entity, whether by contract or + otherwise, or (ii) ownership of fifty percent (50%) or more of the + outstanding shares, or (iii) beneficial ownership of such entity. + + "You" (or "Your") shall mean an individual or Legal Entity + exercising permissions granted by this License. + + "Source" form shall mean the preferred form for making modifications, + including but not limited to software source code, documentation + source, and configuration files. + + "Object" form shall mean any form resulting from mechanical + transformation or translation of a Source form, including but + not limited to compiled object code, generated documentation, + and conversions to other media types. + + "Work" shall mean the work of authorship, whether in Source or + Object form, made available under the License, as indicated by a + copyright notice that is included in or attached to the work + (an example is provided in the Appendix below). + + "Derivative Works" shall mean any work, whether in Source or Object + form, that is based on (or derived from) the Work and for which the + editorial revisions, annotations, elaborations, or other modifications + represent, as a whole, an original work of authorship. For the purposes + of this License, Derivative Works shall not include works that remain + separable from, or merely link (or bind by name) to the interfaces of, + the Work and Derivative Works thereof. + + "Contribution" shall mean any work of authorship, including + the original version of the Work and any modifications or additions + to that Work or Derivative Works thereof, that is intentionally + submitted to Licensor for inclusion in the Work by the copyright owner + or by an individual or Legal Entity authorized to submit on behalf of + the copyright owner. For the purposes of this definition, "submitted" + means any form of electronic, verbal, or written communication sent + to the Licensor or its representatives, including but not limited to + communication on electronic mailing lists, source code control systems, + and issue tracking systems that are managed by, or on behalf of, the + Licensor for the purpose of discussing and improving the Work, but + excluding communication that is conspicuously marked or otherwise + designated in writing by the copyright owner as "Not a Contribution." + + "Contributor" shall mean Licensor and any individual or Legal Entity + on behalf of whom a Contribution has been received by Licensor and + subsequently incorporated within the Work. + + 2. Grant of Copyright License. Subject to the terms and conditions of + this License, each Contributor hereby grants to You a perpetual, + worldwide, non-exclusive, no-charge, royalty-free, irrevocable + copyright license to reproduce, prepare Derivative Works of, + publicly display, publicly perform, sublicense, and distribute the + Work and such Derivative Works in Source or Object form. + + 3. Grant of Patent License. Subject to the terms and conditions of + this License, each Contributor hereby grants to You a perpetual, + worldwide, non-exclusive, no-charge, royalty-free, irrevocable + (except as stated in this section) patent license to make, have made, + use, offer to sell, sell, import, and otherwise transfer the Work, + where such license applies only to those patent claims licensable + by such Contributor that are necessarily infringed by their + Contribution(s) alone or by combination of their Contribution(s) + with the Work to which such Contribution(s) was submitted. If You + institute patent litigation against any entity (including a + cross-claim or counterclaim in a lawsuit) alleging that the Work + or a Contribution incorporated within the Work constitutes direct + or contributory patent infringement, then any patent licenses + granted to You under this License for that Work shall terminate + as of the date such litigation is filed. + + 4. Redistribution. You may reproduce and distribute copies of the + Work or Derivative Works thereof in any medium, with or without + modifications, and in Source or Object form, provided that You + meet the following conditions: + + (a) You must give any other recipients of the Work or + Derivative Works a copy of this License; and + + (b) You must cause any modified files to carry prominent notices + stating that You changed the files; and + + (c) You must retain, in the Source form of any Derivative Works + that You distribute, all copyright, patent, trademark, and + attribution notices from the Source form of the Work, + excluding those notices that do not pertain to any part of + the Derivative Works; and + + (d) If the Work includes a "NOTICE" text file as part of its + distribution, then any Derivative Works that You distribute must + include a readable copy of the attribution notices contained + within such NOTICE file, excluding those notices that do not + pertain to any part of the Derivative Works, in at least one + of the following places: within a NOTICE text file distributed + as part of the Derivative Works; within the Source form or + documentation, if provided along with the Derivative Works; or, + within a display generated by the Derivative Works, if and + wherever such third-party notices normally appear. The contents + of the NOTICE file are for informational purposes only and + do not modify the License. You may add Your own attribution + notices within Derivative Works that You distribute, alongside + or as an addendum to the NOTICE text from the Work, provided + that such additional attribution notices cannot be construed + as modifying the License. + + You may add Your own copyright statement to Your modifications and + may provide additional or different license terms and conditions + for use, reproduction, or distribution of Your modifications, or + for any such Derivative Works as a whole, provided Your use, + reproduction, and distribution of the Work otherwise complies with + the conditions stated in this License. + + 5. Submission of Contributions. Unless You explicitly state otherwise, + any Contribution intentionally submitted for inclusion in the Work + by You to the Licensor shall be under the terms and conditions of + this License, without any additional terms or conditions. + Notwithstanding the above, nothing herein shall supersede or modify + the terms of any separate license agreement you may have executed + with Licensor regarding such Contributions. + + 6. Trademarks. This License does not grant permission to use the trade + names, trademarks, service marks, or product names of the Licensor, + except as required for reasonable and customary use in describing the + origin of the Work and reproducing the content of the NOTICE file. + + 7. Disclaimer of Warranty. Unless required by applicable law or + agreed to in writing, Licensor provides the Work (and each + Contributor provides its Contributions) on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or + implied, including, without limitation, any warranties or conditions + of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A + PARTICULAR PURPOSE. You are solely responsible for determining the + appropriateness of using or redistributing the Work and assume any + risks associated with Your exercise of permissions under this License. + + 8. Limitation of Liability. In no event and under no legal theory, + whether in tort (including negligence), contract, or otherwise, + unless required by applicable law (such as deliberate and grossly + negligent acts) or agreed to in writing, shall any Contributor be + liable to You for damages, including any direct, indirect, special, + incidental, or consequential damages of any character arising as a + result of this License or out of the use or inability to use the + Work (including but not limited to damages for loss of goodwill, + work stoppage, computer failure or malfunction, or any and all + other commercial damages or losses), even if such Contributor + has been advised of the possibility of such damages. + + 9. Accepting Warranty or Additional Liability. While redistributing + the Work or Derivative Works thereof, You may choose to offer, + and charge a fee for, acceptance of support, warranty, indemnity, + or other liability obligations and/or rights consistent with this + License. However, in accepting such obligations, You may act only + on Your own behalf and on Your sole responsibility, not on behalf + of any other Contributor, and only if You agree to indemnify, + defend, and hold each Contributor harmless for any liability + incurred by, or claims asserted against, such Contributor by reason + of your accepting any such warranty or additional liability. + + END OF TERMS AND CONDITIONS + + APPENDIX: How to apply the Apache License to your work. + + To apply the Apache License to your work, attach the following + boilerplate notice, with the fields enclosed by brackets "[]" + replaced with your own identifying information. (Don't include + the brackets!) The text should be enclosed in the appropriate + comment syntax for the file format. We also recommend that a + file or class name and description of purpose be included on the + same "printed page" as the copyright notice for easier + identification within third-party archives. + + Copyright [yyyy] [name of copyright owner] + + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. diff --git a/NOTICE.APLv2 b/NOTICE.APLv2 new file mode 100755 index 0000000..1c1a4d0 --- /dev/null +++ b/NOTICE.APLv2 @@ -0,0 +1,3 @@ +Copyright (c) 2012 Samsung Electronics Co., Ltd. All rights reserved. +Except as noted, this software is licensed under Apache License, Version 2. +Please, see the LICENSE.APLv2 file for Apache License, Version 2 terms and conditions. diff --git a/capi-web-favorites.manifest b/capi-web-favorites.manifest new file mode 100644 index 0000000..97e8c31 --- /dev/null +++ b/capi-web-favorites.manifest @@ -0,0 +1,5 @@ + + + + + diff --git a/capi-web-favorites.pc.in b/capi-web-favorites.pc.in new file mode 100755 index 0000000..71f9891 --- /dev/null +++ b/capi-web-favorites.pc.in @@ -0,0 +1,14 @@ + +# Package Information for pkg-config + +prefix=@PREFIX@ +exec_prefix=/usr +libdir=/usr/lib +includedir=/usr/include/web + +Name: @PC_NAME@ +Description: Internet bookmark and history control API +Version: @VERSION@ +Requires: @PC_REQUIRED@ +Libs: -L${libdir} @PC_LDFLAGS@ +Cflags: -I${includedir} diff --git a/debian/capi-web-favorites-dev.install b/debian/capi-web-favorites-dev.install new file mode 100644 index 0000000..761a28b --- /dev/null +++ b/debian/capi-web-favorites-dev.install @@ -0,0 +1,4 @@ +/usr/include/* +/usr/include/*/* +/usr/lib/pkgconfig/*.pc + diff --git a/debian/capi-web-favorites-dev.postinst b/debian/capi-web-favorites-dev.postinst new file mode 100644 index 0000000..1a24852 --- /dev/null +++ b/debian/capi-web-favorites-dev.postinst @@ -0,0 +1 @@ +#!/bin/sh diff --git a/debian/capi-web-favorites.install b/debian/capi-web-favorites.install new file mode 100644 index 0000000..4a755a4 --- /dev/null +++ b/debian/capi-web-favorites.install @@ -0,0 +1 @@ +/usr/lib/lib*.so* diff --git a/debian/capi-web-favorites.postinst b/debian/capi-web-favorites.postinst new file mode 100644 index 0000000..1a24852 --- /dev/null +++ b/debian/capi-web-favorites.postinst @@ -0,0 +1 @@ +#!/bin/sh diff --git a/debian/changelog b/debian/changelog new file mode 100755 index 0000000..da62784 --- /dev/null +++ b/debian/changelog @@ -0,0 +1,7 @@ +capi-web-favorites (0.0.1) unstable; urgency=low + + * Git: framework/api/favorites + * Tag: capi-web-favorites_0.0.1 + * first upload + + -- Sangpyo Kim Wed, 24 Aug 2011 21:12:42 +0900 diff --git a/debian/compat b/debian/compat new file mode 100755 index 0000000..7ed6ff8 --- /dev/null +++ b/debian/compat @@ -0,0 +1 @@ +5 diff --git a/debian/control b/debian/control new file mode 100644 index 0000000..a6d7bf3 --- /dev/null +++ b/debian/control @@ -0,0 +1,22 @@ + +Source: capi-web-favorites +Section: libs +Priority: extra +Uploaders: Sangpyo Kim , Inbum Chang +Maintainer: Sangpyo Kim , Inbum Chang +Build-Depends: debhelper (>= 5), dlog-dev, libslp-db-util-dev, libsqlite3-dev, libevas-dev(>=0.1), capi-base-common-dev + +Package: capi-web-favorites +Architecture: any +Depends: ${shlibs:Depends}, ${misc:Depends} +Description: Internet Bookmark and history control API + +Package: capi-web-favorites-dev +Architecture: any +Depends: ${shlibs:Depends}, ${misc:Depends}, capi-web-favorites(= ${Source-Version}), capi-base-common-dev +Description: Internet Bookmark and history control API for Developer + +Package: capi-web-favorites-dbg +Architecture: any +Depends: ${shlibs:Depends}, ${misc:Depends}, capi-web-favorites(= ${Source-Version}) +Description: Internet Bookmark and history control API (unstripped) diff --git a/debian/rules b/debian/rules new file mode 100755 index 0000000..e28a316 --- /dev/null +++ b/debian/rules @@ -0,0 +1,71 @@ +#!/usr/bin/make -f + +FULLVER ?= $(shell dpkg-parsechangelog | grep Version: | cut -d ' ' -f 2 | cut -d '-' -f 1) +MAJORVER ?= $(shell echo $(FULLVER) | cut -d '.' -f 1) +CFLAGS = -Wall -g + +ifneq (,$(findstring noopt,$(DEB_BUILD_OPTIONS))) + CFLAGS += -O0 +else + CFLAGS += -O2 +endif +CMAKE_ROOT_DIR ?= $(CURDIR) +CMAKE_BUILD_DIR ?= $(CURDIR)/cmake_build_tmp + +configure: configure-stamp +configure-stamp: + dh_testdir + mkdir -p $(CMAKE_BUILD_DIR) && cd $(CMAKE_BUILD_DIR) && cmake .. -DFULLVER=${FULLVER} -DMAJORVER=${MAJORVER} + touch configure-stamp + +build: build-stamp +build-stamp: configure-stamp + dh_testdir + cd $(CMAKE_BUILD_DIR) && $(MAKE) + touch $@ + +clean: + cd $(CMAKE_ROOT_DIR) + dh_testdir + dh_testroot + rm -f build-stamp configure-stamp + # Add here commands to clean up after the build process. + rm -f + rm -rf $(CMAKE_BUILD_DIR) + dh_clean + +install: build + dh_testdir + dh_testroot + dh_clean -k + dh_installdirs + + # Add here commands to install the package into debian/wavplayer. + cd $(CMAKE_BUILD_DIR) && $(MAKE) DESTDIR=$(CURDIR)/debian/tmp install + +# Build architecture-independent files here. +binary-indep: build install +# We have nothing to do by default. + +# Build architecture-dependent files here. +binary-arch: build install + dh_testdir + dh_testroot + dh_installchangelogs + dh_installdocs + dh_installexamples + dh_install --sourcedir=debian/tmp + dh_installman + dh_link + dh_strip --dbg-package=capi-web-favorites-dbg + dh_fixperms + dh_makeshlibs + dh_installdeb + dh_shlibdeps + dh_gencontrol + dh_md5sums + dh_builddeb + +binary: binary-indep binary-arch +.PHONY: build clean binary-indep binary-arch binary install configure + diff --git a/include/favorites.h b/include/favorites.h new file mode 100644 index 0000000..b16122b --- /dev/null +++ b/include/favorites.h @@ -0,0 +1,316 @@ +/* + * Copyright (c) 2012 Samsung Electronics Co., Ltd All Rights Reserved + * + * Licensed under the Apache License, Version 2.0 (the License); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an AS IS BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +#ifndef __TIZEN_WEB_FAVORITES_H__ +#define __TIZEN_WEB_FAVORITES_H__ + +#include +#include +#include +#include + +#ifdef __cplusplus +extern "C" { +#endif +/** + * @addtogroup CAPI_WEB_FAVORITES_MODULE + * @{ + */ + +/** + * @brief Enumerations for favorites error. + */ +typedef enum favorites_error{ + FAVORITES_ERROR_NONE = TIZEN_ERROR_NONE, /**< Successful */ + FAVORITES_ERROR_INVALID_PARAMETER = TIZEN_ERROR_INVALID_PARAMETER,/**< Invalid parameter */ + FAVORITES_ERROR_DB_FAILED = TIZEN_ERROR_WEB_CLASS | 0x62, /**< Database operation failure */ + FAVORITES_ERROR_ITEM_ALREADY_EXIST = TIZEN_ERROR_WEB_CLASS | 0x63 /**< Requested data already exists */ +} favorites_error_e; + +/** + * @brief The structure of bookmark entry in search results. + * + * @details This structure is passed to callback function in all bookmark related + * iterations through list received from search functions. + * + * @see bookmark_foreach_cb() + */ +typedef struct { + char* address; /**< Bookmark URL */ + char* title; /**< The title of the bookmark */ + char* creation_date; /**< The date of creation */ + char* update_date; /**< The last updated date */ + char* visit_date; /**< The last visit date */ + int id; /**< The unique ID of bookmark */ + bool is_folder; /**< property bookmark or folder\n @c true: folder, @c false: bookmark */ + int folder_id; /**< The ID of parent folder */ + int order_index; /**< The order index of bookmarks when show the list at the browser */ + bool editable; /**< The flag of editability\n @c true : writable, @c false: read-only, not ediable */ +} favorites_bookmark_entry_s; + +/** + * @brief Called to get bookmark details for each found bookmark. + * + * @param[in] item The bookmark entry handle or folder entry handle + * @param[in] user_data The user data passed from the foreach function + * + * @return @c true to continue with the next iteration of the loop or @c false to break out of the loop. + * + * @pre favorites_bookmark_foreach() will invoke this callback. + * + * @see favorites_bookmark_foreach() + */ +typedef bool (*favorites_bookmark_foreach_cb)(favorites_bookmark_entry_s *item, void *user_data); + +/** + * @brief Adds an entry to bookmark list. + * + * @remarks If a folder named @a "foldername" doesn't exist, it will be created. + * @remarks The folder named "Bookmarks" is reserved for the root folder. + * @param[in] url Book URL + * @param[in] title The title of the bookmark + * @param[in] folder_name The name of parent folder + * @param[out] bookmark_id: The unique id of the added bookmark + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_ITEM_ALREADY_EXIST Requested data already exists + * + */ +int favorites_bookmark_add_bookmark(const char *url, const char *title, const char *folder_name, int *bookmark_id); + +/** + * @brief Deletes the bookmark item of given bookmark id. + * + * @param[in] bookmark_id The unique ID of bookmark to delete + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_bookmark_delete_bookmark(int bookmark_id); + +/** + * @brief Deletes all bookmarks and sub folders. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_bookmark_delete_all_bookmarks(void); + +/** + * @brief Gets a number of bookmark list items. + * + * @param[out] count The number of bookmarks and sub folders. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * + */ +int favorites_bookmark_get_count(int *count); + +/** + * @brief Retrieves all bookmarks and folders by invoking the given callback function iteratively. + * + * @remarks All bookmarks and folders data are also used by browser application + * @param[in] callback The callback function to invoke + * @param[in] user_data The user data to be passed to the callback function + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + * @post This function invokes bookmark_foreach_cb() repeatedly for each bookmark. + * + * @see bookmark_foreach_cb() + */ +int favorites_bookmark_foreach(favorites_bookmark_foreach_cb callback, void *user_data); + +/** + * @brief Exports a whole bookmark list as a netscape HTML bookmark file. + * + * @param[in] file_path The absolute path of the export file. This must includes html file name. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_bookmark_export_list(const char *file_path); + +/** + * @brief Gets the bookmark's favicon as a evas object type + * + * @param[in] bookmark_id The unique ID of bookmark + * @param[in] evas The given canvas + * @param[out] icon Retrieved favicon evas object of bookmark. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_bookmark_get_favicon(int bookmark_id, Evas *evas, Evas_Object **icon); + +/** + * @brief The structure of history entry in search results. + * + * @details This structure is passed to callback function in all history related + * iterations through list received from search functions. + * + * @see history_foreach_cb() + */ +typedef struct { + char* address; /**< URL history */ + char* title; /**< The title of history */ + int count; /**< The visit count */ + char* visit_date; /**< The last visit date */ + int id; /**< The unique ID of history */ +} favorites_history_entry_s; + +/** + * @brief Called to get history details for each found history. + * + * @param[in] item The history entry handle + * @param[in] user_data The user data passed from the foreach function + * + * @return @c true to continue with the next iteration of the loop or @c false to break out of the loop. + * + * @pre favorites_history_foreach() will invoke this callback. + * + * @see favorites_history_foreach() + */ +typedef bool (*favorites_history_foreach_cb)(favorites_history_entry_s *item, void *user_data); + +/** + * @brief Gets a number of history list items. + * + * @param[out] count The number of histories. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * + */ +int favorites_history_get_count(int *count); + +/** + * @brief Retrieves all histories by invoking the given callback function iteratively. + * + * @param[in] callback The callback function to invoke + * @param[in] user_data The user data to be passed to the callback function + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + * @post This function invokes history_foreach_cb(). + * + * @see history_foreach_cb() + */ +int favorites_history_foreach(favorites_history_foreach_cb callback, void *user_data); + +/** + * @brief Deletes the history item of given history id. + * + * @param[in] history_id The history ID to delete + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_history_delete_history(int history_id); + +/** + * @brief Deletes the history item of given history url. + * + * @param[in] url history url which wants to be deleted + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_history_delete_history_by_url(const char *url); + +/** + * @brief Deletes all histories. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_history_delete_all_histories(void); + +/** + * @brief Deletes all histories accessed with the browser within the specified time period. + * + * @param[in] begin_date The start date of the period + * @param[in] end_date The end date of the period + * + * @remarks Date format must be "yyyy-mm-dd hh:mm:ss" ex: "2000-01-01 01:20:35". + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_history_delete_history_by_term(const char *begin_date, const char *end_date); + +/** + * @brief Gets the history's favicon as an evas object type + * + * @param[in] history_id The unique ID of history item + * @param[in] evas The given canvas + * @param[out] icon Retrieved favicon evas object of bookmark. + * + * @return 0 on success, otherwise a negative error value. + * @retval #FAVORITES_ERROR_NONE Successful + * @retval #FAVORITES_ERROR_INVALID_PARAMETER Invalid parameter + * @retval #FAVORITES_ERROR_DB_FAILED Database failed + * + */ +int favorites_history_get_favicon(int history_id, Evas *evas, Evas_Object **icon); + +/** + * @} + */ + +#ifdef __cplusplus +}; +#endif + +#endif /* __TIZEN_WEB_FAVORITES_H__ */ diff --git a/include/favorites_private.h b/include/favorites_private.h new file mode 100644 index 0000000..0f624de --- /dev/null +++ b/include/favorites_private.h @@ -0,0 +1,133 @@ +/* + * Copyright (c) 2012 Samsung Electronics Co., Ltd All Rights Reserved + * + * Licensed under the Apache License, Version 2.0 (the License); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an AS IS BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +#ifndef __TIZEN_WEB_FAVORITES_PRIVATE_H__ +#define __TIZEN_WEB_FAVORITES_PRIVATE_H__ + +#ifdef __cplusplus +extern "C" { +#endif + +/********************************************** + * Logging macro + **********************************************/ +#define FAVORITES_LOGD(fmt, args...) LOGD(\ + "[%s: %s: %d] "fmt, (rindex(__FILE__, '/')? rindex(__FILE__, '/') + 1 : __FILE__),\ + __FUNCTION__, __LINE__, ##args) +#define FAVORITES_LOGI(fmt, args...) LOGI(\ + "[%s: %s: %d] "fmt, (rindex(__FILE__, '/') ? rindex(__FILE__, '/') + 1 : __FILE__),\ + __FUNCTION__, __LINE__, ##args) +#define FAVORITES_LOGW(fmt, args...) LOGW(\ + "[%s: %s: %d] "fmt, (rindex(__FILE__, '/') ? rindex(__FILE__, '/') + 1 : __FILE__),\ + __FUNCTION__, __LINE__, ##args) +#define FAVORITES_LOGE(fmt, args...) LOGE(\ + "[%s: %s: %d] "fmt, (rindex(__FILE__, '/') ? rindex(__FILE__, '/') + 1 : __FILE__),\ + __FUNCTION__, __LINE__, ##args) +#define FAVORITES_LOGE_IF(cond, fmt, args...) LOGE_IF(cond,\ + "[%s: %s: %d] "fmt, (rindex(__FILE__, '/') ? rindex(__FILE__, '/') + 1 : __FILE__),\ + __FUNCTION__, __LINE__, ##args) + +/********************************************** + * Argument checking macro + **********************************************/ +#define FAVORITES_NULL_ARG_CHECK(_arg_) do { \ + if(_arg_ == NULL) { \ + LOGE("[%s] FAVORITES_ERR_INVALID_PARAMETER(0x%08x)", __FUNCTION__,\ + FAVORITES_ERROR_INVALID_PARAMETER); \ + return FAVORITES_ERROR_INVALID_PARAMETER; \ + } \ +}while(0) + +#define FAVORITES_INVALID_ARG_CHECK(_condition_) do { \ + if(_condition_) { \ + LOGE("[%s] FAVORITES_ERR_INVALID_PARAMETER(0x%08x)", __FUNCTION__,\ + FAVORITES_ERROR_INVALID_PARAMETER); \ + return FAVORITES_ERROR_INVALID_PARAMETER; \ + } \ +}while(0) + +#define _FAVORITES_FREE(_srcx_) { if(NULL != _srcx_) free(_srcx_); } +#define _FAVORITES_STRDUP(_srcx_) (NULL != _srcx_) ? strdup(_srcx_):NULL + +struct bookmark_entry_internal{ + char* address; /**< URL of the bookmark */ + char* title; /**< Title of the bookmark */ + char* creationdate; /**< date of created */ + char* updatedate; /**< date of last updated */ + char* visitdate; /**< date of last visited */ + int id; /**< uniq id of bookmark */ + int is_folder; /**< property bookmark or folder 1: bookmark 1: folder */ + int folder_id; /**< parent folder id */ + int orderIndex; /**< order sequence */ + int editable; /**< flag of editability 1 : WRITABLE 0: READ ONLY */ +}; +typedef struct bookmark_entry_internal bookmark_entry_internal_s; +typedef struct bookmark_entry_internal *bookmark_entry_internal_h; + +struct bookmark_list { + int count; + bookmark_entry_internal_h item; +}; + +/** + * @brief The bookmark entry list handle. + */ +typedef struct bookmark_list bookmark_list_s; + +/** + * @brief The bookmark entry list structure. + */ +typedef struct bookmark_list *bookmark_list_h; + +struct favicon_entry { + void *data; /* favicon image data pointer. ( Allocated memory) */ + int length; /* favicon image data's length */ + int w; /* favicon image width */ + int h; /* favicon image height */ +}; +typedef struct favicon_entry favicon_entry_s; +typedef struct favicon_entry *favicon_entry_h; + +/* bookmark internal API */ +void _favorites_close_bookmark_db(void); +void _favorites_finalize_bookmark_db(sqlite3_stmt *stmt); +const char *_favorites_get_bookmark_db_name(void); +int _favorites_open_bookmark_db(void); +void _favorites_free_bookmark_list(bookmark_list_h m_list); +int _favorites_free_bookmark_entry(favorites_bookmark_entry_s *entry); +int _favorites_get_bookmark_lastindex(int locationId); +int _favorites_bookmark_get_folderID(const char *foldername); +int _favorites_bookmark_is_folder_exist(const char *foldername); +int _favorites_bookmark_create_folder(const char *foldername); +int _favorites_bookmark_is_bookmark_exist(const char *url, const char *title, const int folderId); +int _favorites_get_bookmark_count_at_folder(int folderId); +int _favorites_bookmark_get_folder_count(void); +bookmark_list_h _favorites_get_bookmark_list_at_folder(int folderId); +bookmark_list_h _favorites_bookmark_get_folder_list(void); +int _favorites_get_unixtime_from_datetime(char *datetime); +int _favorites_bookmark_get_bookmark_id(const char *url, const char *title, const int folder_id); + +/* history internal API */ +void _favorites_history_db_close(void); +void _favorites_history_db_finalize(sqlite3_stmt *stmt); +int _favorites_history_db_open(void); +int _favorites_free_history_entry(favorites_history_entry_s *entry); + +#ifdef __cplusplus +}; +#endif + +#endif /* __TIZEN_WEB_FAVORITES_PRIVATE_H__ */ diff --git a/packaging/capi-web-favorites.spec b/packaging/capi-web-favorites.spec new file mode 100755 index 0000000..c495e2e --- /dev/null +++ b/packaging/capi-web-favorites.spec @@ -0,0 +1,97 @@ +Name: capi-web-favorites +Summary: Internet bookmark and history API +Version: 0.0.7 +Release: 1 +Group: TO_BE/FILLED_IN +License: Apache License, Version 2.0 +Source0: %{name}-%{version}.tar.gz +BuildRequires: cmake +BuildRequires: pkgconfig(dlog) +BuildRequires: pkgconfig(db-util) +BuildRequires: pkgconfig(evas) +BuildRequires: pkgconfig(capi-base-common) +Requires(post): /sbin/ldconfig +Requires(postun): /sbin/ldconfig + +%description + + +%package devel +Summary: Internet Bookmark and History in Tizen Native API (Development) +Group: TO_BE/FILLED_IN +Requires: %{name} = %{version}-%{release} + +%description devel + + + +%prep +%setup -q + + +%build +cmake . -DCMAKE_INSTALL_PREFIX=/usr + + +make %{?jobs:-j%jobs} + +%install +rm -rf %{buildroot} +%make_install + +%post +/sbin/ldconfig +mkdir -p /opt/usr/dbspace/ +##### History ###### +if [ ! -f /opt/usr/dbspace/.browser-history.db ]; +then + sqlite3 /opt/usr/dbspace/.browser-history.db 'PRAGMA journal_mode=PERSIST; + CREATE TABLE history(id INTEGER PRIMARY KEY AUTOINCREMENT, address, title, counter INTEGER, visitdate DATETIME, favicon BLOB, favicon_length INTEGER, favicon_w INTEGER, favicon_h INTEGER);' +fi + +### Bookmark ### +if [ ! -f /opt/usr/dbspace/.internet_bookmark.db ]; +then + sqlite3 /opt/usr/dbspace/.internet_bookmark.db 'PRAGMA journal_mode=PERSIST; + CREATE TABLE bookmarks(id INTEGER PRIMARY KEY AUTOINCREMENT, type INTEGER, parent INTEGER, address, title, creationdate, sequence INTEGER, updatedate, visitdate, editable INTEGER, accesscount INTEGER, favicon BLOB, favicon_length INTEGER, favicon_w INTEGER, favicon_h INTEGER); + create index idx_bookmarks_on_parent_type on bookmarks(parent, type); + + insert into bookmarks (type, parent, title, creationdate, editable, sequence, accesscount) values(1, 0, "Bookmarks", DATETIME("now"), 0, 1, 0);' +fi + +# Change db file owner & permission +chown :5000 /opt/usr/dbspace/.browser-history.db +chown :5000 /opt/usr/dbspace/.browser-history.db-journal +chown :5000 /opt/usr/dbspace/.internet_bookmark.db +chown :5000 /opt/usr/dbspace/.internet_bookmark.db-journal +chmod 666 /opt/usr/dbspace/.browser-history.db +chmod 666 /opt/usr/dbspace/.browser-history.db-journal +chmod 666 /opt/usr/dbspace/.internet_bookmark.db +chmod 666 /opt/usr/dbspace/.internet_bookmark.db-journal + +if [ -f /usr/lib/rpm-plugins/msm.so ] +then + chsmack -a 'org.tizen.browser::db_external' /opt/usr/dbspace/.browser-history.db* + chsmack -a 'org.tizen.browser::db_external' /opt/usr/dbspace/.internet_bookmark.db* +fi +################################################## +# set default vconf values +################################################## +#internal keys +vconftool set -t string db/browser/browser_user_agent "System user agent" -g 5000 -f +vconftool set -t string db/browser/custom_user_agent "" -g 5000 -f +#public keys +vconftool set -t string db/browser/user_agent "Mozilla/5.0 (Linux; U; Tizen 2.0; en-us) AppleWebKit/537.1 (KHTML, like Gecko) Version/2.0 Mobile" -g 5000 -f + +%postun -p /sbin/ldconfig + + +%files +%manifest capi-web-favorites.manifest +%{_libdir}/libcapi-web-favorites.so + +%files devel +%{_includedir}/web/*.h +%{_libdir}/pkgconfig/*.pc + + diff --git a/src/favorites_bookmark.c b/src/favorites_bookmark.c new file mode 100644 index 0000000..6ab46dd --- /dev/null +++ b/src/favorites_bookmark.c @@ -0,0 +1,1150 @@ +/* + * Copyright (c) 2012 Samsung Electronics Co., Ltd All Rights Reserved + * + * Licensed under the Apache License, Version 2.0 (the License); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an AS IS BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +#include +#include +#include +#include +#include + +__thread sqlite3 *gl_internet_bookmark_db = 0; + +/* Private Functions */ +void _favorites_close_bookmark_db(void) +{ + if (gl_internet_bookmark_db) { + /* ASSERT(currentThread() == m_openingThread); */ + db_util_close(gl_internet_bookmark_db); + gl_internet_bookmark_db = 0; + } +} + +void _favorites_finalize_bookmark_db(sqlite3_stmt *stmt) +{ + if (sqlite3_finalize(stmt) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_finalize is failed"); + } + _favorites_close_bookmark_db(); +} +const char *_favorites_get_bookmark_db_name(void) +{ + return "/opt/usr/dbspace/.internet_bookmark.db"; +} +int _favorites_open_bookmark_db(void) +{ + _favorites_close_bookmark_db(); + if (db_util_open + (_favorites_get_bookmark_db_name(), &gl_internet_bookmark_db, + DB_UTIL_REGISTER_HOOK_METHOD) != SQLITE_OK) { + db_util_close(gl_internet_bookmark_db); + gl_internet_bookmark_db = 0; + return -1; + } + return gl_internet_bookmark_db ? 0 : -1; +} + +void _favorites_free_bookmark_list(bookmark_list_h m_list) +{ + FAVORITES_LOGE(" "); + + int i = 0; + if (m_list == NULL) + return; + + if (m_list->item != NULL) { + for (i = 0; i < m_list->count; i++) { + if (m_list->item[i].address != NULL) + free(m_list->item[i].address); + if (m_list->item[i].title != NULL) + free(m_list->item[i].title); + if (m_list->item[i].creationdate != NULL) + free(m_list->item[i].creationdate); + if (m_list->item[i].updatedate != NULL) + free(m_list->item[i].updatedate); + } + free(m_list->item); + } + free(m_list); + m_list = NULL; +} + +int _favorites_free_bookmark_entry(favorites_bookmark_entry_s *entry) +{ + FAVORITES_NULL_ARG_CHECK(entry); + + if (entry->address != NULL) + free(entry->address); + if (entry->title != NULL) + free(entry->title); + if (entry->creation_date != NULL) + free(entry->creation_date); + if (entry->update_date != NULL) + free(entry->update_date); + + return FAVORITES_ERROR_NONE; +} + +/* search last of sequence(order's index) */ +int _favorites_get_bookmark_lastindex(int locationId) +{ + int nError; + sqlite3_stmt *stmt; + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + nError = + sqlite3_prepare_v2(gl_internet_bookmark_db, + "select sequence from bookmarks where parent=? order by sequence desc", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + if (sqlite3_bind_int(stmt, 1, locationId) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_bind_int is failed"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + if ((nError = sqlite3_step(stmt)) == SQLITE_ROW) { + int index = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + return index; + } + FAVORITES_LOGE("Not found items in This Folder"); + _favorites_close_bookmark_db(); + return 0; +} + +int _favorites_bookmark_get_folderID(const char *foldername) +{ + FAVORITES_LOGE("foldername: %s", foldername); + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + memset(&query, 0x00, sizeof(char)*1024); + + /* If there is no identical folder name, create new folder */ + if (_favorites_bookmark_is_folder_exist(foldername)==0){ + if(_favorites_bookmark_create_folder(foldername)!=1){ + FAVORITES_LOGE("folder creating is failed."); + return -1; + } + } + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + sprintf(query, "select id from bookmarks where type=1 AND title='%s'" + , foldername); + + /* check foldername in the bookmark table */ + nError = sqlite3_prepare_v2(gl_internet_bookmark_db,query + ,-1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + int folderId = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + return folderId; + } + _favorites_close_bookmark_db(); + return 1; +} + +int _favorites_bookmark_is_folder_exist(const char *foldername) +{ + FAVORITES_LOGE("\n"); + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + memset(&query, 0x00, sizeof(char)*1024); + + if (!foldername || (strlen(foldername) <= 0)) { + FAVORITES_LOGE("foldername is empty\n"); + return -1; + } + FAVORITES_LOGE("foldername: %s", foldername); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + sprintf(query, "select id from bookmarks where type=1 AND title='%s'" + , foldername); + + /* check foldername in the bookmark table */ + nError = sqlite3_prepare_v2(gl_internet_bookmark_db,query + ,-1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + /* The given foldername is exist on the bookmark table */ + _favorites_finalize_bookmark_db(stmt); + return 1; + } + _favorites_close_bookmark_db(); + return 0; +} + +int _favorites_bookmark_create_folder(const char *foldername) +{ + FAVORITES_LOGE("\n"); + int nError; + sqlite3_stmt *stmt; + char query[1024]; + int lastIndex = 0; + + memset(&query, 0x00, sizeof(char)*1024); + + if (!foldername || (strlen(foldername) <= 0)) { + FAVORITES_LOGE("foldername is empty\n"); + return -1; + } + + if ((lastIndex = _favorites_get_bookmark_lastindex(1)) < 0) { + FAVORITES_LOGE("Database::getLastIndex() is failed.\n"); + return -1; + } + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + sprintf(query, "insert into bookmarks \ + (type, parent, title, creationdate, sequence, updatedate, editable)\ + values (1, 1, '%s', DATETIME('now'), %d, DATETIME('now'), 1)" + , foldername, lastIndex); + + FAVORITES_LOGE("query:%s\n", query); + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + query, -1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed(%s).\n", + sqlite3_errmsg(gl_internet_bookmark_db)); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_finalize_bookmark_db(stmt); + return 1; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_close_bookmark_db(); + return 0; +} + +int _favorites_bookmark_is_bookmark_exist + (const char *url, const char *title, const int folderId) +{ + FAVORITES_LOGE("folderId: %d", folderId); + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + memset(&query, 0x00, sizeof(char)*1024); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + sprintf(query, "select id from bookmarks where \ + type=0 AND address='%s' AND title='%s' AND parent=%d" + , url, title, folderId); + FAVORITES_LOGE("query: %s", query); + + /* check bookmark in the bookmark table */ + nError = sqlite3_prepare_v2(gl_internet_bookmark_db,query + ,-1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + /* There is same bookmark exist. */ + _favorites_finalize_bookmark_db(stmt); + return 1; + } + + FAVORITES_LOGE("there is no identical bookmark\n"); + _favorites_close_bookmark_db(); + /* there is no identical bookmark*/ + return 0; +} + +int _favorites_get_bookmark_count_at_folder(int folderId) +{ + int nError; + sqlite3_stmt *stmt; + FAVORITES_LOGE(""); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + /*bookmark */ + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "select count(*) from bookmarks where parent=? and type=0", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + if (sqlite3_bind_int(stmt, 1, folderId) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_bind_int is failed"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + int count = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + FAVORITES_LOGE("count: %d", count); + return count; + } + _favorites_close_bookmark_db(); + FAVORITES_LOGE("End"); + return 0; +} + +int _favorites_bookmark_get_folder_count(void) +{ + int nError; + sqlite3_stmt *stmt; + FAVORITES_LOGE(""); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + /* folder + bookmark */ + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "select count(*) from bookmarks where type=1 and parent != 0", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + int count = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + return count; + } + _favorites_close_bookmark_db(); + return 0; +} + +bookmark_list_h _favorites_get_bookmark_list_at_folder(int folderId) +{ + bookmark_list_h m_list = NULL; + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + FAVORITES_LOGE("folderId: %d", folderId); + if(folderId<=0){ + FAVORITES_LOGE("folderId is wrong"); + return NULL; + } + + memset(&query, 0x00, sizeof(char)*1024); + + /* check the total count of items */ + int item_count = 0; + item_count = _favorites_get_bookmark_count_at_folder(folderId); + + if (item_count <= 0) + return NULL; + + /* Get bookmarks list only under given folder */ + sprintf(query, "select id, type, parent, address, title, editable,\ + creationdate, updatedate, sequence \ + from bookmarks where type=0 and parent =%d order by sequence" + , folderId); + FAVORITES_LOGE("query: %s", query); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return NULL; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + query, -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE ("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return NULL; + } + + /* allocation .... Array for Items */ + m_list = (bookmark_list_h) calloc(1, sizeof(bookmark_list_s)); + m_list->item = + (bookmark_entry_internal_h) calloc(item_count, sizeof(bookmark_entry_internal_s)); + m_list->count = item_count; + int i = 0; + while ((nError = sqlite3_step(stmt)) == SQLITE_ROW + && (i < item_count)) { + m_list->item[i].id = sqlite3_column_int(stmt, 0); + m_list->item[i].is_folder = sqlite3_column_int(stmt, 1); + m_list->item[i].folder_id = sqlite3_column_int(stmt, 2); + + if (!m_list->item[i].is_folder) { + const char *url = + (const char *)(sqlite3_column_text(stmt, 3)); + m_list->item[i].address = NULL; + if (url) { + int length = strlen(url); + if (length > 0) { + m_list->item[i].address = + (char *)calloc(length + 1, + sizeof(char)); + memcpy(m_list->item[i].address, url, + length); + } + } + } + + const char *title = + (const char *)(sqlite3_column_text(stmt, 4)); + m_list->item[i].title = NULL; + if (title) { + int length = strlen(title); + if (length > 0) { + m_list->item[i].title = + (char *)calloc(length + 1, sizeof(char)); + memcpy(m_list->item[i].title, title, length); + } + FAVORITES_LOGE("Bookmark Title:%s\n", m_list->item[i].title); + } + m_list->item[i].editable = sqlite3_column_int(stmt, 5); + + const char *creationdate = + (const char *)(sqlite3_column_text(stmt, 6)); + m_list->item[i].creationdate = NULL; + if (creationdate) { + int length = strlen(creationdate); + if (length > 0) { + m_list->item[i].creationdate = + (char *)calloc(length + 1, sizeof(char)); + memcpy(m_list->item[i].creationdate, + creationdate, length); + } + } + const char *updatedate = + (const char *)(sqlite3_column_text(stmt, 7)); + m_list->item[i].updatedate = NULL; + if (updatedate) { + int length = strlen(updatedate); + if (length > 0) { + m_list->item[i].updatedate = + (char *)calloc(length + 1, sizeof(char)); + memcpy(m_list->item[i].updatedate, updatedate, + length); + } + } + + m_list->item[i].orderIndex = sqlite3_column_int(stmt, 8); + i++; + } + m_list->count = i; + + if (i <= 0) { + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_close_bookmark_db(); + _favorites_free_bookmark_list(m_list); + return NULL; + } + _favorites_finalize_bookmark_db(stmt); + return m_list; +} + +bookmark_list_h _favorites_bookmark_get_folder_list(void) +{ + bookmark_list_h m_list = NULL; + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + FAVORITES_LOGE(""); + + memset(&query, 0x00, sizeof(char)*1024); + + /* check the total count of items */ + int item_count = 0; + item_count = _favorites_bookmark_get_folder_count(); + + if (item_count <= 0) + return NULL; + + /* Get bookmarks list only under given folder */ + sprintf(query, "select id, type, parent, address, title, editable,\ + creationdate, updatedate, sequence \ + from bookmarks where type=1 and parent != 0 order by sequence"); + FAVORITES_LOGE("query: %s", query); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return NULL; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + query, -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE ("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return NULL; + } + + /* allocation .... Array for Items */ + m_list = (bookmark_list_h) calloc(1, sizeof(bookmark_list_s)); + m_list->item = + (bookmark_entry_internal_h) calloc(item_count, sizeof(bookmark_entry_internal_s)); + m_list->count = item_count; + int i = 0; + while ((nError = sqlite3_step(stmt)) == SQLITE_ROW + && (i < item_count)) { + m_list->item[i].id = sqlite3_column_int(stmt, 0); + m_list->item[i].is_folder = sqlite3_column_int(stmt, 1); + m_list->item[i].folder_id = sqlite3_column_int(stmt, 2); + + if (!m_list->item[i].is_folder) { + const char *url = + (const char *)(sqlite3_column_text(stmt, 3)); + m_list->item[i].address = NULL; + if (url) { + int length = strlen(url); + if (length > 0) { + m_list->item[i].address = + (char *)calloc(length + 1, + sizeof(char)); + memcpy(m_list->item[i].address, url, + length); + } + } + } + + const char *title = + (const char *)(sqlite3_column_text(stmt, 4)); + m_list->item[i].title = NULL; + if (title) { + int length = strlen(title); + if (length > 0) { + m_list->item[i].title = + (char *)calloc(length + 1, sizeof(char)); + memcpy(m_list->item[i].title, title, length); + } + FAVORITES_LOGE("Bookmark Title:%s\n", m_list->item[i].title); + } + m_list->item[i].editable = sqlite3_column_int(stmt, 5); + + const char *creationdate = + (const char *)(sqlite3_column_text(stmt, 6)); + m_list->item[i].creationdate = NULL; + if (creationdate) { + int length = strlen(creationdate); + if (length > 0) { + m_list->item[i].creationdate = + (char *)calloc(length + 1, sizeof(char)); + memcpy(m_list->item[i].creationdate, + creationdate, length); + } + } + const char *updatedate = + (const char *)(sqlite3_column_text(stmt, 7)); + m_list->item[i].updatedate = NULL; + if (updatedate) { + int length = strlen(updatedate); + if (length > 0) { + m_list->item[i].updatedate = + (char *)calloc(length + 1, sizeof(char)); + memcpy(m_list->item[i].updatedate, updatedate, + length); + } + } + + m_list->item[i].orderIndex = sqlite3_column_int(stmt, 8); + i++; + } + m_list->count = i; + + if (i <= 0) { + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_close_bookmark_db(); + _favorites_free_bookmark_list(m_list); + return NULL; + } + _favorites_finalize_bookmark_db(stmt); + return m_list; +} + +int _favorites_get_unixtime_from_datetime(char *datetime) +{ + int nError; + sqlite3_stmt *stmt; + + if(datetime == NULL ) { + FAVORITES_LOGE("datetime is NULL\n"); + return -1; + } + + FAVORITES_LOGE("datetime: %s\n", datetime); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "SELECT strftime('%s', ?)", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + if (sqlite3_bind_text(stmt, 1, datetime, -1, NULL) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_bind_text is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + int unixtime = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + return unixtime; + } + _favorites_close_bookmark_db(); + return 1; +} + +/* search last of sequence(order's index) */ +int _favorites_bookmark_get_bookmark_id(const char *url, const char *title, const int folder_id) +{ + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + /* Get the id of bookmark */ + sprintf(query, "select id from bookmarks where \ + type=0 AND address='%s' AND title='%s' AND parent=%d" + , url, title, folder_id); + FAVORITES_LOGE("query: %s", query); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return -1; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + query, -1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed"); + _favorites_finalize_bookmark_db(stmt); + return -1; + } + + if ((nError = sqlite3_step(stmt)) == SQLITE_ROW) { + int bookmark_id = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + return bookmark_id; + } + FAVORITES_LOGE("No match with given url"); + _favorites_close_bookmark_db(); + return 0; +} + +/************************************************************* + * APIs for Internet favorites + *************************************************************/ +int favorites_bookmark_add_bookmark(const char *url, const char *title, const char *foldername, int *bookmark_id) +{ + FAVORITES_LOGE(""); + int nError; + sqlite3_stmt *stmt; + int folderId = 1; + char query[1024]; + int lastIndex = 0; + + memset(&query, 0x00, sizeof(char)*1024); + if (!url || (strlen(url) <= 0)) { + FAVORITES_LOGE("url is empty\n"); + return FAVORITES_ERROR_INVALID_PARAMETER; + } + + if (!title || (strlen(title) <= 0)) { + FAVORITES_LOGE("title is empty\n"); + return FAVORITES_ERROR_INVALID_PARAMETER; + } + + /* check the foldername is exist and get a folderid */ + if (!foldername || (strlen(foldername) <= 0)) { + FAVORITES_LOGE("foldername is empty. id is now root.\n"); + folderId = 1; + }else if (!strcmp("Bookmarks", foldername)){ + /*root folder name is "Bookmarks".*/ + folderId = 1; + } else { + folderId = _favorites_bookmark_get_folderID(foldername); + if(folderId<0){ + return FAVORITES_ERROR_DB_FAILED; + } + } + + /* Check the bookmarks is already exist*/ + if(_favorites_bookmark_is_bookmark_exist(url, title, folderId)!=0){ + FAVORITES_LOGE("The bookmark is already exist.\n"); + return FAVORITES_ERROR_ITEM_ALREADY_EXIST; + } + + /* get a last index for order of bookmark items */ + if ((lastIndex = _favorites_get_bookmark_lastindex(folderId)) < 0) { + FAVORITES_LOGE("Database::getLastIndex() is failed.\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + /* Creating SQL query sentence. */ + sprintf(query, "insert into bookmarks\ + (type, parent, address, title, creationdate, editable, sequence, accesscount)\ + values(0, %d, '%s', '%s', DATETIME('now'), 1, %d, 0);" + , folderId, url, title, lastIndex); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + query, -1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_finalize_bookmark_db(stmt); + if (bookmark_id != NULL) { + *bookmark_id = _favorites_bookmark_get_bookmark_id(url, title, folderId); + } + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_close_bookmark_db(); + + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_bookmark_get_count(int *count) +{ + int nError; + sqlite3_stmt *stmt; + + FAVORITES_NULL_ARG_CHECK(count); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + /* folder + bookmark */ + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "select count(*) from bookmarks where parent != 0", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + *count = sqlite3_column_int(stmt, 0); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_NONE; + } + _favorites_close_bookmark_db(); + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_bookmark_foreach(favorites_bookmark_foreach_cb callback,void *user_data) +{ + FAVORITES_NULL_ARG_CHECK(callback); + int nError; + int func_ret = 0; + sqlite3_stmt *stmt; + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "select id, type, parent, address, title, editable,\ + creationdate, updatedate, sequence \ + from bookmarks where parent != 0 order by sequence", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE ("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + while ((nError = sqlite3_step(stmt)) == SQLITE_ROW) { + favorites_bookmark_entry_s result; + memset(&result, 0x00, sizeof(favorites_bookmark_entry_s)); + result.id = sqlite3_column_int(stmt, 0); + result.is_folder = sqlite3_column_int(stmt, 1); + result.folder_id = sqlite3_column_int(stmt, 2); + + result.address = NULL; + if (!result.is_folder) { + const char *url = (const char *)(sqlite3_column_text(stmt, 3)); + if (url) { + int length = strlen(url); + if (length > 0) { + result.address = (char *)calloc(length + 1, sizeof(char)); + memcpy(result.address, url, length); + FAVORITES_LOGE ("url:%s\n", url); + } + } + } + + const char *title = (const char *)(sqlite3_column_text(stmt, 4)); + result.title = NULL; + if (title) { + int length = strlen(title); + if (length > 0) { + result.title = (char *)calloc(length + 1, sizeof(char)); + memcpy(result.title, title, length); + } + } + result.editable = sqlite3_column_int(stmt, 5); + + const char *creation_date = (const char *)(sqlite3_column_text(stmt, 6)); + result.creation_date = NULL; + if (creation_date) { + int length = strlen(creation_date); + if (length > 0) { + result.creation_date = (char *)calloc(length + 1, sizeof(char)); + memcpy(result.creation_date, creation_date, length); + } + } + const char *update_date = (const char *)(sqlite3_column_text(stmt, 7)); + result.update_date = NULL; + if (update_date) { + int length = strlen(update_date); + if (length > 0) { + result.update_date = (char *)calloc(length + 1, sizeof(char)); + memcpy(result.update_date, update_date, length); + } + } + + result.order_index = sqlite3_column_int(stmt, 8); + + func_ret = callback(&result, user_data); + _favorites_free_bookmark_entry(&result); + if(func_ret == 0) + break; + } + + FAVORITES_LOGE ("There are no more bookmarks.\n"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_NONE; +} + +int favorites_bookmark_export_list(const char * file_path) +{ + FAVORITES_NULL_ARG_CHECK(file_path); + FILE *fp = NULL; + bookmark_list_h folders_list = NULL; + bookmark_list_h bookmarks_list = NULL; + + /* Get list of all bookmarks */ + folders_list = _favorites_bookmark_get_folder_list(); + if(folders_list == NULL ) { + FAVORITES_LOGE("There is no folders even root folder"); + return FAVORITES_ERROR_DB_FAILED; + } + + fp = fopen( file_path, "w"); + if(fp == NULL) { + FAVORITES_LOGE("file opening is failed."); + _favorites_free_bookmark_list(folders_list); + return FAVORITES_ERROR_INVALID_PARAMETER; + } + fputs("\n", fp); + fputs("\n", fp); + fputs("\n", fp); + fputs("Bookmarks\n", fp); + fputs("

Bookmarks

\n", fp); + fputs("

\n", fp); + /*Set subfolders and its bookmark items */ + int i = 0; + int folder_adddate_unixtime = 0; + int k=0; + int bookmark_adddate_unixtime = 0; + int bookmark_updatedate_unixtime = 0; + for(i=0; i < (folders_list->count); i++) { + folder_adddate_unixtime = + _favorites_get_unixtime_from_datetime( + folders_list->item[i].creationdate); + FAVORITES_LOGE("TITLE: %s", folders_list->item[i].title); + + fprintf(fp, "\t

%s

\n", + folder_adddate_unixtime, folders_list->item[i].title); + fputs("\t

\n", fp); + /* Get bookmarks under this folder and put the list into the file*/ + _favorites_free_bookmark_list(bookmarks_list); + bookmarks_list = NULL; + bookmarks_list = _favorites_get_bookmark_list_at_folder( + folders_list->item[i].id); + if(bookmarks_list!= NULL){ + for(k=0;k<(bookmarks_list->count); k++){ + bookmark_adddate_unixtime = + _favorites_get_unixtime_from_datetime( + bookmarks_list->item[k].creationdate); + + if(bookmark_adddate_unixtime<0) + bookmark_adddate_unixtime=0; + + bookmark_updatedate_unixtime = + _favorites_get_unixtime_from_datetime( + bookmarks_list->item[k].updatedate); + + if(bookmark_updatedate_unixtime<0) + bookmark_updatedate_unixtime=0; + + fprintf(fp,"\t\t

item[k].address); + fprintf(fp,"ADD_DATE=\"%d\" ", + bookmark_adddate_unixtime); + fprintf(fp,"LAST_VISIT=\"%d\" ", + bookmark_updatedate_unixtime); + fprintf(fp,"LAST_MODIFIED=\"%d\">", + bookmark_updatedate_unixtime); + fprintf(fp,"%s\n", bookmarks_list->item[k].title ); + } + } + fputs("\t

\n", fp); + } + + /*Set root folder's bookmark items */ + _favorites_free_bookmark_list(bookmarks_list); + bookmarks_list = NULL; + bookmarks_list = _favorites_get_bookmark_list_at_folder(1); + if(bookmarks_list!= NULL){ + for(k=0;k<(bookmarks_list->count); k++){ + bookmark_adddate_unixtime = + _favorites_get_unixtime_from_datetime( + bookmarks_list->item[k].creationdate); + + if(bookmark_adddate_unixtime<0) + bookmark_adddate_unixtime=0; + + bookmark_updatedate_unixtime = + _favorites_get_unixtime_from_datetime( + bookmarks_list->item[k].updatedate); + + if(bookmark_updatedate_unixtime<0) + bookmark_updatedate_unixtime=0; + + fprintf(fp,"\t

item[k].address); + fprintf(fp,"ADD_DATE=\"%d\" ", + bookmark_adddate_unixtime); + fprintf(fp,"LAST_VISIT=\"%d\" ", + bookmark_updatedate_unixtime); + fprintf(fp,"LAST_MODIFIED=\"%d\">", + bookmark_updatedate_unixtime); + fprintf(fp,"%s\n", bookmarks_list->item[k].title ); + } + } + fputs("

\n", fp); + fclose(fp); + + return FAVORITES_ERROR_NONE; +} + +int favorites_bookmark_get_favicon(int id, Evas *evas, Evas_Object **icon) +{ + FAVORITES_INVALID_ARG_CHECK(id<0); + FAVORITES_NULL_ARG_CHECK(evas); + FAVORITES_NULL_ARG_CHECK(icon); + + sqlite3_stmt *stmt; + char query[1024]; + void *favicon_data_temp=NULL; + favicon_entry_h favicon; + int nError; + + memset(&query, 0x00, sizeof(char)*1024); + sprintf(query, "select favicon, favicon_length, favicon_w, favicon_h from bookmarks\ + where id=%d" + , id); + FAVORITES_LOGE("query: %s", query); + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + query, -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed(%s).\n", + sqlite3_errmsg(gl_internet_bookmark_db)); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + favicon = (favicon_entry_h) calloc(1, sizeof(favicon_entry_s)); + /* loading favicon from bookmark db */ + favicon_data_temp = (void *)sqlite3_column_blob(stmt,0); + favicon->length = sqlite3_column_int(stmt,1); + favicon->w = sqlite3_column_int(stmt,2); + favicon->h = sqlite3_column_int(stmt,3); + + if (favicon->length > 0){ + favicon->data = calloc(1, favicon->length); + memcpy(favicon->data, favicon_data_temp, favicon->length); + /* transforming to evas object */ + *icon = evas_object_image_filled_add(evas); + evas_object_image_colorspace_set(*icon, + EVAS_COLORSPACE_ARGB8888); + evas_object_image_size_set(*icon, favicon->w, favicon->h); + evas_object_image_fill_set(*icon, 0, 0, favicon->w, + favicon->h); + evas_object_image_filled_set(*icon, EINA_TRUE); + evas_object_image_alpha_set(*icon,EINA_TRUE); + evas_object_image_data_set(*icon, favicon->data); + } + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_NONE; + } + + _favorites_close_bookmark_db(); + return FAVORITES_ERROR_NONE; +} + +int favorites_bookmark_delete_bookmark(int id) +{ + FAVORITES_INVALID_ARG_CHECK(id<0); + int nError; + sqlite3_stmt *stmt; + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "delete from bookmarks where id=? and parent != 0", -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + // bind + if (sqlite3_bind_int(stmt, 1, id) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_bind_int is failed"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_close_bookmark_db(); + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_bookmark_delete_all_bookmarks(void) +{ + int nError; + sqlite3_stmt *stmt; + + if (_favorites_open_bookmark_db() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_bookmark_db, + "delete from bookmarks where parent !=0", -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_finalize_bookmark_db(stmt); + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_close_bookmark_db(); + return FAVORITES_ERROR_DB_FAILED; +} + diff --git a/src/favorites_history.c b/src/favorites_history.c new file mode 100644 index 0000000..6a6f4ef --- /dev/null +++ b/src/favorites_history.c @@ -0,0 +1,384 @@ +/* + * Copyright (c) 2012 Samsung Electronics Co., Ltd All Rights Reserved + * + * Licensed under the Apache License, Version 2.0 (the License); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an AS IS BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +#include +#include +#include +#include +#include + +__thread sqlite3 *gl_internet_history_db = 0; + +#define INTERNET_HISTORY_DB_NAME "/opt/usr/dbspace/.browser-history.db" + +/* Private Functions */ +void _favorites_history_db_close(void) +{ + if (gl_internet_history_db) { + /* ASSERT(currentThread() == m_openingThread); */ + db_util_close(gl_internet_history_db); + gl_internet_history_db = 0; + } +} + +void _favorites_history_db_finalize(sqlite3_stmt *stmt) +{ + if (sqlite3_finalize(stmt) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_finalize is failed"); + } + _favorites_history_db_close(); +} +int _favorites_history_db_open(void) +{ + _favorites_history_db_close(); + if (db_util_open + (INTERNET_HISTORY_DB_NAME, &gl_internet_history_db, + DB_UTIL_REGISTER_HOOK_METHOD) != SQLITE_OK) { + db_util_close(gl_internet_history_db); + gl_internet_history_db = 0; + return -1; + } + return gl_internet_history_db ? 0 : -1; +} + +int _favorites_free_history_entry(favorites_history_entry_s *entry) +{ + FAVORITES_NULL_ARG_CHECK(entry); + + if (entry->address != NULL) + free(entry->address); + if (entry->title != NULL) + free(entry->title); + if (entry->visit_date != NULL) + free(entry->visit_date); + + return FAVORITES_ERROR_NONE; +} +/************************************************************* + * APIs for Internet favorites + *************************************************************/ +int favorites_history_get_count(int *count) +{ + int nError; + sqlite3_stmt *stmt; + FAVORITES_LOGE(""); + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + /* folder + bookmark */ + nError = sqlite3_prepare_v2(gl_internet_history_db, + "select count(*) from history", + -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + *count = sqlite3_column_int(stmt, 0); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; + } + _favorites_history_db_close(); + return FAVORITES_ERROR_DB_FAILED; +} +/* Public CAPI */ +int favorites_history_foreach(favorites_history_foreach_cb callback,void *user_data) +{ + FAVORITES_NULL_ARG_CHECK(callback); + int nError; + int func_ret = 0; + sqlite3_stmt *stmt; + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + nError = sqlite3_prepare_v2(gl_internet_history_db, + "select id, address, title, counter, visitdate\ + from history order by visitdate desc", + -1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE ("sqlite3_prepare_v2 is failed.\n"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + while ((nError = sqlite3_step(stmt)) == SQLITE_ROW) { + favorites_history_entry_s result; + result.id = sqlite3_column_int(stmt, 0); + + result.address = NULL; + const char *url = (const char *)(sqlite3_column_text(stmt, 1)); + if (url) { + int length = strlen(url); + if (length > 0) { + result.address = (char *)calloc(length + 1, sizeof(char)); + memcpy(result.address, url, length); + FAVORITES_LOGE ("url:%s\n", url); + } + } + + const char *title = (const char *)(sqlite3_column_text(stmt, 2)); + result.title = NULL; + if (title) { + int length = strlen(title); + if (length > 0) { + result.title = (char *)calloc(length + 1, sizeof(char)); + memcpy(result.title, title, length); + } + } + result.count = sqlite3_column_int(stmt, 3); + + const char *visit_date = + (const char *)(sqlite3_column_text(stmt, 4)); + result.visit_date = NULL; + if (visit_date) { + int length = strlen(visit_date); + if (length > 0) { + result.visit_date = + (char *)calloc(length + 1, sizeof(char)); + memcpy(result.visit_date, + visit_date, length); + FAVORITES_LOGE("Date:%s\n", result.visit_date); + } + } + + func_ret = callback(&result, user_data); + _favorites_free_history_entry(&result); + if(func_ret == 0) + break; + } + + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; +} + +int favorites_history_delete_history(int id) +{ + int nError; + sqlite3_stmt *stmt; + + FAVORITES_INVALID_ARG_CHECK(id<0); + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_history_db, + "delete from history where id=?", -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + // bind + if (sqlite3_bind_int(stmt, 1, id) != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_bind_int is failed"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_history_db_close(); + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_history_delete_history_by_url(const char *url) +{ + int nError; + sqlite3_stmt *stmt; + + if (!url || (strlen(url) <= 0)) { + FAVORITES_LOGE("url is empty\n"); + return FAVORITES_ERROR_INVALID_PARAMETER; + } + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_history_db, + "delete from history where address=?", -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + // bind + if (sqlite3_bind_text(stmt, 1, url, -1, NULL) != SQLITE_OK) + FAVORITES_LOGE("sqlite3_bind_text is failed.\n"); + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_history_db_close(); + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_history_delete_all_histories(void) +{ + int nError; + sqlite3_stmt *stmt; + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_history_db, + "delete from history", -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_history_db_close(); + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_history_delete_history_by_term(const char *begin, const char *end) +{ + int nError; + sqlite3_stmt *stmt; + char query[1024]; + + memset(&query, 0x00, sizeof(char)*1024); + + if (!begin || (strlen(begin) <= 0)) { + FAVORITES_LOGE("begin date is empty\n"); + return FAVORITES_ERROR_INVALID_PARAMETER; + } + + if (!end || (strlen(end) <= 0)) { + FAVORITES_LOGE("end date is empty\n"); + end = "now"; + } + + sprintf(query, "delete from history where visitdate\ + between datetime('%s') and datetime('%s')", begin, end); + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + nError = sqlite3_prepare_v2(gl_internet_history_db, + query, -1, &stmt, NULL); + + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed.\n"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW || nError == SQLITE_DONE) { + FAVORITES_LOGE("sqlite3_step is DONE"); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; + } + FAVORITES_LOGE("sqlite3_step is failed"); + _favorites_history_db_close(); + + return FAVORITES_ERROR_DB_FAILED; +} + +int favorites_history_get_favicon(int id, Evas *evas, Evas_Object **icon) +{ + FAVORITES_INVALID_ARG_CHECK(id<0); + FAVORITES_NULL_ARG_CHECK(evas); + FAVORITES_NULL_ARG_CHECK(icon); + + sqlite3_stmt *stmt; + char query[1024]; + void *favicon_data_temp=NULL; + favicon_entry_h favicon; + int nError; + + memset(&query, 0x00, sizeof(char)*1024); + sprintf(query, "select favicon, favicon_length, favicon_w, favicon_h from history\ + where id=%d" + , id); + FAVORITES_LOGE("query: %s", query); + + if (_favorites_history_db_open() < 0) { + FAVORITES_LOGE("db_util_open is failed\n"); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_prepare_v2(gl_internet_history_db, + query, -1, &stmt, NULL); + if (nError != SQLITE_OK) { + FAVORITES_LOGE("sqlite3_prepare_v2 is failed(%s).\n", + sqlite3_errmsg(gl_internet_history_db)); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_DB_FAILED; + } + + nError = sqlite3_step(stmt); + if (nError == SQLITE_ROW) { + favicon = (favicon_entry_h) calloc(1, sizeof(favicon_entry_s)); + /* loading favicon from history db */ + favicon_data_temp = (void *)sqlite3_column_blob(stmt,0); + favicon->length = sqlite3_column_int(stmt,1); + favicon->w = sqlite3_column_int(stmt,2); + favicon->h = sqlite3_column_int(stmt,3); + + if (favicon->length > 0){ + favicon->data = calloc(1, favicon->length); + memcpy(favicon->data, favicon_data_temp, favicon->length); + /* transforming to evas object */ + *icon = evas_object_image_filled_add(evas); + evas_object_image_colorspace_set(*icon, + EVAS_COLORSPACE_ARGB8888); + evas_object_image_size_set(*icon, favicon->w, favicon->h); + evas_object_image_fill_set(*icon, 0, 0, favicon->w, + favicon->h); + evas_object_image_filled_set(*icon, EINA_TRUE); + evas_object_image_alpha_set(*icon,EINA_TRUE); + evas_object_image_data_set(*icon, favicon->data); + } + free(favicon); + _favorites_history_db_finalize(stmt); + return FAVORITES_ERROR_NONE; + } + + _favorites_history_db_close(); + return FAVORITES_ERROR_NONE; +} + -- 2.7.4