Mercurial > emacs
annotate lisp/soundex.el @ 52242:f5ada28bb9f0
Patch by Michael Mauger <mmaug@yahoo.com>
Version 1.8.0 of sql-mode.
Simplify selection of SQL products to define highlighting and
interactive mode. Includes detailed instructions on adding
support for new products.
* sql.el (sql-product): New variable. Identifies SQL product for
use in highlighting and interactive mode.
(sql-interactive-product): New variable. SQL product for
sql-interactive-mode.
(sql-product-support): New variable. Specifies product-specific
parameters to drive highlighting and interactive mode.
(sql-imenu-generic-expression): Add more object types.
(sql-sqlite-options): Correct comment.
(sql-ms-program): Use "osql" rather than "isql".
(sql-prompt-regexp, sql-prompt-length): Update comment.
(sql-mode-menu): Add "Start SQLi session" entry. Replace
Highlighting submenu with Product menu. Fix Send Region entry.
(sql-mode-abbrev-table): Add abbreviations. Support of
SYSTEM-FLAG on define-abbrev. Support was removed with last
check-in; it now handles older Emacsen without the SYSTEM-FLAG.
(sql-mode-font-lock-object-name): Add font-lock pattern for object
names.
(sql-mode-ansi-font-lock-keywords): Set as default value.
(sql-mode-oracle-font-lock-keywords): Set as default value.
Support Oracle 9i keywords.
(sql-mode-postgres-font-lock-keywords): Set as default value.
(sql-mode-linter-font-lock-keywords): Set as default value.
(sql-mode-ms-font-lock-keywords): New variable. Support Microsoft
SQLServer 2000.
(sql-mode-sybase-font-lock-keywords)
(sql-mode-interbase-font-lock-keywords)
(sql-mode-sqlite-font-lock-keywords)
(sql-mode-strong-font-lock-keywords)
(sql-mode-mysql-font-lock-keywords)
(sql-mode-db2-font-lock-keywords): New variables. Default to ANSI
keywords.
(sql-mode-font-lock-defaults): Update comment.
(sql-product-feature): New function. Returns feature associated
with a product from `sql-product-support' alist.
(sql-product-font-lock): New function. Set font-lock support
based on `sql-product'.
(sql-add-product-keywords): New function. Add font-lock rules to
product-specific keyword variables.
(sql-set-product): New function. Set `sql-product' and apply
appropriate font-lock highlighting.
(sql-highlight-product): New function. Set font-lock support
based on a product. Also set mode name to include product name.
(sql-highlight-ansi-keywords, sql-highlight-oracle-keywords)
(sql-highlight-postgres-keywords, sql-highlight-linter-keywords):
Use `sql-set-product'.
(sql-highlight-ms-keywords)
(sql-highlight-sybase-keywords)
(sql-highlight-interbase-keywords)
(sql-highlight-strong-keywords)
(sql-highlight-mysql-keywords)
(sql-highlight-sqlite-keywords)
(sql-highlight-db2-keywords): New functions. Use
`sql-set-product'.
(sql-get-login): Prompt in the same order as the tokens.
(sql-mode): Uses `sql-product-highlight' and
`sql-product-font-lock'.
(sql-product-interactive): New function. Common portions of
product-specific interactive mode wrappers.
(sql-interactive-mode): Rewritten to use product features.
(sql-oracle, sql-sybase, sql-informix, sql-sqlite, sql-mysql)
(sql-solid, sql-ingres, sql-ms, sql-postgres, sql-interbase)
(sql-db2, sql-linter): Use `sql-product-interactive'.
(sql-connect-oracle, sql-connect-sybase, sql-connect-informix)
(sql-connect-sqlite, sql-connect-mysql, sql-connect-solid)
(sql-connect-ingres, sql-connect-postgres)
(sql-connect-interbase, sql-connect-db2, sql-connect-linter): New
functions. Format command line parameters and invoke comint on
the appropriate interpreter. Code was in the corresponding
`sql-xyz' function before.
(sql-connect-ms): New function. Support -E argument to use
operating system credentials for authentication.
author | Alex Schroeder <alex@gnu.org> |
---|---|
date | Mon, 18 Aug 2003 17:29:23 +0000 |
parents | e88404e8f2cf |
children | 695cf19ef79e d7ddb3e565de |
rev | line source |
---|---|
15261 | 1 ;;; soundex.el --- implement Soundex algorithm |
5995 | 2 |
3 ;; Copyright (C) 1993 Free Software Foundation, Inc. | |
4 | |
5 ;; Author: Christian Plaunt <chris@bliss.berkeley.edu> | |
49597
e88404e8f2cf
Trailing whitespace deleted.
Juanma Barranquero <lekktu@gmail.com>
parents:
38412
diff
changeset
|
6 ;; Maintainer: FSF |
5995 | 7 ;; Keywords: matching |
8 ;; Created: Sat May 15 14:48:18 1993 | |
9 | |
10 ;; This file is part of GNU Emacs. | |
11 | |
12 ;; GNU Emacs is free software; you can redistribute it and/or modify | |
13 ;; it under the terms of the GNU General Public License as published by | |
14 ;; the Free Software Foundation; either version 2, or (at your option) | |
15 ;; any later version. | |
16 | |
17 ;; GNU Emacs is distributed in the hope that it will be useful, | |
18 ;; but WITHOUT ANY WARRANTY; without even the implied warranty of | |
19 ;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
20 ;; GNU General Public License for more details. | |
21 | |
22 ;; You should have received a copy of the GNU General Public License | |
14169 | 23 ;; along with GNU Emacs; see the file COPYING. If not, write to the |
24 ;; Free Software Foundation, Inc., 59 Temple Place - Suite 330, | |
25 ;; Boston, MA 02111-1307, USA. | |
5995 | 26 |
27 ;;; Commentary: | |
28 | |
29 ;; The Soundex algorithm maps English words into representations of | |
30 ;; how they sound. Words with vaguely similar sound map to the same string. | |
31 | |
38412
253f761ad37b
Some fixes to follow coding conventions in files maintained by FSF.
Pavel Janík <Pavel@Janik.cz>
parents:
18383
diff
changeset
|
32 ;;; Code: |
5995 | 33 |
7534
9b82dae27c01
(soundex-alist): Put variable before fn that uses it.
Richard M. Stallman <rms@gnu.org>
parents:
5995
diff
changeset
|
34 (defvar soundex-alist |
8028
ba1bbdb8595e
(soundex-alist): Delete the elements that mapped into nil.
Richard M. Stallman <rms@gnu.org>
parents:
7534
diff
changeset
|
35 '((?B . "1") (?F . "1") (?P . "1") (?V . "1") |
7534
9b82dae27c01
(soundex-alist): Put variable before fn that uses it.
Richard M. Stallman <rms@gnu.org>
parents:
5995
diff
changeset
|
36 (?C . "2") (?G . "2") (?J . "2") (?K . "2") (?Q . "2") (?S . "2") |
9b82dae27c01
(soundex-alist): Put variable before fn that uses it.
Richard M. Stallman <rms@gnu.org>
parents:
5995
diff
changeset
|
37 (?X . "2") (?Z . "2") (?D . "3") (?T . "3") (?L . "4") (?M . "5") |
9b82dae27c01
(soundex-alist): Put variable before fn that uses it.
Richard M. Stallman <rms@gnu.org>
parents:
5995
diff
changeset
|
38 (?N . "5") (?R . "6")) |
9b82dae27c01
(soundex-alist): Put variable before fn that uses it.
Richard M. Stallman <rms@gnu.org>
parents:
5995
diff
changeset
|
39 "Alist of chars-to-key-code for building Soundex keys.") |
9b82dae27c01
(soundex-alist): Put variable before fn that uses it.
Richard M. Stallman <rms@gnu.org>
parents:
5995
diff
changeset
|
40 |
5995 | 41 (defun soundex (word) |
42 "Return a Soundex key for WORD. | |
43 Implemented as described in: | |
44 Knuth, Donald E. \"The Art of Computer Programming, Vol. 3: Sorting | |
45 and Searching\", Addison-Wesley (1973), pp. 391-392." | |
46 (let* ((word (upcase word)) (length (length word)) | |
47 (code (cdr (assq (aref word 0) soundex-alist))) | |
48 (key (substring word 0 1)) (index 1) (prev-code code)) | |
8028
ba1bbdb8595e
(soundex-alist): Delete the elements that mapped into nil.
Richard M. Stallman <rms@gnu.org>
parents:
7534
diff
changeset
|
49 ;; once we have a four char key, we're done |
5995 | 50 (while (and (> 4 (length key)) (< index length)) |
51 ;; look up the code for each letter in word at index | |
52 (setq code (cdr (assq (aref word index) soundex-alist)) | |
53 index (1+ index) | |
54 ;; append code to key unless the same codes belong to | |
55 ;; adjacent letters in the original string | |
56 key (concat key (if (or (null code) (string= code prev-code)) | |
57 () | |
58 code)) | |
59 prev-code code)) | |
60 ;; return a key that is 4 chars long and padded by "0"s if needed | |
61 (if (> 4 (length key)) | |
62 (substring (concat key "000") 0 4) | |
63 key))) | |
64 | |
65 ;(defvar soundex-test | |
66 ; '("Euler" "Gauss" "Hilbert" "Knuth" "Lloyd" "Lukasiewicz" | |
67 ; "Ellery" "Ghosh" "Heilbronn" "Kant" "Ladd" "Lissajous") | |
68 ; "\n Knuth's names to demonstrate the Soundex algorithm.") | |
69 ; | |
70 ;(mapcar 'soundex soundex-test) | |
71 ;("E460" "G200" "H416" "K530" "L300" "L222" | |
72 ; "E460" "G200" "H416" "K530" "L300" "L222") | |
73 | |
18383 | 74 (provide 'soundex) |
75 | |
38412
253f761ad37b
Some fixes to follow coding conventions in files maintained by FSF.
Pavel Janík <Pavel@Janik.cz>
parents:
18383
diff
changeset
|
76 ;;; soundex.el ends here |