File Manager

X7ROOT File Manager

Current Path: /opt/cloudlinux/venv/lib/python3.11/site-packages/lvestats/lib

opt / cloudlinux / venv / lib / python3.11 / site-packages / lvestats / lib /

ðŸ“ ..
ðŸ“„ __init__.py(219 B)
ðŸ“ __pycache__
ðŸ“ bursting
ðŸ“ chart
ðŸ“„ cloudlinux_statistics.py(24.87 KB)
ðŸ“„ cloudlinux_statsnotifier.py(5.09 KB)
ðŸ“ commons
ðŸ“„ config.py(3.2 KB)
ðŸ“„ db_functions.py(1.45 KB)
ðŸ“„ dbengine.py(10.57 KB)
ðŸ“ info
ðŸ“„ jsonhandler.py(443 B)
ðŸ“„ lve_create_db.py(1.88 KB)
ðŸ“„ lve_list.py(3.35 KB)
ðŸ“„ lveinfolib.py(41.82 KB)
ðŸ“„ lveinfolib_gov.py(13.56 KB)
ðŸ“„ lvestats_server.py(8.46 KB)
ðŸ“„ notifications_helper.py(5.41 KB)
ðŸ“ parsers
ðŸ“„ server_id.py(5.14 KB)
ðŸ“„ snapshot.py(7.42 KB)
ðŸ“„ uidconverter.py(5.01 KB)
ðŸ“„ ustate.py(8.62 KB)

Editing: db_functions.py

# 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)}"

X7ROOT File Manager

Editing: db_functions.py

Upload File

Create Folder