Download Latest Version 8.2.1.zip (532.2 kB)
Email in envelope

Get an email when there's a new version of vim-sql

Home / 8.0
Name Modified Size InfoDownloads / Week
Parent folder
8.0.tar.gz 2017-11-22 517.0 kB
0
8.0.zip 2017-11-22 530.2 kB
0
README.md 2017-11-22 2.3 kB
0
Totals: 3 Items   1.0 MB 0
  • 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
Source: README.md, updated 2017-11-22