Merge branch 'master' into next
[paraslash.git] / blob.c
1 /*
2 * Copyright (C) 2007-2009 Andre Noll <maan@systemlinux.org>
3 *
4 * Licensed under the GPL v2. For licencing details see COPYING.
5 */
6
7 /** \file blob.c Macros and functions for blob handling. */
8
9 #include <regex.h>
10 #include <fnmatch.h>
11 #include <openssl/rc4.h>
12 #include <osl.h>
13
14 #include "para.h"
15 #include "error.h"
16 #include "crypt.h"
17 #include "string.h"
18 #include "afh.h"
19 #include "afs.h"
20 #include "net.h"
21 #include "ipc.h"
22 #include "portable_io.h"
23
24 /**
25 * Compare two osl objects pointing to unsigned integers of 32 bit size.
26 *
27 * \param obj1 Pointer to the first integer.
28 * \param obj2 Pointer to the second integer.
29 *
30 * \return The values required for an osl compare function.
31 *
32 * \sa osl_compare_func, osl_hash_compare().
33 */
34 static int uint32_compare(const struct osl_object *obj1, const struct osl_object *obj2)
35 {
36 uint32_t d1 = read_u32((const char *)obj1->data);
37 uint32_t d2 = read_u32((const char *)obj2->data);
38
39 if (d1 < d2)
40 return 1;
41 if (d1 > d2)
42 return -1;
43 return 0;
44 }
45
46 static struct osl_column_description blob_cols[] = {
47 [BLOBCOL_ID] = {
48 .storage_type = OSL_MAPPED_STORAGE,
49 .storage_flags = OSL_RBTREE | OSL_UNIQUE | OSL_FIXED_SIZE,
50 .name = "id",
51 .data_size = 4,
52 .compare_function = uint32_compare
53 },
54 [BLOBCOL_NAME] = {
55 .storage_type = OSL_MAPPED_STORAGE,
56 .storage_flags = OSL_RBTREE | OSL_UNIQUE,
57 .name = "name",
58 .compare_function = string_compare
59 },
60 [BLOBCOL_DEF] = {
61 .storage_type = OSL_DISK_STORAGE,
62 .storage_flags = 0,
63 .name = "definition"
64 }
65 };
66
67 /** Define an osl table description for a blob table. */
68 #define DEFINE_BLOB_TABLE_DESC(table_name) \
69 struct osl_table_description table_name ## _table_desc = { \
70 .name = #table_name, \
71 .num_columns = NUM_BLOB_COLUMNS, \
72 .flags = OSL_LARGE_TABLE, \
73 .column_descriptions = blob_cols \
74 };
75
76 /** Define a pointer to an osl blob table with a canonical name. */
77 #define DEFINE_BLOB_TABLE_PTR(table_name) struct osl_table *table_name ## _table;
78
79
80 /** Define a blob table. */
81 #define INIT_BLOB_TABLE(table_name) \
82 DEFINE_BLOB_TABLE_DESC(table_name); \
83 DEFINE_BLOB_TABLE_PTR(table_name);
84
85 /** \cond doxygen isn't smart enough to recognize these */
86 INIT_BLOB_TABLE(lyrics);
87 INIT_BLOB_TABLE(images);
88 INIT_BLOB_TABLE(moods);
89 INIT_BLOB_TABLE(playlists);
90 /** \endcond */
91
92 /** Flags that may be passed to the \p ls functions of each blob type. */
93 enum blob_ls_flags {
94 /** List both id and name. */
95 BLOB_LS_FLAG_LONG = 1,
96 /** Reverse sort order. */
97 BLOB_LS_FLAG_REVERSE = 2,
98 /** Sort by id instead of name. */
99 BLOB_LS_FLAG_SORT_BY_ID = 4,
100 };
101
102 /** Structure passed to the \p print_blob function. */
103 struct lsblob_action_data {
104 /** The flags given at the command line. */
105 uint32_t flags;
106 /** Message buffer. */
107 struct para_buffer pb;
108 };
109
110 static int print_blob(struct osl_table *table, struct osl_row *row,
111 const char *name, void *data)
112 {
113 struct lsblob_action_data *lbad = data;
114 struct osl_object obj;
115 uint32_t id;
116 int ret;
117
118 if (!(lbad->flags & BLOB_LS_FLAG_LONG))
119 return para_printf(&lbad->pb, "%s\n", name);
120 ret = osl(osl_get_object(table, row, BLOBCOL_ID, &obj));
121 if (ret < 0) {
122 para_printf(&lbad->pb, "%s: %s\n", name, para_strerror(-ret));
123 return ret;
124 }
125 id = *(uint32_t *)obj.data;
126 return para_printf(&lbad->pb, "%u\t%s\n", id, name);
127 }
128
129 static void com_lsblob_callback(struct osl_table *table,
130 int fd, const struct osl_object *query)
131 {
132 struct lsblob_action_data lbad = {
133 .flags = *(uint32_t *)query->data,
134 .pb = {
135 .max_size = SHMMAX,
136 .private_data = &fd,
137 .max_size_handler = pass_buffer_as_shm
138 }
139 };
140 struct pattern_match_data pmd = {
141 .table = table,
142 .patterns = {.data = (char *)query->data + sizeof(uint32_t),
143 .size = query->size - sizeof(uint32_t)},
144 .pm_flags = PM_NO_PATTERN_MATCHES_EVERYTHING | PM_SKIP_EMPTY_NAME,
145 .match_col_num = BLOBCOL_NAME,
146 .data = &lbad,
147 .action = print_blob,
148 };
149 int ret;
150
151 if (lbad.flags & BLOB_LS_FLAG_REVERSE)
152 pmd.pm_flags |= PM_REVERSE_LOOP;
153 if (!(lbad.flags & BLOB_LS_FLAG_SORT_BY_ID))
154 pmd.loop_col_num = BLOBCOL_NAME;
155 else
156 pmd.loop_col_num = BLOBCOL_ID;
157 ret = for_each_matching_row(&pmd);
158 if (ret < 0)
159 para_printf(&lbad.pb, "%s\n", para_strerror(-ret));
160 if (lbad.pb.offset)
161 pass_buffer_as_shm(lbad.pb.buf, lbad.pb.offset, &fd);
162 free(lbad.pb.buf);
163 }
164
165 static int com_lsblob(callback_function *f, struct rc4_context *rc4c, int argc, char * const * const argv)
166 {
167 uint32_t flags = 0;
168 struct osl_object options = {.data = &flags, .size = sizeof(flags)};
169 int i;
170
171 for (i = 1; i < argc; i++) {
172 const char *arg = argv[i];
173 if (arg[0] != '-')
174 break;
175 if (!strcmp(arg, "--")) {
176 i++;
177 break;
178 }
179 if (!strcmp(arg, "-l")) {
180 flags |= BLOB_LS_FLAG_LONG;
181 continue;
182 }
183 if (!strcmp(arg, "-i")) {
184 flags |= BLOB_LS_FLAG_SORT_BY_ID;
185 continue;
186 }
187 if (!strcmp(arg, "-r")) {
188 flags |= BLOB_LS_FLAG_REVERSE;
189 continue;
190 }
191 break;
192 }
193 // if (argc > i)
194 // return -E_BLOB_SYNTAX;
195 return send_option_arg_callback_request(&options, argc - i,
196 argv + i, f, rc4_send_result, rc4c);
197 }
198
199 static int cat_blob(struct osl_table *table, struct osl_row *row,
200 __a_unused const char *name, void *data)
201 {
202 int ret = 0, ret2;
203 struct osl_object obj;
204
205 ret = osl(osl_open_disk_object(table, row, BLOBCOL_DEF, &obj));
206 if (ret < 0)
207 return ret;
208 if (obj.size)
209 ret = pass_buffer_as_shm(obj.data, obj.size, data);
210 ret2 = osl(osl_close_disk_object(&obj));
211 return (ret < 0)? ret : ret2;
212 }
213
214 static void com_catblob_callback(struct osl_table *table, int fd,
215 const struct osl_object *query)
216 {
217 struct pattern_match_data pmd = {
218 .table = table,
219 .patterns = *query,
220 .loop_col_num = BLOBCOL_NAME,
221 .match_col_num = BLOBCOL_NAME,
222 .pm_flags = PM_SKIP_EMPTY_NAME,
223 .data = &fd,
224 .action = cat_blob
225 };
226 for_each_matching_row(&pmd);
227 }
228
229 static int com_catblob(callback_function *f, struct rc4_context *rc4c, int argc,
230 char * const * const argv)
231 {
232 if (argc < 2)
233 return -E_BLOB_SYNTAX;
234 return send_standard_callback_request(argc - 1, argv + 1, f,
235 rc4_send_result, rc4c);
236 }
237
238 /** Used for removing rows from a blob table. */
239 struct rmblob_data {
240 /** Message buffer. */
241 struct para_buffer pb;
242 /** Number of removed blobs. */
243 unsigned num_removed;
244 };
245
246 static int remove_blob(struct osl_table *table, struct osl_row *row,
247 const char *name, void *data)
248 {
249 struct rmblob_data *rmbd = data;
250 int ret = osl(osl_del_row(table, row));
251 if (ret < 0) {
252 para_printf(&rmbd->pb, "%s: %s\n", name, para_strerror(-ret));
253 return ret;
254 }
255 rmbd->num_removed++;
256 return 1;
257 }
258
259 static void com_rmblob_callback(struct osl_table *table, int fd,
260 const struct osl_object *query)
261 {
262 int ret, ret2 = 0;
263 struct rmblob_data rmbd = {
264 .num_removed = 0,
265 .pb = {
266 .max_size = SHMMAX,
267 .private_data = &fd,
268 .max_size_handler = pass_buffer_as_shm
269 }
270 };
271 struct pattern_match_data pmd = {
272 .table = table,
273 .patterns = *query,
274 .loop_col_num = BLOBCOL_NAME,
275 .match_col_num = BLOBCOL_NAME,
276 .pm_flags = PM_SKIP_EMPTY_NAME,
277 .data = &rmbd,
278 .action = remove_blob
279 };
280 ret = for_each_matching_row(&pmd);
281 if (ret < 0) {
282 ret2 = para_printf(&rmbd.pb, "%s\n", para_strerror(-ret));
283 if (ret2 < 0)
284 goto out;
285 }
286 if (!rmbd.num_removed)
287 ret2 = para_printf(&rmbd.pb, "no matches, nothing removed\n");
288 else {
289 ret2 = para_printf(&rmbd.pb, "removed %d blobs\n", rmbd.num_removed);
290 afs_event(BLOB_RENAME, NULL, table);
291 }
292 out:
293 if (ret2 >= 0 && rmbd.pb.offset)
294 pass_buffer_as_shm(rmbd.pb.buf, rmbd.pb.offset, &fd);
295 free(rmbd.pb.buf);
296 }
297
298 static int com_rmblob(callback_function *f, struct rc4_context *rc4c, int argc,
299 char * const * const argv)
300 {
301 if (argc < 2)
302 return -E_MOOD_SYNTAX;
303 return send_option_arg_callback_request(NULL, argc - 1, argv + 1, f,
304 rc4_send_result, rc4c);
305 }
306
307 static void com_addblob_callback(struct osl_table *table, __a_unused int fd,
308 const struct osl_object *query)
309 {
310 struct osl_object objs[NUM_BLOB_COLUMNS];
311 char *name = query->data;
312 size_t name_len = strlen(name) + 1;
313 uint32_t id;
314 unsigned num_rows;
315 int ret;
316
317 ret = osl(osl_get_num_rows(table, &num_rows));
318 if (ret < 0)
319 goto out;
320 if (!num_rows) { /* this is the first entry ever added */
321 /* insert dummy row containing the id */
322 id = 2; /* this entry will be entry #1, so 2 is the next */
323 objs[BLOBCOL_ID].data = &id;
324 objs[BLOBCOL_ID].size = sizeof(id);
325 objs[BLOBCOL_NAME].data = "";
326 objs[BLOBCOL_NAME].size = 1;
327 objs[BLOBCOL_DEF].data = "";
328 objs[BLOBCOL_DEF].size = 1;
329 ret = osl(osl_add_row(table, objs));
330 if (ret < 0)
331 goto out;
332 } else {
333 /* check if name already exists */
334 struct osl_row *row;
335 struct osl_object obj = {.data = name, .size = name_len};
336 ret = osl(osl_get_row(table, BLOBCOL_NAME, &obj, &row));
337 if (ret < 0 && ret != -OSL_ERRNO_TO_PARA_ERROR(E_OSL_RB_KEY_NOT_FOUND))
338 goto out;
339 if (ret >= 0) { /* we already have a blob with this name */
340 obj.data = name + name_len;
341 obj.size = query->size - name_len;
342 ret = osl(osl_update_object(table, row, BLOBCOL_DEF, &obj));
343 goto out;
344 }
345 /* new blob, get id of the dummy row and increment it */
346 obj.data = "";
347 obj.size = 1;
348 ret = osl(osl_get_row(table, BLOBCOL_NAME, &obj, &row));
349 if (ret < 0)
350 goto out;
351 ret = osl(osl_get_object(table, row, BLOBCOL_ID, &obj));
352 if (ret < 0)
353 goto out;
354 id = *(uint32_t *)obj.data + 1;
355 obj.data = &id;
356 ret = osl(osl_update_object(table, row, BLOBCOL_ID, &obj));
357 if (ret < 0)
358 goto out;
359 }
360 id--;
361 objs[BLOBCOL_ID].data = &id;
362 objs[BLOBCOL_ID].size = sizeof(id);
363 objs[BLOBCOL_NAME].data = name;
364 objs[BLOBCOL_NAME].size = name_len;
365 objs[BLOBCOL_DEF].data = name + name_len;
366 objs[BLOBCOL_DEF].size = query->size - name_len;
367 ret = osl(osl_add_row(table, objs));
368 if (ret < 0)
369 goto out;
370 afs_event(BLOB_ADD, NULL, table);
371 out:
372 if (ret < 0)
373 PARA_NOTICE_LOG("%s\n", para_strerror(-ret));
374 }
375
376 /*
377 * write input from fd to dynamically allocated buffer,
378 * but maximal max_size byte.
379 */
380 static int fd2buf(struct rc4_context *rc4c, unsigned max_size, struct osl_object *obj)
381 {
382 const size_t chunk_size = 1024;
383 size_t size = 2048, received = 0;
384 int ret;
385 char *buf = para_malloc(size);
386
387 for (;;) {
388 ret = rc4_recv_bin_buffer(rc4c, buf + received, chunk_size);
389 if (ret <= 0)
390 break;
391 received += ret;
392 if (received + chunk_size >= size) {
393 size *= 2;
394 ret = -E_INPUT_TOO_LARGE;
395 if (size > max_size)
396 break;
397 buf = para_realloc(buf, size);
398 }
399 }
400 obj->data = buf;
401 obj->size = received;
402 if (ret < 0)
403 free(buf);
404 return ret;
405 }
406
407 /*
408 * Read data from a file descriptor, and send it to the afs process.
409 *
410 * \param rc4c crypt context containing the file descriptor to read data from.
411 * \param arg_obj Pointer to the arguments to \a f.
412 * \param f The callback function.
413 * \param max_len Don't read more than that many bytes from stdin.
414 * \param result_handler See \ref send_callback_request.
415 * \param private_result_data See \ref send_callback_request.
416 *
417 * This function is used by commands that wish to let para_server store
418 * arbitrary data specified by the user (for instance the add_blob family of
419 * commands). First, at most \a max_len bytes are read and decrypted from the
420 * file descriptor given by \a rc4c. The result is concatenated with the buffer
421 * given by \a arg_obj, and the combined buffer is made available to the afs
422 * process via the callback method. See \ref send_callback_request for details.
423 *
424 * \return Negative on errors, the return value of the underlying call to
425 * send_callback_request() otherwise.
426 */
427 static int stdin_command(struct rc4_context *rc4c, struct osl_object *arg_obj,
428 callback_function *f, unsigned max_len,
429 callback_result_handler *result_handler,
430 void *private_result_data)
431 {
432 struct osl_object query, stdin_obj;
433 int ret;
434
435 ret = rc4_send_buffer(rc4c, AWAITING_DATA_MSG);
436 if (ret < 0)
437 return ret;
438 ret = fd2buf(rc4c, max_len, &stdin_obj);
439 if (ret < 0)
440 return ret;
441 query.size = arg_obj->size + stdin_obj.size;
442 query.data = para_malloc(query.size);
443 memcpy(query.data, arg_obj->data, arg_obj->size);
444 memcpy((char *)query.data + arg_obj->size, stdin_obj.data, stdin_obj.size);
445 free(stdin_obj.data);
446 ret = send_callback_request(f, &query, result_handler, private_result_data);
447 free(query.data);
448 return ret;
449 }
450
451 static int com_addblob(callback_function *f, struct rc4_context *rc4c, int argc,
452 char * const * const argv)
453 {
454 struct osl_object arg_obj;
455
456 if (argc != 2)
457 return -E_BLOB_SYNTAX;
458 if (!*argv[1]) /* empty name is reserved for the dummy row */
459 return -E_BLOB_SYNTAX;
460 arg_obj.size = strlen(argv[1]) + 1;
461 arg_obj.data = (char *)argv[1];
462 return stdin_command(rc4c, &arg_obj, f, 10 * 1024 * 1024, NULL, NULL);
463 }
464
465 /* FIXME: Print output to client, not to log file */
466 static void com_mvblob_callback(struct osl_table *table, __a_unused int fd,
467 const struct osl_object *query)
468 {
469 char *src = (char *) query->data;
470 struct osl_object obj = {.data = src, .size = strlen(src) + 1};
471 char *dest = src + obj.size;
472 struct osl_row *row;
473 int ret = osl(osl_get_row(table, BLOBCOL_NAME, &obj, &row));
474
475 if (ret < 0)
476 goto out;
477 obj.data = dest;
478 obj.size = strlen(dest) + 1;
479 ret = osl(osl_update_object(table, row, BLOBCOL_NAME, &obj));
480 if (ret < 0)
481 goto out;
482 afs_event(BLOB_RENAME, NULL, table);
483 out:
484 if (ret < 0)
485 PARA_NOTICE_LOG("%s\n", para_strerror(-ret));
486 }
487
488 static int com_mvblob(callback_function *f, __a_unused struct rc4_context *rc4c,
489 int argc, char * const * const argv)
490 {
491 if (argc != 3)
492 return -E_MOOD_SYNTAX;
493 return send_option_arg_callback_request(NULL, argc - 1, argv + 1, f,
494 NULL, NULL);
495 }
496
497 #define DEFINE_BLOB_COMMAND(cmd_name, table_name, cmd_prefix) \
498 static void com_ ## cmd_name ## cmd_prefix ## _callback(int fd, const struct osl_object *query) \
499 { \
500 return com_ ## cmd_name ## blob_callback(table_name ## _table, fd, query); \
501 } \
502 int com_ ## cmd_name ## cmd_prefix(struct rc4_context *rc4c, int argc, char * const * const argv) \
503 { \
504 return com_ ## cmd_name ## blob(com_ ## cmd_name ## cmd_prefix ## _callback, rc4c, argc, argv); \
505 }
506
507 static int blob_get_name_by_id(struct osl_table *table, uint32_t id,
508 char **name)
509 {
510 struct osl_row *row;
511 struct osl_object obj = {.data = &id, .size = sizeof(id)};
512 int ret;
513
514 *name = NULL;
515 if (!id)
516 return 1;
517 ret = osl(osl_get_row(table, BLOBCOL_ID, &obj, &row));
518 if (ret < 0)
519 return ret;
520 ret = osl(osl_get_object(table, row, BLOBCOL_NAME, &obj));
521 if (ret < 0)
522 return ret;
523 *name = (char *)obj.data;
524 return 1;
525 }
526
527 /** Define the \p get_name_by_id function for this blob type. */
528 #define DEFINE_GET_NAME_BY_ID(table_name, cmd_prefix) \
529 int cmd_prefix ## _get_name_by_id(uint32_t id, char **name) \
530 { \
531 return blob_get_name_by_id(table_name ## _table, id, name); \
532 }
533
534
535 static int blob_get_def_by_name(struct osl_table *table, char *name,
536 struct osl_object *def)
537 {
538 struct osl_row *row;
539 struct osl_object obj = {.data = name, .size = strlen(name) + 1};
540 int ret;
541
542 def->data = NULL;
543 if (!*name)
544 return 1;
545 ret = osl(osl_get_row(table, BLOBCOL_NAME, &obj, &row));
546 if (ret < 0)
547 return ret;
548 return osl(osl_open_disk_object(table, row, BLOBCOL_DEF, def));
549 }
550
551 /** Define the \p get_def_by_id function for this blob type. */
552 #define DEFINE_GET_DEF_BY_NAME(table_name, cmd_prefix) \
553 int cmd_prefix ## _get_def_by_name(char *name, struct osl_object *def) \
554 { \
555 return blob_get_def_by_name(table_name ## _table, name, def); \
556 }
557
558 static int blob_get_def_by_id(struct osl_table *table, uint32_t id,
559 struct osl_object *def)
560 {
561 struct osl_row *row;
562 struct osl_object obj = {.data = &id, .size = sizeof(id)};
563 int ret;
564
565 def->data = NULL;
566 if (!id)
567 return 1;
568 ret = osl(osl_get_row(table, BLOBCOL_ID, &obj, &row));
569 if (ret < 0)
570 return ret;
571 return osl(osl_open_disk_object(table, row, BLOBCOL_DEF, def));
572 }
573
574 /** Define the \p get_def_by_id function for this blob type. */
575 #define DEFINE_GET_DEF_BY_ID(table_name, cmd_prefix) \
576 int cmd_prefix ## _get_def_by_id(uint32_t id, struct osl_object *def) \
577 { \
578 return blob_get_def_by_id(table_name ## _table, id, def); \
579 }
580
581 static int blob_get_name_and_def_by_row(struct osl_table *table,
582 const struct osl_row *row, char **name, struct osl_object *def)
583 {
584 struct osl_object obj;
585 int ret = osl(osl_get_object(table, row, BLOBCOL_NAME, &obj));
586 if (ret < 0)
587 return ret;
588 *name = obj.data;
589 return osl(osl_open_disk_object(table, row, BLOBCOL_DEF, def));
590 }
591 /** Define the \p get_name_and_def_by_row function for this blob type. */
592 #define DEFINE_GET_NAME_AND_DEF_BY_ROW(table_name, cmd_prefix) \
593 int cmd_prefix ## _get_name_and_def_by_row(const struct osl_row *row, \
594 char **name, struct osl_object *def) \
595 { \
596 return blob_get_name_and_def_by_row(table_name ## _table, \
597 row, name, def); \
598 }
599
600 /** Define the \p close function for this blob type. */
601 #define DEFINE_BLOB_CLOSE(table_name) \
602 static void table_name ## _close(void) \
603 { \
604 osl_close_table(table_name ## _table, OSL_MARK_CLEAN); \
605 table_name ## _table = NULL; \
606 }
607
608 /** Define the \p create function for this blob type. */
609 #define DEFINE_BLOB_CREATE(table_name) \
610 static int table_name ## _create(const char *dir) \
611 { \
612 table_name ## _table_desc.dir = dir; \
613 return osl_create_table(&table_name ## _table_desc); \
614 }
615
616 static int blob_open(struct osl_table **table,
617 struct osl_table_description *desc,
618 const char *dir)
619 {
620 int ret;
621 desc->dir = dir;
622 ret = osl(osl_open_table(desc, table));
623 if (ret >= 0)
624 return ret;
625 *table = NULL;
626 if (ret >= 0 || ret == -OSL_ERRNO_TO_PARA_ERROR(E_OSL_NOENT))
627 return 1;
628 return ret;
629 }
630
631 #define DEFINE_BLOB_OPEN(table_name) \
632 static int table_name ## _open(const char *dir) \
633 { \
634 return blob_open(&table_name ## _table, \
635 &table_name ## _table_desc, dir); \
636 }
637
638
639 /** Define the \p init function for this blob type. */
640 #define DEFINE_BLOB_INIT(table_name) \
641 void table_name ## _init(struct afs_table *t) \
642 { \
643 t->open = table_name ## _open; \
644 t->close = table_name ## _close; \
645 t->create = table_name ## _create;\
646 t->event_handler = table_name ##_event_handler; \
647 table_name ## _table = NULL; \
648 }
649
650
651 /** Define all functions for this blob type. */
652 #define DEFINE_BLOB_FUNCTIONS(table_name, cmd_prefix) \
653 DEFINE_BLOB_OPEN(table_name) \
654 DEFINE_BLOB_CLOSE(table_name) \
655 DEFINE_BLOB_CREATE(table_name) \
656 DEFINE_BLOB_INIT(table_name) \
657 DEFINE_BLOB_COMMAND(ls, table_name, cmd_prefix) \
658 DEFINE_BLOB_COMMAND(cat, table_name, cmd_prefix) \
659 DEFINE_BLOB_COMMAND(add, table_name, cmd_prefix) \
660 DEFINE_BLOB_COMMAND(rm, table_name, cmd_prefix) \
661 DEFINE_BLOB_COMMAND(mv, table_name, cmd_prefix) \
662 DEFINE_GET_NAME_BY_ID(table_name, cmd_prefix); \
663 DEFINE_GET_DEF_BY_ID(table_name, cmd_prefix); \
664 DEFINE_GET_DEF_BY_NAME(table_name, cmd_prefix); \
665 DEFINE_GET_NAME_AND_DEF_BY_ROW(table_name, cmd_prefix); \
666
667 /** \cond doxygen isn't smart enough to recognize these */
668 DEFINE_BLOB_FUNCTIONS(lyrics, lyr);
669 DEFINE_BLOB_FUNCTIONS(images, img);
670 DEFINE_BLOB_FUNCTIONS(moods, mood);
671 DEFINE_BLOB_FUNCTIONS(playlists, pl);
672 /** \endcond */