Skip to content

8.0

Compare
Choose a tag to compare
@cosminadrianpopescu 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): see SWSqlReferences and SWSqlReferencedBy
  • 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 (see g: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 (see SWSqlFilter)
  • 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

Download vim-sql