-
Notifications
You must be signed in to change notification settings - Fork 0
/
SQLUtilities.stats
258 lines (194 loc) · 10.7 KB
/
SQLUtilities.stats
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
commit SHA1SHA1SHA1 (HEAD, tag: refs/tags/4.00)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Sun Aug 15 00:00:00 2010 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 4.00
NF: Added a tutorial to take users through the common features of the plugin.
NF: Added an option, g:sqlutil_align_keyword_right, to left or right (default) align the keywords (Per Winkvist).
NF: Documented and added new global variables (g:sqlutil_menu_root, g:sqlutil_menu_priority) to customize the location of the SQLUtil menu.
BF: SQLite used slightly different syntax specifying UNIQUE values and would not correctly generate a column list from the CREATE TABLE statement (Oliver Peters).
BF: Ensured all normal commands used ! to ensure no mappings interfered with the commands (Benoit Mortgat).
autoload/SQLUtilities.vim | 111
doc/SQLUtilities.txt | 258
plugin/SQLUtilities.vim | 74
3 files changed, 318 insertions(+), 125 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/3.00)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Thu Jan 15 00:00:00 2009 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 3.00
NF: Added new menu links so that commonly used options can be quickly and easily toggled without having to remember the global variable names or values. For example, if you cut the menu so that it floats beside your buffer you can easily hit "Toggle Align Where" or "Uppercase Keywords".
NF: Using the menu_mode option you can control if and where the SQLUtil menu is created. See the menu_mode option for more details.
NF: Added the default maps to the menus. If you use a floating menu, or simply view the menu you can more easily memorize your most commonly used maps.
BF: UPPER and lower case of keywords did not work for multi-word keywords (ORDER BY, LEFT OUTER JOIN, ...).
autoload/SQLUtilities.vim | 41
doc/SQLUtilities.txt | 38
plugin/SQLUtilities.vim | 125
3 files changed, 163 insertions(+), 41 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/2.0.0)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Sun Sep 9 00:00:00 2007 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 2.0.0: NF: Added support for Vim 7's autoload functionality
autoload/SQLUtilities.vim | 1989
doc/SQLUtilities.txt | 1361
plugin/SQLUtilities.vim | 1946
3 files changed, 2693 insertions(+), 2603 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.4.1)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Fri Oct 7 00:00:00 2005 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.4.1
NF: Added additional statements to g:sqlutil_col_list_terminators
BF: Forgot to increment g:loaded_sqlutilities
doc/SQLUtilities.txt | 11
plugin/SQLUtilities.vim | 112
2 files changed, 109 insertions(+), 14 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.4.0)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Mon Mar 14 00:00:00 2005 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.4.0
BF: If a statement has parenthesis inside of strings, the formatter was not ignoring them. This could result in the formatter reporting there were mismatched parenthesis.
Example: select 'string' + '(' from dummy
BF: If a keyword was not followed by a space, it was not placed on a newline.
Example: SELECT * FROM(T1)
BF: Nested function calls could potentially lead to an endless loop.
doc/SQLUtilities.txt | 19
plugin/SQLUtilities.vim | 173
2 files changed, 120 insertions(+), 72 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3.9)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Thu Feb 10 00:00:00 2005 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3.9
BF: When g:sqlutil_align_comma=1 and a select list spanned more than 1 line (via functions calls and so on), it was possible the remaining comma separated list was not aligned properly.
doc/SQLUtilities.txt | 8
plugin/SQLUtilities.vim | 115
2 files changed, 48 insertions(+), 75 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3.8)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Fri Dec 3 00:00:00 2004 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3.8
NF: Enhanced the feature to change the case of keywords, to include the optional join words, left, right, full, inner, outer. These words were missed prior to this change and only the JOIN word was capitalized.
CH: Changed the default for sqlutil_use_tbl_alias = 'a' (ask) from being on at all times. This can be overridden in your vimrc.
doc/SQLUtilities.txt | 12
plugin/SQLUtilities.vim | 183
2 files changed, 156 insertions(+), 39 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3.7)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Wed Jul 21 00:00:00 2004 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3.7
NF: Added new option g:sqlutil_use_tbl_alias, which is on by default.
When creating a column list for a table, it will add a table
alias to each column. The table alias is calculated based on
rules. This feature has 3 settings:
n - no alias
d - default calculated alias
a - ask the user using default alias
NF: Updated g:sqlutil_col_list_terminators to handle some additional
cases.
BF: In some cases -@- could be left in the query. This seems to be
a bug in Vim, where the marks could move. Unsure why, but put
a workaround in.
BF: When g:sqlutil_align_comma=1, and the lines did not begin with
commas, the formatting was incorrect.
BF: When searching through buffers (SQLU_CreateColumnList), the
alternate buffer could be changed.
doc/SQLUtilities.txt | 68
plugin/SQLUtilities.vim | 142
2 files changed, 171 insertions(+), 39 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3.6)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Mon Jun 21 00:00:00 2004 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3.6
NF: Added support for window functions (OVER, PARTITION BY, ROWS, RANGE), and additional Oracle SELECT keywords (DIMENSION, MEASURES, ITERATE, WITHIN GROUP, IGNORE, KEEP, RETURN, RULES)
doc/SQLUtilities.txt | 5
plugin/SQLUtilities.vim | 43
2 files changed, 36 insertions(+), 12 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3.5)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Sun Mar 7 00:00:00 2004 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3.5
New features added:
New global variables to customization some aspects of the formatting:
sqlutil_align_where - aligns the =, >=, <=, ...
sqlutil_align_comma - places the column lists in select statement on new lines
sqlutil_align_first_word - see examples
You can change the case of the keywords while formatting.
A help has been created to list all the various options and examples for each of them.
Thanks to Ronald Speelman, for suggestions and testing.
doc/SQLUtilities.txt | 598
plugin/SQLUtilities.vim | 602
2 files changed, 875 insertions(+), 325 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3.3)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Sat Sep 6 00:00:00 2003 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3.3
NF: Added global variable sqlutil_col_list_terminators for customization.
NF: Changed all functions to be prefixed bySQLU_ for consistency.
BF: Fixed SQLU_GetColumnDataType andSQLU_GetColumnDef to handle tabs.
BF: -@- could be left after incorrect formatting.
plugin/SQLUtilities.vim | 676
1 files changed, 418 insertions(+), 258 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.3)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Fri Jun 6 00:00:00 2003 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.3
NF: Support the formatting of FUNCTIONS or
stored procedures used as derived tables. This
will nest the function calls on new lines and
correctly split the paranthesis on new lines if
the function call is longer than one line. You
would notice this mainly in the SELECT
column list.
NF: Support the formatting of nested CASE
statements.
NF: Added the GetColumnDataType command
NF: Improved primary key determination, it no
longer requires the PRIMARY KEY statement to
be part of the CREATE TABLE statement, it can
be part of an ALTER TABLE statement.
NF: Improved formatting of SQL keywords.
INSERT INTO statement, the INTO will no longer
be split onto a new line.
Now correctly format the various JOIN keywords:
NATURAL RIGHT OUTER JOIN will be placed one
online instead of just the JOIN keyword as
before.
BF: Did not properly handle the formatting of
nested open paranthesis in all cases.
BF: Using new technique to determine how to change
the textwidth to utilitize more screen space
when wrapping long lines.
nested open paranthesis in all cases.
NF: Create procedure uses shiftwidth for indent.
BF: Save/restore previous search.
plugin/SQLUtilities.vim | 1171
1 files changed, 854 insertions(+), 317 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1.1)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Tue Feb 4 00:00:00 2003 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1.1
Improved a number of items.
1. If a PRIMARY KEY cannot be found for a given table the WHERE clause will contain all columns.
2. Made the lookup for primary keys smarter. Now the script will also look for ALTER TABLE ... ADD PRIMARY KEY statements instead of just the PRIMARY KEY clause as part of the CREATE TABLE statement.
3. If hidden is set, the script will cycle through the buffers looking for the table. Now, it will leave the cursor positioned in the same location when it leaves hidden buffers.
4. You can now define g:sqlutil_cmd_terminator. It currently defaults to ";". This is used when looking gathering columns lists.
plugin/SQLUtilities.vim | 389
1 files changed, 281 insertions(+), 108 deletions(-)
commit SHA1SHA1SHA1 (tag: refs/tags/1)
Author: David Fishburn <dfishburn.vim@gmail.com>
AuthorDate: Sat Nov 23 00:00:00 2002 +0000
Commit: Able Scraper <scraper@vim-scripts.org>
Version 1: Initial upload
README | 271
plugin/SQLUtilities.vim | 1011
2 files changed, 1282 insertions(+), 0 deletions(-)