search

mithrandie / csvq

SQL-like query language for csv
https://mithrandie.github.io/csvq
MIT License
1.5k stars 65 forks source link

Dry-run option #39

Closed cpkio closed 3 years ago

cpkio commented 3 years ago

It would be nice to have a --dry-run option, which would show results but no commit changes to actual file.

ondohotola commented 3 years ago

What is wrong with BEGIN WORK/ROLLBACK?

el

On 09/09/2020 11:53, cpkio wrote:

It would be nice to have a |--dry-run| option, which would show results but no commit changes to actual file. [...]

-- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist el@lisse.NA / * | Telephone: +264 81 124 6733 (cell) PO Box 8421 Bachbrecht \ / If this email is signed with GPG/PGP 10007, Namibia ;____/ Sect 20 of Act No. 4 of 2019 may apply

cpkio commented 3 years ago

The interactive CLI is sluggish and unusable, so I'm using command line queries, which are committing right there and now. Would be useful to see in advance what's going to happen. Maybe I'm missing something?

ondohotola commented 3 years ago

Besides that nobody forces you to be rude to the developer of Open Source software, and that nobody prevents you from contributing code to speed up things, something like this works for me:

 el@practice2:~/Downloads> csvq 'delete from r where rejection = 532;rollback'
 11 records deleted on "/Users/el/Downloads/r.csv".
 Rollback: file "/Users/el/Downloads/r.csv" is restored.

 el@practice2:~/Downloads> csvq 'delete from r where rejection = 532;commit'
 11 records deleted on "/Users/el/Downloads/r.csv".
 Commit: file "/Users/el/Downloads/r.csv" is updated.

el

On 09/09/2020 12:23, cpkio wrote:

The interactive CLI is sluggish and unusable, so I'm using command line queries, which are committing right there and now. Would be useful to see in advance what's going to happen. Maybe I'm missing something? [...]

-- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist el@lisse.NA / * | Telephone: +264 81 124 6733 (cell) PO Box 8421 Bachbrecht \ / If this email is signed with GPG/PGP 10007, Namibia ;____/ Sect 20 of Act No. 4 of 2019 may apply

cpkio commented 3 years ago

Sorry if this appeared to be rude, didn't mean to. This was helpful, thanks. Closing.