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

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

.. autoapi-nested-parse::

   Time-based SQL expression utilities.



Attributes
----------

.. autoapisummary::

   server.web.utils.time_sql.DIALECT


Functions
---------

.. autoapisummary::

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


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

.. py:data:: DIALECT

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

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

   :param delta: Number of seconds to add

   :returns: A SQLAlchemy expression appropriate for the current dialect

   :raises ServerError: If the dialect is not supported


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

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

   :param delta: Number of seconds to subtract

   :returns: A SQLAlchemy expression appropriate for the current dialect

   :raises ServerError: If the dialect is not supported