Change Log
All user visible changes to this project will be documented in this file. This project adheres to Semantic Versioning, as described for Rust libraries in RFC #1105
1.0.1 - 2018-01-23
Fixed
- Diesel's internal dependencies have been locked more restrictively.
diesel1.0.0 would resolve todiesel_derives(an internal dependency) 1.1.1, which assumes it is being used with Diesel 1.1.1. Any dependencies Diesel internal crates and the rest of its dependencies have been locked down.
1.0.0 - 2018-01-02
Added
-
#[derive(QueryableByName)]can now handle structs that have no associated table. If the#[table_name]annotation is left off, you must annotate each field with#[sql_type = "Integer"] -
#[derive(QueryableByName)]can now handle embedding other structs. To have a field whose type is a struct which implementsQueryableByName, rather than a single column in the query, add the annotation#[diesel(embed)] -
The
QueryDsltrait encompasses the majority of the traits that were previously in thequery_dslmodule.
Fixed
-
Executing select statements on SQLite will no longer panic when the database returns
SQLITE_BUSY -
table!s which use theDatetimetype with MySQL will now compile correctly, even without thechronofeature enabled. -
#[derive(QueryableByName)]will now compile correctly when there is a shadowedResulttype in scope. -
BoxableExpressioncan now be used with types that are not'static
Changed
-
Connection::test_transactionnow requires that the error returned implementDebug. -
query_builder::insert_statement::InsertStatementis now accessed asquery_builder::InsertStatement -
query_builder::insert_statement::UndecoratedInsertRecordis now accessed asquery_builder::UndecoratedInsertRecord -
#[derive(QueryableByName)]now requires that the table name be explicitly stated. -
Most of the traits in
query_dslhave been moved toquery_dsl::methods. These traits are no longer exported inprelude. This should not affect most apps, as the behavior of these traits is provided byQueryDsl. However, if you were using these traits inwhereclauses for generic code, you will need to explicitly douse diesel::query_dsl::methods::WhateverDsl. You may also need to use UFCS in these cases. -
If you have a type which implemented
QueryFragmentorQuery, which you intended to be able to callexecuteorloadon, you will need to manually implementRunQueryDslfor that type. The trait should be unconditionally implemented (no where clause beyond what your type requires), and the body should be empty.
Removed
-
All deprecated items have been removed.
-
LoadDslandFirstDslhave been removed. Their functionality now lives inLoadQuery.
0.99.1 - 2017-12-01
Changed
- Diesel CLI now properly restricts its
clapdependency. 0.99.0 mistakenly had no upper bound on the version.
0.99.0 - 2017-11-28
Added
-
The
.for_update()method has been added to select statements, allowing construction ofSELECT ... FOR UPDATE. -
Added
insert_into(table).default_values()as a replacement forinsert_default_values() -
Added
insert_into(table).values(values)as a replacement forinsert(values).into(table). -
Added support for MySQL's
REPLACE INTOasreplace_into(table). -
Added
replace_into(table).values(values)as a replacement forinsert_or_replace(values).into(table). -
Added
on_conflict_do_nothingonInsertStatementas a replacement foron_conflict_do_nothingonInsertablestructs. -
Added
on_conflictonInsertStatementas a replacement foron_conflictonInsertablestructs. -
filtercan now be called on update and delete statements. This means that instead ofupdate(users.filter(...))you can writeupdate(users).filter(...). This allows line breaks to more naturally be introduced. -
Subselects can now reference columns from the outer table. For example,
users.filter(exists(posts.filter(user_id.eq(users::id))))will now compile. -
TextExpressionMethodsis now implemented for expressions of typeNullable<Text>as well asText. -
allow_tables_to_appear_in_same_query!can now take more than 2 tables, and is the same as invoking it separately for every combination of those tables. -
Added
sql_query, a new API for dropping to raw SQL that is more pleasant to use thansqlfor complete queries. The main difference fromsqlis that you do not need to state the return type, and data is loaded from the query by name rather than by index. -
Added a way to rename a table in the
table!macro with#[sql_name="the_table_name"] -
Added support for PostgreSQL's
DISTINCT ON. See.distinct_on()for more details
Changed
-
The signatures of
QueryId,Column, andFromSqlRowhave all changed to use associated constants where appropriate. -
You will now need to invoke
allow_tables_to_appear_in_same_query!any time two tables appear together in the same query, even if there is ajoinable!invocationfor those tables. -
diesel_codegenshould no longer explicitly be used as a dependency. Unless you are usinginfer_schema!orembed_migrations!, you can simply remove it from yourCargo.toml. All other functionality is now provided bydieselitself. -
Code using
infer_schema!orinfer_table_from_schema!must now adddiesel_infer_schematoCargo.toml, and#[macro_use] extern crate diesel_infer_schematosrc/lib.rs -
Code using
embed_migrations!must now adddiesel_migrationstoCargo.toml, and#[macro_use] extern crate diesel_migrationstosrc/lib.rs -
The
migrationsmodule has been moved out ofdieseland intodiesel_migrations
Deprecated
-
Deprecated
insert_default_values()in favor ofinsert_into(table).default_values() -
Deprecated
insert(values).into(table)in favor ofinsert_into(table).values(values). -
Deprecated
insert_or_replace(values).into(table)in favor ofreplace_into(table).values(values). -
Deprecated
.values(x.on_conflict_do_nothing())in favor of.values(x).on_conflict_do_nothing() -
Deprecated
.values(x.on_conflict(y, do_nothing()))in favor of.values(x).on_conflict(y).do_nothing() -
Deprecated
.values(x.on_conflict(y, do_update().set(z)))in favor of.values(x).on_conflict(y).do_update().set(z) -
Deprecated
enable_multi_table_joinsin favor ofallow_tables_to_appear_in_same_query! -
Deprecated
SqlLiteral#bind.sqlis intended for use with small fragments of SQL, not complete queries. Writing bind parameters in raw SQL when you are not writing the whole query is error-prone. Usesql_queryif you need raw SQL with bind parameters.
Removed
-
IntoInsertStatementandBatchInsertStatementhave been removed. It's unlikely that your application is using these types, butInsertStatementis now the only "insert statement" type. -
Citextas a type alias forTexthas been removed. Writingcitext_column.eq("foo")would perform a case-sensitive comparison. More fleshed out support will be required.
Fixed
-
When using MySQL and SQLite, dates which cannot be represented by
chrono(such as0000-00-00) will now properly return an error instead of panicking. -
MySQL URLs will now properly percent decode the username and password.
-
References to types other than
strand slice can now appear on structs which deriveInsertableorAsChangeset. -
Deserializing a date/time/timestamp column into a chrono type on SQLite will now handle any value that is in a format documented as valid for SQLite's
strftimefunction except for the string'now'.
0.16.0 - 2017-08-24
Added
-
Added helper types for inner join and left outer join
-
diesel::debug_queryhas been added as a replacement fordebug_sql!. This function differs from the macro by allowing you to specify the backend, and will generate the actual query which will be run. The returned value will implementDisplayandDebugto show the query in different ways -
diesel::pg::PgConnection,diesel::mysql::MysqlConnection, anddiesel::sqlite::SqliteConnectionare now exported fromdiesel::prelude. You should no longer need to import these types explicitly. -
Added support for the Decimal datatype on MySQL, using the BigDecimal crate.
-
Added support for the Range type on postgreSQL.
-
Added support for the Datetime type on MySQL.
-
Added support for the Blob type on MySQL.
-
infer_schema!will now automatically detect which tables can be joined based on the presence of foreign key constraints. -
Added support for
AddandSubto timestamp types. -
Added a way to rename columns in the table macro with
#[sql_name="the_column_name"] -
Schema inference now also generates documentation comments for tables and columns. For
infer_schema!, this is enabled by default. If you are using Diesel's CLI tool, pass the new--with-docsparameter:diesel print-schema --with-docs. -
infer_schema!now automatically renames columns that conflict with a Rust keyword by placing a _ at the end of the name. For example, a column calledtypewill be referenced astype_in Rust.
Changed
-
The deprecated
debug_sql!andprint_sql!functions will now generate backend specific SQL. (The specific backend they will generate for will be arbitrarily chosen based on the backends enabled). -
#[belongs_to]will no longer generate the code required to join between two tables. You will need to explicitly invokejoinable!instead, unless you are usinginfer_schema! -
Changed the migration directory name format to
%Y-%m-%d-%H%M%S. -
betweenandnot_betweennow take two arguments, rather than a range.
Removed
-
debug_sql!has been deprecated in favor ofdiesel::debug_query. -
print_sql!has been deprecated without replacement. -
diesel::backend::Debughas been removed.
Fixed
-
Diesel now properly supports joins in the form:
grandchild.join(child.join(parent)). Previously onlyparent.join(child.join(grandchild))would compile. -
When encoding a
BigDecimalon PG,1.0is no longer encoded as if it were1.
0.15.2 - 2017-07-28
Fixed
BigDecimalnow properly encodes numbers starting with10000on postgres. See issue #1044 for details.
0.15.1 - 2017-07-24
- No changes to public API
0.15.0 - 2017-07-23
Added
-
Added support for the PG
IS DISTINCT FROMoperator -
The
ONclause of a join can now be manually specified. See the docs for details.
Changed
-
Diesel will now automatically invoke
numeric_expr!for your columns in the common cases. You will likely need to delete any manual invocations of this macro. -
Insertableno longer treats all fields as nullable for type checking. What this means for you is that if you had an impl likeimpl AsExpression<Nullable<SqlType>, DB> for CustomTypein your code base, you can remove theNullableportion (Unless you are using it with fields that are actually nullable) -
Connections will now explicitly set the session time zone to UTC when the connection is established
0.14.1 - 2017-07-10
Changed
- The return type of
sumandavgis now always considered to beNullable, as these functions returnNULLwhen against on an empty table.
0.14.0 - 2017-07-04
Added
- Added support for joining between more than two tables. The query builder can
now be used to join between any number of tables in a single query. See the
documentation for
JoinDslfor details
-
Added support for the PostgreSQL network types
MACADDR. -
Added support for the Numeric datatypes, using the BigDecimal crate.
-
Added a function which maps to SQL
NOT. See the docs for more details. -
Added the
insert_default_valuesfunction.
- Added
diesel_prefix_operator!which behaves identically todiesel_postfix_operator!(previouslypostfix_predicate!), but for operators likeNOTwhich use prefix notation.
Changed
-
infix_predicate!andinfix_expression!have been renamed todiesel_infix_operator!. -
postfix_predicate!andpostfix_expression!have been renamed todiesel_postfix_operator!. -
Trait bounds along the lines of
T: LoadDsl<Conn>, U: Queryable<T::SqlType, Conn::Backend>should be changed toT: LoadQuery<Conn, U>. -
Diesel now uses a migration to set up its timestamp helpers. To generate this migration for your project, run
diesel database setup.
Removed
#[has_many]has been removed. Its functionality is now provided by#[belongs_to]on the child struct. If there is no child struct to put#[belongs_to]on, you can invokejoinable!directly instead.
0.13.0 - 2017-05-15
Added
-
Added support for chrono types with SQLite.
-
Bind values can now be supplied to queries constructed using raw SQL. See the docs for more details.
- Added support for the PostgreSQL network types
CIDRandINET.
-
Added support for
ILIKEin PostgreSQL. -
diesel migration listwill show all migrations, marking those that have been run. -
diesel migration pendingwill list any migrations which have not been run. -
Added support for numeric operations with nullable types.
Fixed
-
Diesel CLI now respects the
--migration-dirargument or theMIGRATION_DIRECTORYenvironment variable for all commands. -
Diesel CLI now properly escapes the database name.
0.12.1 - 2017-05-07
Changed
- Locked the chrono dependency to require exactly
0.3.0instead of a semver restriction. This restriction is required for the 0.12 line of releases to continue compiling, as the chrono project is including breaking changes in patch releases.
0.12.0 - 2017-03-16
Added
- Added support for the majority of PG upsert (
INSERT ON CONFLICT). We now support specifying the constraint, as well asDO UPDATEin addition toDO NOTHING. See the module docs for details.
- Added support for the SQL concatenation operator
||. See the docs for.concatfor more details.
- Added support for the PostgreSQL
Moneytype.
-
Diesel CLI: Added
dbas an alias fordatabase, so you can now writediesel db setup(which is almost 40% faster!). -
The
table!macro now allows you to use types from crates outside of Diesel. You can specify where types should be imported from by doing:table! { use some_modules::*; foo { columns... }. Not specifying any any modules is equivalent touse diesel::types::*;.
Fixed
-
diesel_codegenwill provide a more useful error message when it encounters an unsupported type that contains a space in MySQL. -
#[derive(AsChangeset)]will now respect custom#[primary_key]annotations, and avoid setting those columns.
Removed
-
WithDslandAliasedhave been removed. They were a feature that was actually closer to a cross join than the names implied, and wasn't fully thought out. The functionality they provided will return as joins are further revamped. -
The internal use macro
select_column_workaround!has been removed. If you were relying on this internal macro, you can simply delete the line that was calling it. -
Columns from the right side of a left join will now need to have
.nullable()explicitly called to be passed to.select. This allows it to compose better with functions that don't normally take nullable columns (e.g.lower(name).nullable()).
0.11.4 - 2017-02-21
Fixed
- Corrected a memory safety violation when using MySQL.
0.11.3 - 2017-02-21
- No changes
0.11.2 - 2017-02-19
Changed
pq-sysandmysqlclient-syswill no longer attempt to generate bindings at compile time. Generating the bindings required a bleeding edge version of clang, which caused too many issues.
0.11.1 - 2017-02-17
Fixed
-
.on_conflict_do_nothing()now interacts with slices properly. -
MysqlConnectionnow implementsSend, which is required for connection pooling.
0.11.0 - 2017-02-16
Added
- Added support for MySQL as an additional backend. Diesel CLI will install with
MySQL support by default. To enable it for Diesel and Diesel Codegen, add
features = ["mysql"]to Cargo.toml. See the docs for details.
- Added support for PG's
ON CONFLICT DO NOTHINGclause. See the docs for details.
- Queries constructed using
diesel::selectnow work properly when boxed.
-
Arrays containing null are now supported.
infer_schema!will never infer an array that contains null, but atable!definition which specifies a type ofArray<Nullable<X>>can now be deserialized toVec<Option<T>> -
#[belongs_to]associations can now be self referential. This will generate the code required forbelonging_to, without generating code for performing a join.
- Added support for the
rust-lang-deprecated/timecrate on PostgreSQL. To use it, addfeatures = ["deprecated-time"]
Changed
-
It is no longer possible to exhaustively match against
result::ConnectionError. -
Updated chrono to version 0.3.
-
maxandminare now always nullable. The database will returnNULLwhen the table is empty.
nowcan now be used as an expression of typeTimestamptz.
Connection::transactionnow returns your error directly instead of wrapping it inTransactionError. It requires that the error implementFrom<diesel::result::Error>
- The way tuples of columns from the right side of left outer joins interact
with
.selecthas changed. If you are deserializing into an option of a tuple (instead of a tuple of options), you will need to explicitly call.nullable(). (e.g..select(users::name, (posts::title, posts::body).nullable()))
Removed
result::TransactionErrorresult::TransactionResult
0.10.1 - 2017-02-08
Fixed
infer_table_from_schema!properly handles table names with a custom schema specified.
Changed
- Updated uuid to version 0.4.
0.10.0 - 2017-02-02
Added
- Added support for the PostgreSQL
jsonandjsonbtypes. They can be mapped to/fromserde_json::Value. Theserdefeature must be enabled to use the JSON types.
- Added the
print-schemacommand to Diesel CLI. This command will print the output of theinfer_schema!macro. For more information rundiesel help print-schema.
Changed
-
When possible, we will use deprecation warnings for breaking changes. Deprecated code requires the
with-deprecatedfeature, which is enabled by default. -
The
postgresfeature is no longer enabled by default bydieselordiesel_codegen_syntex. Addfeatures = ["postgres"]to yourCargo.toml. -
The
persistablemodule has been renamed toinsertable.
Fixed
#[derive(Insertable)]allows fields of typeOption<T>to be used with columns that are not null if they have a default value.
Removed
-
diesel_codegen_syntexis no longer supported.diesel_codegencan now be used on stable Rust. -
Dropped support for Rust 1.14 and earlier
0.9.1 - 2016-12-09
Fixed
-
Added missing impls for loading
chrono::NaiveDateTimefrom a column of typeTimestamptz -
#[derive(AsChangeset)]no longer assumes thatuse diesel::prelude::*has been done. -
debug_sql!can now properly be used with types fromchronoorstd::time. -
When using PostgreSQL, attempting to get the error message of a query which could not be transmitted to the server (such as a query with greater than 65535 bind parameters) will no longer panic.
0.9.0 - 2016-12-08
Added
-
Added support for SQL
NOT INusing thene_anymethod. -
The
table!macro now allows custom schemas to be specified. Example:table! { schema_1.table_1 { id -> Integer, } }
The generated module will still be called
table_1. -
The
infer_table_from_schema!macro now allows custom schemas to be specified. Example:infer_table_from_schema!("dotenv:DATABASE_URL", "schema_1.table_1");
-
The
infer_schema!optionally allows a schema name as the second argument. Any schemas other thanpublicwill be wrapped in a module with the same name as the schema. For example,schema_1.table_1would be referenced asschema_1::table_1. -
Added support for batch insert on SQLite. This means that you can now pass a slice or vector to
diesel::inserton all backends.
- Added a function for SQL
EXISTSexpressions. Seediesel::expression::dsl::existsfor details.
#[derive(Identifiable)]can be used with structs that have primary keys other thanid, as well as structs with composite primary keys. You can now annotate the struct with#[primary_key(nonstandard)]or#[primary_key(foo, bar)].
Changed
- All macros with the same name as traits we can derive (e.g.
Queryable!) have been renamed toimpl_Queryable!or similar.
Fixed
-
#[derive(Identifiable)]now works on structs with lifetimes -
Attempting to insert an empty slice will no longer panic. It does not execute any queries, but the result will indicate that we successfully inserted 0 rows.
-
Attempting to update a record with no changes will no longer generate invalid SQL. The result of attempting to execute the query will still be an error, but but it will be a
Error::QueryBuilderError, rather than a database error. This means that it will not abort the current transaction, and can be handled by applications. -
Calling
eq_anyorne_anywith an empty array no longer panics.eq_any(vec![])will return no rows.ne_any(vec![])will return all rows.
0.8.2 - 2016-11-22
Changed
-
Fixed support for nightlies later than 2016-11-07
-
Removed support for nightlies earlier than 2016-11-07
-
Calls to
infer_table_from_schema!will need to be wrapped in a module if called more than once. This change is to work around further limitations of the Macros 1.1 system. Example:mod infer_users { infer_table_from_schema!("dotenv:DATABASE_URL", "users"); } pub use self::infer_users::*;
0.8.1 - 2016-11-01
Added
- SQLite date and time columns can be deserialized to/from strings.
Fixed
- Fixed an issue with
diesel_codegenon nightlies >= 2016-10-20
0.8.0 - 2016-10-10
Added
-
Added partial support for composite primary keys.
-
Added support for PostgreSQL
NULLS FIRSTandNULLS LASTwhen sorting. See https://docs.diesel.rs/diesel/prelude/trait.SortExpressionMethods.html for details. -
Added support for the
timestamp with time zonetype in PostgreSQL (referred to asdiesel::types::Timestamptz) -
Diesel CLI can now generate bash completion. See the readme for details.
-
infer_schema!andinfer_table_from_schema!can now take"env:foo"instead ofenv!("foo")and"dotenv:foo"instead ofdotenv!("foo"). The use ofdotenvrequires thedotenvfeature ondiesel_codegen, which is included by default. Usingenv!anddotenv!will no longer work withdiesel_codegen. They continue to work withdiesel_codgen_syntex, but that crate will be deprecated when Macros 1.1 is in the beta channel for Rust.
Changed
-
Structs annotated with
#[has_many]or#[belongs_to]now require#[derive(Associations)]. This is to allow them to work with Macros 1.1. -
embed_migrations!now resolves paths relative toCargo.tomlinstead of the file the macro was called from. This change is required to allow this macro to work with Macros 1.1.
Fixed
diesel migrations runwill now respect migration directories overridden by command line argument or environment variable- The
infer_schema!macro will no longer fetch views alongside with tables. This was a source of trouble for people that had created views or are using any extension that automatically creates views (e.g. PostGIS)
Changed
#[changeset_for(foo)]should now be written as#[derive(AsChangeset)] #[table_name="foo"]. If you were specifyingtreat_none_as_null = "true", you should additionally have#[changeset_options(treat_none_as_null = "true")].#[insertable_into(foo)]should now be written as#[derive(Insertable)] #[table_name="foo"].
0.7.2 - 2016-08-20
- Updated nightly version and syntex support.
0.7.1 - 2016-08-11
Changed
- The
Copyconstraint has been removed fromIdentifiable::Id, andIdentifiable#idnow returns&Identifiable::Id.
Fixed
#[belongs_to]now respects theforeign_keyoption when usingdiesel_codegenordiesel_codegen_syntex.
0.7.0 - 2016-08-01
Added
-
The initial APIs have been added in the form of
#[has_many]and#[belongs_to]. See the module documentation for more information. -
The
Insertable!macro can now be used instead of#[insertable_into]for those wishing to avoid syntax extensions fromdiesel_codegen. See https://docs.diesel.rs/diesel/macro.Insertable!.html for details. -
The
Queryable!macro can now be used instead of#[derive(Queryable)]for those wishing to avoid syntax extensions fromdiesel_codegen. See https://docs.diesel.rs/diesel/macro.Queryable!.html for details. -
The
Identifiable!macro can now be used instead of#[derive(Identifiable)]for those wishing to avoid syntax extensions fromdiesel_codegen. See https://docs.diesel.rs/diesel/macro.Identifiable!.html for details. -
The
AsChangeset!macro can now be used instead of#[changeset_for(table)]for those wishing to avoid syntax extensions fromdiesel_codegen. See https://docs.diesel.rs/diesel/macro.AsChangeset!.html for details. -
Added support for the PostgreSQL
ALLoperator. See https://docs.diesel.rs/diesel/pg/expression/dsl/fn.all.html for details. -
Added support for
RETURNINGexpressions inDELETEstatements. Implicitly these queries will useRETURNING *.
Changed
-
Diesel now targets
nightly-2016-07-07. Future releases will update to a newer nightly version on the date that Rust releases. -
diesel_codegenhas been split into two crates.diesel_codegenanddiesel_codegen_syntex. See this commit for migration information. -
Most structs that implement
Queryablewill now also need#[derive(Identifiable)]. -
infer_schema!on SQLite now accepts a larger range of type names -
types::VarCharis now an alias fortypes::Text. Most code should be unaffected by this. PG array columns are treated slightly differently, however. If you are usingvarchar[], you should switch totext[]instead. -
Struct fields annotated with
#[column_name="name"]should be changed to#[column_name(name)]. -
The structure of
DatabaseErrorhas changed to hold more information. See https://docs.diesel.rs/diesel/result/enum.Error.html and https://docs.diesel.rs/diesel/result/trait.DatabaseErrorInformation.html for more information -
Structs which implement
Identifiablecan now be passed toupdateanddelete. This means you can now writedelete(&user).execute(&connection)instead ofdelete(users.find(user.id)).execute(&connection)
Fixed
&&[T]can now be used in queries. This allows using slices with things like#[insertable_into].
0.6.1 2016-04-14
Added
- Added the
escapemethod toLikeandNotLike, to specify the escape character used in the pattern. See EscapeExpressionMethods for details.
Fixed
-
diesel_codegenanddiesel_clinow properly rely on Diesel 0.6.0. The restriction to 0.5.0 was an oversight. -
infer_schema!now properly excludes metadata tables on SQLite. -
infer_schema!now properly maps types on SQLite.
0.6.0 2016-04-12
Added
-
Queries can now be boxed using the
into_boxed()method. This is useful for conditionally modifying queries without changing the type. See BoxedDsl for more details. -
infer_schema!is now supported for use with SQLite3. -
The maximum table size can be increased to 52 by enabling the
huge-tablesfeature. This feature will substantially increase compile times. -
The
DISTINCTkeyword can now be added to queries via thedistinct()method. -
SqliteConnectionnow implementsSend
Changed
-
diesel::result::Errornow implementsSendandSync. This required a change in the return type ofToSqlandFromSqlto have those bounds as well. -
It is no longer possible to pass an owned value to
diesel::insert.insertwill now give a more helpful error message when you accidentally try to pass an owned value instead of a reference.
Fixed
-
#[insertable_into]can now be used with structs that have lifetimes with names other than'a'. -
Tables with a single column now properly return a single element tuple. E.g. if the column was of type integer, then
users::all_columnsis now(id,)and notid. -
infer_schema!can now work with tables that have a primary key other thanid.
Removed
- Removed the
no selectoption for thetable!macro. This was a niche feature that didn't fit with Diesel's philosophies. You can write a function that callsselectfor you if you need this functionality.
0.5.4 2016-03-23
- Updated
diesel_codegento allow syntex versions up to 0.30.0.
0.5.3 2016-03-12
Added
-
Added helper function
diesel_manage_updated_at('TABLE_NAME')to postgres upon database setup. This function sets up a trigger on the specified table that automatically updates theupdated_atcolumn to thecurrent_timestampfor each affected row inUPDATEstatements. -
Added support for explicit
RETURNINGexpressions inINSERTandUPDATEqueries. Implicitly these queries will still useRETURNING *.
Fixed
- Updated to work on nightly from early March
0.5.2 2016-02-27
- Updated to work on nightly from late February
0.5.1 2016-02-11
- Diesel CLI no longer has a hard dependency on SQLite and PostgreSQL. It
assumes both by default, but if you need to install on a system that doesn't
have one or the other, you can install it with
cargo install diesel_cli --no-default-features --features postgresorcargo install diesel_cli --no-default-features --features sqlite
0.5.0 2016-02-05
Added
-
Added support for SQLite. Diesel still uses postgres by default. To use SQLite instead, add
default-features = false, features = ["sqlite"]to your Cargo.toml. You'll also want to adddefault-features = false, features = ["sqlite"]todiesel_codegen. Since SQLite is a much more limited database, it does not support our full set of features. You can use SQLite and PostgreSQL in the same project if you desire. -
Added support for mapping
types::Timestamp,types::Date, andtypes::Timeto/fromchrono::NaiveDateTime,chrono::NaiveDate, andchrono::NaiveTime. Addfeatures = ["chrono"]to enable. -
Added a
treat_none_as_nulloption tochangeset_for. When set totrue, a model will set a field toNullwhen an optional struct field isNone, instead of skipping the field entirely. The default value of the option isfalse, as we think the current behavior is a much more common use case. -
Added
Expression#nullable(), to allow comparisons of not null columns with nullable ones when required. -
Added
sumandavgfunctions. -
Added the
diesel setup,diesel database setup, anddiesel database resetcommands to the CLI. -
Added support for SQL
INstatements through theeq_anymethod. -
Added a top level
selectfunction for select statements with no from clause. This is primarily intended to be used for testing Diesel itself, but it has been added to the public API as it will likely be useful for third party crates in the future.select(foo).from(bar)might be a supported API in the future as an alternative tobar.select(foo). -
Added
expression::dsl::sqlas a helper function for constructingSqlLiteralnodes. This is primarily intended to be used for testing Diesel itself, but is part of the public API as an escape hatch if our query builder DSL proves inadequate for a specific case. Use of this function in any production code is discouraged as it is inherently unsafe and avoids real type checking.
Changed
-
Moved most of our top level trait exports into a prelude module, and re-exported our CRUD functions from the top level.
diesel::query_builder::updateand friends are nowdiesel::update, and you will get them by default if you importdiesel::*. For a less aggressive glob, you can importdiesel::prelude::*, which will only export our traits. -
Connectionis now a trait instead of a struct. The struct that was previously known asConnectioncan be found atdiesel::pg::PgConnection. -
Rename both the
#[derive(Queriable)]attribute and theQueriabletrait to use the correct spellingQueryable. -
loadandget_resultsnow return aVec<Model>instead of an iterator. -
Replaced
Connection#find(source, id)withsource.find(id).first(&connection). -
The
debug_sql!macro now uses ` for identifier quoting, and?for bind parameters, which is closer to a "generic" backend. The previous behavior had no identifier quoting, and used PG specific bind params. -
Many user facing types are now generic over the backend. This includes, but is not limited to
QueryableandChangeset. This change should not have much impact, as most impls will have been generated by diesel_codegen, and that API has not changed. -
The mostly internal
NativeSqlTypehas been removed. It now requires a known backend.fn<T> foo() where T: NativeSqlTypeis nowfn<T, DB> foo() where DB: HasSqlType<T>
Removed
Connection#query_sqlandConnection#query_sql_paramshave been removed. These methods were not part of the public API, and were only meant to be used for testing Diesel itself. However, they were technically callable from any crate, so the removal has been noted here. Their usage can be replaced with bareselectandexpression::dsl::sql.
0.4.1 2016-01-11
Changed
-
Diesel CLI will no longer output notices about
__diesel_schema_migrationsalready existing. -
Relicensed under MIT/Apache dual
0.4.0 2016-01-08
Added
-
Added Diesel CLI, a tool for managing your schema. See the readme for more information.
-
Add the ability for diesel to maintain your schema for you automatically. See the migrations module for individual methods.
-
Add DebugQueryBuilder to build sql without requiring a connection.
-
Add print_sql! and debug_sql! macros to print out and return sql strings from QueryFragments.
Fixed
-
#[changeset_for]can now be used with structs containing aVec. Fixes #63. -
No longer generate invalid SQL when an optional update field is not the first field on a changeset. Fixes #68.
-
#[changeset_for]can now be used with structs containing only a single field other thanid. Fixes #66. -
infer_schema!properly works with array columns. Fixes #65.
0.3.0 2015-12-04
Changed
-
#[changeset_for(table)]now treatsOptionfields as an optional update. Previously a field withNonefor the value would insertNULLinto the database field. It now does not update the field if the value isNone. -
.save_changes(generated by#[changeset_for]) now returns a new struct, rather than mutatingself. The returned struct can be any type that implementsQueryablefor the right SQL type
Fixed
-
#[derive(Queryable)]now allows generic parameters on the struct. -
Table definitions can now support up to 26 columns. Because this increases our compile time by 3x,
features = ["large-tables"]is needed to support table definitions above 16 columns.
Added
-
Quickcheck is now an optional dependency. When
features = ["quickcheck"]is added toCargo.toml, you'll gainArbitraryimplementations for everything indiesel::data_types. -
Added support for the SQL
MINfunction. -
Added support for the
Numericdata type. Since there is no Big Decimal type in the standard library, a dumb struct has been provided which mirrors what Postgres provides, which can be converted into whatever crate you are using. -
Timestamp columns can now be used with
std::time::SystemTimewhen compiled with--features unstable -
Implemented
SendonConnection(required for R2D2 support) -
Added
infer_schema!andinfer_table_from_schema!. Both macros take a database URL, and will invoketable!for you automatically based on the schema.infer_schema!queries for the table names, whileinfer_table_from_schema!takes a table name as the second argument.
0.2.0 - 2015-11-30
Added
-
Added an
executemethod toQueryFragment, which is intended to replaceConnection#execute_returning_count. The old method still exists for use under the hood, but has been hidden from docs and is not considered public API. -
Added
get_resultandget_results, which work similarly toloadandfirst, but are intended to make code read better when working with commands likecreateandupdate. In the future,get_resultmay also check that only a single row was affected. -
Added
insert, which mirrors the pattern ofupdateanddelete.
Changed
-
Added a hidden
__Nonexhaustivevariant toresult::Error. This is not intended to be something you can exhaustively match on, but I do want people to be able to check for specific cases, soBox<std::error::Error>is not an option. -
query_one,find, andfirstnow assume a single row is returned. For cases where you actually expect 0 or 1 rows to be returned, theoptionalmethod has been added to the result, in case having aResult<Option<T>>is more ideomatic than checking forErr(NotFound).
Deprecated
Connection#insertandConnection#insert_returning_counthave been deprecated in favor ofinsert
0.1.0 - 2015-11-29
- Initial release