IMPORTANT - sqlb 0.5.x has a TOTALLY NEW STRATEGY and IMPLEMENTATION

• It is now not built on top of sqlx anymore (no sqlx dependencies)
• But on top of sea-query
• So, instead of providing a sea-query alternative solution, it now adds on top of sea-query

The result is a bit more verbose, but it takes full advantage of sea-query:

• Mature and expressive SQL builder API, with joins and more.
• Multi-driver support (postgres/tokio-postgres, rusqlite, sqlx/* diesel/*)

So, sqlb just adds the missing mile:

• HasFields trait on struct, to provide a list of columns, and columns/values for struct instance.
• #[derive(Fields)] proc derive macro to implement HasFields
• fields.zip() and fields.unzip() to conveniently transform a field list to the columns/values expected by sea-query query builders.

And more to come.

See Rust web-app production code blueprint on rust10x.com for an example of how this is used in a production code envornement

Quick Example

• When annotating a struct with #[Derive(sqlb::Fields)]

// sqlb::Fields 
#[derive(sqlb::Fields, Debug, Default)]
struct TodoForCreate {
	title: String,
	done: Option<bool>, // if None, not set, so db default (false)
	#[field(name = "description")]
	desc: Option<String>, // if None, not set, so db default (false)
}

• The following functions/methods are available:

Full examples

See alpha_v050/examples

cargo run -p example-tokio-postgres
cargo run -p example-sqlx-postgres

Notes for other databases

Note: Currently, sqlb is completely DB-unaware, meaning that the examples provided above could be adapted to MySQL or SQLite by simply changing the DB Driver and Sea-Query binding dependency. For reference, see sea-query examples.

Changelog

! breaking change, ^ enhancement, + addition, - fix.

• 0.5.0-alpha.x FULL REWRITE AND DIFFERENT STRATEGY - SEA-QUERY based now
• 0.4.0 - 2023-11-21
  • ^ Updated to sqlx 0.7
• 0.3.3 .. 0.3.8 - 2023-08-03
  • + generic types for bindable! macro. PR from KaiserBh
  • + chrono binding under the feature chrono_support. PR from KaiserBh
  • Thanks to eboody for the potential sqlx conflict (see PR 3).
• 0.3.2 .. 0.3.7
  • + Add support for partial and fully qualified table and column names. #8
  • + Add SqlxBindable blanket implementation for Option<T>. #7
  • + Add .limit(..) and .offset(..) for Select.
  • + Add .count() for Select.
  • + Add #[field(skip)] and #[field(name="other_name")] to skip or rename properties.
• 0.3.1
  • ! BREAKING CHANGE - HasFields.fields has been rename to HasFields.not_none_fields().
  • ! BREAKING CHANGE - HasFields.not_none_fields() and HasFields.all_fields() consume the self (to avoid uncessary clone).
  • + - HasFields.all_fields() - returns all fields (even the one where value are None).
  • + - HasFields::field_names(): &'static [&'static] - list of field names (i.e., column names).
  • + - Added SqlxBindable for the Option<T> (not a blanket impl at this point).
  • 0.3.0 been deprecated since did not have the ...fields(self) behavior.
• 0.2.0
  • Changing the generic order to match sqlx. From .fetch_one::<(i64, String), _> to .fetch_one::<_, (i64, String)>
• 0.0.7

  • sqlb::insert().table("todo") (in 0.0.7) rather than sqlb::insert("toto") (<=0.0.6) (for all SqlBuilders)

For sqlb Dev

Start a PostgreSQL

# In terminal 1 - start postges
docker run --rm --name pg -p 5432:5432  -e POSTGRES_PASSWORD=welcome  postgres:15

# In terminal 2 - (optional) launch psql on the Postgres instance above
docker exec -it -u postgres pg psql

# In terminal 3 -
cargo test

# or watch a particular test target
cargo watch -q -c -x 'test --test test_sb_insert