Sea Query Versions Save

🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

0.31.0-rc.6

1 month ago

New Features

Added table_name attribute to enum_def macro https://github.com/SeaQL/sea-query/pull/759

Breaking Changes

Rework SQLite type mapping https://github.com/SeaQL/sea-query/pull/735

assert_eq!(
    Table::create()
        .table(Alias::new("strange"))
        .col(ColumnDef::new(Alias::new("id")).integer().not_null().auto_increment().primary_key())
        .col(ColumnDef::new(Alias::new("int1")).integer())
        .col(ColumnDef::new(Alias::new("int2")).tiny_integer())
        .col(ColumnDef::new(Alias::new("int3")).small_integer())
        .col(ColumnDef::new(Alias::new("int4")).big_integer())
        .col(ColumnDef::new(Alias::new("string1")).string())
        .col(ColumnDef::new(Alias::new("string2")).string_len(24))
        .col(ColumnDef::new(Alias::new("char1")).char())
        .col(ColumnDef::new(Alias::new("char2")).char_len(24))
        .col(ColumnDef::new(Alias::new("text_col")).text())
        .col(ColumnDef::new(Alias::new("json_col")).json())
        .col(ColumnDef::new(Alias::new("uuid_col")).uuid())
        .col(ColumnDef::new(Alias::new("decimal1")).decimal())
        .col(ColumnDef::new(Alias::new("decimal2")).decimal_len(12, 4))
        .col(ColumnDef::new(Alias::new("money1")).money())
        .col(ColumnDef::new(Alias::new("money2")).money_len(12, 4))
        .col(ColumnDef::new(Alias::new("float_col")).float())
        .col(ColumnDef::new(Alias::new("double_col")).double())
        .col(ColumnDef::new(Alias::new("date_col")).date())
        .col(ColumnDef::new(Alias::new("time_col")).time())
        .col(ColumnDef::new(Alias::new("datetime_col")).date_time())
        .col(ColumnDef::new(Alias::new("boolean_col")).boolean())
        .col(ColumnDef::new(Alias::new("binary2")).binary_len(1024))
        .col(ColumnDef::new(Alias::new("binary3")).var_binary(1024))
        .col(ColumnDef::new(Alias::new("binary4")).blob())
        .to_string(SqliteQueryBuilder),
    [
        r#"CREATE TABLE "strange" ( "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,"#,
            r#""int1" integer,"#,
            r#""int2" tinyint,"#,
            r#""int3" smallint,"#,
            r#""int4" bigint,"#,
            r#""string1" varchar,"#,
            r#""string2" varchar(24),"#,
            r#""char1" char,"#,
            r#""char2" char(24),"#,
            r#""text_col" text,"#,
            r#""json_col" json_text,"#,
            r#""uuid_col" uuid_text,"#,
            r#""decimal1" real,"#,
            r#""decimal2" real(12, 4),"#,
            r#""money1" real_money,"#,
            r#""money2" real_money(12, 4),"#,
            r#""float_col" float,"#,
            r#""double_col" double,"#,
            r#""date_col" date_text,"#,
            r#""time_col" time_text,"#,
            r#""datetime_col" datetime_text,"#,
            r#""boolean_col" boolean,"#,
            r#""binary2" blob(1024),"#,
            r#""binary3" varbinary_blob(1024),"#,
            r#""binary4" blob"#,
        r#")"#,
    ]
    .join(" ")
);

MySQL money type maps to decimal
MySQL blob types moved to sea_query::extension::mysql::MySqlType; ColumnDef::blob() now takes no parameters

assert_eq!(
    Table::create()
        .table(BinaryType::Table)
        .col(ColumnDef::new(BinaryType::BinaryLen).binary_len(32))
        .col(ColumnDef::new(BinaryType::Binary).binary())
        .col(ColumnDef::new(BinaryType::Blob).blob())
        .col(ColumnDef::new(BinaryType::TinyBlob).custom(MySqlType::TinyBlob))
        .col(ColumnDef::new(BinaryType::MediumBlob).custom(MySqlType::MediumBlob))
        .col(ColumnDef::new(BinaryType::LongBlob).custom(MySqlType::LongBlob))
        .to_string(MysqlQueryBuilder),
    [
        "CREATE TABLE `binary_type` (",
            "`binlen` binary(32),",
            "`bin` binary(1),",
            "`b` blob,",
            "`tb` tinyblob,",
            "`mb` mediumblob,",
            "`lb` longblob",
        ")",
    ]
    .join(" ")
);

ColumnDef::binary() set column type as binary with default length of 1
Removed BlobSize enum
Added StringLen to represent length of var-char/binary

/// Length for var-char/binary; default to 255
#[derive(Debug, Default, Clone, Copy, PartialEq, Eq)]
pub enum StringLen {
    /// String size
    N(u32),
    Max,
    #[default]
    None,
}

ValueType::columntype() of Vec<u8> maps to VarBinary(StringLen::None)
ValueType::columntype() of String maps to String(StringLen::None)
ColumnType::Bit maps to bit for Postgres
ColumnType::Binary and ColumnType::VarBinary map to bytea for Postgres
Value::Decimal and Value::BigDecimal bind as real for SQLite
ColumnType::Year(Option<MySqlYear>) changed to ColumnType::Year

Enhancements

Added IntoColumnDef trait, allowing &mut ColumnDef / ColumnDef as argument
Added ColumnType::string() and ColumnType::var_binary() as shim for old API
Added ON DUPLICATE KEY DO NOTHING polyfill for MySQL https://github.com/SeaQL/sea-query/pull/765

House keeping

Added ColumnType mapping documentation
Replace derivative with educe https://github.com/SeaQL/sea-query/pull/763

Upgrades

Upgrade rusqlite to 0.31 https://github.com/SeaQL/sea-query/pull/755

0.31.0-rc.5

1 month ago

New Features

Added table_name attribute to enum_def macro https://github.com/SeaQL/sea-query/pull/759

Breaking Changes

Rework SQLite type mapping https://github.com/SeaQL/sea-query/pull/735

assert_eq!(
    Table::create()
        .table(Alias::new("strange"))
        .col(ColumnDef::new(Alias::new("id")).integer().not_null().auto_increment().primary_key())
        .col(ColumnDef::new(Alias::new("int1")).integer())
        .col(ColumnDef::new(Alias::new("int2")).tiny_integer())
        .col(ColumnDef::new(Alias::new("int3")).small_integer())
        .col(ColumnDef::new(Alias::new("int4")).big_integer())
        .col(ColumnDef::new(Alias::new("string1")).string())
        .col(ColumnDef::new(Alias::new("string2")).string_len(24))
        .col(ColumnDef::new(Alias::new("char1")).char())
        .col(ColumnDef::new(Alias::new("char2")).char_len(24))
        .col(ColumnDef::new(Alias::new("text_col")).text())
        .col(ColumnDef::new(Alias::new("json_col")).json())
        .col(ColumnDef::new(Alias::new("uuid_col")).uuid())
        .col(ColumnDef::new(Alias::new("decimal1")).decimal())
        .col(ColumnDef::new(Alias::new("decimal2")).decimal_len(12, 4))
        .col(ColumnDef::new(Alias::new("money1")).money())
        .col(ColumnDef::new(Alias::new("money2")).money_len(12, 4))
        .col(ColumnDef::new(Alias::new("float_col")).float())
        .col(ColumnDef::new(Alias::new("double_col")).double())
        .col(ColumnDef::new(Alias::new("date_col")).date())
        .col(ColumnDef::new(Alias::new("time_col")).time())
        .col(ColumnDef::new(Alias::new("datetime_col")).date_time())
        .col(ColumnDef::new(Alias::new("boolean_col")).boolean())
        .col(ColumnDef::new(Alias::new("binary2")).binary_len(1024))
        .col(ColumnDef::new(Alias::new("binary3")).var_binary(1024))
        .to_string(SqliteQueryBuilder),
    [
        r#"CREATE TABLE "strange" ( "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,"#,
            r#""int1" integer,"#,
            r#""int2" tinyint,"#,
            r#""int3" smallint,"#,
            r#""int4" bigint,"#,
            r#""string1" varchar,"#,
            r#""string2" varchar(24),"#,
            r#""char1" char,"#,
            r#""char2" char(24),"#,
            r#""text_col" text,"#,
            r#""json_col" json_text,"#,
            r#""uuid_col" uuid_text,"#,
            r#""decimal1" real,"#,
            r#""decimal2" real(12, 4),"#,
            r#""money1" real_money,"#,
            r#""money2" real_money(12, 4),"#,
            r#""float_col" float,"#,
            r#""double_col" double,"#,
            r#""date_col" date_text,"#,
            r#""time_col" time_text,"#,
            r#""datetime_col" datetime_text,"#,
            r#""boolean_col" boolean,"#,
            r#""binary2" blob(1024),"#,
            r#""binary3" varbinary_blob(1024)"#,
        r#")"#,
    ]
    .join(" ")
);

MySQL money type maps to decimal
MySQL blob types moved to sea_query::extension::mysql::MySqlType; ColumnDef::blob() now takes no parameters

assert_eq!(
    Table::create()
        .table(BinaryType::Table)
        .col(ColumnDef::new(BinaryType::BinaryLen).binary_len(32))
        .col(ColumnDef::new(BinaryType::Binary).binary())
        .col(ColumnDef::new(BinaryType::Blob).custom(MySqlType::Blob))
        .col(ColumnDef::new(BinaryType::TinyBlob).custom(MySqlType::TinyBlob))
        .col(ColumnDef::new(BinaryType::MediumBlob).custom(MySqlType::MediumBlob))
        .col(ColumnDef::new(BinaryType::LongBlob).custom(MySqlType::LongBlob))
        .to_string(MysqlQueryBuilder),
    [
        "CREATE TABLE `binary_type` (",
            "`binlen` binary(32),",
            "`bin` binary(1),",
            "`b` blob,",
            "`tb` tinyblob,",
            "`mb` mediumblob,",
            "`lb` longblob",
        ")",
    ]
    .join(" ")
);

ColumnDef::binary() set column type as binary with default length of 1
Removed BlobSize enum
Added StringLen to represent length of var-char/binary

/// Length for var-char/binary; default to 255
#[derive(Debug, Default, Clone, Copy, PartialEq, Eq)]
pub enum StringLen {
    /// String size
    N(u32),
    Max,
    #[default]
    None,
}

ValueType::columntype() of Vec<u8> maps to VarBinary(StringLen::None)
ValueType::columntype() of String maps to String(StringLen::None)
ColumnType::Bit maps to bit for Postgres
ColumnType::Binary and ColumnType::VarBinary map to bytea for Postgres
Value::Decimal and Value::BigDecimal bind as real for SQLite
ColumnType::Year(Option<MySqlYear>) changed to ColumnType::Year

Enhancements

Added IntoColumnDef trait, allowing &mut ColumnDef / ColumnDef as argument
Added ColumnType::string() and ColumnType::var_binary() as shim for old API
Added ON DUPLICATE KEY DO NOTHING polyfill for MySQL https://github.com/SeaQL/sea-query/pull/765

House keeping

Added ColumnType mapping documentation
Replace derivative with educe https://github.com/SeaQL/sea-query/pull/763

Upgrades

Upgrade rusqlite to 0.31 https://github.com/SeaQL/sea-query/pull/755

0.30.7

4 months ago

Enhancements

Added SelectStatement::apply https://github.com/SeaQL/sea-query/pull/730

House keeping

Slight refactors and documentation update

0.30.6

4 months ago

House keeping

Fix clippy warnings on Rust 1.75 https://github.com/SeaQL/sea-query/pull/729

sea-query-rusqlite/0.5.0

4 months ago

Upgrade rusqlite to 0.30 https://github.com/SeaQL/sea-query/pull/728

0.30.5

5 months ago

New Features

Added feature flag option-more-parentheses to have more parentheses in expressions https://github.com/SeaQL/sea-query/pull/723
Added feature flag option-sqlite-exact-column-type to only use integer for SQLite
Support COUNT(DISTINCT "column") https://github.com/SeaQL/sea-query/pull/700
Support index hints for MySQL (via extension::mysql::MySqlSelectStatementExt) https://github.com/SeaQL/sea-query/pull/636
Support expressions for ON CONFLICT targets https://github.com/SeaQL/sea-query/pull/692

Enhancements

Add from_clear to allow emptying current from tables in select statement https://github.com/SeaQL/sea-query/pull/716

Breaking Changes

Caution: do not use the --all-features param in Cargo. If you want to enable all features, use the all-features feature flag instead.

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.30.4...0.30.5

0.30.4

5 months ago

Enhancements

Impl QueryStatementWriter as inherent methods for WithQuery

0.30.3

5 months ago

New Features

Added LTree column type https://github.com/SeaQL/sea-query/pull/604
Improved parenthesis omission logic

Bug Fixes

Fixed BIGINT PRIMARY KEY AUTOINCREMENT for SQLite https://github.com/SeaQL/sea-query/issues/689

Upgrades

Upgrade chrono to 0.4.27

Breaking changes

Removed ToTokens for PgInterval https://github.com/SeaQL/sea-query/pull/710

sea-query-derive/0.4.1

7 months ago

Upgrade syn to 2

0.30.2

7 months ago

sea-query-diesel/0.1.0

Bug Fixes

Fixed incorrect behavior when adding an autoincrement column for Postgres https://github.com/SeaQL/sea-query/pull/697

Enhancements

Make ValueTuple hashable