#oracle #sql #database-access #macro

include-oracle-sql

A Yesql inspired macro for using Oracle SQL in Rust

5 releases

0.2.2 Mar 7, 2023
0.2.1 Feb 15, 2023
0.2.0 Feb 14, 2023
0.1.1 Feb 8, 2023
0.1.0 Apr 18, 2022

#2029 in Database interfaces

21 downloads per month

MIT license

27KB
532 lines

crates.io Documentation MIT

include-oracle-sql is an extension of include-sql for using Oracle SQL in Rust. It completes include-sql by providing impl_sql macro to generate database access methods from the included SQL. include-oracle-sql uses Sibyl 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 include_oracle_sql::{include_sql, impl_sql};

include_sql!("sql/library.sql");

fn main() -> sibyl::Result<()> {
    let db_name = std::env::var("DBNAME").expect("database name");
    let db_user = std::env::var("DBUSER").expect("user name");
    let db_pass = std::env::var("DBPASS").expect("password");

    let oracle = sibyl::env()?;
    let session = oracle.connect(&db_name, &db_user, &db_pass)?;

    db.loan_books(&["War and Peace", "Gone With the Wind"], "Sheldon Cooper")?;

    db.get_loaned_books("Sheldon Cooper", |row| {
        let book_title : &str = row.get("BOOK_TITLE")?;
        println!("{}", book_title);
        Ok(())
    })?;

    Ok(())
}

Documentation

The included documentation describes the supported SQL file format and provides additional details on the generated code.

💥 Breaking Changes in 0.2

  • include-sql changed optional statement terminator from ; to /. SQL files that used ; terminator would need to change it to / or remove it completely.

Dependencies

~4–12MB
~131K SLoC