SQLBoiler v3.2.0 Release Notes

Release Date: 2019-01-22 // over 5 years ago
  • โž• Added

    • ๐Ÿ‘€ Type-safe where clauses can now be created, see README for details. It is highly recommended that this be used at all times.
    • Type-safe where clauses can now be combined with Or2 for setting or.
    • The new Expr query mod will allow you to group where statements manually (this turns off all automatic paretheses in the where clause for the query).
    • โœ… Driver specific commands (eg. pg_dump) that are run for test scaffolding will now output their error messages to stderr where they were previously silently failing (thanks @LukasAuerbeck)
    • โž• Add skipsqlcmd to generated test code for each driver. This allows skipping the whole drop/create database cycle while testing so you may point sqlboiler at a pre-setup test database. (thanks @gemscng)
    • โž• Add a way to skip hook execution for a given query (boil.SkipHooks)
    • โž• Add a way to skip timestamp updating for a given query (boil.SkipTimestamps)
    • โž• Add note about mysql minimum version requirement to README (thanks @jlarusso)

    ๐Ÿ›  Fixed

    • ๐Ÿ›  Fix panic on eager load with nullable foreign keys
    • ๐Ÿ›  Fix bug that prevented 'where' and 'in' from being mixed naturally as 'in' query mods would always be rendered at the end of the query resulting in an unintentional problem.
    • ๐Ÿ›  Fix an issue where 'in' query mods were not being automatically grouped in parentheses like 'where' statements.
    • ๐Ÿ›  Fix bug where mysql columns can sometimes be selected out of order in certain internal queries. (thanks @cpickett-ml)
    • ๐Ÿ›  Fix bug where an incorrect query could be built while eager loading nullable relations (thanks @parnic)
    • ๐Ÿ›  Fix bug where aliases weren't used in many-to-many eager loading (thanks @nwidger for suggested fix)
    • ๐Ÿ›  Fix bug where mysql driver would look outside the current database for indexes that applied to tables and columns named the same and apply those constraints to the generated schema.
    • ๐Ÿ›  Fix MSSQL Link in Readme (thanks @philips)
    • ๐Ÿ›  Fix bug where psql upsert would error when not doing an update
    • ๐Ÿ›  Fix bug where mysql upsert did not have quotes around the table name
    • ๐Ÿ›  Fix bug where yaml config files would panic due to type assertions (thanks @ch3rub1m)
    • ๐Ÿ›  Fix bug where a table name that was a Go keyword could cause test failures
    • ๐Ÿ›  Fix missing boil.Columns type in README (thanks @tatane616)