Tabs and ends of lines in sql mode

Tabs and ends of lines in sql mode

[Jiri Pejchal]

The function sql-send-paragraph in sql.el sends current paragraph to the
SQL process. However it sends the paragraph with leading tabs and ends
of lines. In database front-ends like mysql or psql tabs are bound to
completion and so the completion is printed. Moreover ends of lines
cause secondary prompts to be printed.


So if I send:

create table stock (
	id int4,
	avail int4,
	ordered int4,
	valid bool,
	description text
);

six secondary prompts and five times the completions (several lines) are
printed, that is very inconvenient.

Could sql mode not send the internal tabs and ends of lines?

Jiri Pejchal

Sending the previous example produces following output:

test=> test(>
ABORT        COMMIT       END          LISTEN       RELEASE      SHOW
ALTER        COPY         EXECUTE      LOAD         RESET        START
ANALYZE      CREATE       EXPLAIN      LOCK         REVOKE       TRUNCATE
BEGIN        DEALLOCATE   FETCH        MOVE         ROLLBACK     UNLISTEN
CLOSE        DECLARE      GRANT        NOTIFY       SAVEPOINT    UPDATE
CLUSTER      DELETE FROM  CHECKPOINT   PREPARE      SELECT       VACUUM
COMMENT      DROP         INSERT       REINDEX      SET
test(>
ABORT        COMMIT       END          LISTEN       RELEASE      SHOW
ALTER        COPY         EXECUTE      LOAD         RESET        START
ANALYZE      CREATE       EXPLAIN      LOCK         REVOKE       TRUNCATE
BEGIN        DEALLOCATE   FETCH        MOVE         ROLLBACK     UNLISTEN
CLOSE        DECLARE      GRANT        NOTIFY       SAVEPOINT    UPDATE
CLUSTER      DELETE FROM  CHECKPOINT   PREPARE      SELECT       VACUUM
COMMENT      DROP         INSERT       REINDEX      SET
test(>
ABORT        COMMIT       END          LISTEN       RELEASE      SHOW
ALTER        COPY         EXECUTE      LOAD         RESET        START
ANALYZE      CREATE       EXPLAIN      LOCK         REVOKE       TRUNCATE
BEGIN        DEALLOCATE   FETCH        MOVE         ROLLBACK     UNLISTEN
CLOSE        DECLARE      GRANT        NOTIFY       SAVEPOINT    UPDATE
CLUSTER      DELETE FROM  CHECKPOINT   PREPARE      SELECT       VACUUM
COMMENT      DROP         INSERT       REINDEX      SET
test(>
ABORT        COMMIT       END          LISTEN       RELEASE      SHOW
ALTER        COPY         EXECUTE      LOAD         RESET        START
ANALYZE      CREATE       EXPLAIN      LOCK         REVOKE       TRUNCATE
BEGIN        DEALLOCATE   FETCH        MOVE         ROLLBACK     UNLISTEN
CLOSE        DECLARE      GRANT        NOTIFY       SAVEPOINT    UPDATE
CLUSTER      DELETE FROM  CHECKPOINT   PREPARE      SELECT       VACUUM
COMMENT      DROP         INSERT       REINDEX      SET
test(>
ABORT        COMMIT       END          LISTEN       RELEASE      SHOW
ALTER        COPY         EXECUTE      LOAD         RESET        START
ANALYZE      CREATE       EXPLAIN      LOCK         REVOKE       TRUNCATE
BEGIN        DEALLOCATE   FETCH        MOVE         ROLLBACK     UNLISTEN
CLOSE        DECLARE      GRANT        NOTIFY       SAVEPOINT    UPDATE
CLUSTER      DELETE FROM  CHECKPOINT   PREPARE      SELECT       VACUUM
COMMENT      DROP         INSERT       REINDEX      SET
test(> CREATE TABLE
test=>

Tabs and ends of lines in sql mode

[jiri.pejchal]

I'm using the latest sql mode with emacs from cvs.

The function sql-send-parafraph sends current paragraph
to the SQL process. However it sends the paragraph with
tabs and ends of lines. In mysql or psql tabs are bound
to completion and so the completion is printed. Moreover
ends of lines cause secondary prompts to be printed.

So for:
create table stock (
	id int4,
	avail int4,
	ordered int4,
	valid bool,
	description text
);

six secondary prompts and five times the completions (several lines)
are printed, that is very inconvenient.

Is there a way for sql-send-paragraph to not sends the tabs and ends
of lines?

--
Jiri Pejchal

Re: Tabs and ends of lines in sql mode

[Thien-Thi Nguyen]

jiri.pejchal@gmail.com writes:

> Is there a way for sql-send-paragraph to not sends the tabs and ends
> of lines?

it has to send at least one newline (at the end of the paragraph).
you probably meant to say internal tabs and newlines.  the best
solution would be to disable the secondary prompting and
completion in the subproc, but here is a rewrite of
`sql-send-paragraph' as a workaround:

(defun sql-send-paragraph ()
  "Send the current paragraph to the SQL process."
  (interactive)
  (let ((raw (buffer-substring-no-properties
              (save-excursion
                (backward-paragraph)
                (point))
              (save-excursion
                (forward-paragraph)
                (point)))))
    ;; subdue secondary-prompting and completion over-helpfulness
    (while (string-match "\n\t*" raw)
      (setq raw (concat (substring raw 0 (match-beginning 0))
                        " "
                        (substring raw (match-end 0)))))
    (sql-send-string raw)))

i think this is ugly, however.  mulling over comint.el now...

thi

Re: Tabs and ends of lines in sql mode

[Tim X]

jiri.pejchal@gmail.com writes:

> I'm using the latest sql mode with emacs from cvs.
> 
> The function sql-send-parafraph sends current paragraph
> to the SQL process. However it sends the paragraph with
> tabs and ends of lines. In mysql or psql tabs are bound
> to completion and so the completion is printed. Moreover
> ends of lines cause secondary prompts to be printed.
> 
> So for:
> create table stock (
> 	id int4,
> 	avail int4,
> 	ordered int4,
> 	valid bool,
> 	description text
> );
> 
> six secondary prompts and five times the completions (several lines)
> are printed, that is very inconvenient.
> 
> Is there a way for sql-send-paragraph to not sends the tabs and ends
> of lines?
> 

There are some add-ons I've used int he past which can help with
this. However, I don't seem to have them anymore. I think originally,
I may have found them at the emacs wiki site http://www.emacswiki.org.

One way to prevent the tab problem would be to reconfigure emacs so
that it uses spaces rather than tabs when you insert a tab. From
memory, this is covered in the on-line FAQ.

Tim

P.S. I gather psql is postgres' procedural SQL language. What is it
like to work with compared to oracle plsql or that MS SQL Server one
(whats it called again?).

Just curious 



-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

Re: Tabs and ends of lines in sql mode

[Thien-Thi Nguyen]

Tim X <timx@spamto.devnul.com> writes:

> P.S. I gather psql is postgres' procedural SQL language.

psql is an interactive (shell) that can process SQL and
do other meta stuff (list tables, describe schemas, etc).

to veer this thread even more tangentially, there is a nifty (IMHO)
emacs front end to postgresql via guile called gxrepl in Guile-PG:

  http://www.glug.org/people/ttn/software/guile-pg/

a sample gxrepl session is at:

  http://www.glug.org/docbits/qcons-notes.txt

gxrepl is what i use to type less SQL (and more parens :-).

thi