vim-mysql-suggestions.vim

let g:path_myslq_plugin = expand('<sfile>:p:h')

function! MySQLCompleteFunction( findstart, base )
  if a:findstart
    let line = getline('.')
    let start = col('.') - 1
    while start > 0 && line[start - 1] =~ '[A-Za-z_.]'
        let start -= 1
    endwhile
    return start
  else
    let command = "php ".g:path_myslq_plugin."/db.php '".g:database_host."' '".g:database_user."' '".g:database_password."' '".g:database_database."' '".a:base."'"
    let output = system( command )
    let matches = split(output, ';')
    let result = []
    for i in matches
        let exploded = split(i, '/')
       call add(result, {'word' : exploded[0], 'kind' : exploded[2], 'menu' : exploded[1]}) ", 'info': 'int'
    endfor
    return result
  endif
endfunction


function! DatabasePrefixesInit(word)
    let command = "php ".g:path_myslq_plugin."/db.php '".g:database_host."' '".g:database_user."' '".g:database_password."' '".g:database_database."' 'prefixes' '".a:word."'"
    return system( command )
endfunction


function! MySQLCompleteSuperTabContext()

    let column = col('.')
    if column > 1  
        
        let synname = synIDattr(synID(line('.'), column-1, 1), 'name')
        
        if  synname == 'phpStringSingle' || synname == 'javaScriptString' || synname == 'javaScriptFuncArg'
           return "\<c-x>\<c-u>"
        elseif synname == 'phpMethodsVar' 
            let curline = getline('.')
            let beforecursor = curline[ 0 : (column-2) ]
            let splitWord = split(beforecursor, '->')
            let currentWord = splitWord[-1]
            let currentWord = substitute( currentWord , "_" , '' , 'g')

            if strlen(currentWord) > 2 
               if DatabasePrefixesInit( currentWord ) == '1'
                    return "\<c-x>\<c-u>"
                endif
            endif
            return "\<c-x>\<c-o>"
        endif
        
        if &omnifunc != ''
            return "\<c-x>\<c-o>"
        endif
    endif
    return "\<c-x>\<c-p>"
endfunction