From 95fc8032870678a1f265e0378d5d06476d52edb9 Mon Sep 17 00:00:00 2001 From: jakka Date: Sun, 12 Oct 2025 17:18:03 +0300 Subject: removed unnecessary sql query DEDUPE_DB was still used while path had UNIQUE constaint. removed query --- src/db.rs | 3 --- 1 file changed, 3 deletions(-) diff --git a/src/db.rs b/src/db.rs index ba14c1a..e38808b 100644 --- a/src/db.rs +++ b/src/db.rs @@ -16,8 +16,6 @@ const TOENCODE_NUMBER: &str = "SELECT COUNT(*) from flacs WHERE toencode"; const CHECK_FILE: &str = "SELECT exists(SELECT 1 FROM flacs WHERE path = ?1)"; const FETCH_FILES: &str = "SELECT path FROM flacs"; const REMOVE_FILE: &str = "DELETE FROM flacs WHERE path = ?1"; -const DEDUPE_DB: &str = - "DELETE FROM flacs WHERE rowid NOT IN (SELECT MAX(rowid) FROM flacs GROUP BY path)"; const GET_MODTIME: &str = "SELECT modtime FROM flacs WHERE path = ?1"; pub(crate) fn init_connection(path: Option<&PathBuf>) -> Result { @@ -77,7 +75,6 @@ pub(crate) fn check_file(conn: &Connection, filename: &Path) -> Result { } pub(crate) fn init_clean_files(conn: &Connection) -> Result, rusqlite::Error> { - conn.execute(DEDUPE_DB, ())?; let mut stmt = conn.prepare(FETCH_FILES)?; let mut rows = stmt.query(())?; let mut files = Vec::new(); -- cgit v1.3.1