Transform whole row?
Nobody has claimed this yet.
- Dominant language
- Common Lisp
- Stars
- 6.5k
- Forks
- 613
- Avg merge
- 3h 46m
- Merged PRs (30d)
- 1
Description
Thanks for this amazing tool, it's super!
I'm trying to work out how to transform an entire row and coming up short, it appears all the example transform I can see all act on individual "fields".
I have a data source with a custom comment char #. I want to discard any row that starts with this.
It strikes me the comments are how this is done, rather than field based transforms.
(in-package :pgloader.parser)
(defrule single-line-comment (and "#" (* (not #\Newline)) #\Newline)
(:constant :comment))
I've tried using the above as my --load-lisp-file with no success. Can you please point me in the right direction?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing how --load-lisp-file is applied to the pgloader parser and how the shown single-line-comment rule is registered. Reproduce the custom-comment input with a small load, then determine whether whole-row discarding is supported at that parser stage; done means rows beginning with # are excluded without affecting ordinary fields.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100