feat(postgres): add copyfrom support#92
Conversation
Sorry, something went wrong.
kellen-miller
force-pushed
the
add-copyfrom
branch
from
643c37c to
908c96f
Compare
August 23, 2025 19:08
kellen-miller
force-pushed
the
add-copyfrom
branch
from
908c96f to
2ff13ad
Compare
August 23, 2025 19:13
devstein
requested review from
Copilot,
devstein and
kyleconroy
and removed request for
Copilot and
kyleconroy
November 24, 2025 16:19
There was a problem hiding this comment.
Pull request overview
This PR implements support for the :copyfrom command in sqlc-gen-python, enabling efficient bulk insert operations. The implementation leverages SQLAlchemy's executemany behavior by passing lists of parameter dictionaries to Connection.execute().
Key Changes:
- Added
:copyfromcommand support with automatic handling of both struct and non-struct parameters - Removed the previous error that blocked CopyFrom usage
- Added comprehensive test coverage and examples demonstrating both sync and async usage
Reviewed changes
Copilot reviewed 44 out of 45 changed files in this pull request and generated 1 comment.
Show a summary per file
| File | Description |
|---|---|
| internal/gen.go | Core implementation: adds BuildCopyFromBody, addCopyFromArgs, and buildStructToDictList methods; removes CopyFrom error; adds switch cases for :copyfrom in sync/async queriers |
| internal/imports.go | Adds import logic for typing.List and typing.Any types needed by copyfrom methods |
| internal/endtoend/testdata/copyfrom/* | New end-to-end test case with schema, queries, and expected generated code covering multiple copyfrom scenarios |
| examples/src/authors/query.sql | Adds example CreateAuthorsBatch copyfrom query |
| examples/src/authors/query.py | Generated code demonstrating copyfrom method with List[Any] parameter |
| examples/src/tests/test_authors.py | Test cases validating both sync and async copyfrom functionality |
| README.md | Documentation explaining copyfrom usage with examples for both List[Any] and typed struct parameters |
| internal/endtoend/testdata/*/sqlc.yaml | Updated sha256 hashes for new WASM binary version |
| internal/endtoend/testdata//python/.py | Updated generated file version comments from v1.28.0 to v1.29.0 |
| .gitignore | Adds .idea/ IDE directory to gitignore |
💡 Add Copilot custom instructions for smarter, more guided reviews. Learn how to get started.
Sorry, something went wrong.
|
Hey @kellen-miller - will try take a look at this soon. Feel free to ping me if you don't get a review in the next week or so! |
Sorry, something went wrong.
Closes #63