summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjakka <jakka@jakka.su>2025-10-12 17:18:03 +0300
committerjakka <jakka@jakka.su>2025-10-12 17:18:03 +0300
commit95fc8032870678a1f265e0378d5d06476d52edb9 (patch)
tree557cfe81596a94340529e326251e0636727a2771
parent38777728ba4e0814b84f156b72ba148ecb926a05 (diff)
removed unnecessary sql query
DEDUPE_DB was still used while path had UNIQUE constaint. removed query
-rw-r--r--src/db.rs3
1 files changed, 0 insertions, 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<Connection> {
@@ -77,7 +75,6 @@ pub(crate) fn check_file(conn: &Connection, filename: &Path) -> Result<bool> {
}
pub(crate) fn init_clean_files(conn: &Connection) -> Result<Vec<PathBuf>, rusqlite::Error> {
- conn.execute(DEDUPE_DB, ())?;
let mut stmt = conn.prepare(FETCH_FILES)?;
let mut rows = stmt.query(())?;
let mut files = Vec::new();