| 1 |
/*************************************************************************** |
/* SPDX-License-Identifier: GPL-3.0-or-later */ |
| 2 |
article_favor.c - description |
/* |
| 3 |
------------------- |
* article_favor |
| 4 |
Copyright : (C) 2004-2025 by Leaflet |
* - data model and basic operations of user favorite articles |
| 5 |
Email : leaflet@leafok.com |
* |
| 6 |
***************************************************************************/ |
* Copyright (C) 2004-2025 Leaflet <leaflet@leafok.com> |
| 7 |
|
*/ |
|
/*************************************************************************** |
|
|
* * |
|
|
* This program is free software; you can redistribute it and/or modify * |
|
|
* it under the terms of the GNU General Public License as published by * |
|
|
* the Free Software Foundation; either version 3 of the License, or * |
|
|
* (at your option) any later version. * |
|
|
* * |
|
|
***************************************************************************/ |
|
| 8 |
|
|
| 9 |
#include "article_favor.h" |
#include "article_favor.h" |
| 10 |
#include "common.h" |
#include "common.h" |
| 140 |
"DELETE FROM article_favorite WHERE UID = %d AND AID IN (", |
"DELETE FROM article_favorite WHERE UID = %d AND AID IN (", |
| 141 |
p_favor->uid); |
p_favor->uid); |
| 142 |
|
|
| 143 |
for (i = 0, j = 0; i < p_favor->aid_base_cnt && j < p_favor->aid_inc_cnt;) |
for (i = 0, j = 0; j < p_favor->aid_inc_cnt;) |
| 144 |
{ |
{ |
| 145 |
if (p_favor->aid_base[i] == p_favor->aid_inc[j]) // XOR - delete record |
if (i < p_favor->aid_base_cnt && p_favor->aid_base[i] == p_favor->aid_inc[j]) // XOR - delete record |
| 146 |
{ |
{ |
| 147 |
snprintf(tuple_tmp, sizeof(tuple_tmp), "%d, ", p_favor->aid_inc[j]); |
snprintf(tuple_tmp, sizeof(tuple_tmp), "%d, ", p_favor->aid_inc[j]); |
| 148 |
strncat(sql_del, tuple_tmp, sizeof(sql_del) - 1 - strnlen(sql_del, sizeof(sql_del))); |
strncat(sql_del, tuple_tmp, sizeof(sql_del) - 1 - strnlen(sql_del, sizeof(sql_del))); |
| 151 |
i++; |
i++; |
| 152 |
j++; |
j++; |
| 153 |
} |
} |
| 154 |
else if (p_favor->aid_base[i] < p_favor->aid_inc[j]) // skip existing record |
else if (i < p_favor->aid_base_cnt && p_favor->aid_base[i] < p_favor->aid_inc[j]) // skip existing record |
| 155 |
{ |
{ |
| 156 |
i++; |
i++; |
| 157 |
} |
} |
| 158 |
else // if (p_favor->aid_base[i] > p_favor->aid_inc[j]) |
else // if (i >= p_favor->aid_base_cnt || p_favor->aid_base[i] > p_favor->aid_inc[j]) |
| 159 |
{ |
{ |
| 160 |
snprintf(tuple_tmp, sizeof(tuple_tmp), |
snprintf(tuple_tmp, sizeof(tuple_tmp), |
| 161 |
"(%d, %d), ", |
"(%d, %d), ", |
| 313 |
mid = (left + right) / 2; |
mid = (left + right) / 2; |
| 314 |
if (aid < (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
if (aid < (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
| 315 |
{ |
{ |
| 316 |
right = mid; |
right = mid - 1; |
| 317 |
} |
} |
| 318 |
else if (aid > (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
else if (aid > (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
| 319 |
{ |
{ |
| 364 |
mid = (left + right) / 2; |
mid = (left + right) / 2; |
| 365 |
if (aid < (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
if (aid < (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
| 366 |
{ |
{ |
| 367 |
right = mid; |
right = mid - 1; |
| 368 |
} |
} |
| 369 |
else if (aid > (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
else if (aid > (i == 0 ? p_favor->aid_base[mid] : p_favor->aid_inc[mid])) |
| 370 |
{ |
{ |
| 500 |
return -3; |
return -3; |
| 501 |
} |
} |
| 502 |
|
|
| 503 |
// acquire lock of section |
if (get_section_info(p_section, p_snames[i], NULL, NULL) < 0) |
|
if (section_list_rd_lock(p_section) < 0) |
|
|
{ |
|
|
log_error("section_list_rd_lock(sid = %d) error\n", p_section->sid); |
|
|
return -4; |
|
|
} |
|
|
|
|
|
memcpy(p_snames[i], p_section->sname, sizeof(p_snames[i])); |
|
|
|
|
|
// release lock of section |
|
|
if (section_list_rd_unlock(p_section) < 0) |
|
| 504 |
{ |
{ |
| 505 |
log_error("section_list_rd_unlock(sid = %d) error\n", p_section->sid); |
log_error("get_section_info(sid=%d) error\n", p_section->sid); |
| 506 |
return -4; |
return -4; |
| 507 |
} |
} |
| 508 |
} |
} |