Inserts a row into a table, returns the full list of values INSERTed including defaults that fired off on the DB side and detects rows that had defaults and post-fetches.
(table_, values)
| 138 | """Tests the inserted_primary_key and lastrow_has_id() functions.""" |
| 139 | |
| 140 | def insert_values(table_, values): |
| 141 | """ |
| 142 | Inserts a row into a table, returns the full list of values |
| 143 | INSERTed including defaults that fired off on the DB side and |
| 144 | detects rows that had defaults and post-fetches. |
| 145 | """ |
| 146 | |
| 147 | # verify implicit_returning is working |
| 148 | if ( |
| 149 | connection.dialect.insert_returning |
| 150 | and table_.implicit_returning |
| 151 | and not connection.dialect.postfetch_lastrowid |
| 152 | ): |
| 153 | ins = table_.insert() |
| 154 | comp = ins.compile(connection, column_keys=list(values)) |
| 155 | if not set(values).issuperset( |
| 156 | c.key for c in table_.primary_key |
| 157 | ): |
| 158 | is_(bool(comp.returning), True) |
| 159 | |
| 160 | result = connection.execute(table_.insert(), values) |
| 161 | ret = values.copy() |
| 162 | |
| 163 | ipk = result.inserted_primary_key |
| 164 | for col, id_ in zip(table_.primary_key, ipk): |
| 165 | ret[col.key] = id_ |
| 166 | |
| 167 | if result.lastrow_has_defaults(): |
| 168 | criterion = and_( |
| 169 | *[ |
| 170 | col == id_ |
| 171 | for col, id_ in zip( |
| 172 | table_.primary_key, result.inserted_primary_key |
| 173 | ) |
| 174 | ] |
| 175 | ) |
| 176 | row = connection.execute( |
| 177 | table_.select().where(criterion) |
| 178 | ).first() |
| 179 | for c in table_.c: |
| 180 | ret[c.key] = row._mapping[c] |
| 181 | return ret, ipk |
| 182 | |
| 183 | table_.create(connection, checkfirst=True) |
| 184 | i, ipk = insert_values(table_, values) |
nothing calls this directly
no test coverage detected