pidgin/pidgin

Fix several leaks in tests

14 months ago, Elliott Sales de Andrade
4e1bf25f5575
Fix several leaks in tests

All of these are specific to tests, not the library code.

For the moment, `protocol_xfer` still leaks connections (and anything they hold on to) because it is very difficult to disentangle them from the connection manager in the partially implemented state they are in.

This fixes leaks of options in the account option test (these two leaks occur for every test since they all leak the option):
```
61 (48 direct, 13 indirect) bytes in 1 blocks are definitely lost in loss record 133 of 276
at 0x4848464: calloc (vg_replace_malloc.c:1340)
by 0x49F75F0: g_malloc0 (gmem.c:163)
by 0x48C3B2E: purple_account_option_new (purpleaccountoption.c:78)
by 0x4014AF: test_purple_account_option_copy_int (test_account_option.c:67)
by 0x4A1CC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A1CC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A1C9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A1C9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A1D181: g_test_run_suite (gtestutils.c:3115)
by 0x4A156EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A156EC: g_test_run (gtestutils.c:2221)
by 0x401721: main (test_account_option.c:157)

61 (48 direct, 13 indirect) bytes in 1 blocks are definitely lost in loss record 134 of 276
at 0x4848464: calloc (vg_replace_malloc.c:1340)
by 0x49F75F0: g_malloc0 (gmem.c:163)
by 0x48C3BC7: purple_account_option_copy (purpleaccountoption.c:93)
by 0x4014BF: test_purple_account_option_copy_int (test_account_option.c:68)
by 0x4A1CC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A1CC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A1C9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A1C9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A1D181: g_test_run_suite (gtestutils.c:3115)
by 0x4A156EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A156EC: g_test_run (gtestutils.c:2221)
by 0x401721: main (test_account_option.c:157)
```
leaks in the credential manager test (times 3 for read/write/cancel tests):
```
69 (16 direct, 53 indirect) bytes in 1 blocks are definitely lost in loss record 2,427 of 3,503
at 0x484386F: malloc (vg_replace_malloc.c:393)
by 0x4A58168: g_malloc (gmem.c:130)
by 0x4A6FAB5: g_slice_alloc (gslice.c:1074)
by 0x4A700EC: g_slice_alloc0 (gslice.c:1100)
by 0x4A3BECB: g_error_allocate (gerror.c:710)
by 0x4A3C93F: UnknownInlinedFun (gerror.c:724)
by 0x4A3C93F: g_error_new_valist (gerror.c:766)
by 0x4BEE558: g_task_return_new_error (gtask.c:1941)
by 0x48D82C0: purple_credential_manager_read_password_async (purplecredentialmanager.c:492)
by 0x403634: test_purple_credential_manager_no_provider_read_password_idle (test_credential_manager.c:329)
by 0x4A4ECB1: g_idle_dispatch (gmain.c:6124)
by 0x4A4FCBE: UnknownInlinedFun (gmain.c:3444)
by 0x4A4FCBE: g_main_context_dispatch (gmain.c:4162)
by 0x4AA5597: g_main_context_iterate.constprop.0 (gmain.c:4238)
by 0x4A4F28E: g_main_loop_run (gmain.c:4438)
by 0x40369F: test_purple_credential_manager_no_provider_read_password_async (test_credential_manager.c:345)
by 0x4A7DC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A7DC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A7D9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A7D9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A7E181: g_test_run_suite (gtestutils.c:3115)
by 0x4A766EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A766EC: g_test_run (gtestutils.c:2221)
by 0x4048F6: main (test_credential_manager.c:695)
```
a leak in the image test:
```
161 bytes in 1 blocks are definitely lost in loss record 260 of 274
at 0x484386F: malloc (vg_replace_malloc.c:393)
by 0x4A55363: g_try_malloc (gmem.c:286)
by 0x4A3D630: UnknownInlinedFun (gfileutils.c:819)
by 0x4A3D630: UnknownInlinedFun (gfileutils.c:924)
by 0x4A3D630: g_file_get_contents (gfileutils.c:1027)
by 0x401890: test_image_new_from_file (test_image.c:144)
by 0x4A7DC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A7DC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A7D9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A7E181: g_test_run_suite (gtestutils.c:3115)
by 0x4A766EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A766EC: g_test_run (gtestutils.c:2221)
by 0x40195D: main (test_image.c:172)
```
a leak in queued output stream test:
```
72 (40 direct, 32 indirect) bytes in 1 blocks are definitely lost in loss record 219 of 396
at 0x49D51EF: g_type_create_instance (gtype.c:1909)
by 0x49BAC1F: g_object_new_internal (gobject.c:2228)
by 0x49BC247: g_object_new_with_properties (gobject.c:2391)
by 0x49BCFF0: g_object_new (gobject.c:2037)
by 0x402003: test_queued_output_stream_push_bytes_async_error (test_queued_output_stream.c:219)
by 0x4A7DC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A7DC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A7D9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A7E181: g_test_run_suite (gtestutils.c:3115)
by 0x4A766EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A766EC: g_test_run (gtestutils.c:2221)
by 0x402429: main (test_queued_output_stream.c:280)
```
and protocol xfer tests (times 3 for each test that creates a test protocol object):
```
112 (48 direct, 64 indirect) bytes in 1 blocks are definitely lost in loss record 3,430 of 3,698
at 0x49D51EF: g_type_create_instance (gtype.c:1909)
by 0x49BAC1F: g_object_new_internal (gobject.c:2228)
by 0x49BC247: g_object_new_with_properties (gobject.c:2391)
by 0x49BCFF0: g_object_new (gobject.c:2037)
by 0x40291C: test_purple_protocol_xfer_send_file_func (test_protocol_xfer.c:146)
by 0x4A7DC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A7DC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A7D9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A7E181: g_test_run_suite (gtestutils.c:3115)
by 0x4A766EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A766EC: g_test_run (gtestutils.c:2221)
by 0x402B64: main (test_protocol_xfer.c:195)
```
and util tests (times 3 for each call to `purple_text_strip_mnemonic` in the test):
```
5 bytes in 1 blocks are definitely lost in loss record 5 of 247
at 0x484386F: malloc (vg_replace_malloc.c:393)
by 0x49F7168: g_malloc (gmem.c:130)
by 0x491975B: purple_text_strip_mnemonic (util.c:895)
by 0x4015B0: test_util_text_strip_mnemonic (test_util.c:49)
by 0x4A1CC7D: UnknownInlinedFun (gtestutils.c:2933)
by 0x4A1CC7D: g_test_run_suite_internal (gtestutils.c:3021)
by 0x4A1C9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A1C9E4: g_test_run_suite_internal (gtestutils.c:3038)
by 0x4A1D181: g_test_run_suite (gtestutils.c:3115)
by 0x4A156EC: UnknownInlinedFun (gtestutils.c:2234)
by 0x4A156EC: g_test_run (gtestutils.c:2221)
by 0x401901: main (test_util.c:224)
```
and these leaks in any test that initializes the test UI:
```
4,104 bytes in 1 blocks are possibly lost in loss record 3,451 of 3,457
at 0x484386F: malloc (vg_replace_malloc.c:393)
by 0x5235B67: sqlite3MemMalloc.lto_priv.0 (sqlite3.c:25493)
by 0x5232797: UnknownInlinedFun (sqlite3.c:29181)
by 0x5232797: UnknownInlinedFun (sqlite3.c:29227)
by 0x5232797: sqlite3Malloc.lto_priv.0 (sqlite3.c:29221)
by 0x523BD8B: pcache1Alloc.lto_priv.0 (sqlite3.c:53546)
by 0x5249A8B: UnknownInlinedFun (sqlite3.c:53675)
by 0x5249A8B: allocateTempSpace (sqlite3.c:70848)
by 0x52625A6: sqlite3VdbeExec.lto_priv.0 (sqlite3.c:93857)
by 0x525CBEE: UnknownInlinedFun (sqlite3.c:87995)
by 0x525CBEE: UnknownInlinedFun (sqlite3.c:88056)
by 0x525CBEE: sqlite3_step (sqlite3.c:88045)
by 0x529B324: sqlite3_exec (sqlite3.c:131002)
by 0x48FD558: purple_sqlite3_run_migration (purplesqlite3.c:37)
by 0x48FDBB4: purple_sqlite3_run_migrations_from_resources (purplesqlite3.c:195)
by 0x48FDED9: purple_sqlite_history_adapter_run_migrations (purplesqlitehistoryadapter.c:69)
by 0x48FE7F0: purple_sqlite_history_adapter_activate (purplesqlitehistoryadapter.c:287)
by 0x48DB656: purple_history_adapter_activate (purplehistoryadapter.c:181)
by 0x48DC9BC: purple_history_manager_set_active (purplehistorymanager.c:308)
by 0x402BA8: test_ui_init_history (test_ui.c:132)
by 0x402C80: test_ui_purple_init (test_ui.c:167)
by 0x4027BB: main (test_contact.c:88)

4,368 bytes in 1 blocks are possibly lost in loss record 3,453 of 3,457
at 0x484386F: malloc (vg_replace_malloc.c:393)
by 0x5235B67: sqlite3MemMalloc.lto_priv.0 (sqlite3.c:25493)
by 0x5232797: UnknownInlinedFun (sqlite3.c:29181)
by 0x5232797: UnknownInlinedFun (sqlite3.c:29227)
by 0x5232797: sqlite3Malloc.lto_priv.0 (sqlite3.c:29221)
by 0x523BD8B: pcache1Alloc.lto_priv.0 (sqlite3.c:53546)
by 0x5240077: UnknownInlinedFun (sqlite3.c:53634)
by 0x5240077: pcache1FetchStage2 (sqlite3.c:54104)
by 0x5243E9C: UnknownInlinedFun (sqlite3.c:52671)
by 0x5243E9C: getPageNormal.lto_priv.0 (sqlite3.c:60628)
by 0x524A510: UnknownInlinedFun (sqlite3.c:60805)
by 0x524A510: btreeGetPage.lto_priv.0 (sqlite3.c:70289)
by 0x524C2F6: UnknownInlinedFun (sqlite3.c:71257)
by 0x524C2F6: sqlite3BtreeBeginTrans.lto_priv.0 (sqlite3.c:71647)
by 0x5266B3A: sqlite3VdbeExec.lto_priv.0 (sqlite3.c:93532)
by 0x525CBEE: UnknownInlinedFun (sqlite3.c:87995)
by 0x525CBEE: UnknownInlinedFun (sqlite3.c:88056)
by 0x525CBEE: sqlite3_step (sqlite3.c:88045)
by 0x48FD715: purple_sqlite3_get_schema_version (purplesqlite3.c:79)
by 0x48FD9DD: purple_sqlite3_run_migrations_from_resources (purplesqlite3.c:146)
by 0x48FDED9: purple_sqlite_history_adapter_run_migrations (purplesqlitehistoryadapter.c:69)
by 0x48FE7F0: purple_sqlite_history_adapter_activate (purplesqlitehistoryadapter.c:287)
by 0x48DB656: purple_history_adapter_activate (purplehistoryadapter.c:181)
by 0x48DC9BC: purple_history_manager_set_active (purplehistorymanager.c:308)
by 0x402BA8: test_ui_init_history (test_ui.c:132)
by 0x402C80: test_ui_purple_init (test_ui.c:167)
by 0x4027BB: main (test_contact.c:88)

4,368 bytes in 1 blocks are possibly lost in loss record 3,454 of 3,457
at 0x484386F: malloc (vg_replace_malloc.c:393)
by 0x5235B67: sqlite3MemMalloc.lto_priv.0 (sqlite3.c:25493)
by 0x5232797: UnknownInlinedFun (sqlite3.c:29181)
by 0x5232797: UnknownInlinedFun (sqlite3.c:29227)
by 0x5232797: sqlite3Malloc.lto_priv.0 (sqlite3.c:29221)
by 0x523BD8B: pcache1Alloc.lto_priv.0 (sqlite3.c:53546)
by 0x5240077: UnknownInlinedFun (sqlite3.c:53634)
by 0x5240077: pcache1FetchStage2 (sqlite3.c:54104)
by 0x5243E9C: UnknownInlinedFun (sqlite3.c:52671)
by 0x5243E9C: getPageNormal.lto_priv.0 (sqlite3.c:60628)
by 0x52499BC: UnknownInlinedFun (sqlite3.c:60805)
by 0x52499BC: UnknownInlinedFun (sqlite3.c:70289)
by 0x52499BC: btreeGetUnusedPage (sqlite3.c:70432)
by 0x524F504: allocateBtreePage.lto_priv.0 (sqlite3.c:74604)
by 0x5256209: btreeCreateTable.lto_priv.0 (sqlite3.c:77830)
by 0x5265EB2: UnknownInlinedFun (sqlite3.c:77849)
by 0x5265EB2: sqlite3VdbeExec.lto_priv.0 (sqlite3.c:96382)
by 0x525CBEE: UnknownInlinedFun (sqlite3.c:87995)
by 0x525CBEE: UnknownInlinedFun (sqlite3.c:88056)
by 0x525CBEE: sqlite3_step (sqlite3.c:88045)
by 0x529B324: sqlite3_exec (sqlite3.c:131002)
by 0x48FD558: purple_sqlite3_run_migration (purplesqlite3.c:37)
by 0x48FDBB4: purple_sqlite3_run_migrations_from_resources (purplesqlite3.c:195)
by 0x48FDED9: purple_sqlite_history_adapter_run_migrations (purplesqlitehistoryadapter.c:69)
by 0x48FE7F0: purple_sqlite_history_adapter_activate (purplesqlitehistoryadapter.c:287)
by 0x48DB656: purple_history_adapter_activate (purplehistoryadapter.c:181)
by 0x48DC9BC: purple_history_manager_set_active (purplehistorymanager.c:308)
by 0x402BA8: test_ui_init_history (test_ui.c:132)
by 0x402C80: test_ui_purple_init (test_ui.c:167)
by 0x4027BB: main (test_contact.c:88)
```

Testing Done:
Ran tests in valgrind, and all above leaks were gone except for noted `protocol_xfer` issues, and a bunch of leaks of the `PurpleBuddy`-`PurpleContact` compatibility bindings, which will go away in their entirety eventually.

Reviewed at https://reviews.imfreedom.org/r/2385/
/*
* Purple - Internet Messaging Library
* Copyright (C) Pidgin Developers <devel@pidgin.im>
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, see <https://www.gnu.org/licenses/>.
*/
#include <glib/gi18n-lib.h>
#include <sqlite3.h>
#include "purplesqlitehistoryadapter.h"
#include "account.h"
#include "purpleprivate.h"
#include "purplesqlite3.h"
struct _PurpleSqliteHistoryAdapter {
PurpleHistoryAdapter parent;
gchar *filename;
sqlite3 *db;
};
enum {
PROP_0,
PROP_FILENAME,
N_PROPERTIES,
};
static GParamSpec *properties[N_PROPERTIES] = {NULL, };
G_DEFINE_TYPE(PurpleSqliteHistoryAdapter, purple_sqlite_history_adapter,
PURPLE_TYPE_HISTORY_ADAPTER)
/******************************************************************************
* Helpers
*****************************************************************************/
static void
purple_sqlite_history_adapter_set_filename(PurpleSqliteHistoryAdapter *adapter,
const gchar *filename)
{
g_free(adapter->filename);
adapter->filename = g_strdup(filename);
g_object_notify_by_pspec(G_OBJECT(adapter), properties[PROP_FILENAME]);
}
static gboolean
purple_sqlite_history_adapter_run_migrations(PurpleSqliteHistoryAdapter *adapter,
GError **error)
{
const char *path = "/im/pidgin/libpurple/sqlitehistoryadapter";
const char *migrations[] = {
"01-schema.sql",
NULL
};
return purple_sqlite3_run_migrations_from_resources(adapter->db, path,
migrations, error);
}
static gchar *
purple_sqlite_history_adapter_get_content_type(PurpleMessageContentType content_type) {
switch(content_type) {
case PURPLE_MESSAGE_CONTENT_TYPE_PLAIN:
return "plain";
break;
case PURPLE_MESSAGE_CONTENT_TYPE_HTML:
return "html";
break;
case PURPLE_MESSAGE_CONTENT_TYPE_XHTML:
return "xhtml";
break;
case PURPLE_MESSAGE_CONTENT_TYPE_MARKDOWN:
return "markdown";
break;
default:
return "";
break;
}
}
static PurpleMessageContentType
purple_sqlite_history_adapter_get_content_type_enum(const gchar *content_type)
{
if(purple_strequal(content_type, "plain")) {
return PURPLE_MESSAGE_CONTENT_TYPE_PLAIN;
}
if(purple_strequal(content_type, "html")) {
return PURPLE_MESSAGE_CONTENT_TYPE_HTML;
}
if(purple_strequal(content_type, "xhtml")) {
return PURPLE_MESSAGE_CONTENT_TYPE_XHTML;
}
if(purple_strequal(content_type, "markdown")) {
return PURPLE_MESSAGE_CONTENT_TYPE_MARKDOWN;
}
return PURPLE_MESSAGE_CONTENT_TYPE_PLAIN;
}
static sqlite3_stmt *
purple_sqlite_history_adapter_build_query(PurpleSqliteHistoryAdapter *adapter,
const gchar * search_query,
gboolean remove,
GError **error)
{
gchar **split = NULL;
gint i = 0;
GList *ins = NULL;
GList *froms = NULL;
GList *keywords = NULL;
GString *query = NULL;
GList *iter = NULL;
gboolean first = FALSE;
sqlite3_stmt *prepared_statement = NULL;
gint index = 1;
gint query_items = 0;
split = g_strsplit(search_query, " ", -1);
for(i = 0; split[i] != NULL; i++) {
if(g_str_has_prefix(split[i], "in:")) {
if(split[i][3] == '\0') {
continue;
}
ins = g_list_prepend(ins, g_strdup(split[i]+3));
query_items++;
} else if(g_str_has_prefix(split[i], "from:")) {
if(split[i][5] == '\0') {
continue;
}
froms = g_list_prepend(froms, g_strdup(split[i]+5));
query_items++;
} else {
if(split[i][0] == '\0') {
continue;
}
keywords = g_list_prepend(keywords,
g_strdup_printf("%%%s%%", split[i]));
query_items++;
}
}
g_clear_pointer(&split, g_strfreev);
if(remove) {
if(query_items != 0) {
query = g_string_new("DELETE FROM message_log WHERE TRUE\n");
} else {
g_set_error(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
"Attempting to remove messages without "
"query parameters.");
return NULL;
}
} else {
query = g_string_new("SELECT "
"message_id, author, author_name_color, "
"author_alias, recipient, content_type, "
"content, client_timestamp "
"FROM message_log WHERE TRUE\n");
}
if(ins != NULL) {
first = TRUE;
g_string_append(query, "AND (conversation_id IN (");
for(iter = ins; iter != NULL; iter = iter->next) {
if(!first) {
g_string_append(query, ", ");
}
first = FALSE;
g_string_append(query, "?");
}
g_string_append(query, "))");
}
if(froms != NULL) {
first = TRUE;
g_string_append(query, "AND (author IN (");
for(iter = froms; iter != NULL; iter = iter->next) {
if(!first) {
g_string_append(query, ", ");
}
first = FALSE;
g_string_append(query, "?");
}
g_string_append(query, "))");
}
if(keywords != NULL) {
first = TRUE;
g_string_append(query, "AND (");
for(iter = keywords; iter != NULL; iter = iter->next) {
if(!first) {
g_string_append(query, " OR ");
}
first = FALSE;
g_string_append(query, " content LIKE ? ");
}
g_string_append(query, ")");
}
g_string_append(query, ";");
sqlite3_prepare_v2(adapter->db, query->str, -1, &prepared_statement, NULL);
g_string_free(query, TRUE);
if(prepared_statement == NULL) {
g_set_error(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
"Error creating the prepared statement: %s",
sqlite3_errmsg(adapter->db));
g_list_free_full(ins, g_free);
g_list_free_full(froms, g_free);
g_list_free_full(keywords, g_free);
return NULL;
}
while(ins != NULL) {
sqlite3_bind_text(prepared_statement, index++,
(const char *)ins->data, -1, g_free);
ins = g_list_delete_link(ins, ins);
}
while(froms != NULL) {
sqlite3_bind_text(prepared_statement, index++,
(const char *)froms->data, -1, g_free);
froms = g_list_delete_link(froms, froms);
}
while(keywords != NULL) {
sqlite3_bind_text(prepared_statement, index++,
(const char *)keywords->data, -1, g_free);
keywords = g_list_delete_link(keywords, keywords);
}
return prepared_statement;
}
/******************************************************************************
* PurpleHistoryAdapter Implementation
*****************************************************************************/
static gboolean
purple_sqlite_history_adapter_activate(PurpleHistoryAdapter *adapter,
GError **error)
{
PurpleSqliteHistoryAdapter *sqlite_adapter = NULL;
gint rc = 0;
sqlite_adapter = PURPLE_SQLITE_HISTORY_ADAPTER(adapter);
if(sqlite_adapter->db != NULL) {
g_set_error_literal(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
_("Adapter has already been activated"));
return FALSE;
}
if(sqlite_adapter->filename == NULL) {
g_set_error_literal(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
_("No filename specified"));
return FALSE;
}
rc = sqlite3_open(sqlite_adapter->filename, &sqlite_adapter->db);
if(rc != SQLITE_OK) {
g_set_error(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
_("Error opening database in purplesqlitehistoryadapter for file %s"),
sqlite_adapter->filename);
g_clear_pointer(&sqlite_adapter->db, sqlite3_close);
return FALSE;
}
if(!purple_sqlite_history_adapter_run_migrations(sqlite_adapter, error)) {
g_clear_pointer(&sqlite_adapter->db, sqlite3_close);
return FALSE;
}
return TRUE;
}
static gboolean
purple_sqlite_history_adapter_deactivate(PurpleHistoryAdapter *adapter,
G_GNUC_UNUSED GError **error)
{
PurpleSqliteHistoryAdapter *sqlite_adapter = NULL;
sqlite_adapter = PURPLE_SQLITE_HISTORY_ADAPTER(adapter);
g_clear_pointer(&sqlite_adapter->db, sqlite3_close);
return TRUE;
}
static GList*
purple_sqlite_history_adapter_query(PurpleHistoryAdapter *adapter,
const gchar *query, GError **error)
{
PurpleSqliteHistoryAdapter *sqlite_adapter = NULL;
sqlite3_stmt *prepared_statement = NULL;
GList *results = NULL;
sqlite_adapter = PURPLE_SQLITE_HISTORY_ADAPTER(adapter);
if(sqlite_adapter->db == NULL) {
g_set_error_literal(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
_("Adapter has not been activated"));
return FALSE;
}
prepared_statement = purple_sqlite_history_adapter_build_query(sqlite_adapter,
query,
FALSE,
error);
if(prepared_statement == NULL) {
return NULL;
}
while(sqlite3_step(prepared_statement) == SQLITE_ROW) {
PurpleMessage *message = NULL;
PurpleMessageContentType ct;
GDateTime *g_date_time = NULL;
const gchar *message_id = NULL;
const gchar *author = NULL;
const gchar *author_name_color = NULL;
const gchar *author_alias = NULL;
const gchar *recipient = NULL;
const gchar *content = NULL;
const gchar *content_type = NULL;
const gchar *timestamp = NULL;
message_id = (const gchar *)sqlite3_column_text(prepared_statement, 0);
author = (const gchar *)sqlite3_column_text(prepared_statement, 1);
author_name_color = (const gchar *)sqlite3_column_text(prepared_statement, 2);
author_alias = (const gchar *)sqlite3_column_text(prepared_statement, 3);
recipient = (const gchar *)sqlite3_column_text(prepared_statement, 4);
content_type = (const gchar *)sqlite3_column_text(prepared_statement, 5);
ct = purple_sqlite_history_adapter_get_content_type_enum(content_type);
content = (const gchar *)sqlite3_column_text(prepared_statement, 6);
timestamp = (const gchar *)sqlite3_column_text(prepared_statement, 7);
g_date_time = g_date_time_new_from_iso8601(timestamp, NULL);
message = g_object_new(PURPLE_TYPE_MESSAGE,
"id", message_id,
"author", author,
"author_name_color", author_name_color,
"author_alias", author_alias,
"recipient", recipient,
"contents", content,
"content_type", ct,
"timestamp", g_date_time,
NULL);
results = g_list_prepend(results, message);
}
results = g_list_reverse(results);
sqlite3_finalize(prepared_statement);
return results;
}
static gboolean
purple_sqlite_history_adapter_remove(PurpleHistoryAdapter *adapter,
const gchar *query, GError **error)
{
PurpleSqliteHistoryAdapter *sqlite_adapter = NULL;
sqlite3_stmt * prepared_statement = NULL;
gint result = 0;
sqlite_adapter = PURPLE_SQLITE_HISTORY_ADAPTER(adapter);
if(sqlite_adapter->db == NULL) {
g_set_error_literal(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
_("Adapter has not been activated"));
return FALSE;
}
prepared_statement = purple_sqlite_history_adapter_build_query(sqlite_adapter,
query,
TRUE,
error);
if(prepared_statement == NULL) {
return FALSE;
}
result = sqlite3_step(prepared_statement);
if(result != SQLITE_DONE) {
g_set_error(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
"Error removing from the database: %s",
sqlite3_errmsg(sqlite_adapter->db));
sqlite3_finalize(prepared_statement);
return FALSE;
}
sqlite3_finalize(prepared_statement);
return TRUE;
}
static gboolean
purple_sqlite_history_adapter_write(PurpleHistoryAdapter *adapter,
PurpleConversation *conversation,
PurpleMessage *message, GError **error)
{
PurpleAccount *account = NULL;
PurpleContactInfo *info = NULL;
PurpleSqliteHistoryAdapter *sqlite_adapter = NULL;
sqlite3_stmt *prepared_statement = NULL;
gchar *timestamp = NULL;
gchar *content_type = NULL;
const gchar * message_id = NULL;
const gchar *script = NULL;
gint result = 0;
script = "INSERT INTO message_log(protocol, account, conversation_id, "
"message_id, author, author_name_color, author_alias, "
"recipient, content_type, content, client_timestamp) "
"VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
sqlite_adapter = PURPLE_SQLITE_HISTORY_ADAPTER(adapter);
if(sqlite_adapter->db == NULL) {
g_set_error_literal(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
_("Adapter has not been activated"));
return FALSE;
}
sqlite3_prepare_v2(sqlite_adapter->db, script, -1, &prepared_statement, NULL);
if(prepared_statement == NULL) {
g_set_error(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
"Error creating the prepared statement: %s",
sqlite3_errmsg(sqlite_adapter->db));
return FALSE;
}
account = purple_conversation_get_account(conversation);
info = PURPLE_CONTACT_INFO(account);
sqlite3_bind_text(prepared_statement,
1, purple_account_get_protocol_name(account), -1,
SQLITE_STATIC);
sqlite3_bind_text(prepared_statement,
2, purple_contact_info_get_username(info), -1,
SQLITE_STATIC);
sqlite3_bind_text(prepared_statement,
3, purple_conversation_get_name(conversation), -1,
SQLITE_STATIC);
message_id = purple_message_get_id(message);
if(message_id != NULL) {
sqlite3_bind_text(prepared_statement, 4, message_id, -1,
SQLITE_STATIC);
} else {
sqlite3_bind_text(prepared_statement, 4, g_uuid_string_random(), -1,
g_free);
}
sqlite3_bind_text(prepared_statement,
5, purple_message_get_author(message), -1,
SQLITE_STATIC);
sqlite3_bind_text(prepared_statement,
6, purple_message_get_author_name_color(message), -1,
SQLITE_STATIC);
sqlite3_bind_text(prepared_statement,
7, purple_message_get_author_alias(message), -1,
SQLITE_STATIC);
sqlite3_bind_text(prepared_statement,
8, purple_message_get_recipient(message), -1,
SQLITE_STATIC);
content_type = purple_sqlite_history_adapter_get_content_type(purple_message_get_content_type(message));
sqlite3_bind_text(prepared_statement,
9, content_type, -1, SQLITE_STATIC);
sqlite3_bind_text(prepared_statement,
10, purple_message_get_contents(message), -1,
SQLITE_STATIC);
timestamp = g_date_time_format_iso8601(purple_message_get_timestamp(message));
sqlite3_bind_text(prepared_statement, 11, timestamp, -1, g_free);
result = sqlite3_step(prepared_statement);
if(result != SQLITE_DONE) {
g_set_error(error, PURPLE_HISTORY_ADAPTER_DOMAIN, 0,
"Error writing to the database: %s",
sqlite3_errmsg(sqlite_adapter->db));
sqlite3_finalize(prepared_statement);
return FALSE;
}
sqlite3_finalize(prepared_statement);
return TRUE;
}
/******************************************************************************
* GObject Implementation
*****************************************************************************/
static void
purple_sqlite_history_adapter_get_property(GObject *obj, guint param_id,
GValue *value, GParamSpec *pspec)
{
PurpleSqliteHistoryAdapter *adapter = PURPLE_SQLITE_HISTORY_ADAPTER(obj);
switch(param_id) {
case PROP_FILENAME:
g_value_set_string(value,
purple_sqlite_history_adapter_get_filename(adapter));
break;
default:
G_OBJECT_WARN_INVALID_PROPERTY_ID(obj, param_id, pspec);
break;
}
}
static void
purple_sqlite_history_adapter_set_property(GObject *obj, guint param_id,
const GValue *value,
GParamSpec *pspec)
{
PurpleSqliteHistoryAdapter *adapter = PURPLE_SQLITE_HISTORY_ADAPTER(obj);
switch(param_id) {
case PROP_FILENAME:
purple_sqlite_history_adapter_set_filename(adapter,
g_value_get_string(value));
break;
default:
G_OBJECT_WARN_INVALID_PROPERTY_ID(obj, param_id, pspec);
break;
}
}
static void
purple_sqlite_history_adapter_finalize(GObject *obj) {
PurpleSqliteHistoryAdapter *adapter = NULL;
adapter = PURPLE_SQLITE_HISTORY_ADAPTER(obj);
g_clear_pointer(&adapter->filename, g_free);
if(adapter->db != NULL) {
g_warning("PurpleSqliteHistoryAdapter was finalized before being "
"deactivated");
g_clear_pointer(&adapter->db, sqlite3_close);
}
G_OBJECT_CLASS(purple_sqlite_history_adapter_parent_class)->finalize(obj);
}
static void
purple_sqlite_history_adapter_init(G_GNUC_UNUSED PurpleSqliteHistoryAdapter *adapter)
{
}
static void
purple_sqlite_history_adapter_class_init(PurpleSqliteHistoryAdapterClass *klass)
{
GObjectClass *obj_class = G_OBJECT_CLASS(klass);
PurpleHistoryAdapterClass *adapter_class = PURPLE_HISTORY_ADAPTER_CLASS(klass);
obj_class->get_property = purple_sqlite_history_adapter_get_property;
obj_class->set_property = purple_sqlite_history_adapter_set_property;
obj_class->finalize = purple_sqlite_history_adapter_finalize;
adapter_class->activate = purple_sqlite_history_adapter_activate;
adapter_class->deactivate = purple_sqlite_history_adapter_deactivate;
adapter_class->query = purple_sqlite_history_adapter_query;
adapter_class->remove = purple_sqlite_history_adapter_remove;
adapter_class->write = purple_sqlite_history_adapter_write;
/**
* PurpleHistoryAdapter::filename:
*
* The filename that the sqlite database will store data to.
*
* Since: 3.0.0
*/
properties[PROP_FILENAME] = g_param_spec_string(
"filename", "filename", "The filename of the sqlite database",
NULL,
G_PARAM_READWRITE | G_PARAM_CONSTRUCT_ONLY | G_PARAM_STATIC_STRINGS
);
g_object_class_install_properties(obj_class, N_PROPERTIES, properties);
}
/******************************************************************************
* Public API
*****************************************************************************/
PurpleHistoryAdapter *
purple_sqlite_history_adapter_new(const gchar *filename) {
return g_object_new(
PURPLE_TYPE_SQLITE_HISTORY_ADAPTER,
"filename", filename,
"id", "sqlite-adapter",
"name", N_("SQLite Adapter"),
NULL);
}
const gchar *
purple_sqlite_history_adapter_get_filename(PurpleSqliteHistoryAdapter *adapter)
{
PurpleSqliteHistoryAdapter *sqlite_adapter = NULL;
g_return_val_if_fail(PURPLE_IS_SQLITE_HISTORY_ADAPTER(adapter), NULL);
sqlite_adapter = PURPLE_SQLITE_HISTORY_ADAPTER(adapter);
return sqlite_adapter->filename;
}