postgres 0.9.3

A native PostgreSQL driver
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

extern crate chrono;

use self::chrono::{TimeZone, NaiveDate, NaiveTime, NaiveDateTime, DateTime, UTC};
use types::test_type;

#[test]
fn test_naive_date_time_params() {
    fn make_check<'a>(time: &'a str) -> (Option<NaiveDateTime>, &'a str) {
        (Some(NaiveDateTime::parse_from_str(time, "'%Y-%m-%d %H:%M:%S.%f'").unwrap()), time)
    }
    test_type("TIMESTAMP",
              &[make_check("'1970-01-01 00:00:00.010000000'"),
               make_check("'1965-09-25 11:19:33.100314000'"),
               make_check("'2010-02-09 23:11:45.120200000'"),
               (None, "NULL")]);
}

#[test]
fn test_date_time_params() {
    fn make_check<'a>(time: &'a str) -> (Option<DateTime<UTC>>, &'a str) {
        (Some(UTC.datetime_from_str(time, "'%Y-%m-%d %H:%M:%S.%f'").unwrap()), time)
    }
    test_type("TIMESTAMP WITH TIME ZONE",
              &[make_check("'1970-01-01 00:00:00.010000000'"),
               make_check("'1965-09-25 11:19:33.100314000'"),
               make_check("'2010-02-09 23:11:45.120200000'"),
               (None, "NULL")]);
}

#[test]
fn test_date_params() {
    fn make_check<'a>(time: &'a str) -> (Option<NaiveDate>, &'a str) {
        (Some(NaiveDate::parse_from_str(time, "'%Y-%m-%d'").unwrap()), time)
    }
    test_type("DATE",
              &[make_check("'1970-01-01'"),
               make_check("'1965-09-25'"),
               make_check("'2010-02-09'"),
               (None, "NULL")]);
}

#[test]
fn test_time_params() {
    fn make_check<'a>(time: &'a str) -> (Option<NaiveTime>, &'a str) {
        (Some(NaiveTime::parse_from_str(time, "'%H:%M:%S.%f'").unwrap()), time)
    }
    test_type("TIME",
              &[make_check("'00:00:00.010000000'"),
               make_check("'11:19:33.100314000'"),
               make_check("'23:11:45.120200000'"),
               (None, "NULL")]);
}