8.0
cosminadrianpopescu
released this
22 Nov 16:56
·
17 commits
to master
since this release
- for autocomplete, added all fields
- for autocomplete, in fields insert, added the db type of the field
- for autocomplete, fixed several bugs (now it's working also for subqueries)
- for autocomplete, improved the caching
- for autocomplete, for insert, in the fields part, once a field is inserted,
the next autocomplete will not return it. - added autocomplete for macros
- for autocomplete, when a subquery is found, is returned as
subquery
,
instead of#ALIAS#
in the completion menu - added the possibility to cache several
wbschemaexports
- added the possibility to follow all the references of a resultset (which
rows is the current row referecing and which rows from other tables are
referencing the current row): seeSWSqlReferences
andSWSqlReferencedBy
- added the possibility to fetch the references tree only until a certain
level - for filtering and hiding columns, a new query is sent to the database now
- when in an sql buffer, on an insert, if you are in the fields part, you can
see the corresponding value and when on a value in the values part, you can
see the corresponding column (see SWSqlMatch) - now, you can execute macros just like a query (so no shortcut for
SWSqlExecuteMacro
); you can do<leader>c-<space>
on a macro and is going
to be interpreted correctly - you can now get the sql behind a macro (see `SWSqlGetMacroSql)
- you can choose now to send to the server the macro
sql
query rather than
the macro (seeg:sw_prefer_sql_over_macro
option) - when autocompleting the list of columns (for example for
SWSqlFilter
), now
for identical identifiers the table part will be added in paranthesis after
the column name - now, when filtering, you can directly insert the insert sql part for the
current resultset (seeSWSqlFilter
) - added the
SWSqlGenerateInsert
command, which will generate an insert which
will be coppied in the clipboard - commands removed:
SWSqlExecuteMacro
,SWSqlShowOnlyColumn
,
SWSqlForeignKey
,SWSqlFilterColumn
,SWSqlUnfilterColumn
,
SWSqlRemoveAllFilters
- commands added:
SWSqlReferences
,SWSqlReferencedBy
,SWSqlFilter
,
SWSqlUnfilter
,SWSqlGenerateInsert
,SWSqlGetMacroSql
,
SWSqlInsertMatch
- added
dbext
comparison