From 4bbbea2fbe2d878036cb12bf5c38e464df2acd82 Mon Sep 17 00:00:00 2001
From: Jakub Vrana <jakub@vrana.cz>
Date: Tue, 25 Mar 2025 06:49:34 +0100
Subject: [PATCH] AdminerSqlGemini: Wrap returned text to comment

---
 plugins/sql-gemini.php | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/plugins/sql-gemini.php b/plugins/sql-gemini.php
index 48e8af93..37817a50 100644
--- a/plugins/sql-gemini.php
+++ b/plugins/sql-gemini.php
@@ -38,7 +38,14 @@ class AdminerSqlGemini {
 			)));
 			$response = json_decode(file_get_contents("https://generativelanguage.googleapis.com/v1beta/models/$this->model:generateContent?key=$this->apiKey", false, $context));
 			$text = $response->candidates[0]->content->parts[0]->text;
-			echo preg_replace('~```sql\n(.*\n)```~sU', '\1', $text) . "\n";
+			$in_code = false;
+			foreach (preg_split('~(^|\n)```(sql)?(\n|$)~', $text) as $part) {
+				$part = trim($part);
+				if ($part) {
+					echo ($in_code ? $part : "/*\n$part\n*/") . "\n\n";
+				}
+				$in_code = !$in_code;
+			}
 			exit;
 		}
 	}
-- 
2.39.5