~pythonian/sqlhelp commit

2 files changed, 3 insertions(+), 3 deletions(-)

M sqlhelp/__init__.py
M test/test_sqlhelp.py

M sqlhelp/__init__.py +1 -1

@@ 186,7 186,7 @@ class select(_wherebase):
 
     def join(self, *joins, jtype='inner'):
         """Add relation in join section."""
-        assert jtype in ('inner', 'outer')
+        assert jtype in ('inner', 'left outer')
         for j in joins:
             self._joins.append(f'{jtype} join {j}')
         return self

M test/test_sqlhelp.py +2 -2

@@ 7,7 7,7 @@ def test_select():
         'table1', 'table2'
     ).join(
         'table3 on (table3.table1 = table1.id)'
-    ).join('table4 as t on (t.table2 = table2.id)', jtype='outer'
+    ).join('table4 as t on (t.table2 = table2.id)', jtype='left outer'
     ).where(
         'table1.a > 50',
         'table2.name = %(name)s',

          
@@ 19,7 19,7 @@ def test_select():
     assert str(q) == (
         "query::[select  a, b, c from table1, table2 "
         "inner join table3 on (table3.table1 = table1.id) "
-        "outer join table4 as t on (t.table2 = table2.id) "
+        "left outer join table4 as t on (t.table2 = table2.id) "
         "where table1.a > 50 and table2.name = %(name)s "
         "group by a, b, c "
         "order by a desc "