Crate derive_sql

The crate derive_sql is articulated around two traits.

The trait Sqlable that defines a set of operation for interacting with SQL tables:

• count to provide a count of the number of items in the table.
• select to return an array of the items in the table.
• insert to insert a new item in the table.
• update to update an existing item(s) with the values of the provided item.
• delete to delete items in the table.
• delete_table to drop the table.

Implementation of the trait should allow the user of the trait to interact with the table via the above interface…

The trait Selectable provides a possible interface for selector queries used in the Sqlable trait. It is a possible option - but not limited to it as the Sqlable trait uses an associated type for Selector.

This crate includes the derive macro DeriveSqlite [when compiled with the feature --features sqlite] which provides an implementation of the Sqlable trait for SQLite as a wrapper around the rusqlite crate.

Please see examples here and the DeriveSqlite documentation.

Features:

• sqlite provide a derive macro to implement the Sqlable trait for SQLite database (implemented as a wrapper around the rusqlite crate);
• with-mock provide a MockSqlable implementation of the Sqlable trait to use in testing.

Structs

• SimpleFilter
  Convenient struct for implementing a simple filter, ie a struct that generates the content of a simple WHERE a = value clause
• SimpleLimit
  Convenient struct for implementing a limit, ie a struct that generates the content of a LIMIT value clause
• SimpleOffset
  Convenient struct for implementing am offset, ie a struct that generates the content of an OFFSET value clause

Traits

• Selectable
  Definition of trait Selectable. This trait outputs filter, limit and offset statement.
• Sqlable
  Definition of Sqlable trait to be implemented to allow interaction with SQL tables.