问题描述
限时送ChatGPT账号..我想在 SQLAlchemy 中创建一个临时表.我可以通过对 Table 调用
对象,但不如 table._prefixes.append('TEMPORARY')
来构建带有 TEMPORARY
子句的 CREATE TABLE
语句table.select().prefix_with()
用于为数据操作语言表达式添加前缀.
I'd like to create a temporary table in SQLAlchemy. I can build a CREATE TABLE
statement with a TEMPORARY
clause by calling table._prefixes.append('TEMPORARY')
against a Table
object, but that's less elegant than table.select().prefix_with()
used to add a prefix to data manipulation language expressions.
是否有与 .prefix_with()
等效的 DDL?
Is there an equivalent to .prefix_with()
for DDL?
推荐答案
否,prefix_with()
仅针对 SELECT 和 INSERT 定义.但是向 CREATE TABLE 语句添加前缀的便捷方法是将其传递到表定义中:
No, prefix_with()
is defined for SELECT and INSERT only. But convenient way to add prefix to CREATE TABLE statement is passing it into table definition:
t = Table(
't', metadata,
Column('id', Integer, primary_key=True),
# ...
prefixes=['TEMPORARY'],
)
这篇关于我可以在 SQLAlchemy 中创建临时表而不附加到 Table._prefixes 吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
更多推荐
[db:关键词]
发布评论