Vous êtes un professionnel et vous avez besoin d'une formation ? Machine Learning
avec Scikit-Learn Voir le programme détaillé

Module « sqlalchemy »

Fonction insert - module sqlalchemy

Signature de la fonction insert

def insert(table: '_DMLTableArgument') -> 'Insert' 

Description

help(sqlalchemy.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`

Vous êtes un professionnel et vous avez besoin d'une formation ? Programmation Python
Les compléments Voir le programme détaillé