represents state to use for executing an "insertmanyvalues" statement. The primary consumers of this object are the :meth:`.SQLCompiler._deliver_insertmanyvalues_batches` and :meth:`.DefaultDialect._deliver_insertmanyvalues_batches` methods. .. versionadded:: 2.0
| 488 | |
| 489 | |
| 490 | class _InsertManyValues(NamedTuple): |
| 491 | """represents state to use for executing an "insertmanyvalues" statement. |
| 492 | |
| 493 | The primary consumers of this object are the |
| 494 | :meth:`.SQLCompiler._deliver_insertmanyvalues_batches` and |
| 495 | :meth:`.DefaultDialect._deliver_insertmanyvalues_batches` methods. |
| 496 | |
| 497 | .. versionadded:: 2.0 |
| 498 | |
| 499 | """ |
| 500 | |
| 501 | is_default_expr: bool |
| 502 | """if True, the statement is of the form |
| 503 | ``INSERT INTO TABLE DEFAULT VALUES``, and can't be rewritten as a "batch" |
| 504 | |
| 505 | """ |
| 506 | |
| 507 | single_values_expr: str |
| 508 | """The rendered "values" clause of the INSERT statement. |
| 509 | |
| 510 | This is typically the parenthesized section e.g. "(?, ?, ?)" or similar. |
| 511 | The insertmanyvalues logic uses this string as a search and replace |
| 512 | target. |
| 513 | |
| 514 | """ |
| 515 | |
| 516 | insert_crud_params: List[crud._CrudParamElementStr] |
| 517 | """List of Column / bind names etc. used while rewriting the statement""" |
| 518 | |
| 519 | num_positional_params_counted: int |
| 520 | """the number of bound parameters in a single-row statement. |
| 521 | |
| 522 | This count may be larger or smaller than the actual number of columns |
| 523 | targeted in the INSERT, as it accommodates for SQL expressions |
| 524 | in the values list that may have zero or more parameters embedded |
| 525 | within them. |
| 526 | |
| 527 | This count is part of what's used to organize rewritten parameter lists |
| 528 | when batching. |
| 529 | |
| 530 | """ |
| 531 | |
| 532 | sort_by_parameter_order: bool = False |
| 533 | """if the deterministic_returnined_order parameter were used on the |
| 534 | insert. |
| 535 | |
| 536 | All of the attributes following this will only be used if this is True. |
| 537 | |
| 538 | """ |
| 539 | |
| 540 | includes_upsert_behaviors: bool = False |
| 541 | """if True, we have to accommodate for upsert behaviors. |
| 542 | |
| 543 | This will in some cases downgrade "insertmanyvalues" that requests |
| 544 | deterministic ordering. |
| 545 | |
| 546 | """ |
| 547 |