From 3bd2cfef67d5eaf65a50ccc54a1f70a5328cc8d1 Mon Sep 17 00:00:00 2001 From: Michael Mauger Date: Tue, 10 Aug 2010 19:04:32 -0400 Subject: Suppress continuation prompts in SQL interactive mode * progmodes/sql.el: Version 2.5 (sql-product-alist): Add :prompt-cont-regexp property for several database products. (sql-prompt-cont-regexp): New variable. (sql-output-newline-count, sql-output-by-send): New variables. Record number of newlines in input text. (sql-send-string): Handle multiple filters and count newlines. (sql-send-magic-terminator): Count terminator newline. (sql-interactive-remove-continuation-prompt): Filters output to remove continuation prompts; one for each newline. (sql-interactive-mode): Set up new variables, prompt regexp and output filter. (sql-mode-sqlite-font-lock-keywords): Correct some keywords. (sql-make-alternate-buffer-name): Correct buffer name in edge cases. --- etc/NEWS | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'etc') diff --git a/etc/NEWS b/etc/NEWS index bec5b3b3468..9837e6c95b8 100644 --- a/etc/NEWS +++ b/etc/NEWS @@ -283,6 +283,14 @@ variables `sql-product', `sql-user', `sql-server', `sql-database' and The custom variable `sql-port' can be specified for connection to MySQL servers. +*** Command continuation prompts in SQL interactive mode are suppressed. +Multiple line commands in SQL interactive mode, generate command +continuation prompts which needlessly confuse the output. These +prompts are now filtered out from the output. This change impacts +multiple line SQL statements entered with C-j between each line, +statements yanked into the buffer and statements sent with +`sql-send-*' functions. + *** Custom variables control prompting for login parameters. Each supported product has a custom variable `sql-*-login-params' which is a list of the parameters to be prompted for before a @@ -302,7 +310,8 @@ names (without the directory portion). Generally these strings will be of the form ".+\.SUF" where SUF is the desired file suffix. When :completion is specified, the ARG corresponds to the PREDICATE -argument to the `completing-read' function. +argument to the `completing-read' function (a list of possible values +or a function returning such a list). *** Added `sql-connection-alist' to record login parameter values. An alist for recording different username, database and server -- cgit v1.2.1