(self)
| 1030 | return table1, table2, table3 |
| 1031 | |
| 1032 | def test_outer_join_one(self): |
| 1033 | table1, table2, table3 = self._test_outer_join_fixture() |
| 1034 | |
| 1035 | query = ( |
| 1036 | select(table1, table2) |
| 1037 | .where( |
| 1038 | or_( |
| 1039 | table1.c.name == "fred", |
| 1040 | table1.c.myid == 10, |
| 1041 | table2.c.othername != "jack", |
| 1042 | text("EXISTS (select yay from foo where boo = lar)"), |
| 1043 | ) |
| 1044 | ) |
| 1045 | .select_from( |
| 1046 | outerjoin(table1, table2, table1.c.myid == table2.c.otherid) |
| 1047 | ) |
| 1048 | ) |
| 1049 | self.assert_compile( |
| 1050 | query, |
| 1051 | "SELECT mytable.myid, mytable.name, " |
| 1052 | "mytable.description, myothertable.otherid," |
| 1053 | " myothertable.othername FROM mytable, " |
| 1054 | "myothertable WHERE (mytable.name = " |
| 1055 | ":name_1 OR mytable.myid = :myid_1 OR " |
| 1056 | "myothertable.othername != :othername_1 OR " |
| 1057 | "EXISTS (select yay from foo where boo = " |
| 1058 | "lar)) AND mytable.myid = " |
| 1059 | "myothertable.otherid(+)", |
| 1060 | dialect=oracle.OracleDialect(use_ansi=False), |
| 1061 | ) |
| 1062 | |
| 1063 | def test_outer_join_two(self): |
| 1064 | table1, table2, table3 = self._test_outer_join_fixture() |
nothing calls this directly
no test coverage detected