include-sqlite-sql is an extension of include-sql for using SQLite SQL in Rust. It completes include-sql by providing impl_sql
macro to generate database access methods from the included SQL. include-sqlite-sql uses Rusqlite for database access.
Example
Write your SQL and save it in a file. For example, let's say the following is saved as library.sql
in the project's sql
folder:
-- name: get_loaned_books ?
--
-- Returns the list of books loaned to a patron
--
-- # Parameters
--
-- param: user_id: &str - user ID
--
SELECT book_title
FROM library
WHERE loaned_to = :user_id
ORDER BY 1
-- name: loan_books!
--
-- Updates the book records to reflect loan to a patron
--
-- # Parameters
--
-- param: book_titles: &str - book titles
-- param: user_id: &str - user ID
--
UPDATE library
SET loaned_to = :user_id
, loaned_on = current_timestamp
WHERE book_title IN (:book_titles)
And then use it in Rust as:
use ;
use ;
include_sql!;
Documentation
The included documentation describes the supported SQL file format and provides additional details on the generated code.