server.web.utils.time_sql
=========================

.. py:module:: server.web.utils.time_sql

.. autoapi-nested-parse::

   Time-based SQL expression utilities.



Functions
---------

.. autoapisummary::

   server.web.utils.time_sql.add_time_expr
   server.web.utils.time_sql.subtract_time_expr


Module Contents
---------------

.. py:function:: add_time_expr(delta: float, dialect: str) -> Any

   Create a SQL expression to add time (in seconds) to the current timestamp.

   :param delta: Number of seconds to add
   :param dialect: The database dialect (mysql, sqlite)

   :returns: A SQLAlchemy expression appropriate for the current dialect

   :raises ServerError: If the dialect is not supported


.. py:function:: subtract_time_expr(delta: float, dialect: str) -> Any

   Create a SQL expression to subtract time (in seconds) from the current timestamp.

   :param delta: Number of seconds to subtract
   :param dialect: The database dialect (mysql, sqlite)

   :returns: A SQLAlchemy expression appropriate for the current dialect

   :raises ServerError: If the dialect is not supported