Function _replace_sqlite_datetime_functions

service/server/database.py:182–190

(sql: str)

def _replace_sqlite_datetime_functions(sql: str) -> str:
    def replace_interval(match: re.Match[str]) -> str:
        amount = match.group(1)
        unit = match.group(2)
        return f"to_char((CURRENT_TIMESTAMP AT TIME ZONE 'UTC') + INTERVAL '{amount} {unit}', 'YYYY-MM-DD\"T\"HH24:MI:SS.US\"Z\"')"

    sql = _SQLITE_INTERVAL_PATTERN.sub(replace_interval, sql)
    sql = _SQLITE_NOW_PATTERN.sub(_POSTGRES_NOW_TEXT_SQL, sql)
    return sql


def _adapt_sql_for_postgres(sql: str) -> str: