X7ROOT File Manager
Current Path:
/opt/hc_python/lib/python3.12/site-packages/sqlalchemy/sql
opt
/
hc_python
/
lib
/
python3.12
/
site-packages
/
sqlalchemy
/
sql
/
📁
..
📄
__init__.py
(5.68 KB)
📁
__pycache__
📄
_dml_constructors.py
(3.71 KB)
📄
_elements_constructors.py
(61.16 KB)
📄
_orm_types.py
(625 B)
📄
_py_util.py
(2.12 KB)
📄
_selectable_constructors.py
(19.9 KB)
📄
_typing.py
(12.55 KB)
📄
annotation.py
(17.82 KB)
📄
base.py
(72.21 KB)
📄
cache_key.py
(32.88 KB)
📄
coercions.py
(39.7 KB)
📄
compiler.py
(269.12 KB)
📄
crud.py
(55.19 KB)
📄
ddl.py
(46.32 KB)
📄
default_comparator.py
(16.32 KB)
📄
dml.py
(64.68 KB)
📄
elements.py
(173.16 KB)
📄
events.py
(17.88 KB)
📄
expression.py
(7.41 KB)
📄
functions.py
(62.36 KB)
📄
lambdas.py
(48.04 KB)
📄
naming.py
(6.7 KB)
📄
operators.py
(74.99 KB)
📄
roles.py
(7.48 KB)
📄
schema.py
(224.63 KB)
📄
selectable.py
(235.41 KB)
📄
sqltypes.py
(125.93 KB)
📄
traversals.py
(32.88 KB)
📄
type_api.py
(82.85 KB)
📄
util.py
(46.96 KB)
📄
visitors.py
(35.47 KB)
Editing: _dml_constructors.py
# sql/_dml_constructors.py # Copyright (C) 2005-2025 the SQLAlchemy authors and contributors # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under # the MIT License: https://www.opensource.org/licenses/mit-license.php from __future__ import annotations from typing import TYPE_CHECKING from .dml import Delete from .dml import Insert from .dml import Update if TYPE_CHECKING: from ._typing import _DMLTableArgument def insert(table: _DMLTableArgument) -> Insert: """Construct an :class:`_expression.Insert` object. E.g.:: from sqlalchemy import insert stmt = insert(user_table).values(name="username", fullname="Full Username") Similar functionality is available via the :meth:`_expression.TableClause.insert` method on :class:`_schema.Table`. .. seealso:: :ref:`tutorial_core_insert` - in the :ref:`unified_tutorial` :param table: :class:`_expression.TableClause` which is the subject of the insert. :param values: collection of values to be inserted; see :meth:`_expression.Insert.values` for a description of allowed formats here. Can be omitted entirely; a :class:`_expression.Insert` construct will also dynamically render the VALUES clause at execution time based on the parameters passed to :meth:`_engine.Connection.execute`. :param inline: if True, no attempt will be made to retrieve the SQL-generated default values to be provided within the statement; in particular, this allows SQL expressions to be rendered 'inline' within the statement without the need to pre-execute them beforehand; for backends that support "returning", this turns off the "implicit returning" feature for the statement. If both :paramref:`_expression.insert.values` and compile-time bind parameters are present, the compile-time bind parameters override the information specified within :paramref:`_expression.insert.values` on a per-key basis. The keys within :paramref:`_expression.Insert.values` can be either :class:`~sqlalchemy.schema.Column` objects or their string identifiers. Each key may reference one of: * a literal data value (i.e. string, number, etc.); * a Column object; * a SELECT statement. If a ``SELECT`` statement is specified which references this ``INSERT`` statement's table, the statement will be correlated against the ``INSERT`` statement. .. seealso:: :ref:`tutorial_core_insert` - in the :ref:`unified_tutorial` """ # noqa: E501 return Insert(table) def update(table: _DMLTableArgument) -> Update: r"""Construct an :class:`_expression.Update` object. E.g.:: from sqlalchemy import update stmt = ( update(user_table).where(user_table.c.id == 5).values(name="user #5") ) Similar functionality is available via the :meth:`_expression.TableClause.update` method on :class:`_schema.Table`. :param table: A :class:`_schema.Table` object representing the database table to be updated. .. seealso:: :ref:`tutorial_core_update_delete` - in the :ref:`unified_tutorial` """ # noqa: E501 return Update(table) def delete(table: _DMLTableArgument) -> Delete: r"""Construct :class:`_expression.Delete` object. E.g.:: from sqlalchemy import delete stmt = delete(user_table).where(user_table.c.id == 5) Similar functionality is available via the :meth:`_expression.TableClause.delete` method on :class:`_schema.Table`. :param table: The table to delete rows from. .. seealso:: :ref:`tutorial_core_update_delete` - in the :ref:`unified_tutorial` """ return Delete(table)
Upload File
Create Folder