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:

1. INSERT statement.

```rust let values = [ ( 1i32, &"The Fellowship of the Rings".tostring(), 1954i16, &"J. R. R. Tolkien".tostring(), ), ( 2i32, &"Dune".tostring(), 1965i16, &"Frank Herbret".tostring() ), ]; let insert = xql::insert("book", ["id", "title", "year", "author"]) .values(values) .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", ); ```

1. SELECT statement.

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

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

1. 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", ); ```

1. 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 no_run

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

async fn execute(pool: sqlx::Pool) -> Result<(), sqlx::Error> { xql::postgres::fetchall(pool, insert).await?; xql::postgres::fetchall(pool, select).await?; xql::postgres::fetchall(pool, update).await?; xql::postgres::fetchall(pool, delete).await?; Ok(()); }

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

async fn execute(pool: sqlx::Pool) -> Result<(), sqlx::Error> { xql::postgres::fetchall(pool, insert).await?; xql::postgres::fetchall(pool, select).await?; xql::postgres::fetchall(pool, update).await?; xql::postgres::fetchall(pool, delete).await?; Ok(()); }

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

async fn execute(pool: sqlx::Pool) -> Result<(), sqlx::Error> { xql::postgres::fetchall(pool, insert).await?; xql::postgres::fetchall(pool, select).await?; xql::postgres::fetchall(pool, update).await?; xql::postgres::fetchall(pool, delete).await?; Ok(()); } ```