More information for DbErr::Query

[TheCataliasTNT2k]

Motivation

If you get an DbErr::Query Error, it would be great, if you could get more information, like
executed query including parameters
and the database error like "Duplication in column foo while inserting"

This can be useful for other DbErr types as well...

Proposed Solutions

Adding DbErr::Query::query and DbErr::Query::response

[billy1624]

Hey @TheCataliasTNT2k, you can get the database specific error code and error message from it.

sea-orm/tests/crud/error.rs

Lines 24 to 55 in f360e79

	// if compiling without sqlx, this assignment will complain,
	// but the whole test is useless in that case anyway.
	#[allow(unused_variables)]
	let error: DbErr = cake
	.into_active_model()
	.insert(db)
	.await
	.expect_err("inserting should fail due to duplicate primary key");
	#[cfg(any(feature = "sqlx-mysql", feature = "sqlx-sqlite"))]
	match &error {
	DbErr::Exec(RuntimeErr::SqlxError(error)) => match error {
	Error::Database(e) => {
	#[cfg(feature = "sqlx-mysql")]
	assert_eq!(e.code().unwrap(), "23000");
	#[cfg(feature = "sqlx-sqlite")]
	assert_eq!(e.code().unwrap(), "1555");
	}
	_ => panic!("Unexpected sqlx-error kind"),
	},
	_ => panic!("Unexpected Error kind"),
	}
	#[cfg(feature = "sqlx-postgres")]
	match &error {
	DbErr::Query(RuntimeErr::SqlxError(error)) => match error {
	Error::Database(e) => {
	assert_eq!(e.code().unwrap(), "23505");
	}
	_ => panic!("Unexpected sqlx-error kind"),
	},
	_ => panic!("Unexpected Error kind"),
	}

[TheCataliasTNT2k]

Yes, but I want to get the query and parameters as well.
E.g.: Insert with duplicate column parameter (like username, which is already taken). I would like to know, which parameter was duplicated and which value was the cause for the error.