我可以在 SQLAlchemy 中创建临时表而不附加到 Table._prefixes 吗? [英] Can I CREATE TEMPORARY TABLE in SQLAlchemy without appending to Table._prefixes?

问题描述

我想在 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屋！