Re: trouble using python code with sql code

On Tue, Feb 18, 2014 at 7:10 PM, David Fishburn <dfishburn.vim@gmail.com> wrote:
>
> On Mon, Feb 17, 2014 at 6:45 AM, A Loumiotis <antonis.loumiotis@gmail.com>
> wrote:
>>
>> Hi,
>>
>> Omni sql completion does not seem to work with python filetypes. The
>> example provided in section 4.6 of the helpfile ft_sql.txt works, ie
>> omni sql completion works within a perl file. If I repeat this
>> example editing a python file instead:
>>
>> :e test.py
>> :set filetype=sql
>> :set ft=python
>>
>> omni sql completion does not work within a python file. Is this a bug
>> or am I doing something wrong?
>>
>> I use VIM - Vi IMproved 7.4 (2013 Aug 10, compiled Aug 10 2013 14:38:33)
>> MS-Windows 32-bit GUI version with OLE support.
>>
>>
> That is really interesting, I am seeing the same thing.
>
> :e dave.pl
> :set ft=sql
> :set ft=perl
> :imap <buffer>
>
>
> i <C-C>R *@<C-\><C-O>:call sqlcomplete#Map("resetCache")<CR><C-X><C-O>
> i <C-C>L *@<C-Y><C-\><C-O>:call
> sqlcomplete#Map("column_csv")<CR><C-X><C-O>
> i <C-C>l *@<C-\><C-O>:call sqlcomplete#Map("column_csv")<CR><C-X><C-O>
> i <C-C>c *@<C-\><C-O>:call sqlcomplete#Map("column")<CR><C-X><C-O>
> i <C-C>v *@<C-\><C-O>:call sqlcomplete#Map("view")<CR><C-X><C-O>
> i <C-C>p *@<C-\><C-O>:call sqlcomplete#Map("procedure")<CR><C-X><C-O>
> i <C-C>t *@<C-\><C-O>:call sqlcomplete#Map("table")<CR><C-X><C-O>
> i <C-C>s *@<C-\><C-O>:call
> sqlcomplete#Map("sqlStatement\\w*")<CR><C-X><C-O>
> i <C-C>T *@<C-\><C-O>:call
> sqlcomplete#Map("sqlType\\w*")<CR><C-X><C-O>
> i <C-C>o *@<C-\><C-O>:call
> sqlcomplete#Map("sqlOption\\w*")<CR><C-X><C-O>
> i <C-C>f *@<C-\><C-O>:call
> sqlcomplete#Map("sqlFunction\\w*")<CR><C-X><C-O>
> i <C-C>k *@<C-\><C-O>:call
> sqlcomplete#Map("sqlKeyword\\w*")<CR><C-X><C-O>
> i <C-C>a *@<C-\><C-O>:call sqlcomplete#Map("syntax")<CR><C-X><C-O>
>
>
> :e dave.py
> :set ft=sql
>
> :imap <buffer>
>
> This should have created all the above imaps, just as it did with Perl.
>
> I see why it didn't.
> At the top of ftplugin/sql.vim there is the "usual" code:
>
> if exists("b:did_ftplugin")
> finish
> endif
>
>
> Python is defining b:did_ftplugin, so it is not sourcing this file.
> I guess Perl doesn't.
>
> I will update the ftplugin/sql.vim to perform a different test.
>
> In the meantime, you can do the following to work around the issue:
>
> :e dave.py
> :unlet b:did_ftplugin
> :set ft=sql
> :unlet b:did_ftplugin
> :set ft=python
>
> And completion will be enabled.
>
> HTH,
> David
>
>
> --
> --
> 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
>
> ---
> You received this message because you are subscribed to the Google Groups
> "vim_use" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to vim_use+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

Thanks David for your help. Your ftplugin has been very useful! I
thought the issue was related to MS-Windows and perhaps it had to do
something with the crash of Vim whenever I use the :python command
that I reported but it was not (could anyone with a Windows machine
confirm this crash please?). Your workaround works great!

--
--
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

---
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.