From bfb33f7959244e1ac15d3d713e0abbd49f7a5e31 Mon Sep 17 00:00:00 2001 From: Jason Kirtland Date: Wed, 12 Dec 2007 16:39:10 +0000 Subject: - on mysql, emit inner joins as 'INNER JOIN ... ON' (for version 3.23) --- lib/sqlalchemy/databases/mysql.py | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'lib/sqlalchemy/databases/mysql.py') diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py index 742164412..ba0ad5e0a 100644 --- a/lib/sqlalchemy/databases/mysql.py +++ b/lib/sqlalchemy/databases/mysql.py @@ -1881,6 +1881,14 @@ class MySQLCompiler(compiler.DefaultCompiler): else: return "" + def visit_join(self, join, asfrom=False, **kwargs): + return ''.join( + (self.process(join.left, asfrom=True), + (join.isouter and " LEFT OUTER JOIN " or " INNER JOIN "), + self.process(join.right, asfrom=True), + " ON ", + self.process(join.onclause))) + def for_update_clause(self, select): if select.for_update == 'read': return ' LOCK IN SHARE MODE' -- cgit v1.2.1