On Sun, Mar 18, 2012 at 1:27 AM, Tim Chase <[email protected]> wrote:
> On 03/17/12 10:33, stardiviner wrote:
>
>> I want a vim script to convert SQL keyword(statement, clause,
>> those highlight group in file) to be converted to *uppercase*
>>
>> when I type command `:w` to save file. And another way is when
>> I am typing: `select`, then vim automatically change to
>>
>> `SELECT`. (this can be done with abbreviate).
>>
>
> While I don't know of anything that currently exists, if you want a
> somewhat sloppy version of it, you can use something like
>
> :autocmd BufWrite * %s/\c\<\(select\|insert\|**
> update\|create\|where\|from\|**like\|group\_s\+by\|order\_s\+**
> by\|having\)\>/\U&/g
>
> Adjust for whatever SQL keywords you want to include. I did some basic
> ones, as well as examples of multi-word ones ("group by" and "order by")
>
> The catch is that it only does dumb matching, so if you have something like
>
> select field1, field2
> from some_table
> where field3 like '%having%'
>
> it will transform the "having" even though it's inside a string. It's a
> lot more complex to get it to be a little smarter about it (make sure that
> the current match isn't inside a string-literal on the same line) and a LOT
> more complex to make sure the match isn't part of a multi-line string such
> as
>
> insert into some_table(field1) values (
> 'this string
> is one having
> multiple lines'
> )
>
> (again, the "having" will be uppercased).
There is a syntax file in vim which is sqlanywhere.vim, it will highlight a
lot of keyword. So the smart way is to make uppercase for all of those
keywords.
>
> -tim
>
>
>
> --
> You received this message from the "vim_use" maillist.
> Do not top-post! Type your reply below the text you are replying to.
> For more information, visit
> http://www.vim.org/maillist.**php<http://www.vim.org/maillist.php>
>
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php
