Git init

2 files changed, 915 insertions, 0 deletions

diff --git a/src/appsvc.c b/src/appsvc.c
new file mode 100755
index 0000000..0adcdca
--- /dev/null
+++ b/src/appsvc.c
@@ -0,0 +1,676 @@
+/*
+ *  app-svc
+ *
+ * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@samsung.com>, Sewook Park <sewook7.park@samsung.com>, Jaeho Lee <jaeho81.lee@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 <glib.h>
+#include <string.h>
+
+#include <ail.h>
+#include <aul.h>
+
+#include "appsvc.h"
+#include "appsvc_db.h"
+#include "internal.h"
+#include "priv_key.h"
+
+
+
+
+#define APP_SELECTOR "org.tizen.app-selector"
+
+#ifndef SLPAPI
+#define SLPAPI __attribute__ ((visibility("default")))
+#endif
+
+
+/* callback handling */
+typedef struct _appsvc_cb_info_t{
+	appsvc_res_fn cb_func;
+	int request_code;
+	void *data;
+}appsvc_cb_info_t;
+
+typedef struct _appsvc_resolve_info_t{
+	char *pkgname;
+	char *op;
+	char *uri;
+	char *scheme;
+	char *origin_mime;
+	char *mime;	
+	char *m_type;
+	char *s_type;
+	int mime_set;
+}appsvc_resolve_info_t;
+
+static appsvc_cb_info_t *__create_rescb(int request_code, appsvc_res_fn cbfunc,
+					void *data);
+static void __remove_rescb(appsvc_cb_info_t *info);
+static void __bundle_iterate(const char *key, const char *val, void *data);
+static int __set_bundle(bundle *b, const char *key, const char *value);
+static void __aul_cb(bundle *b, int is_cancel, void *data);
+static int __svc_iter_func(const char* pkg_name, void *data);
+static int __run_svc_with_pkgname(char *pkgname, bundle *b, int request_code,
+				  appsvc_res_fn cbfunc, void *data);
+static int __get_resolve_info(bundle *b, appsvc_resolve_info_t *info);
+static int __free_resolve_info_data(appsvc_resolve_info_t *info);
+static ail_cb_ret_e __ail_iter_func(const ail_appinfo_h appinfo,
+				    void *user_data);
+static int __get_list_with_condition(char *op, char *scheme, 
+				     char *mime, GSList **pkg_list);
+
+
+static appsvc_cb_info_t *__create_rescb(int request_code, appsvc_res_fn cbfunc, void *data)
+{
+	appsvc_cb_info_t* info;
+
+	info = (appsvc_cb_info_t*)calloc(1, sizeof(appsvc_cb_info_t));
+	if(info == NULL)
+		return NULL;
+
+	info->request_code = request_code;
+	info->cb_func = cbfunc;
+	info->data = data;
+
+	return info;
+}
+
+static void __remove_rescb(appsvc_cb_info_t *info)
+{
+	if(info) free(info);
+}
+
+static void __bundle_iterate(const char *key, const char *val, void *data)
+{
+	static int i=0;	
+	_D("%d %s %s", i++, key, val);
+}
+
+static int __set_bundle(bundle *b, const char *key, const char *value)
+{
+	char *val = bundle_get_val(b, key);
+	if(val){
+		if( bundle_del(b, key) != 0 ){
+			return APPSVC_RET_ERROR;
+		}
+	}
+
+	if(!value) 
+		return APPSVC_RET_EINVAL;
+		
+	if( bundle_add(b, key, value) != 0 ){
+		return APPSVC_RET_ERROR;
+	}
+
+	_D("__set_bundle");
+//	bundle_iterate(b, __bundle_iterate, NULL);
+
+	return APPSVC_RET_OK;
+}
+
+static int __set_bundle_array(bundle *b, const char *key, const char **value, int len)
+{
+
+	int type;
+	type = appsvc_data_is_array(b, key);
+
+	if(type == 1) {
+		if( bundle_del(b, key) != 0 ){
+			return APPSVC_RET_ERROR;
+		}
+	}
+
+	if(!value) 
+		return APPSVC_RET_EINVAL;
+
+	if( bundle_add_str_array(b, key, value, len) != 0 ){
+		return APPSVC_RET_ERROR;
+	}
+
+	_D("__set_bundle_array");
+//	bundle_iterate(b, __bundle_iterate, NULL);
+
+	return APPSVC_RET_OK;
+}
+
+
+static void __aul_cb(bundle *b, int is_cancel, void *data)
+{
+	char *val;
+	appsvc_cb_info_t*  cb_info;
+	int res;
+
+	if(is_cancel)
+		res = APPSVC_RES_CANCEL;
+	else{
+		/* get result_code from bundle */
+		val = bundle_get_val(b, APP_SVC_K_RES_VAL);
+		res = (val==NULL)? APPSVC_RES_NOT_OK : atoi(val);
+	}
+
+	/* remove result_code from bundle */
+	bundle_del(b, APP_SVC_K_RES_VAL);
+
+	/* find corresponding callback */
+	cb_info = (appsvc_cb_info_t*)data;
+	
+	cb_info->cb_func(b, cb_info->request_code, (appsvc_result_val)res, cb_info->data);
+	__remove_rescb(cb_info);
+	
+
+	return;
+}
+
+static int __svc_iter_func(const char* pkg_name, void *data)
+{
+	GSList **pkg_list = (GSList **)data;
+	char *pkgname = NULL;
+
+	pkgname = strdup(pkg_name);
+
+	*pkg_list = g_slist_append(*pkg_list, pkgname);
+
+	return 0;
+}
+
+static int __run_svc_with_pkgname(char *pkgname, bundle *b, int request_code, appsvc_res_fn cbfunc, void *data)
+{
+	appsvc_cb_info_t *cb_info = NULL;
+	int ret = -1;
+	
+	if (cbfunc) {
+		_D("pkg_name : %s - with result", pkgname);
+
+		cb_info = __create_rescb(request_code, cbfunc, data);
+		ret = aul_launch_app_with_result(pkgname, b, __aul_cb, cb_info);
+		if(ret < 0)
+			ret = APPSVC_RET_ELAUNCH;
+	} else {
+		_D("pkg_name : %s - no result", pkgname);
+		ret = aul_launch_app(pkgname, b);
+		if(ret < 0)
+			ret = APPSVC_RET_ELAUNCH;
+	}
+
+	return ret;
+}
+
+static int __get_resolve_info(bundle *b, appsvc_resolve_info_t *info)
+{
+	char *tmp = NULL;
+	char *tmp2 = NULL;
+	char *strtok_buf = NULL;
+	
+	info->op = appsvc_get_operation(b);
+	info->uri = appsvc_get_uri(b);
+	info->origin_mime = info->mime = appsvc_get_mime(b);
+	info->pkgname = appsvc_get_pkgname(b);
+
+	if(info->uri) {
+		if(strncmp(info->uri,"/",1) == 0){
+			if(!info->mime) {
+				info->mime = malloc(MAX_MIME_STR_SIZE);
+				aul_get_mime_from_file(info->uri, info->mime, MAX_MIME_STR_SIZE);
+				info->mime_set = 1;
+			}
+			info->uri = NULL;			
+		} else if(strncmp(info->uri,"file:/",6)==0){
+			if(!info->mime) {
+				info->mime = malloc(MAX_MIME_STR_SIZE);
+				aul_get_mime_from_file(&info->uri[5], info->mime, MAX_MIME_STR_SIZE);
+				info->mime_set = 1;
+			}
+			info->uri = NULL;
+		} else if(strncmp(info->uri,"file:///",8) == 0){
+			if(!info->mime) {
+				info->mime = malloc(MAX_MIME_STR_SIZE);
+				aul_get_mime_from_file(&info->uri[7], info->mime, MAX_MIME_STR_SIZE);	
+				info->mime_set = 1;
+			}
+			info->uri = NULL;
+		}
+	}
+
+	if(info->uri) {
+		info->scheme = malloc(MAX_SCHEME_STR_SIZE);
+		tmp = strdup(info->uri);
+		tmp2 = strtok(tmp,":");
+		if(tmp2)
+			strncpy(info->scheme, tmp2, MAX_SCHEME_STR_SIZE-1);
+		free(tmp);
+	} else {
+		info->scheme = strdup("NULL");
+	}
+
+	if(!info->mime) 
+		info->mime = strdup("NULL");
+	else {
+		info->m_type = malloc(MAX_LOCAL_BUFSZ);
+		info->s_type = malloc(MAX_LOCAL_BUFSZ);
+		tmp = strdup(info->mime);
+		strtok_buf = strtok(tmp,"/");
+		if(strtok_buf)
+			strncpy(info->m_type, strtok_buf, MAX_LOCAL_BUFSZ-1);
+		strtok_buf = strtok(NULL,"/");
+		if(strtok_buf)
+			strncpy(info->s_type, strtok_buf, MAX_LOCAL_BUFSZ-1);
+		free(tmp);
+
+		if(strncmp(info->m_type, "*", 1) == 0) {
+			strncpy(info->m_type, "%", MAX_LOCAL_BUFSZ-1);
+		}
+		if(strncmp(info->s_type, "*", 1) == 0) {
+			strncpy(info->s_type, "%", MAX_LOCAL_BUFSZ-1);	
+		}
+
+		if(!info->mime_set) info->mime = malloc(MAX_MIME_STR_SIZE);
+		snprintf(info->mime, MAX_MIME_STR_SIZE-1, "%s/%s", info->m_type, info->s_type);
+	}
+
+	return 0;
+}
+
+static int __free_resolve_info_data(appsvc_resolve_info_t *info)
+{
+	if (info->mime) 
+		free(info->mime);
+	if (info->scheme) 
+		free(info->scheme);
+	if (info->m_type)
+		free(info->m_type);
+	if (info->s_type)
+		free(info->s_type);
+	
+	return 0;
+}
+
+static ail_cb_ret_e __ail_iter_func(
+			const ail_appinfo_h appinfo, void *user_data)
+{
+	GSList **pkg_list = (GSList **)user_data;
+	GSList *iter = NULL;
+	char *str = NULL;
+	char *pkgname = NULL;
+
+	ail_appinfo_get_str(appinfo, AIL_PROP_PACKAGE_STR, &str);
+
+	_D("Matching application is %s",str);
+
+	for (iter = *pkg_list; iter != NULL; iter = g_slist_next(iter)) {
+		pkgname = (char *)iter->data;
+		if (strncmp(str, pkgname, MAX_PACKAGE_STR_SIZE-1) == 0)
+			return AIL_CB_RET_CONTINUE;
+	}
+
+	pkgname = strdup(str);
+	*pkg_list = g_slist_append(*pkg_list, (void *)pkgname);
+	_D("%s is added",pkgname);
+
+	return AIL_CB_RET_CONTINUE;
+}
+
+static int __get_list_with_condition(char *op, char *scheme, char *mime, GSList **pkg_list)
+{
+	ail_filter_h filter;
+	ail_error_e ail_ret;
+	char svc_filter[MAX_FILTER_STR_SIZE] = {0,};
+	
+	ail_ret = ail_filter_new(&filter);
+	if (ail_ret != AIL_ERROR_OK) 
+		return APPSVC_RET_ERROR;
+
+	snprintf(svc_filter, MAX_FILTER_STR_SIZE-1, "%s:%s:%s", op, scheme, mime);
+	_D("svc_filter : %s",svc_filter);
+
+	ail_ret = ail_filter_add_str(filter, AIL_PROP_X_SLP_SVC_STR, svc_filter);
+	if (ail_ret != AIL_ERROR_OK) {
+		ail_filter_destroy(filter);
+		return APPSVC_RET_ERROR;
+	}
+
+	ail_filter_list_appinfo_foreach(filter, __ail_iter_func, (void *)pkg_list);
+
+	ail_filter_destroy(filter);
+
+	return APPSVC_RET_OK;
+}
+
+SLPAPI int appsvc_set_operation(bundle *b, const char *operation)
+{	
+	if(b == NULL){
+		_E("bundle for appsvc_set_operation is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+
+	return __set_bundle(b, APP_SVC_K_OPERATION, operation);
+}
+
+SLPAPI int appsvc_set_uri(bundle *b, const char *uri)
+{	
+	if(b == NULL){
+		_E("bundle for appsvc_set_uri is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+	
+	return __set_bundle(b, APP_SVC_K_URI, uri);
+}
+
+SLPAPI int appsvc_set_mime(bundle *b, const char *mime)
+{	
+	if(b == NULL){
+		_E("bundle for appsvc_set_mime is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+
+	return __set_bundle(b, APP_SVC_K_MIME, mime);
+}
+
+SLPAPI int appsvc_add_data(bundle *b, const char *key, const char *val)
+{
+	if(b == NULL || key == NULL) {
+		return APPSVC_RET_EINVAL;
+	}
+
+	/* check key for data */
+	/******************/
+
+	return __set_bundle(b, key, val);
+}
+
+SLPAPI int appsvc_add_data_array(bundle *b, const char *key,  const char **val_array, int len)
+{
+	if(b == NULL || key == NULL) {
+		return APPSVC_RET_EINVAL;
+	}
+
+	/* check key for data */
+	/******************/
+
+	return __set_bundle_array(b, key, val_array, len);
+}
+
+
+SLPAPI int appsvc_set_pkgname(bundle *b, const char *pkg_name)
+{	
+	if(b == NULL){
+		_E("bundle for appsvc_set_pkgname is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+
+	return __set_bundle(b, APP_SVC_K_PKG_NAME, pkg_name);
+}
+
+SLPAPI int appsvc_run_service(bundle *b, int request_code, appsvc_res_fn cbfunc, void *data)
+{
+	appsvc_resolve_info_t info;
+	char *pkgname;
+	int pkg_count = 0;
+	int ret = -1;
+
+	int mime_set = 0;
+
+	GSList *pkg_list = NULL;
+	GSList *iter = NULL;
+	char *list_item;
+
+	if(b == NULL){
+		_E("bundle for appsvc_set_pkgname is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+
+	memset(&info, 0, sizeof(appsvc_resolve_info_t));
+	__get_resolve_info(b, &info);
+
+	pkgname = info.pkgname;
+	_D("op - %s / mime - %s / shceme - %s\n", info.op, info.mime, info.scheme);
+
+	/* explict*/
+	if(pkgname) {
+		if(appsvc_get_operation(b) == NULL)
+			appsvc_set_operation(b,APPSVC_OPERATION_DEFAULT);
+		ret = __run_svc_with_pkgname(pkgname, b, request_code, cbfunc, data);
+		if (info.mime_set) appsvc_set_mime(b,NULL);
+		__free_resolve_info_data(&info);
+		return ret;
+	}
+	
+	pkgname = _svc_db_get_app(info.op, info.origin_mime, info.scheme);
+
+	if(pkgname==NULL){
+		appsvc_get_list(b, __svc_iter_func, (void *)&pkg_list);
+		
+		pkg_count = g_slist_length(pkg_list);
+		if(pkg_count == 1){
+			pkgname = (char *)pkg_list->data;
+			if(pkgname != NULL){
+				ret = __run_svc_with_pkgname(pkgname, b, request_code, cbfunc, data);
+			}
+		}
+		else if(pkg_count < 1){
+			if (info.mime_set) appsvc_set_mime(b,NULL);
+			return APPSVC_RET_ENOMATCH;
+		} else {
+			ret = __run_svc_with_pkgname(APP_SELECTOR, b, request_code, cbfunc, data);
+		}
+
+		for (iter = pkg_list; iter != NULL; iter = g_slist_next(iter)) {
+			list_item = (char *)iter->data;
+			g_free(list_item);
+		}
+		g_slist_free(pkg_list);	
+	} else {
+		ret = __run_svc_with_pkgname(pkgname, b, request_code, cbfunc, data);
+	}
+	if (info.mime_set) appsvc_set_mime(b,NULL);
+
+	__free_resolve_info_data(&info);
+	return ret;
+}
+
+SLPAPI int appsvc_get_list(bundle *b, appsvc_info_iter_fn iter_fn, void *data)
+{
+	appsvc_resolve_info_t info;
+	char *pkgname = NULL;
+	int pkg_count;
+
+	GSList *pkg_list = NULL;
+	GSList *iter = NULL;
+
+	if(b == NULL){
+		_E("bundle for appsvc_run_service is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+	
+	if (iter_fn == NULL){
+		_E("iter_fn for appsvc_run_service is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+	
+	/* parse bundle */
+	memset(&info, 0, sizeof(appsvc_resolve_info_t));
+	__get_resolve_info(b,&info);
+	
+	_D("operation - %s / shceme - %s / mime - %s\n", info.op, info.scheme, info.mime);
+	__get_list_with_condition(info.op, info.scheme,info.mime, &pkg_list);
+
+	if ((strncmp(info.mime, "NULL", 4) != 0) && (strncmp(info.s_type, "%", 1) != 0)) {
+		snprintf(info.mime, MAX_MIME_STR_SIZE-1, "%s/*", info.m_type);
+		__get_list_with_condition(info.op, info.scheme, info.mime, &pkg_list);
+	}
+
+	if ((strncmp(info.mime, "NULL", 4) != 0) && (strncmp(info.m_type, "%", 1) != 0)) {
+		snprintf(info.mime, MAX_MIME_STR_SIZE-1, "*/*");
+		__get_list_with_condition(info.op, info.scheme, info.mime, &pkg_list);
+	}
+
+	pkg_count = g_slist_length(pkg_list);
+	if (pkg_count == 0) {
+		_E("Cannot find associated application");
+		return APPSVC_RET_ENOMATCH;
+	}
+
+	for (iter = pkg_list; iter != NULL; iter = g_slist_next(iter)) {
+		pkgname = iter->data;
+		_D("PKGNAME : %s\n", pkgname);
+		if( iter_fn(pkgname,data) != 0)
+			break;
+		g_free(pkgname);
+	}
+
+	g_slist_free(pkg_list);
+	__free_resolve_info_data(&info);
+
+	return APPSVC_RET_OK;	
+}
+
+SLPAPI const char *appsvc_get_operation(bundle *b)
+{
+	return bundle_get_val(b, APP_SVC_K_OPERATION);
+}
+
+SLPAPI const char *appsvc_get_uri(bundle *b)
+{
+	return bundle_get_val(b, APP_SVC_K_URI);
+}
+
+SLPAPI const char *appsvc_get_mime(bundle *b)
+{
+	return bundle_get_val(b, APP_SVC_K_MIME);
+}
+
+SLPAPI const char *appsvc_get_data(bundle *b, const char *key)
+{
+	return bundle_get_val(b, key);
+}
+
+SLPAPI const char **appsvc_get_data_array(bundle *b, const char *key, int *len)
+{
+	return bundle_get_str_array(b, key, len);
+}
+
+SLPAPI const char *appsvc_get_pkgname(bundle *b)
+{
+	return bundle_get_val(b, APP_SVC_K_PKG_NAME);
+}
+
+SLPAPI int appsvc_create_result_bundle(bundle *inb, bundle **outb)
+{
+	int ret = -1;
+
+	if(inb == NULL || outb == NULL) {
+		_E("bundle is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+	
+	ret = aul_create_result_bundle(inb, outb);
+
+	/* add additional bundle */
+	/*	bundle_add(outb, " ", " ");  */
+
+	if(ret == AUL_R_OK)
+		ret = APPSVC_RET_OK;
+	else if(ret == AUL_R_EINVAL)
+		ret = APPSVC_RET_EINVAL;
+	else
+		ret = APPSVC_RET_ERROR;
+
+	return ret;
+}
+
+SLPAPI int appsvc_send_result(bundle *b, appsvc_result_val result)
+{
+	int ret;
+	char tmp[MAX_LOCAL_BUFSZ];
+	
+	if(b == NULL){
+		_E("appsvc_send_result is NULL");
+		return APPSVC_RET_EINVAL;
+	}
+
+	if(result != APPSVC_RES_OK && result != APPSVC_RES_NOT_OK){
+		_E("invalid result %d", (int)result);
+		return APPSVC_RET_EINVAL;
+	}
+
+	/* add result_code to bundle */
+	snprintf(tmp,MAX_LOCAL_BUFSZ,"%d", (int)result);
+	ret = __set_bundle(b, APP_SVC_K_RES_VAL, tmp);
+	if(ret < 0)
+		return APPSVC_RET_ERROR;
+
+	ret = aul_send_service_result(b);
+
+	/* remove result_code from bundle */
+	bundle_del(b, APP_SVC_K_RES_VAL);
+
+	return ret;
+} 
+
+SLPAPI int appsvc_set_defapp(const char *op,const char *mime_type,const char *scheme,const char *defapp)
+{
+	int ret;
+
+	if(op == NULL || defapp == NULL)
+		return APPSVC_RET_EINVAL;
+
+	ret = _svc_db_add_app(op,mime_type,scheme,defapp);
+
+	if(ret < 0)
+		return APPSVC_RET_ERROR;
+	
+	return APPSVC_RET_OK;
+}
+
+SLPAPI int appsvc_unset_defapp(const char *defapp)
+{
+	int ret;
+
+	if(defapp == NULL)
+		return APPSVC_RET_EINVAL;
+
+	ret = _svc_db_delete_with_pkgname(defapp);
+
+	if(ret < 0) 
+		return APPSVC_RET_ERROR;
+	
+	return APPSVC_RET_OK;
+}
+
+SLPAPI int appsvc_is_defapp(const char *pkg_name)
+{
+	return _svc_db_is_defapp(pkg_name);
+}
+
+SLPAPI int appsvc_data_is_array(bundle *b, const char *key)
+{
+	int type;
+	type = bundle_get_type(b, key);
+
+	if(type <= 0)
+		return 0;
+
+	if(type & BUNDLE_TYPE_ARRAY) 
+		return 1;
+	return 0;
+}
+
+
diff --git a/src/appsvc_db.c b/src/appsvc_db.c
new file mode 100755
index 0000000..d56ca16
--- /dev/null
+++ b/src/appsvc_db.c
@@ -0,0 +1,239 @@
+/*
+ *  app-svc
+ *
+ * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
+ *
+ * Contact: Jayoun Lee <airjany@samsung.com>, Sewook Park <sewook7.park@samsung.com>, Jaeho Lee <jaeho81.lee@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 <string.h>
+#include <stdlib.h>
+
+#include "appsvc_db.h"
+#include "internal.h"
+
+
+#define SVC_DB_PATH	"/opt/dbspace/.appsvc.db"
+#define QUERY_MAXLEN	4096
+#define BUF_MAX_LEN	1024
+
+static sqlite3 *svc_db = NULL;
+
+
+/**
+ * db initialize
+ */
+static int __init(void)
+{
+	int rc;
+	
+	if (svc_db) {
+		_D("Already initialized\n");
+		return 0;
+	}
+
+	rc = sqlite3_open(SVC_DB_PATH, &svc_db);
+	if(rc) {
+		_E("Can't open database: %s", sqlite3_errmsg(svc_db));
+		goto err;
+	}
+
+	// Enable persist journal mode
+	rc = sqlite3_exec(svc_db, "PRAGMA journal_mode = PERSIST", NULL, NULL, NULL);
+	if(SQLITE_OK!=rc){
+		_D("Fail to change journal mode\n");
+		goto err;
+	}
+
+	return 0;
+err:
+	sqlite3_close(svc_db);
+	return -1;
+}
+
+static int __fini(void)
+{
+	if (svc_db) {
+		sqlite3_close(svc_db);
+		svc_db = NULL;
+	}
+	return 0;
+}
+
+
+int _svc_db_add_app(const char *op, const char *mime_type, const char *uri, const char *pkg_name)
+{
+	int ret = -1;
+	char m[BUF_MAX_LEN];
+	char u[BUF_MAX_LEN];
+	char query[BUF_MAX_LEN];
+	char* error_message = NULL;
+
+	if(__init()<0)
+		return -1;
+
+	if(op == NULL )
+		return -1;
+
+	if(mime_type==NULL)
+		strncpy(m,"NULL",BUF_MAX_LEN-1);
+	else 
+		strncpy(m,mime_type,BUF_MAX_LEN-1);
+
+	if(uri==NULL)
+		strncpy(u,"NULL",BUF_MAX_LEN-1);
+	else 
+		strncpy(u,uri,BUF_MAX_LEN-1);
+	
+	sprintf(query,"insert into appsvc( operation, mime_type, uri, pkg_name) \
+		values('%s','%s','%s','%s')",op,m,u,pkg_name);
+
+	if (SQLITE_OK != sqlite3_exec(svc_db, query, NULL, NULL, &error_message))
+	{
+	 	_E("Don't execute query = %s, error message = %s\n", query, error_message);
+		return -1;
+	}
+	
+	__fini();
+	return 0;
+}
+
+int _svc_db_delete_with_pkgname(const char *pkg_name)
+{
+	char query[BUF_MAX_LEN];
+	char* error_message = NULL;
+	
+	if(pkg_name == NULL) {
+		_E("Invalid argument: data to delete is NULL\n");
+		return -1;
+	}
+
+	if(__init()<0)
+		return -1;
+
+	snprintf(query, BUF_MAX_LEN, "delete from appsvc where pkg_name = '%s';", pkg_name);
+
+	if (SQLITE_OK != sqlite3_exec(svc_db, query, NULL, NULL, &error_message))
+	{
+	 	_E("Don't execute query = %s, error message = %s\n", query, error_message);
+		return -1;
+	}
+		
+	__fini();
+
+	return 0;
+}
+
+int _svc_db_is_defapp(const char *pkg_name)
+{
+	char query[BUF_MAX_LEN];
+	char* error_message = NULL;
+	sqlite3_stmt *stmt;
+	int cnt = 0;
+	int ret = -1;
+	
+	if(pkg_name == NULL) {
+		_E("Invalid argument: data to delete is NULL\n");
+		return 0;
+	}
+
+	if(__init()<0)
+		return 0;
+
+	snprintf(query, BUF_MAX_LEN,
+		"select count(*) from appsvc where pkg_name = '%s';", pkg_name);
+
+	ret = sqlite3_prepare(svc_db, query, sizeof(query), &stmt, NULL);
+	if (ret != SQLITE_OK) {
+		return -1;
+	}
+
+	ret = sqlite3_step(stmt);
+	if (ret == SQLITE_ROW) {
+		cnt = sqlite3_column_int(stmt, 0);
+	}
+	sqlite3_finalize(stmt);
+		
+	__fini();
+
+	if(cnt < 1) return 0;
+
+	return 1;
+}
+
+char* _svc_db_get_app(const char *op, const char *mime_type, const char *uri)
+{
+	char* res = NULL;
+	char m[BUF_MAX_LEN];
+	char u[BUF_MAX_LEN];
+	char query[BUF_MAX_LEN];
+	char* error_message = NULL;
+	sqlite3_stmt* stmt;
+	int ret;
+	char* pkgname;
+
+	if(op == NULL )
+		return NULL;
+
+	if(mime_type==NULL)
+		strncpy(m,"NULL",BUF_MAX_LEN-1);
+	else 
+		strncpy(m,mime_type,BUF_MAX_LEN-1);
+
+	if(uri==NULL)
+		strncpy(u,"NULL",BUF_MAX_LEN-1);
+	else 
+		strncpy(u,uri,BUF_MAX_LEN-1);
+
+//	if(doubt_sql_injection(mime_type))
+//		return NULL;
+	
+	if(__init() < 0)
+		return NULL;
+	
+	
+	sprintf(query,"select pkg_name from appsvc where operation='%s' and mime_type='%s' and uri='%s'",\
+				op,m,u);
+
+	_D("query : %s\n",query);
+
+	ret = sqlite3_prepare(svc_db, query, strlen(query), &stmt, NULL);
+
+	if ( ret != SQLITE_OK) {
+		_E("prepare error\n");
+		return NULL;
+	}
+
+	ret = sqlite3_step(stmt);
+	if (ret == SQLITE_DONE) {
+		return NULL;
+	}
+
+	pkgname = malloc(BUF_MAX_LEN);
+	strncpy(pkgname,	sqlite3_column_text(stmt, 0),BUF_MAX_LEN-1);
+	//pkgname = (char*) sqlite3_column_text(stmt, 0);
+
+	_D("pkgname : %s\n",pkgname);
+	
+	ret = sqlite3_finalize(stmt);
+
+	__fini();
+
+	return pkgname;
+}
+