From 5a85cb310272e232afaf73160d00650bf050d689 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Sun, 29 Sep 2024 19:24:47 -0500
Subject: [PATCH] Add help text to say downloads do not use server RAM

---
 src/pgwui_sql/static/sql_edit.js     | 8 ++++++++
 src/pgwui_sql/templates/sql_edit.mak | 2 +-
 2 files changed, 9 insertions(+), 1 deletion(-)

diff --git a/src/pgwui_sql/static/sql_edit.js b/src/pgwui_sql/static/sql_edit.js
index 9ecac76..d8828ca 100644
--- a/src/pgwui_sql/static/sql_edit.js
+++ b/src/pgwui_sql/static/sql_edit.js
@@ -80,6 +80,14 @@ function attachEvents() {
               + '  Data containing tab characters will introduce'
               + ' spurious/extra columns.'
             ));
+    document.getElementById('download_help_id')
+        .addEventListener("click", () =>
+            window.alert(
+              "Downloading does not put SQL results in the webserver's RAM,"
+              + " or your browser's RAM,"
+              + ' so downloading may be able to return larger data sets'
+              + ' than on-screen display.'
+              ));
 }
 
 attachEvents();
diff --git a/src/pgwui_sql/templates/sql_edit.mak b/src/pgwui_sql/templates/sql_edit.mak
index 7ce75d8..c509e09 100644
--- a/src/pgwui_sql/templates/sql_edit.mak
+++ b/src/pgwui_sql/templates/sql_edit.mak
@@ -191,7 +191,7 @@
       <tr>
         ## Download
         <%self.lib:td_label for_id="download_id">
-          Download
+          Download<span id="download_help_id" class="help">?</span>
         </%self.lib:td_label>
         <%self.lib:td_input tab_index="${tab_index}">
           <input name="download"
-- 
2.34.1