Database update

Closes #43 (closed) and can also delete multiple karas.

Closes #44 (closed)

inc/lektor/database.h

@@ -22,9 +22,11 @@ struct lkt_queue_state {
     int length;
 };
 
-long database_get_timestamp(volatile sqlite3 *db);
-void database_stamp        (volatile sqlite3 *db);
-void database_updated      (volatile sqlite3 *db);
+/* Update stuff */
+void database_get_update  (volatile sqlite3 *db, long *timestamp, long *job, int *current);
+void database_stamp       (volatile sqlite3 *db);
+void database_updated     (volatile sqlite3 *db);
+void database_deleted_kara(volatile sqlite3 *db, int **kara_id, size_t *len);
 
 /* Open correctly a database for lektor. */
 bool database_new   (volatile sqlite3 **db);
@@ -41,13 +43,13 @@ bool database_queue_set_paused       (volatile sqlite3 *db, bool paused);
 bool database_queue_set_current_index(volatile sqlite3 *db, int idx);
 bool database_queue_get_current_file (volatile sqlite3 *db, char filepath[PATH_MAX]);
 
-/* Mpv and database synchronisation. */
-bool database_sync_mpv_state(volatile sqlite3 *db, mpv_handle **mpv);
+bool database_get_kara_path(volatile sqlite3 *db, int id, char filepath[PATH_MAX]);
 
 /* Update the database. */
 bool database_update              (volatile sqlite3 *db, const char *kara_dir, int check_timestamp);
 bool database_update_add          (volatile sqlite3 *db, const char *kara_path, struct kara_metadata *mdt, uint64_t id, bool avail);
-bool database_update_set_available(volatile sqlite3 *db, uint64_t id);
+bool database_update_set_available(volatile sqlite3 *db, int id);
+void database_update_del          (volatile sqlite3 *db, int id);
 
 /* Control the content of the queue. */
 bool database_queue_add_uri(volatile sqlite3 *db, struct lkt_uri *uri, int priority);
@@ -114,6 +116,7 @@ bool database_search_iter(struct lkt_search *item);
 /* Next and prev operation on the queue. */
 bool database_queue_next(volatile sqlite3 *db, char filepath[PATH_MAX]);
 bool database_queue_prev(volatile sqlite3 *db, char filepath[PATH_MAX]);
+bool database_queue_skip_current(volatile sqlite3 *db, char filepath[PATH_MAX]);
 
 /* Set a value in the config table */
 bool database_config_set     (volatile sqlite3 *db, const char *section, const char *key, const char *value);