X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fpkgmgrinfo_certinfo.c;h=c626b519180812690af733a6da3bf5342c72ce1a;hb=0351902ae4693aa31e73fe53d509e66683aa904d;hp=4fceee2dc59bbaeaf8750e60e2cc419cd9a3a14d;hpb=8d814684ca84d93193345fd24d60fdef2b028680;p=platform%2Fcore%2Fappfw%2Fpkgmgr-info.git

diff --git a/src/pkgmgrinfo_certinfo.c b/src/pkgmgrinfo_certinfo.c
index 4fceee2..c626b51 100644
--- a/src/pkgmgrinfo_certinfo.c
+++ b/src/pkgmgrinfo_certinfo.c
@@ -129,7 +129,7 @@ API int pkgmgrinfo_pkginfo_compare_usr_pkg_cert_info(const char *lhs_package_id,
 	if (dbpath == NULL)
 		return PMINFO_R_ERROR;
 
-	ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
+	ret = __open_db(dbpath, &db, SQLITE_OPEN_READONLY);
 	if (ret != SQLITE_OK) {
 		_LOGE("failed to open db: %d", ret);
 		free(dbpath);
@@ -168,7 +168,7 @@ static int _pkginfo_get_pkgid_from_appid(uid_t uid, const char *appid,
 	if (dbpath == NULL)
 		return PMINFO_R_ERROR;
 
-	ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
+	ret = __open_db(dbpath, &db, SQLITE_OPEN_READONLY);
 	if (ret != SQLITE_OK) {
 		_LOGE("failed to open db: %d", ret);
 		free(dbpath);
@@ -367,7 +367,7 @@ static int _pkginfo_get_certinfo(const char *pkgid, pkgmgr_certinfo_x *info)
 	if (dbpath == NULL)
 		return PMINFO_R_ERROR;
 
-	ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
+	ret = __open_db(dbpath, &db, SQLITE_OPEN_READONLY);
 	if (ret != SQLITE_OK) {
 		_LOGE("failed to open db: %d", ret);
 		free(dbpath);
@@ -387,6 +387,8 @@ static int _pkginfo_get_certinfo(const char *pkgid, pkgmgr_certinfo_x *info)
 		return ret;
 	}
 
+	sqlite3_close_v2(db);
+
 	return PMINFO_R_OK;
 }
 
@@ -601,12 +603,14 @@ API int pkgmgrinfo_save_certinfo(const char *pkgid, pkgmgrinfo_instcertinfo_h ha
 		return PMINFO_R_EINVAL;
 	}
 
+	_check_create_cert_db();
+
 	/* open unified global cert db */
 	dbpath = getUserPkgCertDBPathUID(GLOBAL_USER);
 	if (dbpath == NULL)
 		return PMINFO_R_ERROR;
 
-	ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READWRITE, NULL);
+	ret = __open_db(dbpath, &db, SQLITE_OPEN_READWRITE);
 	if (ret != SQLITE_OK) {
 		_LOGE("failed to open db: %d", ret);
 		free(dbpath);
@@ -621,8 +625,6 @@ API int pkgmgrinfo_save_certinfo(const char *pkgid, pkgmgrinfo_instcertinfo_h ha
 		return PMINFO_R_ERROR;
 	}
 
-	_check_create_cert_db(db);
-
 	if (_pkginfo_save_cert_index_info(db, info->cert_info)) {
 		_LOGE("failed to save cert index info, rollback now");
 		sqlite3_exec(GET_DB(cert_db), "ROLLBACK", NULL, NULL, NULL);
@@ -719,7 +721,7 @@ API int pkgmgrinfo_delete_usr_certinfo(const char *pkgid, uid_t uid)
 	if (dbpath == NULL)
 		return PMINFO_R_ERROR;
 
-	ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READWRITE, NULL);
+	ret = __open_db(dbpath, &db, SQLITE_OPEN_READWRITE);
 	if (ret != SQLITE_OK) {
 		_LOGE("failed to open db: %d", ret);
 		free(dbpath);