Lines Matching refs:table
15 " - Jonas Enberg - if no table is found when using column completion
16 " look backwards to a FROM clause and find the first table
20 " - NF: If resetting the cache and table, procedure or view completion
36 " - NF: When completing column lists or drilling into a table
38 " only the table name would be replaced with the column
39 " list instead of the table name and owner (if specified).
40 " - NF: When completing column lists using table aliases
42 " for the owner name when looking up the table
43 " list instead of the table name and owner (if specified).
44 " - BF: When completing column lists or drilling into a table
46 " column list could often not be found for the table.
51 " - Partial column name completion did not work when a table
52 " name or table alias was provided (Jonas Enberg).
55 " consider the partial name to be a table or table alias for the
83 " names in order to simplify the regexes used to pull out query table
84 " aliases for more robust table name and column name code completion.
85 " Full support for "table names with spaces" can be added in again
90 " when drilling in and out of a column list for a table.
96 " Supports object names with spaces "my table name"
143 " Default the option to verify table alias
162 " During table completion, should the table list also
168 " New to dbext 3.00, by default the table lists include the owner
169 " name of the table. This is used when determining how much of
178 let g:omni_sql_default_compl_type = 'table'
191 " Default to table name completion
192 let compl_type = 'table'
212 " can contain spaces like "my table name".
222 \ compl_type =~ 'column\|table\|view\|procedure'
230 " a table name if it was also supplied.
243 " If omni_sql_include_owner = 0, do not include the table
246 \ compl_type =~ '\<\(table\|view\|procedure\|column\|column_csv\)\>' &&
275 " Default to table name completion
284 let compl_type = 'table'
288 if compl_type == 'table' ||
328 " the table name. If the user selects a column list
329 " without a table name of alias present, assume they want
340 let table = matchstr( base, '^\(.*\.\)\?\zs.*\ze\..*' )
343 if g:omni_sql_include_owner == 1 && owner == '' && table != '' && column != ''
344 let owner = table
345 let table = column
351 " owner.table
352 " table.column_prefix
357 " 2. Based on 1, if the user is showing a table list
359 " this will be owner.table. In this case, we can
360 " check to see the table.column exists in the
361 " cached table list. If it does, then we have
363 " owner.table, not table.column_prefix.
368 let found = index( tbl_list, ((table != '')?(table.'.'):'').column)
371 " If the table.column was found in the table list, we can safely assume
374 " If the user has indicated not to use table owners at all and
378 " let owner = table
379 " let table = column
389 " the table name. If the user selects a column list
390 " without a table name of alias present, assume they want
392 let table = s:save_prev_table
395 let compl_list = s:SQLCGetColumns(table, list_type)
397 " If no column prefix has been provided and the table
411 " for a table (and or an alias to a table).
412 let table = base
415 " Get anything after the . and consider this the table name
420 if table != ""
427 " for each column in the table.
432 " table completion, if we have it, it should be included
433 " as there can be the same table names in a database yet
435 if g:omni_sql_include_owner == 1 && owner != '' && table != ''
436 let compl_list = s:SQLCGetColumns(owner.'.'.table, list_type)
438 let compl_list = s:SQLCGetColumns(table, list_type)
442 " If no column prefix has been provided and the table
445 let compl_list = map(compl_list, 'table.".".v:val')
471 call DB_DictionaryDelete("table")
508 " Match to a owner.table or alias.column type match
511 " Handle names with spaces "my table name"
520 if empty(compl_list) && compl_type == 'table' && base =~ '\.$'
525 " completing table names or column names.
752 let table_alias = inputdialog("Enter table alias:", table_alias)
782 let table = matchstr( a:table_name, '^\(.*\.\)\?\zs.*\ze\..*' )
785 if g:omni_sql_include_owner == 1 && owner == '' && table != '' && column != ''
786 let owner = table
787 let table = column
792 let table = matchstr(a:table_name, '^["\[\]a-zA-Z0-9_ ]\+\ze\.\?')
796 " Check if the table name was provided as part of the column name
798 let table_name = table
805 " If the table name was given as:
815 " Check if we have already cached the column list for this table
821 " Check if we have already cached the column list for this table
823 " the alias for the table instead
835 " If we have not found a cached copy of the table
836 " And the table ends in a "." or we are looking for a column list
880 " '\<\w\+\>\ze' - Get the table name
900 " '\("\|\[\)\?\w\+\("\|\]\)\?\ze' - Get the table name
942 " Simply assume it is a table name provided with a . on the end