go-jet/jet v2.0.0

Release v.2.0.0

on GitHub

Changes:

1. MySQL and MariaDB support:
   • SELECT (DISTINCT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, FOR, UNION, LOCK_IN_SHARE_MODE, sub-queries)
   • INSERT (VALUES, query),
   • UPDATE (SET, WHERE),
   • DELETE (WHERE, ORDER_BY, LIMIT),
   • LOCK (READ, WRITE)
2. PostgreSQL import part has changed: github.com/go-jet/jet -> github.com/go-jet/jet/postgres
3. Query execution mapping will also try to convert result set object to destination type if such a conversion is allowed.
4. For every time type there is now a constructor method that accepts time.Time (DateT, TimeT, TimestampT, TimezT...)
5. Some methods and types are changed or replaced:
   • Sql() and DebuSql does not return error as a last parameter. If there is an error in statement this methods will panic.
   • RAW -> Raw
   • SIMILAR_TO -> REGEXP_LIKE
   • NOT_SIMILAR_TO -> NOT_REGEXP_LIKE
   • ColumnList{column1, ...} -> ColumnList(column1, ...)