1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
;;; emacspeak-sql.el --- Speech enable sql-mode -*- lexical-binding: t; -*-
;;; $Id$
;;; $Author: tv.raman.tv $
;;; Description: Emacspeak extension to speech enable sql-mode
;;; Keywords: Emacspeak, database interaction
;;{{{ LCD Archive entry:
;;; LCD Archive Entry:
;;; emacspeak| T. V. Raman |raman@cs.cornell.edu
;;; A speech interface to Emacs |
;;; $Date: 2007-08-25 18:28:19 -0700 (Sat, 25 Aug 2007) $ |
;;; $Revision: 4532 $ |
;;; Location undetermined
;;;
;;}}}
;;{{{ Copyright:
;;;Copyright (C) 1995 -- 2018, T. V. Raman
;;; Copyright (c) 1994, 1995 by Digital Equipment Corporation.
;;; All Rights Reserved.
;;;
;;; This file is not part of GNU Emacs, but the same permissions apply.
;;;
;;; GNU Emacs is free software; you can redistribute it and/or modify
;;; it under the terms of the GNU General Public License as published by
;;; the Free Software Foundation; either version 2, or (at your option)
;;; any later version.
;;;
;;; GNU Emacs is distributed in the hope that it will be useful,
;;; but WITHOUT ANY WARRANTY; without even the implied warranty of
;;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
;;; GNU General Public License for more details.
;;;
;;; You should have received a copy of the GNU General Public License
;;; along with GNU Emacs; see the file COPYING. If not, write to
;;; the Free Software Foundation, 675 Mass Ave, Cambridge, MA 02139, USA.
;;}}}
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;{{{ required modules
(cl-declaim (optimize (safety 0) (speed 3)))
(require 'emacspeak-preamble)
;;}}}
;;{{{ Introduction:
;;; Commentary:
;;; This module speech enables sql-mode--
;;; available from
;;; http://paddington.ic.uva.nl/public/sql-modes.zip
;;; sql-mode.el implemented by the above package
;;;sets up an Emacs to SQL interface where you can
;;;interactively evaluate SQL expressions.
;;; Code:
;;}}}
;;{{{ advice
(defadvice sqlplus-execute-command (after emacspeak pre act comp)
"Provide auditory feedback and place point at the start of the output."
(when (ems-interactive-p)
(emacspeak-auditory-icon 'scroll)
(sqlplus-back-command 2)
(forward-line 1)
(emacspeak-speak-line)))
(defadvice sqlplus-back-command (after emacspeak pre act
comp)"Move prompt appropriately, and speak the line."
(when (ems-interactive-p)
(emacspeak-auditory-icon 'large-movement)
(forward-line 1)
(emacspeak-speak-line)))
(defadvice sqlplus-forward-command (after emacspeak pre act
comp)
"Move prompt appropriately, and speak the line."
(when (ems-interactive-p)
(emacspeak-auditory-icon 'large-movement)
(forward-line 1)
(emacspeak-speak-line)))
(defadvice sqlplus-next-command (after emacspeak pre act comp)
"Speak the line."
(when (ems-interactive-p)
(emacspeak-auditory-icon 'select-object)
(emacspeak-speak-line)))
(defadvice sqlplus-previous-command (after emacspeak pre act comp)
"Speak the line."
(when (ems-interactive-p)
(emacspeak-auditory-icon 'select-object)
(emacspeak-speak-line)))
(defadvice sql-send-region (around emacspeak pre act comp)
"Provide auditory feedback."
(cond
((ems-interactive-p)
(emacspeak-auditory-icon 'select-object)
ad-do-it
(emacspeak-auditory-icon 'mark-object))
(t ad-do-it))
ad-return-value)
(defadvice sql-send-buffer (around emacspeak pre act comp)
"Provide auditory feedback."
(cond
((ems-interactive-p)
(emacspeak-auditory-icon 'select-object)
ad-do-it
(emacspeak-auditory-icon 'mark-object))
(t ad-do-it))
ad-return-value)
;;}}}
(provide 'emacspeak-sql)
;;{{{ end of file
;;; local variables:
;;; folded-file: t
;;; byte-compile-dynamic: t
;;; end:
;;}}}
|
