diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2023-01-12 16:55:11 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@ci3.zzzcomputing.com> | 2023-01-12 16:55:11 +0000 |
| commit | 4bd07126f072dfa0d078644c85a896fc165f2137 (patch) | |
| tree | ec708da835e406eb0c5db37b85609785fbcef10a /lib/sqlalchemy/dialects/mysql | |
| parent | a06cd94baab114cd0b2fa0987267e31811d38f7a (diff) | |
| parent | dce11383f83c28f2acc0ed9ee346a56d63e9fcf8 (diff) | |
| download | sqlalchemy-4bd07126f072dfa0d078644c85a896fc165f2137.tar.gz | |
Merge "Improve sql formatting" into main
Diffstat (limited to 'lib/sqlalchemy/dialects/mysql')
| -rw-r--r-- | lib/sqlalchemy/dialects/mysql/base.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index 1a0534490..50e0ec07e 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -553,7 +553,7 @@ the generative method :meth:`~.mysql.Insert.on_duplicate_key_update`: ... status='U' ... ) >>> print(on_duplicate_key_stmt) - {opensql}INSERT INTO my_table (id, data) VALUES (%s, %s) + {printsql}INSERT INTO my_table (id, data) VALUES (%s, %s) ON DUPLICATE KEY UPDATE data = VALUES(data), status = %s @@ -584,7 +584,7 @@ as values: ... ) >>> print(on_duplicate_key_stmt) - {opensql}INSERT INTO my_table (id, data) VALUES (%s, %s) + {printsql}INSERT INTO my_table (id, data) VALUES (%s, %s) ON DUPLICATE KEY UPDATE data = %s, updated_at = CURRENT_TIMESTAMP In a manner similar to that of :meth:`.UpdateBase.values`, other parameter @@ -613,7 +613,7 @@ this context is unambiguous: ... ) >>> print(on_duplicate_key_stmt) - {opensql}INSERT INTO my_table (id, data) VALUES (%s, %s) + {printsql}INSERT INTO my_table (id, data) VALUES (%s, %s) ON DUPLICATE KEY UPDATE data = %s, updated_at = CURRENT_TIMESTAMP .. versionchanged:: 1.3 support for parameter-ordered UPDATE clause within @@ -649,7 +649,7 @@ table: ... ) >>> print(do_update_stmt) - {opensql}INSERT INTO my_table (id, data, author) VALUES (%s, %s, %s) + {printsql}INSERT INTO my_table (id, data, author) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE data = %s, author = VALUES(author) When rendered, the "inserted" namespace will produce the expression |
