Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/sqlalchemy/sqlalchemy/issues/8963 below:

freeze does not work for textual SQL · Issue #8963 · sqlalchemy/sqlalchemy · GitHub

import sqlalchemy as sa

metadata = sa.MetaData()

user = sa.Table(
    "user",
    metadata,
    sa.Column("user_id", sa.Integer, primary_key=True),
    sa.Column("user_name", sa.String(16), nullable=False),
    sa.Column("email_address", sa.String(60)),
    sa.Column("nickname", sa.String(50), nullable=False),
)

db_uri = "sqlite:///"
engine = sa.create_engine(db_uri, future=True)
user.create(bind=engine)
with engine.connect() as conn:
    result = conn.execute(sa.select(user))
    frozen = result.freeze()

    # both fail
    result = conn.execute(sa.text("select * from user"))
#    result = conn.exec_driver_sql("select * from user")
    frozen = result.freeze()

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4