Skip to content

Temporary tables support (including patch) #1075

Closed
@sqlalchemy-bot

Description

@sqlalchemy-bot
Collaborator

Migrated issue, originally created by Anonymous

I patched in temporary tables support. It was discussed on the mailing list a while back, and you seem to have agreed to a "prefixes" addition to Table, so that's exactly what this patch does. It includes the appropriate unit test.

For a lot of databases, temporary tables are local to connections, so if you document its usage, it should go something like:

db = create_engine('postgres://vomjom:hojachi5@localhost/api')
meta = MetaData()
conn = db.connect()
meta.bind = conn
tbl = Table('foo', meta, Column('bar', Integer), prefixes='TEMPORARY')
meta.create_all()


Attachments: temporary_tables.patch

Activity

sqlalchemy-bot

sqlalchemy-bot commented on Jun 13, 2008

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

prefixes patch for Table

sqlalchemy-bot

sqlalchemy-bot commented on Jun 13, 2008

@sqlalchemy-bot
CollaboratorAuthor

Changes by Anonymous:

  • attached file temporary_tables.patch
sqlalchemy-bot

sqlalchemy-bot commented on Jun 13, 2008

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

E-mail is vomjom at vomjom.net

Thanks.

sqlalchemy-bot

sqlalchemy-bot commented on Jun 13, 2008

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

Haha, looks like I'm going to have to change my database password since I included it in my example :)

sqlalchemy-bot

sqlalchemy-bot commented on Jul 4, 2008

@sqlalchemy-bot
CollaboratorAuthor

Michael Trier (@empty) wrote:

Added in 9d7c690

sqlalchemy-bot

sqlalchemy-bot commented on Jul 4, 2008

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Trier (@empty):

  • added labels: schema
  • set milestone to "0.5.0"
  • changed status to closed
added
schemathings related to the DDL related objects like Table, Column, CreateIndex, etc.
on Nov 27, 2018
added this to the 0.5.0 milestone on Nov 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    featureschemathings related to the DDL related objects like Table, Column, CreateIndex, etc.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @sqlalchemy-bot

        Issue actions

          Temporary tables support (including patch) · Issue #1075 · sqlalchemy/sqlalchemy