Revise parser, insert db
[platform/core/appfw/pkgmgr-info.git] / parser / pkgmgr_parser_db.c
index dcd4c89..5c71742 100644 (file)
 #define BUFSIZE 4096
 #define OWNER_ROOT 0
 
-#define SET_SMACK_LABEL(x,uid) \
-       if(smack_setlabel((x), (((uid) == GLOBAL_USER)?"*":"User"), SMACK_LABEL_ACCESS)) _LOGE("failed chsmack -a \"User/*\" %s", x); \
-       else _LOGD("chsmack -a \"User/*\" %s", x);
+#define SET_SMACK_LABEL(x) \
+do { \
+       if (smack_setlabel((x), "System::Shared", SMACK_LABEL_ACCESS)) \
+               _LOGE("failed chsmack -a \"System::Shared\" %s", x); \
+       else \
+               _LOGD("chsmack -a \"System::Shared\" %s", x); \
+} while (0)
 
 sqlite3 *pkgmgr_parser_db;
 sqlite3 *pkgmgr_cert_db;
@@ -64,6 +68,7 @@ sqlite3 *pkgmgr_cert_db;
                                                "(package text primary key not null, " \
                                                "package_type text DEFAULT 'rpm', " \
                                                "package_version text, " \
+                                               "package_api_version text, " \
                                                "install_location text, " \
                                                "package_size text, " \
                                                "package_removable text DEFAULT 'true', " \
@@ -256,6 +261,18 @@ sqlite3 *pkgmgr_cert_db;
                                                "FOREIGN KEY(app_id) " \
                                                "REFERENCES package_app_info(app_id) " \
                                                "ON DELETE CASCADE)"
+#define QUERY_CREATE_TABLE_PACKAGE_RESOURCE_INFO "CREATE TABLE IF NOT EXISTS package_resource_info" \
+                                               "(pkg_id text NOT NULL," \
+                                               "group_folder text NOT NULL," \
+                                               "group_type text NOT NULL," \
+                                               "PRIMARY KEY(pkg_id, group_type))"
+
+#define QUERY_CREATE_TABLE_PACKAGE_RESOURCE_DATA "CREATE TABLE IF NOT EXISTS package_resource_data" \
+                                               "(id integer REFERENCES package_resource_info(rowid)," \
+                                               "node_folder text NOT NULL," \
+                                               "attr_name text NOT NULL," \
+                                               "attr_value test NOT NULL," \
+                                               "PRIMARY KEY(id, node_folder, attr_name))"
 
 static int __insert_uiapplication_info(manifest_x *mfx);
 static int __insert_serviceapplication_info(manifest_x *mfx);
@@ -271,6 +288,7 @@ static int __insert_uiapplication_share_allowed_info(manifest_x *mfx);
 static int __insert_serviceapplication_share_allowed_info(manifest_x *mfx);
 static int __insert_uiapplication_share_request_info(manifest_x *mfx);
 static int __insert_serviceapplication_share_request_info(manifest_x *mfx);
+static int __insert_uiapplication_datacontrol_info(manifest_x *mfx);
 static int __insert_serviceapplication_datacontrol_info(manifest_x *mfx);
 static void __insert_serviceapplication_locale_info(gpointer data, gpointer userdata);
 static void __insert_uiapplication_locale_info(gpointer data, gpointer userdata);
@@ -288,6 +306,7 @@ static GList *__create_locale_list(GList *locale, label_x *lbl, license_x *lcn,
 static void __preserve_guestmode_visibility_value(manifest_x *mfx);
 static int __guestmode_visibility_cb(void *data, int ncols, char **coltxt, char **colname);
 static int __pkgmgr_parser_create_db(sqlite3 **db_handle, const char *db_path);
+static int __parserdb_change_perm(const char *db_file, uid_t uid);
 
 static int __delete_subpkg_list_cb(void *data, int ncols, char **coltxt, char **colname)
 {
@@ -959,68 +978,26 @@ static int __insert_uiapplication_appcontrol_info(manifest_x *mfx)
 {
        uiapplication_x *up = mfx->uiapplication;
        appcontrol_x *acontrol = NULL;
-       operation_x *op = NULL;
-       mime_x *mi = NULL;
-       uri_x *ui = NULL;
-       subapp_x *sub = NULL;
        int ret = -1;
        char query[MAX_QUERY_LEN] = {'\0'};
        char buf[BUFSIZE] = {'\0'};
-       const char *operation = NULL;
-       const char *mime = NULL;
-       const char *uri = NULL;
-       const char *subapp = NULL;
        while (up != NULL) {
                acontrol = up->appcontrol;
                while (acontrol != NULL) {
-                       op = acontrol->operation;
-                       while (op != NULL) {
-                               if (op)
-                                       operation = op->name;
-                               mi = acontrol->mime;
-
-                               do {
-                                       if (mi)
-                                               mime = mi->name;
-                                       sub = acontrol->subapp;
-                                       do {
-                                               if (sub)
-                                                       subapp = sub->name;
-                                               ui = acontrol->uri;
-                                               do {
-                                                       if (ui)
-                                                               uri = ui->name;
-                                                       snprintf(buf, BUFSIZE, "%s|%s|%s|%s",
-                                                                       operation ? operation : "NULL",
-                                                                       uri ? uri : "NULL",
-                                                                       mime ? mime : "NULL",
-                                                                       subapp ? subapp : "NULL");
-                                                       snprintf(query, MAX_QUERY_LEN,
-                                                                       "insert into package_app_app_control(app_id, app_control) " \
-                                                                       "values('%s', '%s')",\
-                                                                       up->appid, buf);
-                                                       ret = __exec_query(query);
-                                                       if (ret == -1) {
-                                                               _LOGD("Package UiApp AppSvc DB Insert Failed\n");
-                                                               return -1;
-                                                       }
-                                                       memset(query, '\0', MAX_QUERY_LEN);
-                                                       if (ui)
-                                                               ui = ui->next;
-                                                       uri = NULL;
-                                               } while (ui != NULL);
-                                               if (sub)
-                                                       sub = sub->next;
-                                               subapp = NULL;
-                                       } while (sub != NULL);
-                                       if (mi)
-                                               mi = mi->next;
-                                       mime = NULL;
-                               } while (mi != NULL);
-                               if (op)
-                                       op = op->next;
-                               operation = NULL;
+                       snprintf(buf, BUFSIZE, "%s|%s|%s",\
+                                       acontrol->operation ? (strlen(acontrol->operation) > 0 ? acontrol->operation : "NULL") : "NULL",
+                                       acontrol->uri ? (strlen(acontrol->uri) > 0 ? acontrol->uri : "NULL") : "NULL",
+                                       acontrol->mime ? (strlen(acontrol->mime) > 0 ? acontrol->mime : "NULL") : "NULL");
+                       snprintf(query, MAX_QUERY_LEN,
+                                       "insert into package_app_app_control(app_id, app_control) " \
+                                       "values('%s', '%s')",\
+                                       up->appid, buf);
+                       ret = __exec_query(query);
+                       if (ret == -1) {
+                               _LOGD("Package UiApp AppSvc DB Insert Failed\n");
+                               return -1;
                        }
+                       memset(query, '\0', MAX_QUERY_LEN);
                        acontrol = acontrol->next;
                }
                up = up->next;
@@ -1106,6 +1083,39 @@ static int __insert_uiapplication_appsvc_info(manifest_x *mfx)
        return 0;
 }
 
+static int __insert_uiapplication_datacontrol_info(manifest_x *mfx)
+{
+       uiapplication_x *up = mfx->uiapplication;
+       datacontrol_x *dc = NULL;
+       int ret = -1;
+       char query[MAX_QUERY_LEN] = {'\0'};
+
+       while(up != NULL)
+       {
+               dc = up->datacontrol;
+               while(dc != NULL)
+               {
+                       snprintf(query, MAX_QUERY_LEN,
+                                       "insert into package_app_data_control(app_id, providerid, access, type) " \
+                                       "values('%s', '%s', '%s', '%s')",\
+                                       mfx->uiapplication->appid,
+                                       dc->providerid,
+                                       dc->access,
+                                       dc->type);
+
+                       ret = __exec_query(query);
+                       if (ret == -1) {
+                               _LOGD("Package UiApp Data Control DB Insert Failed\n");
+                               return -1;
+                       }
+                       memset(query, '\0', MAX_QUERY_LEN);
+                       dc = dc->next;
+               }
+               up = up->next;
+       }
+       return 0;
+}
+
 static int __insert_uiapplication_share_request_info(manifest_x *mfx)
 {
        uiapplication_x *up = mfx->uiapplication;
@@ -1297,64 +1307,23 @@ static int __insert_serviceapplication_appcontrol_info(manifest_x *mfx)
        int ret = -1;
        char query[MAX_QUERY_LEN] = {'\0'};
        char buf[BUFSIZE] = {'\0'};
-       operation_x *op = NULL;
-       mime_x *mi = NULL;
-       uri_x *ui = NULL;
-       subapp_x *sub = NULL;
-       const char *operation = NULL;
-       const char *mime = NULL;
-       const char *uri = NULL;
-       const char *subapp = NULL;
        while (sp != NULL) {
                acontrol = sp->appcontrol;
                while (acontrol != NULL) {
-                       op = acontrol->operation;
-                       while (op != NULL) {
-                               if (op)
-                                       operation = op->name;
-                               mi = acontrol->mime;
-                               do {
-                                       if (mi)
-                                               mime = mi->name;
-                                       sub = acontrol->subapp;
-                                       do {
-                                               if (sub)
-                                                       subapp = sub->name;
-                                               ui = acontrol->uri;
-                                               do {
-                                                       if (ui)
-                                                               uri = ui->name;
-                                                       snprintf(buf, BUFSIZE, "%s|%s|%s|%s",
-                                                                       operation ? operation : "NULL",
-                                                                       uri ? uri : "NULL",
-                                                                       mime ? mime : "NULL",
-                                                                       subapp ? subapp : "NULL");
-                                                       snprintf(query, MAX_QUERY_LEN,
-                                                                       "insert into package_app_app_control(app_id, app_control) " \
-                                                                       "values('%s', '%s')",\
-                                                                       sp->appid, buf);
-                                                       ret = __exec_query(query);
-                                                       if (ret == -1) {
-                                                               _LOGD("Package UiApp AppSvc DB Insert Failed\n");
-                                                               return -1;
-                                                       }
-                                                       memset(query, '\0', MAX_QUERY_LEN);
-                                                       if (ui)
-                                                               ui = ui->next;
-                                                       uri = NULL;
-                                               } while (ui != NULL);
-                                               if (sub)
-                                                       sub = sub->next;
-                                               subapp = NULL;
-                                       } while (sub != NULL);
-                                       if (mi)
-                                               mi = mi->next;
-                                       mime = NULL;
-                               } while (mi != NULL);
-                               if (op)
-                                       op = op->next;
-                               operation = NULL;
+                       snprintf(buf, BUFSIZE, "%s|%s|%s",
+                                       acontrol->operation ? (strlen(acontrol->operation) > 0 ? acontrol->operation : "NULL") : "NULL",
+                                       acontrol->uri ? (strlen(acontrol->uri) > 0 ? acontrol->uri : "NULL") : "NULL",
+                                       acontrol->mime ? (strlen(acontrol->mime) > 0 ? acontrol->mime : "NULL") : "NULL");
+                       snprintf(query, MAX_QUERY_LEN,
+                                       "insert into package_app_app_control(app_id, app_control) " \
+                                       "values('%s', '%s')",\
+                                       sp->appid, buf);
+                       ret = __exec_query(query);
+                       if (ret == -1) {
+                               _LOGD("Package UiApp AppSvc DB Insert Failed\n");
+                               return -1;
                        }
+                       memset(query, '\0', MAX_QUERY_LEN);
                        acontrol = acontrol->next;
                }
                sp = sp->next;
@@ -1563,8 +1532,6 @@ static int __insert_manifest_info_in_db(manifest_x *mfx, uid_t uid)
        char query[MAX_QUERY_LEN] = { '\0' };
        char root[MAX_QUERY_LEN] = { '\0' };
        int ret = -1;
-       char *type = NULL;
-       char *path = NULL;
        const char *auth_name = NULL;
        const char *auth_email = NULL;
        const char *auth_href = NULL;
@@ -1599,31 +1566,15 @@ static int __insert_manifest_info_in_db(manifest_x *mfx, uid_t uid)
        }
 
        /*Insert in the package_info DB*/
-       if (mfx->type)
-               type = strdup(mfx->type);
-       else
-               type = strdup("rpm");
-       /*Insert in the package_info DB*/
-       if (mfx->root_path)
-               path = strdup(mfx->root_path);
-       else{
-               if (strcmp(type,"rpm")==0) {
-                       apps_path = tzplatform_getenv(TZ_SYS_RO_APP);
-                       snprintf(root, MAX_QUERY_LEN - 1, "%s/%s", apps_path, mfx->package);
-               } else {
-                       apps_path = tzplatform_getenv(TZ_USER_APP);
-                       snprintf(root, MAX_QUERY_LEN - 1, "%s/%s", apps_path, mfx->package);
-               }
-               path = strdup(root);
-       }
        snprintf(query, MAX_QUERY_LEN,
-                "insert into package_info(package, package_type, package_version, install_location, package_size, " \
+                "insert into package_info(package, package_type, package_version, package_api_version, install_location, package_size, " \
                "package_removable, package_preload, package_readonly, package_update, package_appsetting, package_nodisplay, package_system," \
                "author_name, author_email, author_href, installed_time, installed_storage, storeclient_id, mainapp_id, package_url, root_path, csc_path) " \
-               "values('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",\
+               "values('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",\
                 mfx->package,
-                type,
+                mfx->type,
                 mfx->version,
+                __get_str(mfx->api_version),
                 __get_str(mfx->installlocation),
                 __get_str(mfx->package_size),
                 mfx->removable,
@@ -1641,43 +1592,13 @@ static int __insert_manifest_info_in_db(manifest_x *mfx, uid_t uid)
                 __get_str(mfx->storeclient_id),
                 mfx->mainapp_id,
                 __get_str(mfx->package_url),
-                path,
+                mfx->root_path,
                 __get_str(mfx->csc_path));
-       /*If package dont have main_package tag, this package is main package.*/
-       if (mfx->main_package == NULL) {
-               ret = __exec_query(query);
-               if (ret == -1) {
-                       _LOGD("Package Info DB Insert Failed\n");
-                       if (type) {
-                               free(type);
-                               type = NULL;
-                       }
-                       if (path) {
-                               free(path);
-                               path = NULL;
-                       }
-                       return -1;
-               }
-       } else {
-               /*If package has main_package tag, this package is sub package(ug, efl).
-               skip __exec_query for package_info and change pkgid with main_package*/
-               memset(root, '\0', MAX_QUERY_LEN);
-               snprintf(root, MAX_QUERY_LEN - 1, "/usr/apps/%s", mfx->main_package);
-               if (access(root, F_OK) == 0) {
-                       free((void *)mfx->package);
-                       mfx->package = strdup(mfx->main_package);
-               } else {
-                       _LOGE("main package[%s] is not installed\n", root);
-                       return -1;
-               }
-       }
-       if (type) {
-               free(type);
-               type = NULL;
-       }
-       if (path) {
-               free(path);
-               path = NULL;
+
+       ret = __exec_query(query);
+       if (ret == -1) {
+               _LOGD("Package Info DB Insert Failed\n");
+               return -1;
        }
 
        /*Insert in the package_privilege_info DB*/
@@ -1747,9 +1668,7 @@ static int __insert_manifest_info_in_db(manifest_x *mfx, uid_t uid)
        /*_LOGD("\n");*/
        /*g_list_foreach(applocale, __printfunc, NULL);*/
 
-       /*package locale info, it is only for main package.*/
-       if (mfx->main_package == NULL)
-               g_list_foreach(pkglocale, __insert_pkglocale_info, (gpointer)mfx);
+       g_list_foreach(pkglocale, __insert_pkglocale_info, (gpointer)mfx);
 
        /*native app locale info*/
        up = mfx->uiapplication;
@@ -1855,6 +1774,9 @@ static int __insert_manifest_info_in_db(manifest_x *mfx, uid_t uid)
                return -1;
 
        /*Insert in the package_app_data_control DB*/
+       ret = __insert_uiapplication_datacontrol_info(mfx);
+       if (ret == -1)
+               return -1;
        ret = __insert_serviceapplication_datacontrol_info(mfx);
        if (ret == -1)
                return -1;
@@ -2084,7 +2006,7 @@ static int __update_preload_condition_in_db()
        return ret;
 }
 
-API int pkgmgr_parser_initialize_db(void)
+API int pkgmgr_parser_initialize_db(uid_t uid)
 {
        int ret = -1;
        /*Manifest DB*/
@@ -2174,11 +2096,29 @@ API int pkgmgr_parser_initialize_db(void)
                _LOGD("package cert index info DB initialization failed\n");
                return ret;
        }
+       /*resource DB*/
+       ret = __initialize_db(pkgmgr_parser_db, QUERY_CREATE_TABLE_PACKAGE_RESOURCE_INFO);
+       if (ret == -1) {
+               _LOGD("package resource info DB initialization failed\n");
+               return ret;
+       }
+       ret = __initialize_db(pkgmgr_parser_db, QUERY_CREATE_TABLE_PACKAGE_RESOURCE_DATA);
+       if (ret == -1) {
+               _LOGD("package resource data DB initialization failed\n");
+               return ret;
+       }
+
+       if( 0 != __parserdb_change_perm(getUserPkgCertDBPathUID(uid), uid)) {
+               _LOGD("Failed to change cert db permission\n");
+       }
+       if( 0 != __parserdb_change_perm(getUserPkgParserDBPathUID(uid), uid)) {
+               _LOGD("Failed to change parser db permission\n");
+       }
 
        return 0;
 }
 
-static int parserdb_change_perm(const char *db_file, uid_t uid)
+static int __parserdb_change_perm(const char *db_file, uid_t uid)
 {
        char buf[BUFSIZE];
        char journal_file[BUFSIZE];
@@ -2189,14 +2129,16 @@ static int parserdb_change_perm(const char *db_file, uid_t uid)
        files[1] = journal_file;
        files[2] = NULL;
 
-       if(db_file == NULL)
+       if (db_file == NULL)
                return -1;
 
-       if(getuid() != OWNER_ROOT) //At this time we should be root to apply this
-                       return 0;
+       if (getuid() != OWNER_ROOT) //At this time we should be root to apply this
+               return 0;
        snprintf(journal_file, sizeof(journal_file), "%s%s", db_file, "-journal");
-    userinfo = getpwuid(uid);
-    if (!userinfo) {
+       if (uid == OWNER_ROOT)
+               uid = GLOBAL_USER;
+       userinfo = getpwuid(uid);
+       if (!userinfo) {
                _LOGE("FAIL: user %d doesn't exist", uid);
                return -1;
        }
@@ -2204,20 +2146,55 @@ static int parserdb_change_perm(const char *db_file, uid_t uid)
 
        for (i = 0; files[i]; i++) {
                ret = chown(files[i], uid, userinfo->pw_gid);
-               SET_SMACK_LABEL(files[i],uid)
                if (ret == -1) {
-                       strerror_r(errno, buf, sizeof(buf));
-                       _LOGD("FAIL : chown %s %d.%d, because %s", db_file, uid, userinfo->pw_gid, buf);
+                       if (strerror_r(errno, buf, sizeof(buf)))
+                               strcpy(buf, "");
+                       _LOGD("FAIL : chown %s %d.%d : %s", files[i], uid,
+                                       userinfo->pw_gid, buf);
                        return -1;
                }
 
                ret = chmod(files[i], S_IRUSR | S_IWUSR | S_IRGRP | S_IWGRP | S_IROTH);
                if (ret == -1) {
-                       strerror_r(errno, buf, sizeof(buf));
-                       _LOGD("FAIL : chmod %s 0664, because %s", db_file, buf);
+                       if (strerror_r(errno, buf, sizeof(buf)))
+                               strcpy(buf, "");
+                       _LOGD("FAIL : chmod %s 0664 : %s", files[i], buf);
                        return -1;
                }
+               SET_SMACK_LABEL(files[i]);
+       }
+       return 0;
+}
+
+API int pkgmgr_parser_create_and_initialize_db(uid_t uid)
+{
+       int ret;
+
+       if (getuid() != OWNER_ROOT) {
+               _LOGE("Only root user is allowed");
+               return -1;
+       }
+
+       if (access(getUserPkgParserDBPathUID(uid), F_OK) != -1) {
+               _LOGE("Manifest db for user %d is already exists", uid);
+               return -1;
        }
+
+       if (access(getUserPkgCertDBPathUID(uid), F_OK) != -1) {
+               _LOGE("Cert db for user %d is already exists", uid);
+               return -1;
+       }
+
+       ret = pkgmgr_parser_check_and_create_db(uid);
+       if (ret < 0)
+               return -1;
+       ret = pkgmgr_parser_initialize_db(uid);
+       if (ret < 0) {
+               pkgmgr_parser_close_db();
+               return -1;
+       }
+       pkgmgr_parser_close_db();
+
        return 0;
 }
 
@@ -2237,12 +2214,6 @@ API int pkgmgr_parser_check_and_create_db(uid_t uid)
                _LOGD("Cert DB creation Failed\n");
                return -1;
        }
-       if( 0 != parserdb_change_perm(getUserPkgCertDBPathUID(uid), uid)) {
-               _LOGD("Failed to change cert db permission\n");
-       }
-       if( 0 != parserdb_change_perm(getUserPkgParserDBPathUID(uid), uid)) {
-               _LOGD("Failed to change parser db permission\n");
-       }
        return 0;
 }
 
@@ -2266,7 +2237,7 @@ API int pkgmgr_parser_insert_manifest_info_in_db(manifest_x *mfx)
                _LOGD("Failed to open DB\n");
                return ret;
        }
-       ret = pkgmgr_parser_initialize_db();
+       ret = pkgmgr_parser_initialize_db(GLOBAL_USER);
        if (ret == -1)
                goto err;
        /*Begin transaction*/
@@ -2310,7 +2281,7 @@ API int pkgmgr_parser_insert_manifest_info_in_usr_db(manifest_x *mfx, uid_t uid)
                _LOGD("Failed to open DB\n");
                return ret;
        }
-       ret = pkgmgr_parser_initialize_db();
+       ret = pkgmgr_parser_initialize_db(uid);
        if (ret == -1)
                goto err;
        /*Begin transaction*/
@@ -2353,7 +2324,7 @@ API int pkgmgr_parser_update_manifest_info_in_usr_db(manifest_x *mfx, uid_t uid)
                _LOGD("Failed to open DB\n");
                return ret;
        }
-       ret = pkgmgr_parser_initialize_db();
+       ret = pkgmgr_parser_initialize_db(uid);
        if (ret == -1)
                goto err;
        /*Preserve guest mode visibility*/