Viewing file:  db_functions.py (1.45 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
# coding=utf-8
#
# Copyright © Cloud Linux GmbH & Cloud Linux Software, Inc 2010-2019 All Rights Reserved
#
# Licensed under CLOUD LINUX LICENSE AGREEMENT
# http://cloudlinux.com/docs/LICENSE.TXT
from sqlalchemy.ext.compiler import compiles
from sqlalchemy.sql import expression
from sqlalchemy.types import Numeric
class greatest(expression.FunctionElement):
type = Numeric()
name = "greatest"
class least(expression.FunctionElement):
type = Numeric()
name = "least"
@compiles(greatest)
def default_greatest(element, compiler, **kw):
return compiler.visit_function(element)
@compiles(least)
def default_least(element, compiler, **kw):
return compiler.visit_function(element)
@compiles(greatest, "sqlite")
def case_greatest(element, compiler, **kw):
arg1, arg2 = list(element.clauses)
return f"max({compiler.process(arg1)}, {compiler.process(arg2)})"
@compiles(least, "sqlite")
def case_least(element, compiler, **kw):
arg1, arg2 = list(element.clauses)
return f"min({compiler.process(arg1)}, {compiler.process(arg2)})"
class div(expression.FunctionElement):
type = Numeric
name = "div"
@compiles(div)
def default_div(element, compiler, **kw):
arg1, arg2 = list(element.clauses)
return f"{compiler.process(arg1)} / {compiler.process(arg2)}"
@compiles(div, "mysql")
def case_div(element, compiler, **kw):
arg1, arg2 = list(element.clauses)
return f"{compiler.process(arg1)} div {compiler.process(arg2)}"
|