upload tizen1.0 source

14 files changed, 805 insertions, 0 deletions

diff --git a/AUTHORS b/AUTHORS
new file mode 100644
index 0000000..0e9faa9
--- /dev/null
+++ b/AUTHORS
@@ -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)
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/README b/README
new file mode 100644
index 0000000..fde8c86
--- /dev/null
+++ b/README
@@ -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
+};