Change codes for performance
[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_db.c
index c9ad72a..0ead442 100644 (file)
 #include "pkgmgrinfo_debug.h"
 #include "pkgmgrinfo_private.h"
 #include "pkgmgr_parser.h"
-#include "pkgmgr_parser_internal.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;
@@ -184,7 +112,7 @@ static char *_get_db_path(uid_t uid)
 static int __attach_and_create_view(sqlite3 *handle, const char *db, const char *tables[], uid_t uid)
 {
        int i;
-       char *err;
+       char *err = NULL;
        char query[MAX_QUERY_LEN];
 
        if (uid != GLOBAL_USER && uid != ROOT_UID) {
@@ -215,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];
@@ -279,11 +177,10 @@ API const char *getIconPath(uid_t uid, bool readonly)
 
        if (readonly)
                path = tzplatform_mkpath(TZ_SYS_RO_ICONS, "/");
-       else
-               path = tzplatform_mkpath(TZ_SYS_RW_ICONS, "/");
 
        /* just allow certain users to create the icon directory if needed. */
-       if (uid_caller == ROOT_UID || uid_caller == uid)
+       if (path && (uid_caller == ROOT_UID  ||
+               uid_caller == APPFW_UID || uid_caller == uid))
                _mkdir_for_user(path, uid, gid);
 
        return path;
@@ -308,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 == uid)
-               _mkdir_for_user(db_path, uid, gid);
-
        free(db_path);
 
        return strdup(pkgmgr_parser_db);
@@ -350,8 +247,8 @@ API char *getUserPkgCertDBPathUID(uid_t uid)
                tzplatform_reset_user();
        }
 
-       // just allow certain users to create the dbspace directory if needed.
-       if (uid_caller == ROOT_UID || uid_caller == uid)
+       /* 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);
@@ -378,7 +275,7 @@ API const char *getUserManifestPath(uid_t uid, bool readonly)
        }
 
        /* just allow certain users to create the icon directory if needed. */
-       if (uid_caller == ROOT_UID || uid_caller == uid)
+       if (uid_caller == ROOT_UID || uid_caller == APPFW_UID || uid_caller == uid)
                _mkdir_for_user(path, uid, gid);
 
        return path;
@@ -465,7 +362,7 @@ int __close_cert_db(void)
        if (cert_db.ref) {
                if (--cert_db.ref == 0)
                        sqlite3_close_v2(GET_DB(cert_db));
-                       return 0;
+               return 0;
        }
        _LOGE("Certificate DB is already closed !!\n");
        return -1;
@@ -529,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;
 
@@ -538,7 +435,7 @@ void _save_column_str(sqlite3_stmt *stmt, int idx, char **str)
                *str = strdup(val);
 }
 
-API int pkgmgrinfo_pkginfo_set_usr_installed_storage(const char *pkgid, INSTALL_LOCATION location, uid_t uid)
+API int pkgmgrinfo_pkginfo_set_usr_installed_storage(const char *pkgid, INSTALL_LOCATION location, const char *external_pkg_path, uid_t uid)
 {
        retvm_if(pkgid == NULL, PMINFO_R_EINVAL, "pkgid is NULL\n");
        int ret = -1;
@@ -569,8 +466,8 @@ API int pkgmgrinfo_pkginfo_set_usr_installed_storage(const char *pkgid, INSTALL_
 
        /* pkgcakge_info table */
        query = sqlite3_mprintf(
-                       "update package_info set installed_storage=%Q where package=%Q",
-                       location ? "installed_external" : "installed_internal", pkgid);
+                       "update package_info set installed_storage=%Q, external_path=%Q where package=%Q",
+                       location ? "installed_external" : "installed_internal", external_pkg_path, pkgid);
 
        ret = sqlite3_exec(pkgmgr_parser_db, query, NULL, NULL, NULL);
        tryvm_if(ret != SQLITE_OK, ret = PMINFO_R_ERROR, "Don't execute query = %s\n", query);
@@ -578,8 +475,8 @@ API int pkgmgrinfo_pkginfo_set_usr_installed_storage(const char *pkgid, INSTALL_
 
        /* package_app_info table */
        query = sqlite3_mprintf(
-                       "update package_app_info set app_installed_storage=%Q where package=%Q",
-                       location ? "installed_external" : "installed_internal", pkgid);
+                       "update package_app_info set app_installed_storage=%Q, app_external_path=%Q where package=%Q",
+                       location ? "installed_external" : "installed_internal", external_pkg_path, pkgid);
 
        ret = sqlite3_exec(pkgmgr_parser_db, query, NULL, NULL, NULL);
        tryvm_if(ret != SQLITE_OK, ret = PMINFO_R_ERROR, "Don't execute query = %s\n", query);
@@ -600,7 +497,7 @@ catch:
        return ret;
 }
 
-API int pkgmgrinfo_pkginfo_set_installed_storage(const char *pkgid, INSTALL_LOCATION location)
+API int pkgmgrinfo_pkginfo_set_installed_storage(const char *pkgid, INSTALL_LOCATION location, const char *external_pkg_path)
 {
-       return pkgmgrinfo_pkginfo_set_usr_installed_storage(pkgid, location, _getuid());
+       return pkgmgrinfo_pkginfo_set_usr_installed_storage(pkgid, location, external_pkg_path, _getuid());
 }