support exclude column

[yuhaya]

Motivation

The data table has 20 fields, but I only want to query 19 of them. Sea-orm does not seem to support field exclusion at present. It is too troublesome to call .column() 19 times

Proposed Solutions

add select api

fn column_exclude<C>(mut self, col: C) -> Self
    where
        C: ColumnTrait,
    {
        // code...
        self
    }

[billy1624]

Hey @yuhaya, welcome!! Thanks for the suggestions! I just created a PR to perform similar operation.

sea-orm/src/query/helper.rs

Lines 115 to 131 in 1520bea

	/// Conditionally select all columns expect a specific column
	///
	/// ```
	/// use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};
	///
	/// assert_eq!(
	/// cake::Entity::find()
	/// .select_only()
	/// .columns(cake::Column::iter().filter(|col| match col {
	/// cake::Column::Id => false,
	/// _ => true,
	/// }))
	/// .build(DbBackend::Postgres)
	/// .to_string(),
	/// r#"SELECT "cake"."name" FROM "cake""#
	/// );
	/// ```

[yuhaya]

Hey @yuhaya, welcome!! Thanks for the suggestions! I just created a PR to perform similar operation.

sea-orm/src/query/helper.rs

Lines 115 to 131 in 1520bea

	/// Conditionally select all columns expect a specific column
	///
	/// ```
	/// use sea_orm::{entity::*, query::*, tests_cfg::cake, DbBackend};
	///
	/// assert_eq!(
	/// cake::Entity::find()
	/// .select_only()
	/// .columns(cake::Column::iter().filter(|col| match col {
	/// cake::Column::Id => false,
	/// _ => true,
	/// }))
	/// .build(DbBackend::Postgres)
	/// .to_string(),
	/// r#"SELECT "cake"."name" FROM "cake""#
	/// );
	/// ```

good!