xql

An SQL query builder for sqlx. Work in progress

example usages

Suppose you have a table like this:

sql CREATE TABLE book( id INTEGER NOT NULL PRIMARY KEY, title TEXT NOT NULL, year SMALLINT NOT NULL, author TEXT );

The CRUD (or ISUD with sql acronym) will be look like this:

INSERT statement.

```rust let book1 = "The Fellowship of the Rings".tostring(); let auth1 = "J. R. R. Tolkien".tostring(); let book2 = "Dune".tostring(); let auth2 = "Frank Herbret".tostring();

let insert = xql::insert("book", ["id", "title", "year", "author"]) .values([ (1i32, &book1, 1954i16, &auth1), (2i32, &book2, 1965i16, &auth2), ]) .returning(["id"]);

asserteq!( insert.tostring(), "INSERT INTO book(id, title, year, author) VALUES \ (1, 'The Fellowship of the Rings', 1954, 'J. R. R. Tolkien'), \ (2, 'Dune', 1965, 'Frank Herbret') \ RETURNING id", ); ```

SELECT statement.

```rust use xql::blanket::ExprExt; use xql::ops::or;

let select = xql::select(["id", "title"]) .from("book") .filter(or( "id".equal(1), "id".equal(2), )) .order_by(xql::desc("year"));

asserteq!( select.tostring(), "SELECT id, title \ FROM book \ WHERE id = 1 OR id = 2 \ ORDER BY year DESC" ); ```

UPDATE statement.

```rust let author = &"Frank Herbert".to_string(); let update = xql::update("book") .set("author", author) .filter(xql::eq("id", 2)) .returning(["id"]);

asserteq!( update.tostring(), "UPDATE book \ SET author = 'Frank Herbert' \ WHERE id = 2 \ RETURNING id", ); ```

DELETE statement.

```rust let delete = xql::delete("book") .filter(xql::eq("id", 1)) .returning(["id", "title"]);

asserteq!( delete.tostring(), "DELETE FROM book \ WHERE id = 1 \ RETURNING id, title", ); ```

To execute those queries, add sqlx to dependencies and enable the backend.

```rust

[cfg(all(feature = "postgres", not(feature = "mysql"), not(feature = "sqlite")))]

async fn execute<'a>( pool: sqlx::Pool, insert: xql::stmt::insert::Insert<'a>, select: xql::stmt::select::Select<'a>, update: xql::stmt::update::Update<'a>, delete: xql::stmt::delete::Delete<'a>, ) -> Result<(), sqlx::Error> { xql::exec::fetchall(insert, &pool).await?; xql::exec::fetchall(select, &pool).await?; xql::exec::fetchall(update, &pool).await?; xql::exec::fetchall(delete, &pool).await?; Ok(()) }

[cfg(all(not(feature = "postgres"), feature = "mysql", not(feature = "sqlite")))]

[cfg(all(not(feature = "postgres"), not(feature = "mysql"), feature = "sqlite"))]