Forum OpenACS Development: Replacing SQL bind variables in Emacs

1: Replacing SQL bind variables in Emacs

Posted by Bart Teeuwisse on 06/04/03 03:35 AM

I've written an article explaining how one can customize Emacs so that OpenACS bind variables are being replaced with real values. Read it at http://www.thecodemill.biz/publications/articles/emacs-sql-vars/

With the customization in place you can enter query definitions with bind variables and all in an interactive SQL buffer and have Emacs ask you for values for the bind variables in the query. Pure magic!

Works almost perfect with MMM mode for XQL files as described in my article on the XQL DTD over at http://www.thecodemill.biz/publications/articles/xql-dtd/.

/Bart

2: Re: Replacing SQL bind variables in Emacs (response to 1)

Posted by Rocael Hernández Rizzardini on 06/04/03 04:17 PM

cool Bart,
what about oracle, something like this?
(defadvice sql-oracle (after sql-oracle)
"Use xql-query-bind-and-send for `comint-input-sender'."
(setq comint-input-sender 'xql-query-bind-and-send)
)

3: Re: Replacing SQL bind variables in Emacs (response to 2)

Posted by Bart Teeuwisse on 06/04/03 07:28 PM

Rocael,

to be honest, I'm not 100% sure if Oracle places the same quotes (') around the bound values as Postgres does. If it doesn't you'd have to modify xql-query-bind-and-send. Provided that both databases can use the same function, you'd have to add:

(defadvice sql-oracle (after sql-oracle)
  "Use xql-query-bind-and-send for `comint-input-sender'."
  (setq comint-input-sender 'xql-query-bind-and-send)
)
(ad-activate 'sql-oracle)

The ad-activate is important, it activates the defined advise. If you leave it out, nothing will happen.

/Bart

4: Re: Replacing SQL bind variables in Emacs (response to 1)

Posted by Randy O'Meara on 06/06/03 05:29 AM

Awwww. I was just taking the time to look at both of your articles regarding Emacs and XQL/SQL, but it looks like your site is having problems. I get the following, even at the root of your site:

"The requested URL was not found on this server."

Randy

5: Re: Replacing SQL bind variables in Emacs (response to 4)

Posted by Bart Teeuwisse on 06/06/03 07:07 AM

Randy,

sorry, had to turn the power off for some electricity upgrades. The server is back up.

/Bart

6: Re: Replacing SQL bind variables in Emacs (response to 1)

Posted by Randy O'Meara on 07/31/03 03:29 AM

Bart: I just wanted to say thanks for putting this information together and sharing it. This is slick and has simplified my life several times over the last couple months. If other folks haven't set this up, they should definitely give it a try!

Randy