1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

//! # Insert / Delete / Update
//!
//! The database support of the Toql derive can build functions to insert, delete and update structs.
//!
//! ## Example (Read the guide for derive attributes)
//! 
//! ``` ignore
//! #[derive(Debug, PartialEq, Toql)]
//! struct NewUser {
//!     #[toql(skip_inup)]
//!     id: u8, // Auto value, no insert
//!     username: Option<String>,
//! }
//! 
//! let u = NewUser {
//!             id: 5,
//!             username: Some(String::from("Foo")),
//!         };
//!
//! let (sql, params) = NewUser::insert_one_sql(&u).unwrap();
//!
//! assert_eq!("INSERT INTO NewUser (username) VALUES (?)", sql);
//! assert_eq!(["Foo"], *params);
//! ```
//! 
//! Note that operations are not cascaded. If you insert a struct `Foo` that contains another struct `Bar` only `Foo will be inserted.
//! To deal with those dependencies, you are expected to make multiple calls. 
//! 
//! If you *update* a struct, fields of type `Option<>` with value `None` are skipped. Read the guide for details!
//! 

use crate::error::Result;

/// Trait for insert delete and update functions.
pub trait Indelup<'a, T: 'a> {
    /// Insert one struct, returns tuple with SQL statement and SQL params or error.
    fn insert_one_sql (entity: & T) -> Result<(String, Vec<String>)>;
    /// Insert many structs, returns tuple with SQL statement and SQL params or error.
    fn insert_many_sql<I> (entities: I) -> Result<(String, Vec<String>)> where I: IntoIterator<Item = &'a T> + 'a; 
    /// Delete one structs, returns tuple with SQL statement and SQL params or error.
    fn delete_one_sql (entity: & T) -> Result<(String, Vec<String>)>;
    /// Delete many structs, returns tuple with SQL statement and SQL params or error.
    fn delete_many_sql<I> (entities: I) -> Result<(String, Vec<String>)> where I: IntoIterator<Item = &'a T> + 'a; 
     /// Update one struct, returns tuple with SQL statement and SQL params or error.
    fn update_one_sql (entity: & T) -> Result<(String, Vec<String>)>;
    /// Update many structs, returns tuple with SQL statement and SQL params or error.
    fn update_many_sql<I> (entities: I) -> Result<(String, Vec<String>)> where I: IntoIterator<Item = &'a T> + 'a + Clone;
}