void
xmms_medialib_entry_cleanup (xmms_medialib_session_t *session,
xmms_medialib_entry_t entry)
{
s4_resultset_t *set;
s4_val_t *song_id;
gint i;
song_id = s4_val_new_int (entry);
set = xmms_medialib_filter (session, "song_id", song_id,
S4_COND_PARENT, NULL, NULL, S4_FETCH_DATA);
for (i = 0; i < s4_resultset_get_rowcount (set); i++) {
const s4_result_t *res;
res = s4_resultset_get_result (set, i, 0);
while (res != NULL) {
const gchar *src = s4_result_get_src (res);
const gchar *key = s4_result_get_key (res);
if (entry_attribute_is_derived (src, key)) {
const s4_val_t *value = s4_result_get_val (res);
xmms_medialib_session_property_unset (session, entry, key,
value, src);
}
res = s4_result_next (res);
}
}
s4_resultset_free (set);
s4_val_free (song_id);
}
/**
* @internal
*/
static xmms_medialib_entry_t
xmms_medialib_get_id (xmms_medialib_session_t *session, const char *url, xmms_error_t *error)
{
s4_sourcepref_t *sourcepref;
s4_resultset_t *set;
s4_val_t *value;
const s4_result_t *res;
gint32 id = 0;
sourcepref = xmms_medialib_session_get_source_preferences (session);
value = s4_val_new_string (url);
set = xmms_medialib_filter (session, XMMS_MEDIALIB_ENTRY_PROPERTY_URL,
value, 0, sourcepref, "song_id", S4_FETCH_PARENT);
s4_val_free (value);
s4_sourcepref_unref (sourcepref);
res = s4_resultset_get_result (set, 0, 0);
if (res != NULL) {
s4_val_get_int (s4_result_get_val (res), &id);
}
s4_resultset_free (set);
return id;
}
/**
* Remove a medialib entry from the database
*
* @param id_num Entry to remove
*/
void
xmms_medialib_entry_remove (xmms_medialib_session_t *session,
xmms_medialib_entry_t entry)
{
s4_resultset_t *set;
s4_val_t *song_id;
gint i;
song_id = s4_val_new_int (entry);
set = xmms_medialib_filter (session, "song_id", song_id,
S4_COND_PARENT, NULL, NULL, S4_FETCH_DATA);
for (i = 0; i < s4_resultset_get_rowcount (set); i++) {
const s4_result_t *res;
res = s4_resultset_get_result (set, i, 0);
while (res != NULL) {
xmms_medialib_session_property_unset (session, entry,
s4_result_get_key (res),
s4_result_get_val (res),
s4_result_get_src (res));
res = s4_result_next (res);
}
}
s4_resultset_free (set);
s4_val_free (song_id);
}
static void
xmms_medialib_property_remove (xmms_medialib_session_t *session,
xmms_medialib_entry_t entry,
const gchar *source, const gchar *key,
xmms_error_t *error)
{
const char *sources[2] = { source, NULL };
s4_sourcepref_t *sp;
s4_resultset_t *set;
const s4_result_t *res;
s4_val_t *song_id;
sp = s4_sourcepref_create (sources);
song_id = s4_val_new_int (entry);
set = xmms_medialib_filter (session, "song_id", song_id,
S4_COND_PARENT, sp, key, S4_FETCH_DATA);
res = s4_resultset_get_result (set, 0, 0);
if (res != NULL) {
xmms_medialib_session_property_unset (session, entry, key,
s4_result_get_val (res),
source);
}
s4_resultset_free (set);
s4_sourcepref_unref (sp);
s4_val_free (song_id);
}
gint
xmms_medialib_session_property_set (xmms_medialib_session_t *session,
xmms_medialib_entry_t entry,
const gchar *key,
const s4_val_t *value,
const gchar *source)
{
const gchar *sources[2] = { source, NULL };
const s4_result_t *res;
s4_condition_t *cond;
s4_fetchspec_t *spec;
s4_resultset_t *set;
s4_sourcepref_t *sp;
s4_val_t *song_id;
gint result;
GHashTable *events;
song_id = s4_val_new_int (entry);
sp = s4_sourcepref_create (sources);
cond = s4_cond_new_filter (S4_FILTER_EQUAL, "song_id", song_id,
sp, S4_CMP_CASELESS, S4_COND_PARENT);
spec = s4_fetchspec_create ();
s4_fetchspec_add (spec, key, sp, S4_FETCH_DATA);
set = s4_query (session->trans, spec, cond);
s4_cond_free (cond);
s4_fetchspec_free (spec);
res = s4_resultset_get_result (set, 0, 0);
if (res != NULL) {
const s4_val_t *old_value = s4_result_get_val (res);
s4_del (session->trans, "song_id", song_id,
key, old_value, source);
}
s4_resultset_free (set);
s4_sourcepref_unref (sp);
result = s4_add (session->trans, "song_id", song_id,
key, value, source);
s4_val_free (song_id);
if (strcmp (key, XMMS_MEDIALIB_ENTRY_PROPERTY_URL) == 0) {
events = xmms_medialib_session_get_table (&session->added);
} else {
events = xmms_medialib_session_get_table (&session->updated);
}
g_hash_table_insert (events,
GINT_TO_POINTER (entry),
GINT_TO_POINTER (entry));
return result;
}
static xmmsv_t *
xmms_medialib_entry_to_tree (xmms_medialib_session_t *session,
xmms_medialib_entry_t entry)
{
s4_resultset_t *set;
s4_val_t *song_id;
xmmsv_t *ret, *id;
gint i;
song_id = s4_val_new_int (entry);
set = xmms_medialib_filter (session, "song_id", song_id, S4_COND_PARENT,
NULL, NULL, S4_FETCH_PARENT | S4_FETCH_DATA);
s4_val_free (song_id);
ret = xmmsv_new_dict ();
for (i = 0; i < s4_resultset_get_rowcount (set); i++) {
const s4_result_t *res;
res = s4_resultset_get_result (set, 0, 0);
while (res != NULL) {
xmmsv_t *v_entry = NULL;
const s4_val_t *val;
const char *s;
gint32 i;
val = s4_result_get_val (res);
if (s4_val_get_str (val, &s)) {
v_entry = xmmsv_new_string (s);
} else if (s4_val_get_int (val, &i)) {
v_entry = xmmsv_new_int (i);
}
xmms_medialib_tree_add_tuple (ret, s4_result_get_key (res),
s4_result_get_src (res), v_entry);
xmmsv_unref (v_entry);
res = s4_result_next (res);
}
}
s4_resultset_free (set);
id = xmmsv_new_int (entry);
xmms_medialib_tree_add_tuple (ret, "id", "server", id);
xmmsv_unref (id);
return ret;
}
xmms_medialib_entry_t
xmms_medialib_entry_not_resolved_get (xmms_medialib_session_t *session)
{
const s4_result_t *res;
s4_resultset_t *set;
gint32 ret = 0;
set = not_resolved_set (session);
res = s4_resultset_get_result (set, 0, 0);
if (res != NULL) {
s4_val_get_int (s4_result_get_val (res), &ret);
}
s4_resultset_free (set);
return ret;
}
static void
xmms_medialib_client_rehash (xmms_medialib_t *medialib,
xmms_medialib_entry_t entry,
xmms_error_t *error)
{
xmms_medialib_session_t *session;
do {
session = xmms_medialib_session_begin (medialib);
if (xmms_medialib_check_id (session, entry)) {
xmms_medialib_entry_status_set (session, entry, XMMS_MEDIALIB_ENTRY_STATUS_REHASH);
} else if (entry == 0) {
s4_sourcepref_t *sourcepref;
s4_resultset_t *set;
s4_val_t *status;
gint i;
sourcepref = xmms_medialib_session_get_source_preferences (session);
status = s4_val_new_int (XMMS_MEDIALIB_ENTRY_STATUS_OK);
set = xmms_medialib_filter (session, XMMS_MEDIALIB_ENTRY_PROPERTY_STATUS,
status, 0, sourcepref, "song_id", S4_FETCH_PARENT);
s4_val_free (status);
s4_sourcepref_unref (sourcepref);
for (i = 0; i < s4_resultset_get_rowcount (set); i++) {
const s4_result_t *res;
res = s4_resultset_get_result (set, i, 0);
for (; res != NULL; res = s4_result_next (res)) {
xmms_medialib_entry_t item;
s4_val_get_int (s4_result_get_val (res), &item);
xmms_medialib_entry_status_set (session, item, XMMS_MEDIALIB_ENTRY_STATUS_REHASH);
}
}
s4_resultset_free (set);
} else {
xmms_error_set (error, XMMS_ERROR_NOENT, "No such entry");
}
} while (!xmms_medialib_session_commit (session));
}
static void check_db (struct db_struct *db)
{
int i, j;
s4_fetchspec_t *fs = s4_fetchspec_create ();
s4_fetchspec_add (fs, NULL, NULL, S4_FETCH_DATA);
for (i = 0; db[i].name != NULL; i++) {
s4_val_t *name_val = s4_val_new_string (db[i].name);
s4_condition_t *cond = s4_cond_new_filter (S4_FILTER_EQUAL,
"entry", name_val, NULL, S4_CMP_CASELESS, S4_COND_PARENT);
s4_transaction_t *trans = s4_begin (s4, 0);
s4_resultset_t *set = s4_query (trans, fs, cond);
s4_commit (trans);
const s4_result_t *res = s4_resultset_get_result (set, 0, 0);
int found[ARG_SIZE] = {0};
for (; res != NULL; res = s4_result_next (res)) {
for (j = 0; db[i].args[j] != NULL; j++) {
const char *str;
if (s4_val_get_str (s4_result_get_val (res), &str) && !strcmp (str, db[i].args[j]) &&
!strcmp (s4_result_get_key (res), "property") &&
!strcmp (s4_result_get_src (res), db[i].src)) {
found[j] = 1;
break;
}
}
}
for (j = 0; db[i].args[j] != NULL; j++) {
CU_ASSERT_EQUAL (found[j], 1);
}
s4_resultset_free (set);
s4_cond_free (cond);
s4_val_free (name_val);
}
s4_fetchspec_free (fs);
}
static s4_val_t *
xmms_medialib_entry_property_get (xmms_medialib_session_t *session,
xmms_medialib_entry_t entry,
const gchar *property)
{
s4_sourcepref_t *sourcepref;
const s4_result_t *res;
s4_resultset_t *set;
s4_val_t *ret = NULL;
s4_val_t *song_id;
g_return_val_if_fail (property, NULL);
song_id = s4_val_new_int (entry);
if (strcmp (property, XMMS_MEDIALIB_ENTRY_PROPERTY_ID) == 0) {
/* only resolving attributes other than 'id' */
return song_id;
}
sourcepref = xmms_medialib_session_get_source_preferences (session);
set = xmms_medialib_filter (session, "song_id", song_id, S4_COND_PARENT,
sourcepref, property, S4_FETCH_DATA);
s4_sourcepref_unref (sourcepref);
res = s4_resultset_get_result (set, 0, 0);
if (res != NULL) {
ret = s4_val_copy (s4_result_get_val (res));
}
s4_resultset_free (set);
s4_val_free (song_id);
return ret;
}
/* Converts an S4 resultset to an xmmsv using the fetch specification */
static xmmsv_t *
metadata_to_xmmsv (s4_resultset_t *set, xmms_fetch_spec_t *spec)
{
const s4_resultrow_t *row;
xmmsv_t *ret = NULL;
gint i;
/* Loop over the rows in the resultset */
for (i = 0; s4_resultset_get_row (set, i, &row); i++) {
gint32 id, j;
s4_val_get_int (s4_result_get_val (s4_resultset_get_result (set, i, 0)), &id);
for (j = 0; j < spec->data.metadata.col_count; j++) {
const s4_result_t *res;
if (s4_resultrow_get_col (row, spec->data.metadata.cols[j], &res)) {
ret = result_to_xmmsv (ret, id, res, spec);
}
}
}
return aggregate_result (ret, spec->data.metadata.get_size - 1,
spec->data.metadata.aggr_func);
}
