sql_query_builder 2.6.2

Write SQL queries in a simple and composable way
Documentation 
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

mod commit_command {
  use pretty_assertions::assert_eq;
  use sql_query_builder as sql;

  #[test]
  fn method_commit_should_add_a_commit_command() {
    let query = sql::Transaction::new().commit("").as_string();
    let expected_query = "COMMIT;";

    assert_eq!(query, expected_query);
  }

  #[test]
  fn method_commit_should_add_the_transaction_mode_argument() {
    let query = sql::Transaction::new().commit("TRANSACTION").as_string();
    let expected_query = "COMMIT TRANSACTION;";

    assert_eq!(query, expected_query);
  }

  #[test]
  fn method_commit_should_trim_space_of_the_argument() {
    let query = sql::Transaction::new().commit("  TRANSACTION  ").as_string();
    let expected_query = "COMMIT TRANSACTION;";

    assert_eq!(query, expected_query);
  }

  #[test]
  fn method_commit_should_overrides_the_current_value_on_consecutive_calls() {
    let query = sql::Transaction::new().commit("TRANSACTION").commit("WORK").as_string();
    let expected_query = "COMMIT WORK;";

    assert_eq!(query, expected_query);
  }
}