rustorm 0.14.0

A complete rewrite of rustorm
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143

# rustorm


### Rustorm

[![Latest Version](https://img.shields.io/crates/v/rustorm.svg)](https://crates.io/crates/rustorm)
[![Build Status](https://travis-ci.org/ivanceras/rustorm.svg?branch=master)](https://travis-ci.org/ivanceras/rustorm)
[![MIT licensed](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE)

Rustorm is an SQL-centered ORM with focus on ease of use on conversion of database types to
their appropriate rust type.

Selecting records

```rust
use cfg_if::cfg_if;
use rustorm::ToTableName;
use rustorm::ToColumnNames;
use rustorm::FromDao;
use rustorm::DbError;
use rustorm::Pool;

#[derive(Debug, FromDao, ToColumnNames, ToTableName)]
struct Actor {
    actor_id: i32,
    first_name: String,
}


cfg_if! {
     if #[cfg(feature="with-postgres")] {
       fn db_url() -> &'static str {
           "postgres://postgres:p0stgr3s@localhost/sakila"
       }
     }
     else if #[cfg(feature = "with-sqlite")] {
       fn db_url() -> &'static str{
           "sqlite://sakila.db"
       }
     }
     else {
       fn db_url() -> &'static str {
           panic!("add --features flag, ie: --features=\"with-postgres\" ");
       }
     }
}
fn main(){
    let mut pool = Pool::new();
    let em = pool.em(db_url()).unwrap();
    let sql = "SELECT * FROM actor LIMIT 10";
    let actors: Result<Vec<Actor>, DbError> = em.execute_sql_with_return(sql, &[]);
    println!("Actor: {:#?}", actors);
    let actors = actors.unwrap();
    assert_eq!(actors.len(), 10);
    for actor in actors {
        println!("actor: {:?}", actor);
    }
}
```
Inserting and displaying the inserted records

```rust

use rustorm::TableName;
use rustorm::ToColumnNames;
use rustorm::ToTableName;
use rustorm::{FromDao, ToDao};
use rustorm::Pool;
use rustorm::DbError;
use chrono::offset::Utc;
use chrono::{DateTime, NaiveDate};
use cfg_if::cfg_if;

cfg_if! {
     if #[cfg(feature="with-postgres")] {
       fn db_url() -> &'static str {
           "postgres://postgres:p0stgr3s@localhost/sakila"
       }
     }
     else if #[cfg(feature = "with-sqlite")] {
       fn db_url() -> &'static str {
           "sqlite://sakila.db"
       }
     }
     else {
       fn db_url() -> &'static str {
           panic!("add --features flag, ie: --features=\"with-postgres\" ");
       }
     }
}

  fn main() {
      mod for_insert {
          use super::*;
          #[derive(Debug, PartialEq, ToDao, ToColumnNames, ToTableName)]
          pub struct Actor {
              pub first_name: String,
              pub last_name: String,
          }
      }

      mod for_retrieve {
          use super::*;
          #[derive(Debug, FromDao, ToColumnNames, ToTableName)]
          pub struct Actor {
              pub actor_id: i32,
              pub first_name: String,
              pub last_name: String,
              pub last_update: DateTime<Utc>,
          }
      }

      let mut pool = Pool::new();
      let em = pool.em(db_url()).unwrap();
      let tom_cruise = for_insert::Actor {
          first_name: "TOM".into(),
          last_name: "CRUISE".to_string(),
      };
      let tom_hanks = for_insert::Actor {
          first_name: "TOM".into(),
          last_name: "HANKS".to_string(),
      };

      let actors: Result<Vec<for_retrieve::Actor>, DbError> =
          em.insert(&[&tom_cruise, &tom_hanks]);
      println!("Actor: {:#?}", actors);
      assert!(actors.is_ok());
      let actors = actors.unwrap();
      let today = Utc::now().date();
      assert_eq!(tom_cruise.first_name, actors[0].first_name);
      assert_eq!(tom_cruise.last_name, actors[0].last_name);
      assert_eq!(today, actors[0].last_update.date());

      assert_eq!(tom_hanks.first_name, actors[1].first_name);
      assert_eq!(tom_hanks.last_name, actors[1].last_name);
      assert_eq!(today, actors[1].last_update.date());
  }
```
Rustorm is wholly used by [diwata](https://github.com/ivanceras/diwata)



License: MIT