diff options
| author | Glenn Morris | 2012-02-07 23:54:09 -0800 |
|---|---|---|
| committer | Glenn Morris | 2012-02-07 23:54:09 -0800 |
| commit | 34e8a2da58131aa0e30f2b7427829b41d2997f10 (patch) | |
| tree | 3364592f7d78c633bd558444ffce2ae0d9f6133b /etc | |
| parent | 14a1f3806c3d189d0dd10db863320fa36d428fd1 (diff) | |
| download | emacs-34e8a2da58131aa0e30f2b7427829b41d2997f10.tar.gz emacs-34e8a2da58131aa0e30f2b7427829b41d2997f10.zip | |
Shorten SQL mode NEWS entry, moving more details to doc strings
* lisp/progmodes/sql.el (sql-port, sql-connection-alist, sql-list-all)
(sql-list-table): Doc fixes.
* etc/NEWS: Related edits.
Diffstat (limited to 'etc')
| -rw-r--r-- | etc/NEWS | 57 |
1 files changed, 22 insertions, 35 deletions
| @@ -781,63 +781,50 @@ directory is a remote file name and neither the environment variable | |||
| 781 | $ESHELL nor the variable `explicit-shell-file-name' is set. | 781 | $ESHELL nor the variable `explicit-shell-file-name' is set. |
| 782 | 782 | ||
| 783 | --- | 783 | --- |
| 784 | ** SQL Mode enhancements. | 784 | ** SQL mode |
| 785 | 785 | ||
| 786 | *** `sql-dialect' is an alias for `sql-product'. | 786 | --- |
| 787 | *** New options `sql-port', `sql-connection-alist', `sql-send-terminator', | ||
| 788 | and `sql-oracle-scan-on'. | ||
| 787 | 789 | ||
| 788 | *** New variable `sql-port' specifies the port number for connecting | 790 | --- |
| 789 | to a MySQL or Postgres server. | 791 | *** New custom variables control prompting for login parameters. |
| 792 | Each supported product has a custom variable `sql-*-login-params', | ||
| 793 | which is a list of the parameters to be prompted for before a | ||
| 794 | connection is established. | ||
| 790 | 795 | ||
| 796 | --- | ||
| 791 | *** The command `sql-product-interactive' now takes a prefix argument, | 797 | *** The command `sql-product-interactive' now takes a prefix argument, |
| 792 | which causes it to prompt for an SQL product instead of the current | 798 | which causes it to prompt for an SQL product. |
| 793 | value of `sql-product'. | ||
| 794 | 799 | ||
| 795 | *** Product-specific SQL interactive commands now take prefix args. | 800 | --- |
| 801 | *** Product-specific SQL interactive commands now take prefix arguments. | ||
| 796 | These commands (`sql-sqlite', `sql-postgres', `sql-mysql', etc.), | 802 | These commands (`sql-sqlite', `sql-postgres', `sql-mysql', etc.), |
| 797 | given a prefix argument, prompt for a name for the SQL interactive | 803 | given a prefix argument, prompt for a name for the SQL interactive |
| 798 | buffer. This reduces the need for calling `sql-rename-buffer'. | 804 | buffer. This reduces the need for calling `sql-rename-buffer'. |
| 799 | 805 | ||
| 806 | --- | ||
| 800 | *** SQL interactive modes suppress command continuation prompts, and | 807 | *** SQL interactive modes suppress command continuation prompts, and |
| 801 | replace tabs with spaces. The first change impacts multiple line SQL | 808 | replace tabs with spaces. The first change impacts multiple line SQL |
| 802 | statements entered with C-j between each line, statements yanked into | 809 | statements entered with C-j between each line, statements yanked into |
| 803 | the buffer and statements sent with `sql-send-*' functions. The | 810 | the buffer and statements sent with `sql-send-*' functions. The |
| 804 | second change prevents the MySQL and Postgres interpreters from | 811 | second prevents the MySQL and Postgres interpreters from listing |
| 805 | listing object name completions when sent text via `sql-send-*' | 812 | object name completions when sent text via `sql-send-*' functions. |
| 806 | functions. | ||
| 807 | |||
| 808 | *** New custom variables control prompting for login parameters. | ||
| 809 | Each supported product has a custom variable `sql-*-login-params', | ||
| 810 | which is a list of the parameters to be prompted for before a | ||
| 811 | connection is established. | ||
| 812 | |||
| 813 | *** New variable `sql-connection-alist' for login parameter values. | ||
| 814 | This can be used to store different username, database and server | ||
| 815 | values. Connections defined in this variable appear in the submenu | ||
| 816 | SQL->Start... for making new SQLi sessions. | ||
| 817 | 813 | ||
| 814 | --- | ||
| 818 | *** New command `sql-connect' starts a predefined SQLi session, | 815 | *** New command `sql-connect' starts a predefined SQLi session, |
| 819 | using the login parameters from `sql-connection-alist'. | 816 | using the login parameters from `sql-connection-alist'. |
| 820 | 817 | ||
| 818 | --- | ||
| 821 | *** New "Save Connection" menu item in SQLi buffers. | 819 | *** New "Save Connection" menu item in SQLi buffers. |
| 822 | This gathers the login params specified for the SQLi session, if it | 820 | This gathers the login params specified for the SQLi session, if it |
| 823 | was not started by a connection, and saves them as a new connection. | 821 | was not started by a connection, and saves them as a new connection. |
| 824 | 822 | ||
| 825 | *** Commands for listing database objects and details. | 823 | --- |
| 826 | In an SQLi session, you can get a list of objects in the database. | 824 | *** New commands for listing database objects and details: |
| 827 | The contents of these lists are product specific. | 825 | sql-list-all and sql-list-table. |
| 828 | |||
| 829 | **** `C-c C-l a' or the "SQL->List all objects" menu item | ||
| 830 | lists all the objects in the database. With a prefix argument, it | ||
| 831 | displays additional details or extend the listing to include other | ||
| 832 | schemas objects. | ||
| 833 | |||
| 834 | **** `C-c C-l t' or the "SQL->List Table details" menu item | ||
| 835 | prompts for the name of a database table or view and displays the list | ||
| 836 | of columns in the relation. With a prefix argument, it displays | ||
| 837 | additional details about each column. | ||
| 838 | |||
| 839 | *** New options `sql-send-terminator' and `sql-oracle-scan-on'. | ||
| 840 | 826 | ||
| 827 | --- | ||
| 841 | *** An API for manipulating SQL product definitions has been added. | 828 | *** An API for manipulating SQL product definitions has been added. |
| 842 | 829 | ||
| 843 | ** TeX modes | 830 | ** TeX modes |