From 92a5df77538069efd9f8cfc14cf83807ce43c288 Mon Sep 17 00:00:00 2001 From: Jason Kirtland Date: Tue, 25 Mar 2008 16:51:29 +0000 Subject: - Added generic func.random (non-standard SQL) --- lib/sqlalchemy/databases/mysql.py | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'lib/sqlalchemy/databases/mysql.py') diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py index 314cb8dac..f2544e9b5 100644 --- a/lib/sqlalchemy/databases/mysql.py +++ b/lib/sqlalchemy/databases/mysql.py @@ -158,6 +158,7 @@ from array import array as _array from sqlalchemy import exceptions, logging, schema, sql, util from sqlalchemy.sql import operators as sql_operators +from sqlalchemy.sql import functions as sql_functions from sqlalchemy.sql import compiler from sqlalchemy.engine import base as engine_base, default @@ -1898,6 +1899,11 @@ class MySQLCompiler(compiler.DefaultCompiler): sql_operators.concat_op: lambda x, y: "concat(%s, %s)" % (x, y), sql_operators.mod: '%%' }) + functions = compiler.DefaultCompiler.functions.copy() + functions.update ({ + sql_functions.random: 'rand%(expr)s' + }) + def visit_typeclause(self, typeclause): type_ = typeclause.type.dialect_impl(self.dialect) -- cgit v1.2.1