annotate runtime/ftplugin/sql.vim @ 856:8cd729851562 v7.0g

updated for version 7.0g
author vimboss
date Sun, 30 Apr 2006 18:54:39 +0000
parents d3bbb5dd3913
children 73fe8baea242
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
1 " SQL filetype plugin file
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
2 " Language: SQL (Common for Oracle, Microsoft SQL Server, Sybase)
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
3 " Version: 3.0
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
4 " Maintainer: David Fishburn <fishburn at ianywhere dot com>
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
5 " Last Change: Wed Apr 26 2006 3:02:32 PM
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
6 " Download: http://vim.sourceforge.net/script.php?script_id=454
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
7
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
8 " For more details please use:
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
9 " :h sql.txt
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
10 "
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
11 " This file should only contain values that are common to all SQL languages
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
12 " Oracle, Microsoft SQL Server, Sybase ASA/ASE, MySQL, and so on
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
13 " If additional features are required create:
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
14 " vimfiles/after/ftplugin/sql.vim (Windows)
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
15 " .vim/after/ftplugin/sql.vim (Unix)
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
16 " to override and add any of your own settings.
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
17
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
18
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
19 " This file also creates a command, SQLSetType, which allows you to change
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
20 " SQL dialects on the fly. For example, if I open an Oracle SQL file, it
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
21 " is color highlighted appropriately. If I open an Informix SQL file, it
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
22 " will still be highlighted according to Oracles settings. By running:
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
23 " :SQLSetType sqlinformix
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
24 "
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
25 " All files called sqlinformix.vim will be loaded from the indent and syntax
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
26 " directories. This allows you to easily flip SQL dialects on a per file
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
27 " basis. NOTE: you can also use completion:
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
28 " :SQLSetType <tab>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
29 "
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
30 " To change the default dialect, add the following to your vimrc:
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
31 " let g:sql_type_default = 'sqlanywhere'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
32
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
33
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
34 " Only do this when not done yet for this buffer
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
35 if exists("b:did_ftplugin")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
36 finish
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
37 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
38
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
39 let s:save_cpo = &cpo
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
40 set cpo=
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
41
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
42 " Functions/Commands to allow the user to change SQL syntax dialects
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
43 " through the use of :SQLSetType <tab> for completion.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
44 " This works with both Vim 6 and 7.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
45
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
46 if !exists("*SQL_SetType")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
47 " NOTE: You cannot use function! since this file can be
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
48 " sourced from within this function. That will result in
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
49 " an error reported by Vim.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
50 function SQL_GetList(ArgLead, CmdLine, CursorPos)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
51
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
52 if !exists('s:sql_list')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
53 " Grab a list of files that contain "sql" in their names
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
54 let list_indent = globpath(&runtimepath, 'indent/*sql*')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
55 let list_syntax = globpath(&runtimepath, 'syntax/*sql*')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
56 let list_ftplugin = globpath(&runtimepath, 'ftplugin/*sql*')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
57
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
58 let sqls = "\n".list_indent."\n".list_syntax."\n".list_ftplugin."\n"
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
59
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
60 " Strip out everything (path info) but the filename
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
61 " Regex
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
62 " From between two newline characters
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
63 " Non-greedily grab all characters
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
64 " Followed by a valid filename \w\+\.\w\+ (sql.vim)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
65 " Followed by a newline, but do not include the newline
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
66 "
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
67 " Replace it with just the filename (get rid of PATH)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
68 "
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
69 " Recursively, since there are many filenames that contain
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
70 " the word SQL in the indent, syntax and ftplugin directory
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
71 let sqls = substitute( sqls,
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
72 \ '[\n]\%(.\{-}\)\(\w\+\.\w\+\)\n\@=',
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
73 \ '\1\n',
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
74 \ 'g'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
75 \ )
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
76
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
77 " Remove duplicates, since sqlanywhere.vim can exist in the
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
78 " sytax, indent and ftplugin directory, yet we only want
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
79 " to display the option once
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
80 let index = match(sqls, '.\{-}\ze\n')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
81 while index > -1
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
82 " Get the first filename
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
83 let file = matchstr(sqls, '.\{-}\ze\n', index)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
84 " Recursively replace any *other* occurrence of that
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
85 " filename with nothing (ie remove it)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
86 let sqls = substitute(sqls, '\%>'.(index+strlen(file)).'c\<'.file.'\>\n', '', 'g')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
87 " Move on to the next filename
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
88 let index = match(sqls, '.\{-}\ze\n', (index+strlen(file)+1))
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
89 endwhile
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
90
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
91 " Sort the list if using version 7
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
92 if v:version >= 700
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
93 let mylist = split(sqls, "\n")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
94 let mylist = sort(mylist)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
95 let sqls = join(mylist, "\n")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
96 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
97
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
98 let s:sql_list = sqls
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
99 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
100
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
101 return s:sql_list
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
102
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
103 endfunction
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
104
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
105 function SQL_SetType(name)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
106
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
107 " User has decided to override default SQL scripts and
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
108 " specify a vendor specific version
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
109 " (ie Oracle, Informix, SQL Anywhere, ...)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
110 " So check for an remove any settings that prevent the
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
111 " scripts from being executed, and then source the
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
112 " appropriate Vim scripts.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
113 if exists("b:did_ftplugin")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
114 unlet b:did_ftplugin
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
115 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
116 if exists("b:current_syntax")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
117 " echomsg 'SQLSetType - clearing syntax'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
118 syntax clear
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
119 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
120 if exists("b:did_indent")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
121 " echomsg 'SQLSetType - clearing indent'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
122 unlet b:did_indent
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
123 " Set these values to their defaults
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
124 setlocal indentkeys&
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
125 setlocal indentexpr&
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
126 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
127
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
128 " Ensure the name is in the correct format
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
129 let new_sql_type = substitute(a:name,
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
130 \ '\s*\([^\.]\+\)\(\.\w\+\)\?', '\L\1', '')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
131
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
132 " Do not specify a buffer local variable if it is
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
133 " the default value
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
134 if new_sql_type == 'sql'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
135 let new_sql_type = 'sqloracle'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
136 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
137 let b:sql_type_override = new_sql_type
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
138
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
139 " Vim will automatically source the correct files if we
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
140 " change the filetype. You cannot do this with setfiletype
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
141 " since that command will only execute if a filetype has
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
142 " not already been set. In this case we want to override
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
143 " the existing filetype.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
144 let &filetype = 'sql'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
145 endfunction
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
146 command! -nargs=* -complete=custom,SQL_GetList SQLSetType :call SQL_SetType(<q-args>)
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
147
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
148 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
149
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
150 if exists("b:sql_type_override")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
151 " echo 'sourcing buffer ftplugin/'.b:sql_type_override.'.vim'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
152 if globpath(&runtimepath, 'ftplugin/'.b:sql_type_override.'.vim') != ''
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
153 exec 'runtime ftplugin/'.b:sql_type_override.'.vim'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
154 " else
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
155 " echomsg 'ftplugin/'.b:sql_type_override.' not exist, using default'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
156 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
157 elseif exists("g:sql_type_default")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
158 " echo 'sourcing global ftplugin/'.g:sql_type_default.'.vim'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
159 if globpath(&runtimepath, 'ftplugin/'.g:sql_type_default.'.vim') != ''
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
160 exec 'runtime ftplugin/'.g:sql_type_default.'.vim'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
161 " else
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
162 " echomsg 'ftplugin/'.g:sql_type_default.'.vim not exist, using default'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
163 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
164 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
165
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
166 " If the above runtime command succeeded, do not load the default settings
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
167 if exists("b:did_ftplugin")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
168 finish
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
169 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
170
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
171 let b:undo_ftplugin = "setl comments<"
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
172
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
173 " Don't load another plugin for this buffer
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
174 let b:did_ftplugin = 1
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
175 let b:current_ftplugin = 'sql'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
176
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
177 " Win32 can filter files in the browse dialog
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
178 if has("gui_win32") && !exists("b:browsefilter")
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
179 let b:browsefilter = "SQL Files (*.sql)\t*.sql\n" .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
180 \ "All Files (*.*)\t*.*\n"
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
181 endif
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
182
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
183 " Some standard expressions for use with the matchit strings
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
184 let s:notend = '\%(\<end\s\+\)\@<!'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
185 let s:when_no_matched_or_others = '\%(\<when\>\%(\s\+\%(\%(\<not\>\s\+\)\?<matched\>\)\|\<others\>\)\@!\)'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
186 let s:or_replace = '\%(or\s\+replace\s\+\)\?'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
187
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
188 " Define patterns for the matchit macro
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
189 if !exists("b:match_words")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
190 " SQL is generally case insensitive
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
191 let b:match_ignorecase = 1
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
192
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
193 " Handle the following:
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
194 " if
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
195 " elseif | elsif
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
196 " else [if]
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
197 " end if
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
198 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
199 " [while condition] loop
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
200 " leave
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
201 " break
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
202 " continue
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
203 " exit
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
204 " end loop
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
205 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
206 " for
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
207 " leave
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
208 " break
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
209 " continue
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
210 " exit
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
211 " end loop
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
212 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
213 " do
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
214 " statements
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
215 " doend
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
216 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
217 " case
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
218 " when
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
219 " when
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
220 " default
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
221 " end case
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
222 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
223 " merge
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
224 " when not matched
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
225 " when matched
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
226 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
227 " EXCEPTION
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
228 " WHEN column_not_found THEN
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
229 " WHEN OTHERS THEN
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
230 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
231 " create[ or replace] procedure|function|event
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
232
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
233 let b:match_words =
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
234 \ '\<begin\>:\<end\>\W*$,'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
235 \
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
236 \ s:notend . '\<if\>:'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
237 \ '\<elsif\>\|\<elseif\>\|\<else\>:'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
238 \ '\<end\s\+if\>,'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
239 \
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
240 \ '\<do\>\|'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
241 \ '\<while\>\|'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
242 \ '\%(' . s:notend . '\<loop\>\)\|'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
243 \ '\%(' . s:notend . '\<for\>\):'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
244 \ '\<exit\>\|\<leave\>\|\<break\>\|\<continue\>:'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
245 \ '\%(\<end\s\+\%(for\|loop\>\)\)\|\<doend\>,'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
246 \
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
247 \ '\%('. s:notend . '\<case\>\):'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
248 \ '\%('.s:when_no_matched_or_others.'\):'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
249 \ '\%(\<when\s\+others\>\|\<end\s\+case\>\),' .
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
250 \
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
251 \ '\<merge\>:' .
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
252 \ '\<when\s\+not\s\+matched\>:' .
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
253 \ '\<when\s\+matched\>,' .
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
254 \
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
255 \ '\%(\<create\s\+' . s:or_replace . '\)\?'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
256 \ '\%(function\|procedure\|event\):'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
257 \ '\<returns\?\>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
258 " \ '\<begin\>\|\<returns\?\>:'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
259 " \ '\<end\>\(;\)\?\s*$'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
260 " \ '\<exception\>:'.s:when_no_matched_or_others.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
261 " \ ':\<when\s\+others\>,'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
262 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
263 " \ '\%(\<exception\>\|\%('. s:notend . '\<case\>\)\):'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
264 " \ '\%(\<default\>\|'.s:when_no_matched_or_others.'\):'.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
265 " \ '\%(\%(\<when\s\+others\>\)\|\<end\s\+case\>\),' .
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
266 endif
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
267
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
268 " Define how to find the macro definition of a variable using the various
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
269 " [d, [D, [_CTRL_D and so on features
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
270 " Match these values ignoring case
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
271 " ie DECLARE varname INTEGER
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
272 let &l:define = '\c\<\(VARIABLE\|DECLARE\|IN\|OUT\|INOUT\)\>'
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
273
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
274
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
275 " Mappings to move to the next BEGIN ... END block
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
276 " \W - no characters or digits
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
277 nmap <buffer> <silent> ]] :call search('\\c^\\s*begin\\>', 'W' )<CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
278 nmap <buffer> <silent> [[ :call search('\\c^\\s*begin\\>', 'bW' )<CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
279 nmap <buffer> <silent> ][ :call search('\\c^\\s*end\\W*$', 'W' )<CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
280 nmap <buffer> <silent> [] :call search('\\c^\\s*end\\W*$', 'bW' )<CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
281 vmap <buffer> <silent> ]] /\\c^\\s*begin\\><CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
282 vmap <buffer> <silent> [[ ?\\c^\\s*begin\\><CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
283 vmap <buffer> <silent> ][ /\\c^\\s*end\\W*$<CR>
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
284 vmap <buffer> <silent> [] ?\\c^\\s*end\\W*$<CR>
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
285
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
286
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
287 " By default only look for CREATE statements, but allow
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
288 " the user to override
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
289 if !exists('g:ftplugin_sql_statements')
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
290 let g:ftplugin_sql_statements = 'create'
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
291 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
292
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
293 " Predefined SQL objects what are used by the below mappings using
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
294 " the ]} style maps.
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
295 " This global variable allows the users to override it's value
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
296 " from within their vimrc.
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
297 " Note, you cannot use \?, since these patterns can be used to search
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
298 " backwards, you must use \{,1}
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
299 if !exists('g:ftplugin_sql_objects')
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
300 let g:ftplugin_sql_objects = 'function,procedure,event,' .
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
301 \ '\\(existing\\\\|global\\s\\+temporary\\s\\+\\)\\\{,1}' .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
302 \ 'table,trigger' .
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
303 \ ',schema,service,publication,database,datatype,domain' .
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
304 \ ',index,subscription,synchronization,view,variable'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
305 endif
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
306
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
307 " Replace all ,'s with bars, except ones with numbers after them.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
308 " This will most likely be a \{,1} string.
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
309 let s:ftplugin_sql_objects =
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
310 \ '\\c^\\s*' .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
311 \ '\\(\\(' .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
312 \ substitute(g:ftplugin_sql_statements, ',\d\@!', '\\\\\\|', 'g') .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
313 \ '\\)\\s\\+\\(or\\s\\+replace\\\s\+\\)\\{,1}\\)\\{,1}' .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
314 \ '\\<\\(' .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
315 \ substitute(g:ftplugin_sql_objects, ',\d\@!', '\\\\\\|', 'g') .
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
316 \ '\\)\\>'
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
317
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
318 " Mappings to move to the next CREATE ... block
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
319 exec "nmap <buffer> <silent> ]} :call search('".s:ftplugin_sql_objects."', 'W')<CR>"
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
320 exec "nmap <buffer> <silent> [{ :call search('".s:ftplugin_sql_objects."', 'bW')<CR>"
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
321 " Could not figure out how to use a :call search() string in visual mode
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
322 " without it ending visual mode
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
323 " Unfortunately, this will add a entry to the search history
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
324 exec 'vmap <buffer> <silent> ]} /'.s:ftplugin_sql_objects.'<CR>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
325 exec 'vmap <buffer> <silent> [{ ?'.s:ftplugin_sql_objects.'<CR>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
326
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
327 " Mappings to move to the next COMMENT
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
328 "
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
329 " Had to double the \ for the \| separator since this has a special
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
330 " meaning on maps
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
331 let b:comment_leader = '\\(--\\\|\\/\\/\\\|\\*\\\|\\/\\*\\\|\\*\\/\\)'
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
332 " Find the start of the next comment
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
333 let b:comment_start = '^\\(\\s*'.b:comment_leader.'.*\\n\\)\\@<!'.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
334 \ '\\(\\s*'.b:comment_leader.'\\)'
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
335 " Find the end of the previous comment
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
336 let b:comment_end = '\\(^\\s*'.b:comment_leader.'.*\\n\\)'.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
337 \ '\\(^\\s*'.b:comment_leader.'\\)\\@!'
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
338 " Skip over the comment
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
339 let b:comment_jump_over = "call search('".
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
340 \ '^\\(\\s*'.b:comment_leader.'.*\\n\\)\\@<!'.
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
341 \ "', 'W')"
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
342 let b:comment_skip_back = "call search('".
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
343 \ '^\\(\\s*'.b:comment_leader.'.*\\n\\)\\@<!'.
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
344 \ "', 'bW')"
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
345 " Move to the start and end of comments
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
346 exec 'nnoremap <silent><buffer> ]" /'.b:comment_start.'<CR>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
347 exec 'nnoremap <silent><buffer> [" /'.b:comment_end.'<CR>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
348 exec 'vnoremap <silent><buffer> ]" /'.b:comment_start.'<CR>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
349 exec 'vnoremap <silent><buffer> [" /'.b:comment_end.'<CR>'
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
350
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
351 " Comments can be of the form:
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
352 " /*
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
353 " *
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
354 " */
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
355 " or
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
356 " --
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
357 " or
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
358 " //
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
359 setlocal comments=s1:/*,mb:*,ex:*/,:--,://
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
360
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
361 " Set completion with CTRL-X CTRL-O to autoloaded function.
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
362 if exists('&omnifunc')
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
363 " Since the SQL completion plugin can be used in conjunction
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
364 " with other completion filetypes it must record the previous
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
365 " OMNI function prior to setting up the SQL OMNI function
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
366 let b:sql_compl_savefunc = &omnifunc
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
367
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
368 " This is used by the sqlcomplete.vim plugin
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
369 " Source it for it's global functions
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
370 runtime autoload/syntaxcomplete.vim
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
371
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
372 setlocal omnifunc=sqlcomplete#Complete
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
373 " Prevent the intellisense plugin from loading
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
374 let b:sql_vis = 1
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
375 if !exists('g:omni_sql_no_default_maps')
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
376 " Static maps which use populate the completion list
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
377 " using Vim's syntax highlighting rules
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
378 imap <buffer> <c-c>a <C-\><C-O>:call sqlcomplete#Map('syntax')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
379 imap <buffer> <c-c>k <C-\><C-O>:call sqlcomplete#Map('sqlKeyword')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
380 imap <buffer> <c-c>f <C-\><C-O>:call sqlcomplete#Map('sqlFunction')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
381 imap <buffer> <c-c>o <C-\><C-O>:call sqlcomplete#Map('sqlOption')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
382 imap <buffer> <c-c>T <C-\><C-O>:call sqlcomplete#Map('sqlType')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
383 imap <buffer> <c-c>s <C-\><C-O>:call sqlcomplete#Map('sqlStatement')<CR><C-X><C-O>
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
384 " Dynamic maps which use populate the completion list
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
385 " using the dbext.vim plugin
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
386 imap <buffer> <c-c>t <C-\><C-O>:call sqlcomplete#Map('table')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
387 imap <buffer> <c-c>p <C-\><C-O>:call sqlcomplete#Map('procedure')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
388 imap <buffer> <c-c>v <C-\><C-O>:call sqlcomplete#Map('view')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
389 imap <buffer> <c-c>c <C-\><C-O>:call sqlcomplete#Map('column')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
390 imap <buffer> <c-c>l <C-\><C-O>:call sqlcomplete#Map('column_csv')<CR><C-X><C-O>
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
391 " The next 3 maps are only to be used while the completion window is
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
392 " active due to the <CR> at the beginning of the map
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
393 imap <buffer> <c-c>L <C-Y><C-\><C-O>:call sqlcomplete#Map('column_csv')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
394 " <C-Right> is not recognized on most Unix systems, so only create
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
395 " these additional maps on the Windows platform.
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
396 " If you would like to use these maps, choose a different key and make
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
397 " the same map in your vimrc.
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
398 if has('win32')
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
399 imap <buffer> <c-right> <C-R>=sqlcomplete#DrillIntoTable()<CR>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
400 imap <buffer> <c-left> <C-R>=sqlcomplete#DrillOutOfColumns()<CR>
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
401 endif
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
402 " Remove any cached items useful for schema changes
844
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
403 imap <buffer> <c-c>R <C-\><C-O>:call sqlcomplete#Map('resetCache')<CR><C-X><C-O>
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
404 endif
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
405
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
406 if b:sql_compl_savefunc != ""
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
407 " We are changing the filetype to SQL from some other filetype
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
408 " which had OMNI completion defined. We need to activate the
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
409 " SQL completion plugin in order to cache some of the syntax items
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
410 " while the syntax rules for SQL are active.
d3bbb5dd3913 updated for version 7.0f02
vimboss
parents: 818
diff changeset
411 call sqlcomplete#PreCacheSyntax()
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
412 endif
718
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
413 endif
7b21554be7a1 updated for version 7.0219
vimboss
parents: 167
diff changeset
414
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
415 let &cpo = s:save_cpo
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
416
818
1f929f3ca806 updated for version 7.0c03
vimboss
parents: 718
diff changeset
417 " vim:sw=4:
167
c93c9cad9618 updated for version 7.0051
vimboss
parents: 7
diff changeset
418