Files
GRDB.swift/Tests/GRDBTests/SQLIdentifyingColumnsTests.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), [])
}
}
}