diff options
Diffstat (limited to 'doc/build/tutorial/data_insert.rst')
| -rw-r--r-- | doc/build/tutorial/data_insert.rst | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/build/tutorial/data_insert.rst b/doc/build/tutorial/data_insert.rst index 5087434d7..4e85f903c 100644 --- a/doc/build/tutorial/data_insert.rst +++ b/doc/build/tutorial/data_insert.rst @@ -47,7 +47,7 @@ SQL expressions can be stringified in place as a means to see the general form of what's being produced:: >>> print(stmt) - {opensql}INSERT INTO user_account (name, fullname) VALUES (:name, :fullname) + {printsql}INSERT INTO user_account (name, fullname) VALUES (:name, :fullname) The stringified form is created by producing a :class:`_engine.Compiled` form of the object which includes a database-specific string SQL representation of @@ -76,7 +76,7 @@ SQL logging: >>> with engine.connect() as conn: ... result = conn.execute(stmt) ... conn.commit() - {opensql}BEGIN (implicit) + {execsql}BEGIN (implicit) INSERT INTO user_account (name, fullname) VALUES (?, ?) [...] ('spongebob', 'Spongebob Squarepants') COMMIT @@ -131,7 +131,7 @@ illustrate this: ... ], ... ) ... conn.commit() - {opensql}BEGIN (implicit) + {execsql}BEGIN (implicit) INSERT INTO user_account (name, fullname) VALUES (?, ?) [...] [('sandy', 'Sandy Cheeks'), ('patrick', 'Patrick Star')] COMMIT{stop} @@ -190,7 +190,7 @@ construct automatically. ... ], ... ) ... conn.commit() - {opensql}BEGIN (implicit) + {execsql}BEGIN (implicit) INSERT INTO address (user_id, email_address) VALUES ((SELECT user_account.id FROM user_account WHERE user_account.name = ?), ?) @@ -212,7 +212,7 @@ method:: ... ["user_id", "email_address"], select_stmt ... ) >>> print(insert_stmt) - {opensql}INSERT INTO address (user_id, email_address) + {printsql}INSERT INTO address (user_id, email_address) SELECT user_account.id, user_account.name || :name_1 AS anon_1 FROM user_account @@ -233,7 +233,7 @@ can be fetched:: ... address_table.c.id, address_table.c.email_address ... ) >>> print(insert_stmt) - {opensql}INSERT INTO address (id, user_id, email_address) + {printsql}INSERT INTO address (id, user_id, email_address) VALUES (:id, :user_id, :email_address) RETURNING address.id, address.email_address @@ -246,7 +246,7 @@ as in the example below that builds upon the example stated in ... ["user_id", "email_address"], select_stmt ... ) >>> print(insert_stmt.returning(address_table.c.id, address_table.c.email_address)) - {opensql}INSERT INTO address (user_id, email_address) + {printsql}INSERT INTO address (user_id, email_address) SELECT user_account.id, user_account.name || :name_1 AS anon_1 FROM user_account RETURNING address.id, address.email_address |
