Skip to content

Support For Multi-Row Inserts #670

@waltaskew

Description

@waltaskew

The dialect currently doesn't support multi-row / bulk inserts, although Spanner itself does.

    engine = sa.create_engine(
        "spanner+spanner:///...", 
    )

    with engine.begin() as conn:                                                                                                                                                                                                                                                
        conn.execute(
            sa.insert(Person)
            .values([{"name": "jdoe"}, {"name": "jmoe"}])
            .returning(Person.id)
        )
        session.commit()

sqlalchemy.exc.CompileError: The 'spanner+spanner' dialect with current database version settings does not support in-place multirow inserts.

Metadata

Metadata

Assignees

Labels

api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.priority: p3Desirable enhancement or fix. May not be included in next release.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions