mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
31 lines
1.9 KiB
Swift
31 lines
1.9 KiB
Swift
import XCTest
|
|
@testable import GRDB
|
|
|
|
class SQLIdentifyingColumnsTests: GRDBTestCase {
|
|
func testIdentifyingColumns() throws {
|
|
try makeDatabaseQueue().write { db in
|
|
try db.create(table: "t") { t in
|
|
t.autoIncrementedPrimaryKey("id")
|
|
}
|
|
let alias = TableAlias(tableName: "t")
|
|
let otherAlias = TableAlias()
|
|
|
|
try XCTAssertEqual((alias[Column("a")] == 1)._identifyingColums(db, for: alias), ["a"])
|
|
try XCTAssertEqual((alias[Column("a")] === 1)._identifyingColums(db, for: alias), ["a"])
|
|
try XCTAssertEqual((alias[Column("a")] == nil)._identifyingColums(db, for: alias), ["a"])
|
|
try XCTAssertEqual((1 == alias[Column("a")])._identifyingColums(db, for: alias), ["a"])
|
|
try XCTAssertEqual((alias[SQLExpressionFastPrimaryKey()] == 1)._identifyingColums(db, for: alias), ["id"])
|
|
try XCTAssertEqual((alias[Column("a")] == 1 && alias[Column("a")] == 2)._identifyingColums(db, for: alias), ["a"])
|
|
try XCTAssertEqual((alias[Column("a")] == 1 && alias[Column("b")] == 1)._identifyingColums(db, for: alias), ["a", "b"])
|
|
try XCTAssertEqual((alias[Column("a")] == 1 && alias[Column("b")] > 1)._identifyingColums(db, for: alias), ["a"])
|
|
try XCTAssertEqual((otherAlias[Column("a")] == 1 && alias[Column("b")] == 1)._identifyingColums(db, for: alias), ["b"])
|
|
|
|
try XCTAssertEqual((otherAlias[Column("a")])._identifyingColums(db, for: alias), [])
|
|
try XCTAssertEqual((alias[Column("a")] == 1 || alias[Column("a")] == 2)._identifyingColums(db, for: alias), [])
|
|
try XCTAssertEqual((alias[Column("a")] == alias[Column("b")])._identifyingColums(db, for: alias), [])
|
|
try XCTAssertEqual((alias[Column("a")] > 1)._identifyingColums(db, for: alias), [])
|
|
try XCTAssertEqual((alias[Column("a")] != 1)._identifyingColums(db, for: alias), [])
|
|
}
|
|
}
|
|
}
|