#include <stdlib.h>
#include <string.h>
#include <unistd.h>
+#include <ctype.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <grp.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 not null, " \
- "cert_id integer, " \
- "cert_ref_count integer, " \
- "PRIMARY KEY(cert_id)) "
-
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INFO "create table if not exists package_cert_info " \
- "(package text not null, " \
- "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, " \
- "PRIMARY KEY(package)) "
+#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, " \
+ " 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_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;"
+
+#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO_FORMAT \
+ "CREATE TRIGGER IF NOT EXISTS update_%s_info " \
+ "AFTER UPDATE ON package_cert_info " \
+ "WHEN (OLD.%s IS NOT NULL) " \
+ "BEGIN" \
+ " UPDATE package_cert_index_info SET" \
+ " cert_ref_count = cert_ref_count - 1" \
+ " WHERE cert_id = OLD.%s;" \
+ "END;"
+
__thread db_handle manifest_db;
__thread db_handle cert_db;
int _check_create_cert_db(sqlite3 *certdb)
{
+ int i;
+ char buf[BUFSIZE];
+ static const char *columns[] = {
+ "author_root_cert", "author_im_cert", "author_signer_cert",
+ "dist_root_cert", "dist_im_cert", "dist_signer_cert",
+ "dist2_root_cert", "dist2_im_cert", "dist2_signer_cert",
+ NULL};
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_DELETE_CERT_INFO, NULL, NULL);
+ if (ret < 0)
+ return ret;
+ ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO, NULL, NULL);
+
+ for (i = 0; columns[i] != NULL; i++) {
+ snprintf(buf, sizeof(buf),
+ QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO_FORMAT,
+ columns[i], columns[i], columns[i], columns[i]);
+ ret = __exec_db_query(certdb, buf, NULL, NULL);
+ if (ret < 0)
+ return ret;
+ }
return ret;
}
static gid_t _get_gid(const char *name)
"package_app_share_allowed",
"package_app_app_permission",
"package_app_share_request",
- "package_app_app_svc",
"package_info",
"package_app_data_control",
"package_localized_info",
NULL
};
-int __open_manifest_db(uid_t uid)
+int __open_manifest_db(uid_t uid, bool readonly)
{
- int ret = -1;
+ int ret;
+ const char *user_pkg_parser;
+ int flags;
+
if (manifest_db.ref) {
manifest_db.ref ++;
return 0;
}
- const char* user_pkg_parser = getUserPkgParserDBPathUID(uid);
- if (access(user_pkg_parser, F_OK) != 0) {
- _LOGE("Manifest DB does not exists !! try to create\n");
-
- if (pkgmgr_parser_check_and_create_db(uid)) {
- _LOGE("create db failed");
- return -1;
- }
- if (pkgmgr_parser_initialize_db(uid)) {
- _LOGE("initialize db failed");
- return -1;
- }
+ user_pkg_parser = getUserPkgParserDBPathUID(uid);
+ if (access(user_pkg_parser, F_OK) != 0) {
+ _LOGE("Manifest DB does not exists !!");
+ return -1;
}
+ flags = readonly ? SQLITE_OPEN_READONLY : SQLITE_OPEN_READWRITE;
ret = db_util_open_with_options(user_pkg_parser, &GET_DB(manifest_db),
- SQLITE_OPEN_READONLY, NULL);
- retvm_if(ret != SQLITE_OK, -1, "connect db [%s] failed!\n", user_pkg_parser);
- manifest_db.ref ++;
- ret = __attach_and_create_view(GET_DB(manifest_db), MANIFEST_DB, parserdb_tables, uid);
- retvm_if(ret != SQLITE_OK, -1, "attach db [%s] failed!\n", user_pkg_parser);
-
+ flags, NULL);
+ retvm_if(ret != SQLITE_OK, -1, "connect db [%s] failed!\n",
+ user_pkg_parser);
+ manifest_db.ref++;
+ if (readonly) {
+ ret = __attach_and_create_view(GET_DB(manifest_db), MANIFEST_DB,
+ parserdb_tables, uid);
+ retvm_if(ret != SQLITE_OK, -1, "attach db [%s] failed!\n",
+ user_pkg_parser);
+ }
return 0;
}
NULL
};
-int __open_cert_db(uid_t uid, char* mode)
+int __open_cert_db(uid_t uid, bool readonly)
{
- int ret = -1;
+ int ret;
+ const char *user_cert_parser;
+ int flags;
+
if (cert_db.ref) {
cert_db.ref ++;
return 0;
}
- const char* user_cert_parser = getUserPkgCertDBPathUID(uid);
- if (access(user_cert_parser, F_OK) == 0) {
- ret = db_util_open_with_options(user_cert_parser, &GET_DB(cert_db),
- SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL);
- retvm_if(ret != SQLITE_OK, -1, "connect db [%s] failed!\n", user_cert_parser);
- cert_db.ref ++;
- if ((strcmp(mode, "w") != 0)) {
- ret = __attach_and_create_view(GET_DB(cert_db), CERT_DB, certdb_tables, uid);
- retvm_if(ret != SQLITE_OK, -1, "attach db [%s] failed!\n", user_cert_parser);
- }
- return 0;
+ user_cert_parser = getUserPkgCertDBPathUID(uid);
+ if (access(user_cert_parser, F_OK) != 0) {
+ _LOGE("Cert DB does not exists !!");
+ return -1;
}
- _LOGE("Cert DB does not exists !!\n");
- return -1;
+
+ flags = readonly ? SQLITE_OPEN_READONLY : SQLITE_OPEN_READWRITE;
+ ret = db_util_open_with_options(user_cert_parser, &GET_DB(cert_db),
+ flags, NULL);
+ retvm_if(ret != SQLITE_OK, -1, "connect db [%s] failed!",
+ user_cert_parser);
+ cert_db.ref++;
+ if (readonly) {
+ ret = __attach_and_create_view(GET_DB(cert_db), CERT_DB,
+ certdb_tables, uid);
+ retvm_if(ret != SQLITE_OK, -1, "attach db [%s] failed!",
+ user_cert_parser);
+ }
+ return 0;
+}
+
+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, const char **str)
retvm_if(appid == NULL, PMINFO_R_EINVAL, "appid is NULL\n");
/* Open db.*/
- ret = __open_manifest_db(uid);
+ ret = __open_manifest_db(uid, false);
if (ret != SQLITE_OK) {
_LOGE("connect db [%s] failed!\n", getUserPkgParserDBPathUID(uid));
return PMINFO_R_ERROR;
retvm_if(appid == NULL, PMINFO_R_EINVAL, "appid is NULL\n");
- ret = __open_manifest_db(uid);
+ ret = __open_manifest_db(uid, false);
if (ret == -1) {
_LOGE("Fail to open manifest DB\n");
return PMINFO_R_ERROR;
retvm_if(handle == NULL, PMINFO_R_EINVAL, "appinfo handle is NULL\n");
pkgmgr_appinfo_x *info = (pkgmgr_appinfo_x *)handle;
- val = info->uiapp_info->guestmode_visibility;
+ val = info->app_info->guestmode_visibility;
if (val) {
ret = db_util_open_with_options(getUserPkgParserDBPathUID(uid), &pkgmgr_parser_db,
SQLITE_OPEN_READWRITE, NULL);
/*TODO: Write to DB here*/
if (status == true)
- snprintf(query, MAX_QUERY_LEN, "update package_app_info set app_guestmodevisibility = 'true' where app_id = '%s'", (char *)info->uiapp_info->appid);
+ snprintf(query, MAX_QUERY_LEN, "update package_app_info set app_guestmodevisibility = 'true' where app_id = '%s'", (char *)info->app_info->appid);
else
- snprintf(query, MAX_QUERY_LEN, "update package_app_info set app_guestmodevisibility = 'false' where app_id = '%s'", (char *)info->uiapp_info->appid);
+ snprintf(query, MAX_QUERY_LEN, "update package_app_info set app_guestmodevisibility = 'false' where app_id = '%s'", (char *)info->app_info->appid);
ret = sqlite3_exec(pkgmgr_parser_db, query, NULL, NULL, &errmsg);
sqlite3_close(pkgmgr_parser_db);
{
return pkgmgrinfo_appinfo_set_usr_guestmode_visibility(handle, GLOBAL_USER, status);
}
+
+API int pkgmgrinfo_pkginfo_set_usr_installed_storage(const char *pkgid, INSTALL_LOCATION location, uid_t uid)
+{
+ retvm_if(pkgid == NULL, PMINFO_R_EINVAL, "pkgid is NULL\n");
+ int ret = -1;
+ int exist = 0;
+ sqlite3 *pkgmgr_parser_db = NULL;
+ char *query = NULL;
+
+ ret = db_util_open_with_options(getUserPkgParserDBPathUID(uid), &pkgmgr_parser_db,
+ SQLITE_OPEN_READWRITE, NULL);
+ retvm_if(ret != SQLITE_OK, PMINFO_R_ERROR, "connect db failed!");
+
+ /*Begin transaction*/
+ // Setting Manifest DB
+ ret = sqlite3_exec(pkgmgr_parser_db, "BEGIN EXCLUSIVE", NULL, NULL, NULL);
+ tryvm_if(ret != SQLITE_OK, ret = PMINFO_R_ERROR, "Failed to begin transaction\n");
+ _LOGD("Transaction Begin\n");
+
+ // pkgcakge_info table
+ query = sqlite3_mprintf("update package_info set installed_storage=%Q where package=%Q", location?"installed_external":"installed_internal", 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);
+ sqlite3_free(query);
+
+ // 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);
+
+ 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);
+
+ /*Commit transaction*/
+ ret = sqlite3_exec(pkgmgr_parser_db, "COMMIT", NULL, NULL, NULL);
+ if (ret != SQLITE_OK) {
+ _LOGE("Failed to commit transaction. Rollback now\n");
+ ret = sqlite3_exec(pkgmgr_parser_db, "ROLLBACK", NULL, NULL, NULL);
+ tryvm_if(ret != SQLITE_OK, ret = PMINFO_R_ERROR, "Don't execute query = %s\n", query);
+ }
+ _LOGD("Transaction Commit and End\n");
+
+ ret = PMINFO_R_OK;
+catch:
+ sqlite3_close(pkgmgr_parser_db);
+ sqlite3_free(query);
+ return ret;
+}
+
+API int pkgmgrinfo_pkginfo_set_installed_storage(const char *pkgid, INSTALL_LOCATION location)
+{
+ return pkgmgrinfo_pkginfo_set_usr_installed_storage(pkgid, location, GLOBAL_USER);
+}