ormer 0.2.7

A minimalist ORM framework that supports SQLite, PostgreSQL, MySQL, and SqlServer
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

#![cfg(feature = "mssql")]

use ormer::{DbType, Model, Select};

#[derive(Debug, Clone, Model)]
#[table = "mssql_range_users"]
struct MssqlRangeUser {
    #[primary]
    id: i32,
}

#[test]
fn open_mssql_range_keeps_offset_clause() {
    let (sql, _) = Select::<MssqlRangeUser>::new()
        .range(10..)
        .to_sql_with_params(DbType::MSSQL);

    assert!(sql.contains("OFFSET 10 ROWS"), "SQL: {sql}");
    assert!(!sql.contains("FETCH NEXT"), "SQL: {sql}");
}