From 8671206d0c84ad4c676dfda2a31fcfa766e6c926 Mon Sep 17 00:00:00 2001 From: alexaustin007 Date: Sun, 9 Feb 2025 17:22:29 -0500 Subject: [PATCH 1/2] Reverse SQL history order to show latest queries first --- .../wbprivate/sqlide/db_sql_editor_history_be.cpp | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) diff --git a/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp b/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp index 50eece4de..bec126938 100644 --- a/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp +++ b/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp @@ -383,7 +383,14 @@ void DbSqlEditorHistory::DetailsModel::load(const std::string &storage_file_path xmlFree(xmlDoc); } - std::reverse(_data.begin(), _data.end()); + + size_t num_entries = _data.size() / 2; // Each entry has now 2 elements (timestamp + SQL) + for (size_t i = 0; i < num_entries / 2; ++i) { + size_t front = i * 2; + size_t back = (num_entries - 1 - i) * 2; + std::swap(_data[front], _data[back]); // Swap timestamp. + std::swap(_data[front + 1], _data[back + 1]); // Swap SQL query +} _data_frame_end = _row_count; @@ -472,12 +479,12 @@ void DbSqlEditorHistory::DetailsModel::add_entries(const std::list if (*rit != _last_timestamp.toString()) _last_timestamp = *rit; - _data.insert(_data.begin(), _last_timestamp); + _data.push_back(_last_timestamp); } else { if (*rit != _last_statement.toString()) _last_statement = *rit; - _data.insert(_data.begin(), _last_statement); + _data.push_back(_last_statement); } index++; } From 767b8693509f643d2acc994386f24e012c62cb91 Mon Sep 17 00:00:00 2001 From: Alex Austin Chettiar <75135556+alexaustin007@users.noreply.github.com> Date: Wed, 19 Feb 2025 08:43:21 -0500 Subject: [PATCH 2/2] Update db_sql_editor_history_be.cpp --- backend/wbprivate/sqlide/db_sql_editor_history_be.cpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp b/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp index bec126938..1040a89fa 100644 --- a/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp +++ b/backend/wbprivate/sqlide/db_sql_editor_history_be.cpp @@ -384,12 +384,12 @@ void DbSqlEditorHistory::DetailsModel::load(const std::string &storage_file_path } - size_t num_entries = _data.size() / 2; // Each entry has now 2 elements (timestamp + SQL) + size_t num_entries = _data.size() / 2; for (size_t i = 0; i < num_entries / 2; ++i) { size_t front = i * 2; size_t back = (num_entries - 1 - i) * 2; - std::swap(_data[front], _data[back]); // Swap timestamp. - std::swap(_data[front + 1], _data[back + 1]); // Swap SQL query + std::swap(_data[front], _data[back]); + std::swap(_data[front + 1], _data[back + 1]); } _data_frame_end = _row_count;