Upon execution, the values of the columns to be returned are madeĪvailable via the result set and can be iterated using The values are those of the rows which were deleted. The values are the newly inserted/updated values. Upon compilation, a RETURNING clause, or database equivalent, first_name || : first_name_1 || some_table. INSERT INTO some_table ( first_name, last_name ) VALUES (: first_name, : last_name ) RETURNING some_table. INSERT statement’s table, the statement will be correlated If a SELECT statement is specified which references this Each key may reference one of:Ī literal data value (i.e. The keys within Insert.values can be either Information specified within insert.values on a Parameters are present, the compile-time bind parameters override the If both insert.values and compile-time bind Statement without the need to pre-execute them beforehand forīackends that support “returning”, this turns off the “implicit This allows SQL expressions to be rendered ‘inline’ within the SQL-generated default values to be provided within the statement Inline ¶ – if True, no attempt will be made to retrieve the Will also dynamically render the VALUES clause at execution timeīased on the parameters passed to Connection.execute(). Values ¶ – collection of values to be inserted seeįor a description of allowed formats here.Ĭan be omitted entirely a Insert construct Using INSERT Statements - in the SQLAlchemy Unified Tutorial Parameters : SQL Expression Language Foundational Constructs.Custom SQL Constructs and Compilation Extension.UpdateBase.returning_column_descriptions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |