From 483f6bb20f8b1316d89c7ac09dfba72b596ca75e Mon Sep 17 00:00:00 2001 From: APTX Date: Tue, 3 Jul 2012 02:48:05 +0200 Subject: [PATCH] Use wild card select for queries from which data is obtained by column name --- localmylist/renamehandler.cpp | 7 +------ management-gui/renamesettingsdialog.cpp | 7 +------ 2 files changed, 2 insertions(+), 12 deletions(-) diff --git a/localmylist/renamehandler.cpp b/localmylist/renamehandler.cpp index 0f917ae..808e434 100644 --- a/localmylist/renamehandler.cpp +++ b/localmylist/renamehandler.cpp @@ -33,12 +33,7 @@ void RenameHandler::handleRename() RaiiTransaction t(db); QSqlQuery q(db->connection()); - q.prepare("SELECT fid, eid, aid, gid, anime_anidb_update, anime_entry_update, anime_my_update, anime_title_english, anime_title_romaji, anime_title_kanji, " - " description, year, start_date, end_date, anime_type, anime_rating, anime_votes, temp_rating, temp_votes, anime_my_vote, anime_my_vote_date, my_temp_vote, my_temp_vote_date, " - "episode_anidb_update, episode_entry_update, episode_my_update, epno, episode_title_english, episode_title_romaji, episode_title_kanji, episode_length, airdate, state, special, recap, " - " opening, ending, rating, votes, my_vote, my_vote_date, " - "anidb_update, entry_update, my_update, ed2k, size, length, extension, group_name, group_name_short, crc, release_date, version, censored, type, quality_id, quality, resolution, " - " video_codec, audio_codec, audio_language, subtitle_language, aspect_ratio, my_watched, my_state, my_file_state, my_storage, my_source, my_other, host_id, path, renamed " + q.prepare("SELECT * " "FROM rename_data " "WHERE host_id = :host_id " "AND renamed IS NULL AND failed_rename = false " diff --git a/management-gui/renamesettingsdialog.cpp b/management-gui/renamesettingsdialog.cpp index 406fd82..91ac1ca 100644 --- a/management-gui/renamesettingsdialog.cpp +++ b/management-gui/renamesettingsdialog.cpp @@ -157,12 +157,7 @@ void RenameSettingsDialog::setupEnvForFile(int fid) QSqlQuery q(db->connection()); - q.prepare("SELECT fid, eid, aid, gid, anime_anidb_update, anime_entry_update, anime_my_update, anime_title_english, anime_title_romaji, anime_title_kanji, " - " description, year, start_date, end_date, anime_type, anime_rating, anime_votes, temp_rating, temp_votes, anime_my_vote, anime_my_vote_date, my_temp_vote, my_temp_vote_date, " - "episode_anidb_update, episode_entry_update, episode_my_update, epno, episode_title_english, episode_title_romaji, episode_title_kanji, episode_length, airdate, state, special, recap, " - " opening, ending, rating, votes, my_vote, my_vote_date, " - "anidb_update, entry_update, my_update, ed2k, size, length, extension, group_name, group_name_short, crc, release_date, version, censored, type, quality_id, quality, resolution, " - " video_codec, audio_codec, audio_language, subtitle_language, aspect_ratio, my_watched, my_state, my_file_state, my_storage, my_source, my_other, host_id, path, renamed " + q.prepare("SELECT * " "FROM rename_data " "WHERE fid = :fid "); -- 2.52.0