pidgin/pidgin

Remove the private data from PurplePresence
default tip
11 hours ago, Gary Kramlich
939814cb9972
Remove the private data from PurplePresence

Testing Done:
Ran the turtles.

Reviewed at https://reviews.imfreedom.org/r/3149/
/*
* Purple - Internet Messaging Library
* Copyright (C) Pidgin Developers <devel@pidgin.im>
*
* Purple is the legal property of its developers, whose names are too numerous
* to list here. Please refer to the COPYRIGHT file distributed with this
* source distribution.
*
* This library 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 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 General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along with
* this library; if not, see <https://www.gnu.org/licenses/>.
*/
#include <gio/gio.h>
#include <sqlite3.h>
#include "purplesqlite3.h"
/******************************************************************************
* Helpers
*****************************************************************************/
static gboolean
purple_sqlite3_run_migration(sqlite3 *db, int version, const char *migration,
GError **error)
{
char *errmsg = NULL;
char *str = NULL;
gboolean success = TRUE;
str = g_strdup_printf("BEGIN;%s;PRAGMA user_version=%d;COMMIT;", migration,
version);
sqlite3_exec(db, str, NULL, NULL, &errmsg);
if(errmsg != NULL) {
g_set_error(error, PURPLE_SQLITE3_DOMAIN, 0,
"failed to run migration: %s", errmsg);
sqlite3_free(errmsg);
sqlite3_exec(db, "ROLLBACK", NULL, NULL, &errmsg);
if(errmsg != NULL) {
g_error("failed to rollback transaction: %s", errmsg);
sqlite3_free(errmsg);
}
success = FALSE;
}
g_free(str);
return success;
}
/******************************************************************************
* Public API
*****************************************************************************/
int
purple_sqlite3_get_schema_version(sqlite3 *db, GError **error) {
sqlite3_stmt *stmt = NULL;
int version = -1;
g_return_val_if_fail(db != NULL, -1);
sqlite3_prepare_v2(db, "PRAGMA user_version", -1, &stmt, NULL);
if(stmt == NULL) {
g_set_error(error, PURPLE_SQLITE3_DOMAIN, 0,
"error while creating prepared statement: %s",
sqlite3_errmsg(db));
return -1;
}
if(sqlite3_step(stmt) == SQLITE_ROW) {
version = sqlite3_column_int(stmt, 0);
} else {
g_set_error_literal(error, PURPLE_SQLITE3_DOMAIN, 0,
"'PRAGMA user_version' didn't return a row");
sqlite3_finalize(stmt);
return -1;
}
sqlite3_finalize(stmt);
return version;
}
gboolean
purple_sqlite3_run_migrations_from_strings(sqlite3 *db,
const char *migrations[],
GError **error)
{
int current_version = 0;
guint n_migrations = 0;
g_return_val_if_fail(db != NULL, FALSE);
g_return_val_if_fail(migrations != NULL, FALSE);
/* Get the current version or bail if it failed. */
current_version = purple_sqlite3_get_schema_version(db, error);
if(current_version == -1) {
return FALSE;
}
n_migrations = g_strv_length((char **)migrations);
if((guint)current_version > n_migrations) {
g_set_error(error, PURPLE_SQLITE3_DOMAIN, 0,
"schema version %u is higher than known migrations %u",
(guint)current_version, n_migrations);
return FALSE;
}
for(int i = current_version; migrations[i] != NULL; i++) {
int version = i + 1;
if(!purple_sqlite3_run_migration(db, version, migrations[i], error)) {
return FALSE;
}
}
return TRUE;
}
gboolean
purple_sqlite3_run_migrations_from_resources(sqlite3 *db, const char *path,
const char *migrations[],
GError **error)
{
GError *local_error = NULL;
int current_version = 0;
guint n_migrations = 0;
g_return_val_if_fail(db != NULL, FALSE);
g_return_val_if_fail(path != NULL, FALSE);
g_return_val_if_fail(migrations != NULL, FALSE);
/* Get the current version or bail if it failed. */
current_version = purple_sqlite3_get_schema_version(db, error);
if(current_version == -1) {
return FALSE;
}
n_migrations = g_strv_length((char **)migrations);
if((guint)current_version > n_migrations) {
g_set_error(error, PURPLE_SQLITE3_DOMAIN, 0,
"schema version %u is higher than known migrations %u",
(guint)current_version, n_migrations);
return FALSE;
}
/* `PRAGMA user_version` starts at 0, so write our version as i + 1. We
* start iterating the list of migrations at the current version of the
* database. If the database is already up to date, then current_version
* will point us at the null terminator in the list of migrations, which
* will short circuit the for loop.
*/
for(int i = current_version; migrations[i] != NULL; i++) {
GBytes *data = NULL;
char *full_path = NULL;
const gchar *migration = NULL;
int version = i + 1;
/* Get the data from the resource */
full_path = g_build_path("/", path, migrations[i], NULL);
data = g_resources_lookup_data(full_path, G_RESOURCE_LOOKUP_FLAGS_NONE,
&local_error);
if(data == NULL || local_error != NULL) {
if(local_error == NULL) {
local_error = g_error_new(PURPLE_SQLITE3_DOMAIN, 0,
"failed to load resource %s",
full_path);
}
g_propagate_error(error, local_error);
g_clear_pointer(&data, g_bytes_unref);
g_free(full_path);
return FALSE;
}
g_free(full_path);
migration = (const char *)g_bytes_get_data(data, NULL);
if(!purple_sqlite3_run_migration(db, version, migration, error)) {
g_bytes_unref(data);
return FALSE;
}
g_bytes_unref(data);
}
return TRUE;
}