diff options
| -rw-r--r-- | AUTHORS | 6 | ||||
| -rw-r--r-- | CMakeLists.txt | 45 | ||||
| -rw-r--r-- | LICENSE | 204 | ||||
| -rw-r--r-- | README | 2 | ||||
| -rw-r--r-- | debian/changelog | 31 | ||||
| -rw-r--r-- | debian/compat | 1 | ||||
| -rw-r--r-- | debian/control | 21 | ||||
| -rw-r--r-- | debian/copyright | 7 | ||||
| -rw-r--r-- | debian/dirs | 2 | ||||
| -rw-r--r-- | debian/docs | 0 | ||||
| -rwxr-xr-x | debian/rules | 123 | ||||
| -rw-r--r-- | debian/tel-plugin-database.install.in | 1 | ||||
| -rw-r--r-- | packaging/tel-plugin-database.spec | 39 | ||||
| -rw-r--r-- | src/database_main.c | 323 |
14 files changed, 805 insertions, 0 deletions
@@ -0,0 +1,6 @@ +Jongman Park <jman.park@samsung.com> +Ja-young Gu <jygu@samsung.com> +Kyeongchul Kim <kyeongchul.kim@samsung.com> +DongHoo Park <donghoo.park@samsung.> +Youngman Park <youngman.park@samsung.com> +Inho Oh <inho48.oh@samsung.com> diff --git a/CMakeLists.txt b/CMakeLists.txt new file mode 100644 index 0000000..681e803 --- /dev/null +++ b/CMakeLists.txt @@ -0,0 +1,45 @@ +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=\"SP_DB\"") + +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) @@ -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.
+
@@ -0,0 +1,2 @@ +database access plug-in +DongHoo Park - evilpanda
\ No newline at end of file diff --git a/debian/changelog b/debian/changelog new file mode 100644 index 0000000..65d5748 --- /dev/null +++ b/debian/changelog @@ -0,0 +1,31 @@ +tel-plugin-database (0.1.3) unstable; urgency=low + + * fix crash + * Git: pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.3 + + -- DongHoo Park <donghoo.park@samsung.com> Thu, 29 Mar 2012 13:49:39 +0900 + +tel-plugin-database (0.1.2) unstable; urgency=low + + * Fix prefix (TAPI_ to TCORE_) + * Git: pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.2 + + -- Inho Oh <inho48.oh@samsung.com> Tue, 27 Mar 2012 22:12:52 +0900 + +tel-plugin-database (0.1.1) unstable; urgency=low + + * Add .spec file for OBS + * Git: pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.1 + + -- DongHoo Park <donghoo.park@samsung.com> Fri, 16 Mar 2012 21:14:25 +0900 + +tel-plugin-database (0.1.0) unstable; urgency=low + + * initialize + * Git: pkgs/t/tel-plugin-database + * Tag: tel-plugin-database_0.1.0 + + -- Inho Oh <inho48.oh@samsung.com> 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 <donghoo.park@samsung.com> +Uploaders: DongHoo Park <donghoo.park@samsung.com> +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..d5a0cca --- /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 GNU Lesser General Public License version 2.1. + +The full text of the LGPL 2.1 can be found in +/usr/share/common-licenses. 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 --- /dev/null +++ b/debian/docs 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..952e743 --- /dev/null +++ b/packaging/tel-plugin-database.spec @@ -0,0 +1,39 @@ +#sbs-git:slp/pkgs/t/tel-plugin-database +Name: tel-plugin-database +Summary: Telephony DataBase storage plugin +Version: 0.1.3 +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 + +%files +%defattr(-,root,root,-) +#%doc COPYING +%{_libdir}/telephony/plugins/db-plugin* diff --git a/src/database_main.c b/src/database_main.c new file mode 100644 index 0000000..093fa3c --- /dev/null +++ b/src/database_main.c @@ -0,0 +1,323 @@ +/* + * tel-plugin-database + * + * Copyright (c) 2012 Samsung Electronics Co., Ltd. All rights reserved. + * + * Contact: DongHoo Park <donghoo.park@samsung.com> + * + * 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 <stdio.h> +#include <stdlib.h> +#include <string.h> +#include <strings.h> + +#include <glib.h> +#include <db-util.h> + +#include <tcore.h> +#include <plugin.h> +#include <storage.h> + +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]; + + GHashTableIter iter; + gpointer key, value; + + dbg("update query"); + + memset(szQuery, '\0', 1000); + strcpy(szQuery, query); + + 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]; + + GHashTableIter iter; + gpointer key, value; + + dbg("read query"); + + memset(szQuery, '\0', 5000); + strcpy(szQuery, query); + + 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]; + + GHashTableIter iter; + gpointer key, value; + dbg("insert query"); + + memset(szQuery, '\0', 5000); + strcpy(szQuery, query); + + 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]; + + GHashTableIter iter; + gpointer key, value; + dbg("remove query"); + + memset(szQuery, '\0', 1000); + strcpy(szQuery, query); + + 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) +{ + Storage *strg; + + if (!p) + return FALSE; + + strg = 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 +}; |