sqlserver.rs

use crate::common::*;
use indoc::indoc;

#[test]
fn enum_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "file:test.db"
        }

        model Todo {
          id     Int    @id
          status Status
        }

        enum Status {
          DONE
          NOT_DONE
        }
    "#};

    let error = parse_unwrap_err(dml);

    let expectation = expect![[r#"
        error: Error validating: You defined the enum `Status`. But the current connector does not support enums.
          -->  schema.prisma:11
           | 
        10 | 
        11 | enum Status {
        12 |   DONE
        13 |   NOT_DONE
        14 | }
           | 
    "#]];

    expectation.assert_eq(&error);
}

#[test]
fn scalar_list_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "file:test.db"
        }

        model Todo {
          id     Int    @id
          val    String[]
        }
    "#};

    let error = parse_unwrap_err(dml);

    let expectation = expect![[r#"
        error: Field "val" in model "Todo" can't be a list. The current connector does not support lists of primitive types.
          -->  schema.prisma:8
           | 
         7 |   id     Int    @id
         8 |   val    String[]
         9 | }
           | 
    "#]];

    expectation.assert_eq(&error);
}

#[test]
fn unique_index_names_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "sqlserver://"
        }

        model User {
          id         Int @id
          neighborId Int

          @@index([id], name: "metaId")
        }

        model Post {
          id Int @id
          optionId Int

          @@index([id], name: "metaId")
        }
    "#};

    assert_valid(dml);
}

#[test]
fn json_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "sqlserver://"
        }

        model User {
          id   Int @id
          data Json
        }
    "#};

    let error = parse_unwrap_err(dml);

    let expectation = expect![[r#"
        error: Error validating field `data` in model `User`: Field `data` in model `User` can't be of type Json. The current connector does not support the Json type.
          -->  schema.prisma:8
           | 
         7 |   id   Int @id
         8 |   data Json
         9 | }
           | 
    "#]];

    expectation.assert_eq(&error);
}

#[test]
fn non_unique_relation_criteria_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "sqlserver://"
        }

        model Todo {
          id           Int    @id
          assigneeName String
          assignee     User   @relation(fields: [assigneeName], references: [name])
        }

        model User {
          id   Int    @id
          name String
          todos Todo[]
        }
    "#};

    let error = parse_unwrap_err(dml);

    let expectation = expect![[r#"
        error: Error parsing attribute "@relation": The argument `references` must refer to a unique criterion in the related model. Consider adding an `@unique` attribute to the field `name` in the model `User`.
          -->  schema.prisma:9
           | 
         8 |   assigneeName String
         9 |   assignee     User   @relation(fields: [assigneeName], references: [name])
        10 | }
           | 
    "#]];

    expectation.assert_eq(&error);
}

#[test]
fn auto_increment_on_non_primary_column_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "sqlserver://"
        }

        model Todo {
          id           Int    @id
          non_primary  Int    @default(autoincrement()) @unique
        }
    "#};

    assert_valid(dml)
}

#[test]
fn key_order_enforcement_support() {
    let dml = indoc! {r#"
        datasource db {
          provider = "sqlserver"
          url = "sqlserver://"
        }

        model  Todo {
          id1  Int
          id2  Int
          cats Cat[]

          @@id([id1, id2])
        }

        model Cat {
          id    Int @id
          todo1 Int
          todo2 Int

          rel Todo @relation(fields: [todo1, todo2], references: [id2, id1])
        }
    "#};

    let error = parse_unwrap_err(dml);

    let expectation = expect![[r#"
        error: Error validating: The argument `references` must refer to a unique criterion in the related model `Todo` using the same order of fields. Please check the ordering in the following fields: `id2, id1`.
          -->  schema.prisma:19
           | 
        18 | 
        19 |   rel Todo @relation(fields: [todo1, todo2], references: [id2, id1])
        20 | }
           | 
    "#]];

    expectation.assert_eq(&error);
}

#[test]
fn postgres_does_not_support_composite_types() {
    let schema = r#"
        datasource db {
            provider = "sqlserver"
            url = "sqlserver://"
        }

        type Address {
            street String
        }
    "#;

    let err = parse_unwrap_err(schema);

    let expected = expect![[r#"
        error: Error validating: Composite types are not supported on SQL Server.
          -->  schema.prisma:7
           | 
         6 | 
         7 |         type Address {
         8 |             street String
         9 |         }
           | 
    "#]];

    expected.assert_eq(&err);
}