about summary refs log tree commit diff
path: root/users/Profpatsch/lyric.nix
diff options
context:
space:
mode:
Diffstat (limited to 'users/Profpatsch/lyric.nix')
-rw-r--r--users/Profpatsch/lyric.nix54
1 files changed, 0 insertions, 54 deletions
diff --git a/users/Profpatsch/lyric.nix b/users/Profpatsch/lyric.nix
deleted file mode 100644
index b3914d195e1f..000000000000
--- a/users/Profpatsch/lyric.nix
+++ /dev/null
@@ -1,54 +0,0 @@
-# Display lyrics for the given search string;
-# search string can contain a substring of band name, album name, song title
-#
-# Use the database dump from https://lrclib.net/db-dumps and place it in ~/.cache/lyric/lrclib-db-dump.sqlite3
-
-{ depot, pkgs, lib, ... }:
-
-let
-  bins = depot.nix.getBins pkgs.sqlite-utils [ "sqlite-utils" ]
-    // depot.nix.getBins pkgs.jq [ "jq" ];
-
-in
-depot.nix.writeExecline "lyric" { readNArgs = 1; } [
-  "backtick"
-  "-E"
-  "cache"
-  [ depot.users.Profpatsch.xdg-cache-home ]
-  "pipeline"
-  [
-    bins.sqlite-utils
-    "query"
-    "\${cache}/lyric/lrclib-db-dump.sqlite3"
-    ''
-      select
-          synced_lyrics,
-          has_synced_lyrics,
-          plain_lyrics
-      from
-          tracks_fts(:searchstring) tf
-          join tracks t on t.rowid = tf.rowid
-          join lyrics l on t.rowid = l.track_id
-      order by
-          t.id
-      limit
-          1
-    ''
-    "--param"
-    "searchstring"
-    "$1"
-  ]
-  bins.jq
-  "-r"
-  ''
-    if .[0] == null
-    then ""
-    else
-      .[0]
-        | if .has_synced_lyrics == 1
-          then .synced_lyrics
-          else .plain_lyrics
-          end
-    end
-  ''
-]