From 222ec51a272024f0228a0eede8b46d729b343b45 Mon Sep 17 00:00:00 2001 From: HyungKyu Song Date: Thu, 14 Feb 2013 21:48:36 +0900 Subject: [PATCH] Tizen 2.0 Release --- AUTHORS | 6 + CMakeLists.txt | 46 +++++ LICENSE | 204 +++++++++++++++++++++ debian/changelog | 39 +++++ debian/compat | 1 + debian/control | 21 +++ debian/copyright | 7 + debian/dirs | 2 + debian/docs | 0 debian/rules | 123 +++++++++++++ debian/tel-plugin-database.install.in | 1 + packaging/tel-plugin-database.spec | 41 +++++ src/database_main.c | 321 ++++++++++++++++++++++++++++++++++ tel-plugin-database.manifest | 11 ++ 14 files changed, 823 insertions(+) create mode 100644 AUTHORS create mode 100644 CMakeLists.txt create mode 100644 LICENSE create mode 100644 debian/changelog create mode 100644 debian/compat create mode 100644 debian/control create mode 100644 debian/copyright create mode 100644 debian/dirs create mode 100644 debian/docs create mode 100755 debian/rules create mode 100644 debian/tel-plugin-database.install.in create mode 100644 packaging/tel-plugin-database.spec create mode 100644 src/database_main.c create mode 100644 tel-plugin-database.manifest diff --git a/AUTHORS b/AUTHORS new file mode 100644 index 0000000..0e9faa9 --- /dev/null +++ b/AUTHORS @@ -0,0 +1,6 @@ +Jongman Park +Ja-young Gu +Kyeongchul Kim +DongHoo Park +Youngman Park +Inho Oh diff --git a/CMakeLists.txt b/CMakeLists.txt new file mode 100644 index 0000000..ac50494 --- /dev/null +++ b/CMakeLists.txt @@ -0,0 +1,46 @@ +CMAKE_MINIMUM_REQUIRED(VERSION 2.6) +PROJECT(db-plugin C) + +### Global setting ### +SET(PREFIX ${CMAKE_INSTALL_PREFIX}) +SET(EXEC_PREFIX "\${prefix}") +SET(LIBDIR "\${prefix}/lib") +SET(INCLUDEDIR "\${prefix}/include") +SET(PKGCONFIGDIR "${PREFIX}/lib/pkgconfig" CACHE PATH PKGCONFIGDIR) +SET(CMAKE_INSTALL_PREFIX "${PREFIX}") + +# Set required packages +INCLUDE(FindPkgConfig) +pkg_check_modules(pkgs REQUIRED glib-2.0 tcore dlog db-util) + +FOREACH(flag ${pkgs_CFLAGS}) + SET(EXTRA_CFLAGS "${EXTRA_CFLAGS} ${flag}") +ENDFOREACH(flag) + + +INCLUDE_DIRECTORIES(${CMAKE_SOURCE_DIR}/include/) + +SET(CMAKE_C_FLAGS "${CMAKE_C_FLAGS} ${EXTRA_CFLAGS} -Werror -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Wdeclaration-after-statement -Wmissing-declarations -Wredundant-decls -Wcast-align") + +ADD_DEFINITIONS("-DFEATURE_DLOG_DEBUG") +ADD_DEFINITIONS("-DTCORE_LOG_TAG=\"TEL_PLUGIN_DATABASE\"") + +MESSAGE(${CMAKE_C_FLAGS}) +MESSAGE(${CMAKE_EXE_LINKER_FLAGS}) + +SET(SRCS + src/database_main.c +) + + +# library build +ADD_LIBRARY(db-plugin SHARED ${SRCS}) +TARGET_LINK_LIBRARIES(db-plugin ${pkgs_LDFLAGS}) +SET_TARGET_PROPERTIES(db-plugin PROPERTIES PREFIX "" OUTPUT_NAME db-plugin) + + + +# install +INSTALL(TARGETS db-plugin + LIBRARY DESTINATION lib/telephony/plugins) +INSTALL(FILES ${CMAKE_SOURCE_DIR}/LICENSE DESTINATION /usr/share/license RENAME tel-plugin-database) diff --git a/LICENSE b/LICENSE new file mode 100644 index 0000000..bae7f54 --- /dev/null +++ b/LICENSE @@ -0,0 +1,204 @@ +Copyright (c) 2000 - 2012 Samsung Electronics Co., Ltd. All rights reserved. + + 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/debian/changelog b/debian/changelog new file mode 100644 index 0000000..1bb4523 --- /dev/null +++ b/debian/changelog @@ -0,0 +1,39 @@ +tel-plugin-database (0.1.4) unstable; urgency=low + + * package version sync with public + * Git: slp/pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.4 + + -- Inho Oh Mon, 02 Apr 2012 14:54:27 +0900 + +tel-plugin-database (0.1.3) unstable; urgency=low + + * fix crash + * Git: slp/pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.3 + + -- DongHoo Park Thu, 29 Mar 2012 13:49:39 +0900 + +tel-plugin-database (0.1.2) unstable; urgency=low + + * Fix prefix (TAPI_ to TCORE_) + * Git: slp/pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.2 + + -- Inho Oh Tue, 27 Mar 2012 22:12:52 +0900 + +tel-plugin-database (0.1.1) unstable; urgency=low + + * Add .spec file for OBS + * Git: slp/pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.1 + + -- DongHoo Park Fri, 16 Mar 2012 21:14:25 +0900 + +tel-plugin-database (0.1.0) unstable; urgency=low + + * initialize + * Git: slp/pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.0 + + -- Inho Oh Thu, 15 Mar 2012 23:40:55 +0900 diff --git a/debian/compat b/debian/compat new file mode 100644 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..71d61b8 --- /dev/null +++ b/debian/control @@ -0,0 +1,21 @@ +Source: tel-plugin-database +Section: libs +Priority: extra +Maintainer: DongHoo Park +Uploaders: DongHoo Park +Build-Depends: debhelper (>= 5), + libglib2.0-dev, libtcore-dev, dlog-dev, libslp-db-util-dev +Standards-Version: 0.0.0 + +Package: tel-plugin-database +Section: libs +Architecture: any +Depends: ${shlibs:Depends}, ${misc:Depends}, +Description: data base access library (Shared Object) + +Package: tel-plugin-database-dbg +Section: debug +Architecture: any +Depends: ${shlibs:Depends}, ${misc:Depends}, tel-plugin-database (= ${Source-Version}) +Description: data base access library (dbg package) + diff --git a/debian/copyright b/debian/copyright new file mode 100644 index 0000000..dd6dabe --- /dev/null +++ b/debian/copyright @@ -0,0 +1,7 @@ +Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved. + +This program is free software; you can redistribute it and/or modify +it under the terms of the the Apache License, Version 2.0 (the "License"); + +You may obtain a copy of the License at +http://www.apache.org/licenses/LICENSE-2.0. diff --git a/debian/dirs b/debian/dirs new file mode 100644 index 0000000..ca882bb --- /dev/null +++ b/debian/dirs @@ -0,0 +1,2 @@ +usr/bin +usr/sbin diff --git a/debian/docs b/debian/docs new file mode 100644 index 0000000..e69de29 diff --git a/debian/rules b/debian/rules new file mode 100755 index 0000000..dcbd9ce --- /dev/null +++ b/debian/rules @@ -0,0 +1,123 @@ +#!/usr/bin/make -f +# -*- makefile -*- +# Sample debian/rules that uses debhelper. +# This file was originally written by Joey Hess and Craig Small. +# As a special exception, when this file is copied by dh-make into a +# dh-make output file, you may use that output file without restriction. +# This special exception was added by Craig Small in version 0.37 of dh-make. + +# Uncomment this to turn on verbose mode. +#export DH_VERBOSE=1 + +CFLAGS ?= -Wall -g +CXXFLAGS ?= -Wall -g +LDFLAGS ?= +PREFIX ?= /usr +DATADIR ?= /opt + +ifneq (,$(findstring noopt,$(DEB_BUILD_OPTIONS))) + CFLAGS += -O0 + CXXFLAGS += -O0 +else + CFLAGS += -O2 + CXXFLAGS += -O2 +endif + +#CFLAGS += -fvisibility=hidden -fPIC +CFLAGS += -fvisibility=default -fPIC +LDFLAGS += -rdynamic -fPIC -Wl,--rpath=$(PREFIX)/lib -Wl,--as-needed +#LDFLAGS += -Wl,--unresolved-symbols=ignore-in-shared-libs,--as-needed + +CMAKE_TMP_DIR = $(CURDIR)/cmake_tmp + +configure: configure-stamp +configure-stamp: + dh_testdir + # Add here commands to configure the package. + mkdir -p $(CMAKE_TMP_DIR); + cd $(CMAKE_TMP_DIR); CFLAGS="$(CFLAGS)" LDFLAGS="$(LDFLAGS)" cmake .. -DCMAKE_INSTALL_PREFIX=$(PREFIX) + + touch configure-stamp + +build: build-stamp + +build-stamp: configure-stamp + dh_testdir + + # Add here commands to compile the package. + cd $(CMAKE_TMP_DIR) && $(MAKE) all + + for f in `find $(CURDIR)/debian/ -name "*.in"`; do \ + cat $$f > $${f%.in}; \ + sed -i -e "s#@PREFIX@#$(PREFIX)#g" $${f%.in}; \ + sed -i -e "s#@DATADIR@#$(DATADIR)#g" $${f%.in}; \ + done + + touch $@ + +clean: + dh_testdir + dh_testroot + rm -f build-stamp configure-stamp + + # Add here commands to clean up after the build process. + rm -rf $(CMAKE_TMP_DIR) + + for f in `find $(CURDIR)/debian/ -name "*.in"`; do \ + rm -f $${f%.in}; \ + done + + dh_clean + +rmpkg: + rm ../tel-plugin-database*.deb + rm ../tel-plugin-database*.changes + +install: build + dh_testdir + dh_testroot + dh_clean -k + dh_installdirs + + # Add here commands to install the package into debian/wavplayer. + cd $(CMAKE_TMP_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_installmenu +# dh_installdebconf +# dh_installlogrotate +# dh_installemacsen +# dh_installpam +# dh_installmime +# dh_python +# dh_installinit +# dh_installcron +# dh_installinfo + dh_installman + dh_link + dh_strip --dbg-package=tel-plugin-database-dbg + dh_compress + dh_fixperms +# dh_perl + dh_makeshlibs + dh_installdeb + dh_shlibdeps +# dh_shlibdeps --dpkg-shlibdeps-params=--ignore-missing-info + dh_gencontrol + dh_md5sums + dh_builddeb + +binary: binary-indep binary-arch +.PHONY: build clean binary-indep binary-arch binary install configure diff --git a/debian/tel-plugin-database.install.in b/debian/tel-plugin-database.install.in new file mode 100644 index 0000000..112242d --- /dev/null +++ b/debian/tel-plugin-database.install.in @@ -0,0 +1 @@ +@PREFIX@/lib/* diff --git a/packaging/tel-plugin-database.spec b/packaging/tel-plugin-database.spec new file mode 100644 index 0000000..c55ce18 --- /dev/null +++ b/packaging/tel-plugin-database.spec @@ -0,0 +1,41 @@ +#sbs-git:slp/pkgs/t/tel-plugin-database +Name: tel-plugin-database +Summary: Telephony DataBase storage plugin +Version: 0.1.7 +Release: 1 +Group: System/Libraries +License: Apache +Source0: tel-plugin-database-%{version}.tar.gz +Requires(post): /sbin/ldconfig +Requires(postun): /sbin/ldconfig +BuildRequires: cmake +BuildRequires: pkgconfig(glib-2.0) +BuildRequires: pkgconfig(tcore) +BuildRequires: pkgconfig(dlog) +BuildRequires: pkgconfig(db-util) + +%description +Telephony DataBase storage plugin + +%prep +%setup -q + +%build +cmake . -DCMAKE_INSTALL_PREFIX=%{_prefix} +make %{?jobs:-j%jobs} + +%post +/sbin/ldconfig + +%postun -p /sbin/ldconfig + +%install +rm -rf %{buildroot} +%make_install +mkdir -p %{buildroot}/usr/share/license + +%files +%defattr(-,root,root,-) +#%doc COPYING +%{_libdir}/telephony/plugins/db-plugin* +/usr/share/license/tel-plugin-database diff --git a/src/database_main.c b/src/database_main.c new file mode 100644 index 0000000..471e4bf --- /dev/null +++ b/src/database_main.c @@ -0,0 +1,321 @@ +/* + * tel-plugin-database + * + * Copyright (c) 2012 Samsung Electronics Co., Ltd. All rights reserved. + * + * Contact: DongHoo Park + * + * 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 +#include + +#include +#include +#include + +static void* create_handle(Storage *strg, const char *path) +{ + int rv = 0; + sqlite3 *handle = NULL; + + rv = db_util_open(path, &handle, 0); + if (rv != SQLITE_OK) { + err("fail to connect database err(%d)", rv); + return NULL; + } + + dbg("connected to %s", path); + return handle; +} + +static gboolean remove_handle(Storage *strg, void *handle) +{ + if (!handle) + return FALSE; + + db_util_close(handle); + //free(handle); + + dbg("disconnected from database"); + return TRUE; +} + +static gboolean update_query_database(Storage *strg, void *handle, const char *query, GHashTable *in_param) +{ + int rv = 0; + sqlite3_stmt* stmt = NULL; + char szQuery[1000+1]; // +1 is for NULL Termination Character '\0' + + GHashTableIter iter; + gpointer key, value; + + dbg("update query"); + + memset(szQuery, '\0', 1001); + strncpy(szQuery, query, 1000); + + rv = sqlite3_prepare_v2(handle, szQuery, strlen(szQuery), &stmt, NULL); + if (rv != SQLITE_OK) { + err("fail to connect to table (%d)", rv); + return FALSE; + } + + g_hash_table_iter_init(&iter, in_param); + while (g_hash_table_iter_next(&iter, &key, &value) == TRUE) { + dbg("key(%s), value(%s)", (const char*)key, (const char*)value); + + if (!value || g_strcmp0((const char*) value, "") == 0) { + dbg("bind null"); + rv = sqlite3_bind_null(stmt, atoi((const char*) key)); + } + else { + dbg("bind value"); + rv = sqlite3_bind_text(stmt, atoi((const char*) key), (const char*) value, strlen((const char*) value), + SQLITE_STATIC); + } + + if (rv != SQLITE_OK) { + dbg("fail to bind data (%d)", rv); + return FALSE; + } + } + + rv = sqlite3_step(stmt); + dbg("update query executed (%d)", rv); + sqlite3_finalize(stmt); + + if (rv != SQLITE_DONE) { + return FALSE; + } + + return TRUE; +} + +static gboolean read_query_database(Storage *strg, void *handle, const char *query, GHashTable *in_param, + GHashTable *out_param, int out_param_cnt) +{ + int rv = 0, index = 0, outter_index = 0; + sqlite3_stmt* stmt = NULL; + char szQuery[5000+1]; // +1 is for NULL Termination Character '\0' + + GHashTableIter iter; + gpointer key, value; + + dbg("read query"); + + memset(szQuery, '\0', 5001); + strncpy(szQuery, query, 5000); + + rv = sqlite3_prepare_v2(handle, szQuery, strlen(szQuery), &stmt, NULL); + if (rv != SQLITE_OK) { + err("fail to connect to table (%d)", rv); + return FALSE; + } + + if (in_param) { + g_hash_table_iter_init(&iter, in_param); + while (g_hash_table_iter_next(&iter, &key, &value) == TRUE) { + dbg("key(%s), value(%s)", (const char*)key, (const char*)value); + + if (!value || g_strcmp0((const char*) value, "") == 0) { + dbg("bind null"); + rv = sqlite3_bind_null(stmt, atoi((const char*) key)); + } + else { + dbg("bind value"); + rv = sqlite3_bind_text(stmt, atoi((const char*) key), (const char*) value, strlen((const char*) value), + SQLITE_STATIC); + } + + if (rv != SQLITE_OK) { + dbg("fail to bind data (%d)", rv); + return FALSE; + } + } + } + + rv = sqlite3_step(stmt); + dbg("read query executed (%d)", rv); + + while (rv == SQLITE_ROW) { + + char tmp_key_outter[10]; + GHashTable *out_param_data; + + out_param_data = g_hash_table_new_full(g_str_hash, g_str_equal, NULL, g_free); + + for (index = 0; index < out_param_cnt; index++) { + char *tmp = NULL, tmp_key[10]; + tmp = (char *) sqlite3_column_text(stmt, index); + snprintf(tmp_key, sizeof(tmp_key), "%d", index); + g_hash_table_insert(out_param_data, g_strdup(tmp_key), g_strdup(tmp)); + } + + snprintf(tmp_key_outter, sizeof(tmp_key_outter), "%d", outter_index); + g_hash_table_insert(out_param, g_strdup(tmp_key_outter), out_param_data); + outter_index++; + rv = sqlite3_step(stmt); + } + + sqlite3_finalize(stmt); + return TRUE; +} + +static gboolean insert_query_database(Storage *strg, void *handle, const char *query, GHashTable *in_param) +{ + int rv = 0; + sqlite3_stmt* stmt = NULL; + char szQuery[5000+1]; // +1 is for NULL Termination Character '\0' + + GHashTableIter iter; + gpointer key, value; + dbg("insert query"); + + memset(szQuery, '\0', 5001); + strncpy(szQuery, query, 5000); + + rv = sqlite3_prepare_v2(handle, szQuery, strlen(szQuery), &stmt, NULL); + if (rv != SQLITE_OK) { + err("fail to connect to table (%d)", rv); + return FALSE; + } + + g_hash_table_iter_init(&iter, in_param); + while (g_hash_table_iter_next(&iter, &key, &value) == TRUE) { + dbg("key(%s), value(%s)", (const char*)key, (const char*)value); + + if (!value || g_strcmp0((const char*) value, "") == 0) { + dbg("bind null"); + rv = sqlite3_bind_null(stmt, atoi((const char*) key)); + } + else { + dbg("bind value"); + rv = sqlite3_bind_text(stmt, atoi((const char*) key), (const char*) value, strlen((const char*) value), + SQLITE_STATIC); + } + + if (rv != SQLITE_OK) { + dbg("fail to bind data (%d)", rv); + return FALSE; + } + } + + rv = sqlite3_step(stmt); + dbg("insert query executed (%d)", rv); + sqlite3_finalize(stmt); + + if (rv != SQLITE_DONE) { + return FALSE; + } + return TRUE; +} + +static gboolean remove_query_database(Storage *strg, void *handle, const char *query, GHashTable *in_param) +{ + int rv = 0; + sqlite3_stmt* stmt = NULL; + char szQuery[1000+1]; // +1 is for NULL Termination Character '\0' + + GHashTableIter iter; + gpointer key, value; + dbg("remove query"); + + memset(szQuery, '\0', 1001); + strncpy(szQuery, query, 1000); + + rv = sqlite3_prepare_v2(handle, szQuery, strlen(szQuery), &stmt, NULL); + if (rv != SQLITE_OK) { + err("fail to connect to table (%d)", rv); + return FALSE; + } + + g_hash_table_iter_init(&iter, in_param); + while (g_hash_table_iter_next(&iter, &key, &value) == TRUE) { + dbg("key(%s), value(%s)", (const char*)key, (const char*)value); + + if (!value || g_strcmp0((const char*) value, "") == 0) { + dbg("bind null"); + rv = sqlite3_bind_null(stmt, atoi((const char*) key)); + } + else { + dbg("bind value"); + rv = sqlite3_bind_text(stmt, atoi((const char*) key), (const char*) value, strlen((const char*) value), + SQLITE_STATIC); + } + + if (rv != SQLITE_OK) { + dbg("fail to bind data (%d)", rv); + return FALSE; + } + } + + rv = sqlite3_step(stmt); + dbg("remove query executed (%d)", rv); + sqlite3_finalize(stmt); + + if (rv != SQLITE_DONE) { + return FALSE; + } + + return TRUE; +} + +struct storage_operations ops = { + .create_handle = create_handle, + .remove_handle = remove_handle, + .update_query_database = update_query_database, + .read_query_database = read_query_database, + .insert_query_database = insert_query_database, + .remove_query_database = remove_query_database, +}; + +static gboolean on_load() +{ + dbg("i'm load!"); + return TRUE; +} + +static gboolean on_init(TcorePlugin *p) +{ + if (!p) + return FALSE; + + tcore_storage_new(p, "database", &ops); + + dbg("finish to initialize database plug-in"); + return TRUE; +} + +static void on_unload(TcorePlugin *p) +{ + dbg("i'm unload!"); + return; +} + +struct tcore_plugin_define_desc plugin_define_desc = +{ + .name = "DATABASE", + .priority = TCORE_PLUGIN_PRIORITY_HIGH -1, + .version = 1, + .load = on_load, + .init = on_init, + .unload = on_unload +}; diff --git a/tel-plugin-database.manifest b/tel-plugin-database.manifest new file mode 100644 index 0000000..0fb5c39 --- /dev/null +++ b/tel-plugin-database.manifest @@ -0,0 +1,11 @@ + + + + + + + + + + + -- 2.7.4