Priority

Closes #31 (closed)

Fix the misbehaviour of inserts with different priorities in the queue. The aim is to suppress the use the the view queue_.

src/database/queue.c

@@ -207,45 +207,21 @@ error:
     return false;
 }
 
-bool
-database_queue_add_query(volatile sqlite3 *db, const char *query, int priority)
-{
-    bool status = queue_add_with_col_like_str(db, LKT_DATABASE_KARA_ALL, query, priority);
-    LOG_INFO("%s '%s' with prio %d", status ? "Successfull add query" : "Failed add query", query, priority);
-    return status;
-}
-
-bool
-database_queue_add_author(volatile sqlite3 *db, const char *author, int priority)
-{
-    bool status = queue_add_with_col_like_str(db, LKT_DATABASE_NAME_KAUTHOR, author, priority);
-    LOG_INFO("%s '%s'", status ? "Successfull add author" : "Failed add author", author);
-    return status;
-}
-
-bool
-database_queue_add_language(volatile sqlite3 *db, const char *language, int priority)
-{
-    bool status = queue_add_with_col_like_str(db, LKT_DATABASE_NAME_KLANG, language, priority);
-    LOG_INFO("%s '%s'", status ? "Successfull add language" : "Failed add language", language);
-    return status;
-}
-
-bool
-database_queue_add_category(volatile sqlite3 *db, const char *cat, int priority)
-{
-    bool status = queue_add_with_col_like_str(db, LKT_DATABASE_NAME_KCAT, cat, priority);
-    LOG_INFO("%s '%s'", status ? "Successfull add category" : "Failed add category", cat);
-    return status;
-}
-
-bool
-database_queue_add_type(volatile sqlite3 *db, const char *type, int priority)
-{
-    bool status = queue_add_with_col_like_str(db, LKT_DATABASE_NAME_KTYPE, type, priority);
-    LOG_INFO("%s '%s'", status ? "Successfull add type" : "Failed add type", type);
-    return status;
-}
+#define database_queue_add(suffix, column_name)                                             \
+    bool                                                                                    \
+    database_queue_add_ ## suffix (volatile sqlite3 *db, const char *query, int priority)   \
+    {                                                                                       \
+        bool status = queue_add_with_col_like_str(db, column_name, query, priority);        \
+        LOG_INFO("%s " #suffix " '%s' with priority of %d",                                 \
+                 status ? "Successfully added" : "Failed to add", query, priority);         \
+        return status;                                                                      \
+    }
+database_queue_add(query,    LKT_DATABASE_KARA_ALL)
+database_queue_add(author,   LKT_DATABASE_NAME_KAUTHOR)
+database_queue_add(language, LKT_DATABASE_NAME_KLANG)
+database_queue_add(category, LKT_DATABASE_NAME_KCAT)
+database_queue_add(type,     LKT_DATABASE_NAME_KTYPE)
+#undef database_queue_add
 
 bool
 database_queue_add_id(volatile sqlite3 *db, int id, int priority)