diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-03-28 11:50:09 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-03-28 11:50:09 -0400 |
| commit | d61919118072f4c31ba2ee0bd8c4ac22a92e92f4 (patch) | |
| tree | 1dd12ef15aa76f25d048377c518ff0c7f03a7fe7 /lib/sqlalchemy/dialects | |
| parent | 63d2a486bf84f798387bd45db558610b247e0aa5 (diff) | |
| download | sqlalchemy-d61919118072f4c31ba2ee0bd8c4ac22a92e92f4.tar.gz | |
- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.
Pull request courtesy Stefan Urbanek. fixes #1957
Diffstat (limited to 'lib/sqlalchemy/dialects')
| -rw-r--r-- | lib/sqlalchemy/dialects/mysql/base.py | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index b85e32db0..5abb1f3d6 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -861,9 +861,16 @@ class MySQLCompiler(compiler.SQLCompiler): return "" def visit_join(self, join, asfrom=False, **kwargs): + if join.full: + join_type = " FULL OUTER JOIN " + elif join.isouter: + join_type = " LEFT OUTER JOIN " + else: + join_type = " INNER JOIN " + return ''.join( (self.process(join.left, asfrom=True, **kwargs), - (join.isouter and " LEFT OUTER JOIN " or " INNER JOIN "), + join_type, self.process(join.right, asfrom=True, **kwargs), " ON ", self.process(join.onclause, **kwargs))) |