# Changelog

All notable changes to this project will be documented in this file.

The format is based on [Keep a Changelog](http://keepachangelog.com/)
and this project adheres to [Semantic Versioning](http://semver.org/).

## 0.16.0 - 2024-10-17

### Versions

+ `sea-schema`/`0.16.0-rc.1`: 2024-08-09

### Upgrades

* Upgrade `sea-query` to `0.32.0` https://github.com/SeaQL/sea-schema/pull/136
* Upgrade `sea-query-binder` to `0.7.0` https://github.com/SeaQL/sea-schema/pull/136
* Upgrade `sqlx` to `0.8` https://github.com/SeaQL/sea-schema/pull/136

## 0.15.0 - 2024-08-02

### Versions

+ `sea-schema`/`0.15.0-rc.1`: 2024-01-31
+ `sea-schema`/`0.15.0-rc.2`: 2024-02-02
+ `sea-schema`/`0.15.0-rc.3`: 2024-03-15
+ `sea-schema`/`0.15.0-rc.4`: 2024-03-24
+ `sea-schema`/`0.15.0-rc.5`: 2024-05-02
+ `sea-schema`/`0.15.0-rc.6`: 2024-05-03
+ `sea-schema`/`0.15.0-rc.7`: 2024-06-19
+ `sea-schema-derive`/`0.3.0`: 2024-08-02

### Features

* Rework SQLite data type mapping https://github.com/SeaQL/sea-schema/pull/117
* Update binary and bit data types mapping https://github.com/SeaQL/sea-schema/pull/122

### Bug fixes

* Fix constraint query when table is partitioned https://github.com/SeaQL/sea-schema/pull/125
* Fix Postgres foreign key column without unique constraint https://github.com/SeaQL/sea-schema/pull/131
* Fix discovery of MySQL, SQLite and PostgreSQL unique indexes https://github.com/SeaQL/sea-schema/pull/133

### Breaking changes

* `SchemaProbe::query_tables(..)` changed to `SchemaProbe::query_tables(&self, ..)` https://github.com/SeaQL/sea-schema/pull/127
* `SchemaProbe::has_table(..)` changed to `SchemaProbe::has_table(&self, ..)` https://github.com/SeaQL/sea-schema/pull/126
* `SchemaProbe::has_column(..)` changed to `SchemaProbe::has_column(&self, ..)` https://github.com/SeaQL/sea-schema/pull/126
* `SchemaProbe::has_index(..)` changed to `SchemaProbe::has_index(&self, ..)` https://github.com/SeaQL/sea-schema/pull/126

### Enhancements

* Added non-TLS runtime https://github.com/SeaQL/sea-schema/pull/134

### Upgrades

* Upgrade `syn` to `2` https://github.com/SeaQL/sea-schema/pull/129

## 0.14.2 - 2024-01-18

### Bug fixes

* Fix composite foreign key discovery for Postgres https://github.com/SeaQL/sea-schema/pull/118
* Fix composite foreign key discovery for SQLite https://github.com/SeaQL/sea-schema/pull/119

### House keeping

* Fix clippy warnings on 1.75 https://github.com/SeaQL/sea-schema/pull/121

## 0.14.1 - 2023-09-14

* Added `has_index` to `SchemaProbe` https://github.com/SeaQL/sea-schema/pull/115

## 0.14.0 - 2023-07-21

### Upgrades

* Upgrade `sea-query` to `0.30` https://github.com/SeaQL/sea-schema/pull/114
* Upgrade `sea-query-binder` to `0.5` https://github.com/SeaQL/sea-schema/pull/114
* Upgrade `sqlx` to `0.7` https://github.com/SeaQL/sea-schema/pull/114

### Bug fixes

* Fix PostgreSQL enum arrays and case-sensitive types https://github.com/SeaQL/sea-schema/pull/108

## 0.13.0 - Skipped

## 0.12.0 - 2023-07-20

+ 2023-03-22: `0.12.0-rc.1`
+ 2023-05-18: `0.12.0-rc.2`

### Features and upgrades

* Skip parsing partitioned Postgres tables https://github.com/SeaQL/sea-schema/pull/105
* Upgrade `heck` dependency in `sea-schema-derive` to 0.4 https://github.com/SeaQL/sea-schema/pull/103
* Upgrade `sea-query` to `0.29` https://github.com/SeaQL/sea-schema/pull/104
* Upgrade `sea-query-binder` to `0.4` https://github.com/SeaQL/sea-schema/pull/104
* Replace the use of `SeaRc<T>` where `T` isn't `dyn Iden` with `RcOrArc<T>` https://github.com/SeaQL/sea-schema/pull/107
* Customized parsing logic for MySQL and MariaDB column default https://github.com/SeaQL/sea-schema/pull/110
    * Properly distinguish between Value and Expression, and the very special CURRENT_TIMESTAMP
* Improve SQLite's column default parsing logic https://github.com/SeaQL/sea-schema/pull/112

### Breaking changes

* API now returns `Result` instead of panic on errors https://github.com/SeaQL/sea-schema/pull/109
* `ColumnDefault` changed from a struct into an enum https://github.com/SeaQL/sea-schema/pull/110
* Added `CurrentTimestamp` variant to SQLite's `DefaultType` https://github.com/SeaQL/sea-schema/pull/112

## 0.11.0 - 2023-01-05

* Upgrade SeaQuery to 0.28 https://github.com/SeaQL/sea-schema/pull/90
* Changed all version = "^x.y.z" into version = "x.y.z" and disabled default features and enable only the needed ones https://github.com/SeaQL/sea-schema/pull/93
* Skip parsing Postgres check constraints when check expression is empty https://github.com/SeaQL/sea-schema/pull/96
* Parsing Postgres citext column type https://github.com/SeaQL/sea-schema/pull/94

## 0.10.3 - 2022-11-16

* Backward compatible schema discovery for MySQL 5.6 https://github.com/SeaQL/sea-schema/pull/86

## 0.10.2 - 2022-10-26

* Fix parsing of Postgres user-defined types https://github.com/SeaQL/sea-schema/pull/84

## 0.10.1 - 2022-10-23

* Parse & write Postgres array datatypes https://github.com/SeaQL/sea-schema/pull/83

## 0.10.0 - 2022-10-18

* Upgrade SeaQuery to 0.27 https://github.com/SeaQL/sea-schema/pull/81

## 0.9.4 - 2022-09-16

* Parsing SQLite integer column types without space in it https://github.com/SeaQL/sea-schema/pull/77

## 0.9.3 - 2022-07-17

* SQLite real datatype maps to double https://github.com/SeaQL/sea-schema/pull/75
* Discover SYSTEM VERSIONED tables for MariaDB https://github.com/SeaQL/sea-schema/pull/76

## 0.9.2 - 2022-07-04

* PostgreSQL datetime and timestamp datatype are equivalent https://github.com/SeaQL/sea-schema/pull/69
* MySQL VarBinary column type mapping https://github.com/SeaQL/sea-schema/pull/67
* Upgrade `sqlx` to 0.6
* Upgrade `sea-query` to 0.26

## 0.8.1 - 2022-06-17

* Fix SQLx version to ^0.5 https://github.com/SeaQL/sea-schema/pull/70
* PostgreSQL query non-key foreign key info https://github.com/SeaQL/sea-schema/pull/65

## 0.8.0 - 2022-05-09

* Dropping `migration` entirely; introducing `SchemaProbe`

## 0.7.1 - 2022-03-26

* Support SeaORM 0.7.0
* Support Postgres jsonb in entity generation https://github.com/SeaQL/sea-schema/pull/51

## 0.6.0 - 2022-03-14

* Write MySQL unsigned integer types https://github.com/SeaQL/sea-schema/pull/37
* Fix Sqlite BLOB type https://github.com/SeaQL/sea-schema/pull/44
* Migrate with `sea_orm::DbConn` https://github.com/SeaQL/sea-schema/pull/49

## 0.5.1 - 2022-02-07

* Add `migration::prelude` to replace wildcard imports #43

## 0.5.0 - 2022-02-07

* Fix Postgres discover duplicated foreign keys by @billy1624 in https://github.com/SeaQL/sea-schema/pull/30
* Schema Manager by @billy1624 in https://github.com/SeaQL/sea-schema/pull/26

**Full Changelog**: https://github.com/SeaQL/sea-schema/compare/0.4.0...0.5.0

## 0.4.0 - 2021-12-25

* SQLite schema discovery https://github.com/SeaQL/sea-schema/pull/34

## 0.3.1 - 2021-12-12

* Add support for the Postgres interval type by @autarch in https://github.com/SeaQL/sea-schema/pull/20
* CI: Clippy, MySQL & Postgres by @billy1624 in https://github.com/SeaQL/sea-schema/pull/21
* Write MySQL & Postgres Enum Columns by @billy1624 in https://github.com/SeaQL/sea-schema/pull/29

**Full Changelog**: https://github.com/SeaQL/sea-schema/compare/0.2.9...0.3.1

## 0.2.9 - 2021-09-24

+ [[#18]] MySQL: handle panic upon unique constraint

[#18]: https://github.com/SeaQL/sea-schema/issues/18

## 0.2.8 - 2021-09-17

+ Fix Postgres `TimestampWithTimeZone`

## 0.2.7 - 2021-08-23

+ Use SeaRc to support SeaQuery's `thread-safe`

## 0.2.6 - 2021-08-21

+ Use sea-query to 0.15
+ [[#13]] Added `is_identity` to Postgres `ColumnInfo`

[#13]: https://github.com/SeaQL/sea-schema/issues/13

## 0.2.5 - 2021-08-14

+ improve Postgres schema discovery

## 0.2.4 - 2021-08-07

+ improve Postgres schema discovery

## 0.2.3 - 2021-06-19

+ Improve `ColumnType` output of MySQL writer

## 0.2.2 - 2021-06-19

+ Added `ColumnExpression` to MySQL ColumnInfo output
+ Postgres type definitions

## 0.2.1 - 2021-04-30

+ Foreign key writer
+ Index prefix and order

## 0.2.0 - 2021-04-25

+ `Writer`
+ changed `StringAttr` definition
+ added `IndexPart` definition

## 0.1.4 - 2021-04-13

+ serde support on types
+ Query table's `char_set` from information_schema

## 0.1.3 - 2021-04-11

+ `TableInfo` includes `char_set`

## 0.1.2 - 2021-04-11

+ Restructure dependencies

## 0.1.1 - 2021-04-08

+ Fix docs.rs

## 0.1.0 - 2021-04-08

+ Initial release