X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fpkgmgrinfo_db.c;h=0ead442398a572b154eaf6d785352cc5f65d105d;hb=296b836f2187cedf267ad21b78aea105d6ba6e7e;hp=7af6e7123271256d39b3c56beea761db43a9f3f0;hpb=6b7a6f903afb575920f322489e481aa78c18c1d3;p=platform%2Fcore%2Fappfw%2Fpkgmgr-info.git

diff --git a/src/pkgmgrinfo_db.c b/src/pkgmgrinfo_db.c
index 7af6e71..0ead442 100644
--- a/src/pkgmgrinfo_db.c
+++ b/src/pkgmgrinfo_db.c
@@ -19,78 +19,7 @@
 #include "pkgmgrinfo_debug.h"
 #include "pkgmgrinfo_private.h"
 #include "pkgmgr_parser.h"
-
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO \
-	"CREATE TABLE IF NOT EXISTS package_cert_index_info( " \
-	" cert_info TEXT UNIQUE, " \
-	" cert_id INTEGER PRIMARY KEY, " \
-	" cert_ref_count INTEGER NOT NULL)"
-
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INFO \
-	"CREATE TABLE IF NOT EXISTS package_cert_info( " \
-	" package TEXT PRIMARY KEY, " \
-	" package_count INTEGER, " \
-	" author_root_cert INTEGER, " \
-	" author_im_cert INTEGER, " \
-	" author_signer_cert INTEGER, " \
-	" dist_root_cert INTEGER, " \
-	" dist_im_cert INTEGER, " \
-	" dist_signer_cert INTEGER, " \
-	" dist2_root_cert INTEGER, " \
-	" dist2_im_cert INTEGER, " \
-	" dist2_signer_cert INTEGER)"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO \
-	"CREATE TRIGGER IF NOT EXISTS update_cert_info " \
-	"AFTER UPDATE ON package_cert_info " \
-	"WHEN (NEW.package_count = 0) " \
-	"BEGIN" \
-	" DELETE FROM package_cert_info WHERE package=OLD.package;" \
-	"END;"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO2 \
-	"CREATE TRIGGER IF NOT EXISTS update_cert_info2 " \
-	"AFTER UPDATE ON package_cert_info " \
-	"WHEN (NEW.package_count = OLD.package_count + 1) " \
-	"BEGIN" \
-	" UPDATE package_cert_index_info SET" \
-	"  cert_ref_count = cert_ref_count - 1" \
-	" WHERE cert_id = OLD.author_root_cert" \
-	"  OR cert_id = OLD.author_im_cert" \
-	"  OR cert_id = OLD.author_signer_cert" \
-	"  OR cert_id = OLD.dist_root_cert" \
-	"  OR cert_id = OLD.dist_im_cert" \
-	"  OR cert_id = OLD.dist_signer_cert" \
-	"  OR cert_id = OLD.dist2_root_cert" \
-	"  OR cert_id = OLD.dist2_im_cert" \
-	"  OR cert_id = OLD.dist2_signer_cert;" \
-	"END;"
-
-#define QUERY_CREATE_TRIGGER_DELETE_CERT_INFO \
-	"CREATE TRIGGER IF NOT EXISTS delete_cert_info " \
-	"AFTER DELETE ON package_cert_info " \
-	"BEGIN" \
-	" UPDATE package_cert_index_info SET" \
-	"  cert_ref_count = cert_ref_count - 1" \
-	" WHERE cert_id = OLD.author_root_cert" \
-	"  OR cert_id = OLD.author_im_cert" \
-	"  OR cert_id = OLD.author_signer_cert" \
-	"  OR cert_id = OLD.dist_root_cert" \
-	"  OR cert_id = OLD.dist_im_cert" \
-	"  OR cert_id = OLD.dist_signer_cert" \
-	"  OR cert_id = OLD.dist2_root_cert" \
-	"  OR cert_id = OLD.dist2_im_cert" \
-	"  OR cert_id = OLD.dist2_signer_cert;" \
-	"END;"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO \
-	"CREATE TRIGGER IF NOT EXISTS update_cert_index_info " \
-	"AFTER UPDATE ON package_cert_index_info " \
-	"WHEN ((SELECT cert_ref_count FROM package_cert_index_info " \
-	"       WHERE cert_id = OLD.cert_id) = 0) "\
-	"BEGIN" \
-	" DELETE FROM package_cert_index_info WHERE cert_id = OLD.cert_id;" \
-	"END;"
+#include "pkgmgr_parser_db.h"
 
 __thread db_handle manifest_db;
 __thread db_handle cert_db;
@@ -214,41 +143,11 @@ static int __attach_and_create_view(sqlite3 *handle, const char *db, const char
 	return SQLITE_OK;
 }
 
-static int __exec_db_query(sqlite3 *db, char *query, sqlite_query_callback callback, void *data)
+int _check_create_cert_db(void)
 {
-	char *error_message = NULL;
-	int ret = sqlite3_exec(db, query, callback, data, &error_message);
-	if (SQLITE_OK != ret) {
-		_LOGE("Don't execute query = %s error message = %s   ret = %d\n", query,
-		       error_message, ret);
-		sqlite3_free(error_message);
-		return -1;
-	}
-	sqlite3_free(error_message);
-	return 0;
+	return pkgmgr_parser_initialize_cert_db();
 }
 
-int _check_create_cert_db(sqlite3 *certdb)
-{
-	int ret = 0;
-	ret = __exec_db_query(certdb, QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO, NULL, NULL);
-	if (ret < 0)
-		return ret;
-	ret = __exec_db_query(certdb, QUERY_CREATE_TABLE_PACKAGE_CERT_INFO, NULL, NULL);
-	if (ret < 0)
-		return ret;
-	ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO, NULL, NULL);
-	if (ret < 0)
-		return ret;
-	ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO2, NULL, NULL);
-	if (ret < 0)
-		return ret;
-	ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_DELETE_CERT_INFO, NULL, NULL);
-	if (ret < 0)
-		return ret;
-	ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO, NULL, NULL);
-	return ret;
-}
 static gid_t _get_gid(const char *name)
 {
 	char buf[BUFSIZE];
@@ -306,17 +205,17 @@ API char *getUserPkgParserDBPathUID(uid_t uid)
 	}
 	snprintf(pkgmgr_parser_db, sizeof(pkgmgr_parser_db),
 			"%s/.pkgmgr_parser.db", db_path);
-
-	if (uid != GLOBAL_USER && uid != ROOT_UID) {
-		tzplatform_set_user(uid);
-		gid = _get_gid(tzplatform_getenv(TZ_SYS_USER_GROUP));
-		tzplatform_reset_user();
+	if (access(db_path, F_OK) != 0) {
+		if (uid != GLOBAL_USER && uid != ROOT_UID) {
+			tzplatform_set_user(uid);
+			gid = _get_gid(tzplatform_getenv(TZ_SYS_USER_GROUP));
+			tzplatform_reset_user();
+		}
+		/* just allow certain users to create the dbspace directory if needed. */
+		if (uid_caller == ROOT_UID || uid_caller == APPFW_UID ||
+				uid_caller == uid)
+			_mkdir_for_user(db_path, uid, gid);
 	}
-
-	/* just allow certain users to create the dbspace directory if needed. */
-	if (uid_caller == ROOT_UID  || uid_caller == APPFW_UID || uid_caller == uid)
-		_mkdir_for_user(db_path, uid, gid);
-
 	free(db_path);
 
 	return strdup(pkgmgr_parser_db);
@@ -527,7 +426,7 @@ void _save_column_int(sqlite3_stmt *stmt, int idx, int *i)
 	*i = sqlite3_column_int(stmt, idx);
 }
 
-void _save_column_str(sqlite3_stmt *stmt, int idx, char **str)
+inline void _save_column_str(sqlite3_stmt *stmt, int idx, char **str)
 {
 	const char *val;