[SVACE Issue Fixes]

[platform/core/pim/contacts-service.git] / server / db / ctsvc_db_plugin_email.c

diff --git a/server/db/ctsvc_db_plugin_email.c b/server/db/ctsvc_db_plugin_email.c
index 9b63b45..fc515ce 100644 (file)
--- a/server/db/ctsvc_db_plugin_email.c
+++ b/server/db/ctsvc_db_plugin_email.c
@@ -40,7 +40,7 @@ static int __ctsvc_db_email_get_person_default_email(int person_id)
        snprintf(query, sizeof(query),
                        "SELECT id FROM "CTSVC_DB_VIEW_CONTACT" c, "CTS_TABLE_DATA" d "
                        "WHERE c.person_id = %d AND d.datatype = %d AND c.contact_id = d.contact_id AND d.is_default = 1",
-                       person_id, CTSVC_DATA_EMAIL);
+                       person_id, CONTACTS_DATA_TYPE_EMAIL);
        ret = ctsvc_query_get_first_int_result(query, &default_email_id);
        if (CONTACTS_ERROR_NONE != ret)
                return 0;
@@ -82,7 +82,7 @@ static int __ctsvc_db_email_get_default_email_id(int contact_id)
        char query[CTS_SQL_MAX_LEN] = {0};
        snprintf(query, sizeof(query),
                        "SELECT id FROM "CTS_TABLE_DATA" WHERE datatype=%d AND contact_id=%d AND is_default=1",
-                       CTSVC_DATA_EMAIL, contact_id);
+                       CONTACTS_DATA_TYPE_EMAIL, contact_id);
        ret = ctsvc_query_get_first_int_result(query, &email_id);
        if (CONTACTS_ERROR_NONE != ret)
                return 0;
@@ -96,7 +96,7 @@ static int __ctsvc_db_email_get_primary_default_email_id(int contact_id)
        char query[CTS_SQL_MAX_LEN] = {0};
        snprintf(query, sizeof(query),
                        "SELECT id FROM "CTS_TABLE_DATA" WHERE datatype=%d AND contact_id=%d AND is_primary_default=1",
-                       CTSVC_DATA_EMAIL, contact_id);
+                       CONTACTS_DATA_TYPE_EMAIL, contact_id);
        ret = ctsvc_query_get_first_int_result(query, &email_id);
        if (CONTACTS_ERROR_NONE != ret)
                return 0;
@@ -112,7 +112,7 @@ static int __ctsvc_db_email_get_primary_default_contact_id(int person_id)
        snprintf(query, sizeof(query),
                        "SELECT c.contact_id FROM "CTS_TABLE_CONTACTS" c, "CTS_TABLE_DATA" d "
                        "WHERE c.person_id = %d AND d.datatype = %d AND c.contact_id = d.contact_id AND d.is_primary_default = 1",
-                       person_id, CTSVC_DATA_EMAIL);
+                       person_id, CONTACTS_DATA_TYPE_EMAIL);
        ret = ctsvc_query_get_first_int_result(query, &default_contact_id);
        if (CONTACTS_ERROR_NONE != ret)
                return 0;
@@ -145,21 +145,26 @@ static int __ctsvc_db_email_insert_record(contacts_record_h record, int *id)
 
        ret = ctsvc_begin_trans();
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_begin_trans() Fail(%d)", ret);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        snprintf(query, sizeof(query),
                        "SELECT addressbook_id, person_id FROM "CTSVC_DB_VIEW_CONTACT" WHERE contact_id = %d", email->contact_id);
        ret = ctsvc_query_prepare(query, &stmt);
        if (NULL == stmt) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_query_prepare() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        ret = ctsvc_stmt_step(stmt);
        if (1 != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_stmt_step() Fail(%d)", ret);
                ctsvc_stmt_finalize(stmt);
                ctsvc_end_trans(false);
@@ -167,15 +172,18 @@ static int __ctsvc_db_email_insert_record(contacts_record_h record, int *id)
                        return CONTACTS_ERROR_INVALID_PARAMETER;
                else
                        return ret;
+               /* LCOV_EXCL_STOP */
        }
        addressbook_id = ctsvc_stmt_get_int(stmt, 0);
        person_id = ctsvc_stmt_get_int(stmt, 1);
        ctsvc_stmt_finalize(stmt);
 
        if (false == ctsvc_have_ab_write_permission(addressbook_id, false)) {
+               /* LCOV_EXCL_START */
                ERR("No permission in this addresbook_id(%d)", addressbook_id);
                ctsvc_end_trans(false);
                return CONTACTS_ERROR_PERMISSION_DENIED;
+               /* LCOV_EXCL_STOP */
        }
 
        old_default_email_id = __ctsvc_db_email_get_default_email_id(email->contact_id);
@@ -184,9 +192,11 @@ static int __ctsvc_db_email_insert_record(contacts_record_h record, int *id)
 
        ret = ctsvc_db_email_insert(record, email->contact_id, false, id);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_begin_trans() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        snprintf(query, sizeof(query),
@@ -196,9 +206,11 @@ static int __ctsvc_db_email_insert_record(contacts_record_h record, int *id)
 
        ret = ctsvc_query_exec(query);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_query_exec() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        if (email->is_default) {
@@ -218,8 +230,10 @@ static int __ctsvc_db_email_insert_record(contacts_record_h record, int *id)
 
        ret = ctsvc_end_trans(true);
        if (ret < CONTACTS_ERROR_NONE) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_end_trans() Fail(%d)", ret);
                return ret;
+               /* LCOV_EXCL_STOP */
        } else {
                return CONTACTS_ERROR_NONE;
        }
@@ -239,19 +253,21 @@ static int __ctsvc_db_email_get_record(int id, contacts_record_h *out_record)
                        "FROM "CTS_TABLE_DATA", "CTSVC_DB_VIEW_CONTACT" "
                        "ON "CTS_TABLE_DATA".contact_id = "CTSVC_DB_VIEW_CONTACT".contact_id "
                        "WHERE id = %d AND datatype = %d ",
-                       id, CTSVC_DATA_EMAIL);
+                       id, CONTACTS_DATA_TYPE_EMAIL);
 
        ret = ctsvc_query_prepare(query, &stmt);
        RETVM_IF(NULL == stmt, ret, "ctsvc_query_prepare() Fail(%d)", ret);
 
        ret = ctsvc_stmt_step(stmt);
        if (1 /*CTS_TRUE*/ != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_stmt_step() Fail(%d)", ret);
                ctsvc_stmt_finalize(stmt);
                if (CONTACTS_ERROR_NONE == ret)
                        return CONTACTS_ERROR_NO_DATA;
                else
                        return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        ctsvc_db_email_get_value_from_stmt(stmt, out_record, 0);
@@ -271,30 +287,38 @@ static int __ctsvc_db_email_update_record(contacts_record_h record)
 
        ret = ctsvc_begin_trans();
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_begin_trans() Fail(%d)", ret);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        snprintf(query, sizeof(query),
                        "SELECT addressbook_id FROM "CTSVC_DB_VIEW_CONTACT" WHERE contact_id = %d", email->contact_id);
        ret = ctsvc_query_get_first_int_result(query, &addressbook_id);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("No data : contact_id (%d) is not exist", email->contact_id);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        if (false == ctsvc_have_ab_write_permission(addressbook_id, false)) {
+               /* LCOV_EXCL_START */
                ERR("No permission in this addresbook_id(%d)", addressbook_id);
                ctsvc_end_trans(false);
                return CONTACTS_ERROR_PERMISSION_DENIED;
+               /* LCOV_EXCL_STOP */
        }
 
        ret = ctsvc_db_email_update(record, false);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("update record Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        if (email->is_default) {
@@ -307,16 +331,20 @@ static int __ctsvc_db_email_update_record(contacts_record_h record)
 
        ret = ctsvc_db_contact_update_changed_time(email->contact_id);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_db_contact_update_changed_time() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
        ctsvc_set_person_noti();
 
        ret = ctsvc_end_trans(true);
        if (ret < CONTACTS_ERROR_NONE) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_end_trans() Fail(%d)", ret);
                return ret;
+               /* LCOV_EXCL_STOP */
        } else {
                return CONTACTS_ERROR_NONE;
        }
@@ -337,8 +365,10 @@ static int __ctsvc_db_email_delete_record(int id)
 
        ret = ctsvc_begin_trans();
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_begin_trans() Fail(%d)", ret);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        snprintf(query, sizeof(query),
@@ -347,13 +377,16 @@ static int __ctsvc_db_email_delete_record(int id)
 
        ret = ctsvc_query_prepare(query, &stmt);
        if (NULL == stmt) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_query_prepare() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        ret = ctsvc_stmt_step(stmt);
        if (1 != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_stmt_step() Fail(%d)", ret);
                ctsvc_stmt_finalize(stmt);
                ctsvc_end_trans(false);
@@ -361,6 +394,7 @@ static int __ctsvc_db_email_delete_record(int id)
                        return CONTACTS_ERROR_NO_DATA;
                else
                        return ret;
+               /* LCOV_EXCL_STOP */
        }
        contact_id = ctsvc_stmt_get_int(stmt, 0);
        person_id = ctsvc_stmt_get_int(stmt, 1);
@@ -368,9 +402,11 @@ static int __ctsvc_db_email_delete_record(int id)
        ctsvc_stmt_finalize(stmt);
 
        if (false == ctsvc_have_ab_write_permission(addressbook_id, false)) {
+               /* LCOV_EXCL_START */
                ERR("No permission in this addresbook_id(%d)", addressbook_id);
                ctsvc_end_trans(false);
                return CONTACTS_ERROR_PERMISSION_DENIED;
+               /* LCOV_EXCL_STOP */
        }
 
        snprintf(query, sizeof(query),
@@ -381,6 +417,7 @@ static int __ctsvc_db_email_delete_record(int id)
 
        ret = ctsvc_stmt_step(stmt);
        if (1 != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_stmt_step() Fail(%d)", ret);
                ctsvc_stmt_finalize(stmt);
                ctsvc_end_trans(false);
@@ -388,6 +425,7 @@ static int __ctsvc_db_email_delete_record(int id)
                        return CONTACTS_ERROR_NO_DATA;
                else
                        return ret;
+               /* LCOV_EXCL_STOP */
        }
        is_default = ctsvc_stmt_get_int(stmt, 0);
        is_primary_default = ctsvc_stmt_get_int(stmt, 1);
@@ -395,14 +433,16 @@ static int __ctsvc_db_email_delete_record(int id)
 
        ret = ctsvc_db_email_delete(id, false);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_begin_trans() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        snprintf(query, sizeof(query),
                        "SELECT id FROM "CTS_TABLE_DATA" WHERE datatype = %d AND contact_id = %d AND is_my_profile = 0 limit 1",
-                       CTSVC_DATA_EMAIL, contact_id);
+                       CONTACTS_DATA_TYPE_EMAIL, contact_id);
        ret = ctsvc_query_get_first_int_result(query, &email_id);
        if (0 < ret)
                has_email = true;
@@ -414,9 +454,11 @@ static int __ctsvc_db_email_delete_record(int id)
 
        ret = ctsvc_query_exec(query);
        if (CONTACTS_ERROR_NONE != ret) {
+               /* LCOV_EXCL_START */
                ERR("ctsvc_query_exec() Fail(%d)", ret);
                ctsvc_end_trans(false);
                return ret;
+               /* LCOV_EXCL_STOP */
        }
 
        if (is_default) {
@@ -456,7 +498,7 @@ static int __ctsvc_db_email_get_all_records(int offset, int limit, contacts_list
                        "FROM "CTS_TABLE_DATA", "CTSVC_DB_VIEW_CONTACT" "
                        "ON "CTS_TABLE_DATA".contact_id = "CTSVC_DB_VIEW_CONTACT".contact_id "
                        "WHERE datatype = %d AND is_my_profile=0 ",
-                       CTSVC_DATA_EMAIL);
+                       CONTACTS_DATA_TYPE_EMAIL);
 
        if (0 != limit) {
                len += snprintf(query+len, sizeof(query)-len, " LIMIT %d", limit);
@@ -470,10 +512,12 @@ static int __ctsvc_db_email_get_all_records(int offset, int limit, contacts_list
        contacts_list_create(&list);
        while ((ret = ctsvc_stmt_step(stmt))) {
                if (1 /*CTS_TRUE */ != ret) {
+                       /* LCOV_EXCL_START */
                        ERR("DB : ctsvc_stmt_step() Fail(%d)", ret);
                        ctsvc_stmt_finalize(stmt);
                        contacts_list_destroy(list, true);
                        return ret;
+                       /* LCOV_EXCL_STOP */
                }
                ctsvc_db_email_get_value_from_stmt(stmt, (contacts_record_h*)&email, 0);
                ctsvc_list_prepend(list, (contacts_record_h)email);
@@ -506,10 +550,12 @@ static int __ctsvc_db_email_get_records_with_query(contacts_query_h query, int o
        while ((ret = ctsvc_stmt_step(stmt))) {
                contacts_record_h record;
                if (1 /*CTS_TRUE */ != ret) {
+                       /* LCOV_EXCL_START */
                        ERR("ctsvc_stmt_step() Fail(%d)", ret);
                        ctsvc_stmt_finalize(stmt);
                        contacts_list_destroy(list, true);
                        return ret;
+                       /* LCOV_EXCL_STOP */
                }
 
                contacts_record_create(_contacts_email._uri, &record);