| 477 | assert obj.as_string(conn) == "foofoofoo" |
| 478 | |
| 479 | def test_join(self, conn): |
| 480 | obj = sql.SQL(", ").join( |
| 481 | [sql.Identifier("foo"), sql.SQL("bar"), sql.Literal(42)] |
| 482 | ) |
| 483 | assert isinstance(obj, sql.Composed) |
| 484 | assert obj.as_string(conn) == '"foo", bar, 42' |
| 485 | |
| 486 | obj = sql.SQL(", ").join( |
| 487 | sql.Composed([sql.Identifier("foo"), sql.SQL("bar"), sql.Literal(42)]) |
| 488 | ) |
| 489 | assert isinstance(obj, sql.Composed) |
| 490 | assert obj.as_string(conn) == '"foo", bar, 42' |
| 491 | |
| 492 | obj = sql.SQL(", ").join(["foo", "bar", 42]) |
| 493 | assert isinstance(obj, sql.Composed) |
| 494 | assert obj.as_string(conn) == """'foo', 'bar', 42""" |
| 495 | |
| 496 | obj2 = sql.SQL(", ").join([]) |
| 497 | assert obj2 == sql.Composed([]) |
| 498 | |
| 499 | def test_as_string(self, conn): |
| 500 | assert sql.SQL("foo").as_string(conn) == "foo" |