Good work :)

You can setup a github account so others can contribute
also you can upload it to vim.org scripts area

On Fri, Jun 13, 2014 at 6:48 PM, Scott Morgan blumf@...
[Firebird-general] <Firebird-general@yahoogroups.com> wrote:

> On 13/06/14 15:45, mapopa@... [Firebird-general] wrote:
>> We need to create a Firebird dialect
>>
>> http://vimdoc.sourceforge.net/htmldoc/ft_sql.html#sql-dialects
>
>> ps: if you have time please contribute
>
> Had a quick stab at it, never done anything like this before.
>
> Took the list of Firebird keywords from here:
> http://www.firebirdsql.org/refdocs/langrefupd25-reskeywords-full-keywords.html
>
> And added on types to them (not all of them currently)
> http://pastebin.com/4J1ZgLMf
> (also added the 'SHELL' keyword, which isn't technically part of FB's
> dialect but crops up in ISQL scripts)
>
> Then, based on the sqloracle.vim file, I built sqlfirebird.vim:
> http://pastebin.com/DNag96VC
> (Have a Lua script that does the work)
>
> It's not perfect but it works okay.
>
> Lots of keywords are unassigned a type so they just get a default highlight.
>
> Problems:
> * Some of the operators don't match (e.g. "||", "~="...)
> * Some keywords have different meaning based on context (i.e. 'LEFT'
> is both a statement keyword as in 'LEFT OUTER JOIN' and a function)
> I suspect you could do some fancy work with nestled ranges but,
> heh, lot of work there (doesn't seem like anyone else has tried it
> for the other SQL dialects either)
> * Haven't looked into how well it works with procedure definitions yet
> (probably a lot of the unassigned keywords relevant to that)
>
> Might set up a github project if anyone's interested (or whatever works
> best for the vim team)
>
> Scott
>
>
>
> ------------------------------------
> Posted by: Scott Morgan <blumf@...>
> ------------------------------------
>
> Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-generalYahoo Groups Links
>
>
>