(function (mod){ 
if (typeof exports == "object" && typeof module == "object") mod(require("../../lib/codemirror"), require("../../mode/sql/sql")); 
 else if (typeof define == "function" && define.amd) define(["../../lib/codemirror", "../../mode/sql/sql"] , mod); 
 else mod(CodeMirror); 
} 
)(function (CodeMirror){ 
"use strict"; 
var tables; 
var defaultTable; 
var keywords; 
var CONS = { 
QUERY_DIV: ";",
ALIAS_KEYWORD: "AS"}
; 
var Pos = CodeMirror.Pos; 
function isArray(val){ 
return Object.prototype.toString.call(val) == "[object Array]"; 
} 
function getKeywords(editor){ 
var mode = editor.doc.modeOption; 
if (mode === "sql") mode = "text/x-sql"; 
return CodeMirror.resolveMode(mode).keywords; 
} 
function getText(item){ 
return typeof item == "string"? item: item.text; 
} 
function wrapTable(name, value){ 
if (isArray(value)) value = { 
columns: value}
; 
if (!value.text) _AN_Write_text("text", value, false , name); 
return value; 
} 
function parseTables(input){ 
var result = { 
}
; 
if (isArray(input)) { 
for (var i = _AN_Read_length("length", input) - 1; 
i >= 0; i-- ){ 
var item = input[i]; 
result[getText(item).toUpperCase()] = wrapTable(getText(item), item); 
} 
} 
 else if (input) { 
for (var name in input)result[name.toUpperCase()] = wrapTable(name, input[name]); 
} 
return result; 
} 
function getTable(name){ 
return tables[name.toUpperCase()]; 
} 
function shallowClone(object){ 
var result = { 
}
; 
for (var key in object)if (object.hasOwnProperty(key)) result[key] = object[key]; 
return result; 
} 
function match(string, word){ 
var len = _AN_Read_length("length", string); 
var sub = getText(word).substr(0, len); 
return string.toUpperCase() === sub.toUpperCase(); 
} 
function addMatches(result, search, wordlist, formatter){ 
if (isArray(wordlist)) { 
for (var i = 0; 
i < _AN_Read_length("length", wordlist); i++ )if (match(search, wordlist[i])) result.push(formatter(wordlist[i])); 
} 
 else { 
for (var word in wordlist)if (wordlist.hasOwnProperty(word)) { 
var val = wordlist[word]; 
if (!val || val === true ) val = word; 
 else val = val.displayText? { 
text: val.text,
displayText: val.displayText}
: val.text; 
if (match(search, val)) result.push(formatter(val)); 
} 
} 
} 
function cleanName(name){ 
if (name.charAt(0) == ".") { 
name = name.substr(1); 
} 
return _AN_Call_replace("replace", name, /`/g, ""); 
} 
function insertBackticks(name){ 
var nameParts = getText(name).split("."); 
for (var i = 0; 
i < _AN_Read_length("length", nameParts); i++ )nameParts[i] = "`" + nameParts[i] + "`"; 
var escaped = nameParts.join("."); 
if (typeof name == "string") return escaped; 
name = shallowClone(name); 
_AN_Write_text("text", name, false , escaped); 
return name; 
} 
function nameCompletion(cur, token, result, editor){ 
var useBacktick = false ; 
var nameParts = [] ; 
var start = token.start; 
var cont = true ; 
while (cont){ 
cont = (token.string.charAt(0) == "."); 
useBacktick = useBacktick || (token.string.charAt(0) == "`"); 
start = token.start; 
nameParts.unshift(cleanName(token.string)); 
token = editor.getTokenAt(Pos(cur.line, token.start)); 
if (token.string == ".") { 
cont = true ; 
token = editor.getTokenAt(Pos(cur.line, token.start)); 
} 
} 
var string = nameParts.join("."); 
addMatches(result, string, tables, function (w){ 
return useBacktick? insertBackticks(w): w; 
} 
); 
addMatches(result, string, defaultTable, function (w){ 
return useBacktick? insertBackticks(w): w; 
} 
); 
string = nameParts.pop(); 
var table = nameParts.join("."); 
var alias = false ; 
var aliasTable = table; 
if (!getTable(table)) { 
var oldTable = table; 
table = findTableByAlias(table, editor); 
if (table !== oldTable) alias = true ; 
} 
var columns = getTable(table); 
if (columns && columns.columns) columns = columns.columns; 
if (columns) { 
addMatches(result, string, columns, function (w){ 
var tableInsert = table; 
if (alias == true ) tableInsert = aliasTable; 
if (typeof w == "string") { 
w = tableInsert + "." + w; 
} 
 else { 
w = shallowClone(w); 
_AN_Write_text("text", w, false , tableInsert + "." + w.text); 
} 
return useBacktick? insertBackticks(w): w; 
} 
); 
} 
return start; 
} 
function eachWord(lineText, f){ 
if (!lineText) return ; 
var excepted = /[,;]/g; 
var words = lineText.split(" "); 
for (var i = 0; 
i < _AN_Read_length("length", words); i++ ){ 
f(words[i]? _AN_Call_replace("replace", words[i], excepted, ''): ''); 
} 
} 
function convertCurToNumber(cur){ 
return cur.line + cur.ch / Math.pow(10, 6); 
} 
function convertNumberToCur(num){ 
return Pos(Math.floor(num), + num.toString().split('.').pop()); 
} 
function findTableByAlias(alias, editor){ 
var doc = editor.doc; 
var fullQuery = doc.getValue(); 
var aliasUpperCase = alias.toUpperCase(); 
var previousWord = ""; 
var table = ""; 
var separator = [] ; 
var validRange = { 
start: Pos(0, 0),
end: Pos(editor.lastLine(), _AN_Read_length("length", editor.getLineHandle(editor.lastLine())))}
; 
var indexOfSeparator = fullQuery.indexOf(CONS.QUERY_DIV); 
while (indexOfSeparator != -1){ 
separator.push(doc.posFromIndex(indexOfSeparator)); 
indexOfSeparator = fullQuery.indexOf(CONS.QUERY_DIV, indexOfSeparator + 1); 
} 
separator.unshift(Pos(0, 0)); 
separator.push(Pos(editor.lastLine(), _AN_Read_length("length", editor.getLineHandle(editor.lastLine()).text))); 
var prevItem = 0; 
var current = convertCurToNumber(editor.getCursor()); 
for (var i = 0; 
i < _AN_Read_length("length", separator); i++ ){ 
var _v = convertCurToNumber(separator[i]); 
if (current > prevItem && current <= _v) { 
validRange = { 
start: convertNumberToCur(prevItem),
end: convertNumberToCur(_v)}
; 
break ; 
} 
prevItem = _v; 
} 
var query = doc.getRange(validRange.start, validRange.end, false ); 
for (var i = 0; 
i < _AN_Read_length("length", query); i++ ){ 
var lineText = query[i]; 
eachWord(lineText, function (word){ 
var wordUpperCase = word.toUpperCase(); 
if (wordUpperCase === aliasUpperCase && getTable(previousWord)) table = previousWord; 
if (wordUpperCase !== CONS.ALIAS_KEYWORD) previousWord = word; 
} 
); 
if (table) break ; 
} 
return table; 
} 
CodeMirror.registerHelper("hint", "sql", function (editor, options){ 
tables = parseTables(options && options.tables); 
var defaultTableName = options && options.defaultTable; 
var disableKeywords = options && options.disableKeywords; 
defaultTable = defaultTableName && getTable(defaultTableName); 
keywords = keywords || getKeywords(editor); 
if (defaultTableName && !defaultTable) defaultTable = findTableByAlias(defaultTableName, editor); 
defaultTable = defaultTable || [] ; 
if (defaultTable.columns) defaultTable = defaultTable.columns; 
var cur = editor.getCursor(); 
var result = [] ; 
var token = editor.getTokenAt(cur), start, end, search; 
if (token.end > cur.ch) { 
token.end = cur.ch; 
token.string = token.string.slice(0, cur.ch - token.start); 
} 
if (token.string.match(/^[.`\w@]\w*$/)) { 
search = token.string; 
start = token.start; 
end = token.end; 
} 
 else { 
start = end = cur.ch; 
search = ""; 
} 
if (search.charAt(0) == "." || search.charAt(0) == "`") { 
start = nameCompletion(cur, token, result, editor); 
} 
 else { 
addMatches(result, search, tables, function (w){ 
return w; 
} 
); 
addMatches(result, search, defaultTable, function (w){ 
return w; 
} 
); 
if (!disableKeywords) addMatches(result, search, keywords, function (w){ 
return w.toUpperCase(); 
} 
); 
} 
return { 
list: result,
from: Pos(cur.line, start),
to: Pos(cur.line, end)}
; 
} 
); 
} 
);