search

mithrandie / csvq

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

Request for Feature #61

Closed ondohotola closed 2 years ago

ondohotola commented 3 years ago

Would it be difficult to add another output format similar to TEXT but using Unicode drawing characters, ie what the parameter "-box" does for sqlite3?

It's just for aesthetics :-)-O

greetings, el

mithrandie commented 3 years ago

I want that feature too! Maybe it's not so difficult to implement.

mithrandie commented 2 years ago

This feature has been included in version 1.16.0.

ondohotola commented 2 years ago

Fantastic!

el

— Sent from Dr Lisse’s iPhone/iPad On 26. Feb 2022, 21:47 +0200, Yuki @.***>, wrote:

Closed #61. — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you authored the thread.Message ID: @.***>

ondohotola commented 2 years ago

Awesome,

changed all my functions and scripts to use -f BOX.

Is there a way of making this default, ie, what would one have to enter into the .csvq_env.json file?

greetings, el

On 27/02/2022 08:38, Dr Eberhard W Lisse wrote:

Fantastic!

el

— Sent from Dr Lisse’s iPhone/iPad On 26. Feb 2022, 21:47 +0200, Yuki @.***>, wrote:

Closed #61 https://github.com/mithrandie/csvq/issues/61. [...]

-- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist @.** / | 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

mithrandie commented 2 years ago

.csvq_env.json can only set a few options. You can write statements in a specific file and run it before each execution.

touch $HOME/.csvqrc
echo 'SET @@FORMAT TO BOX' > $HOME/.csvqrc

These files will be loaded and run before each execution.

  1. $XDG_CONFIG_HOME/csvq/csvqrc or $HOME/.config/csvq/csvqrc
  2. $HOME/.csvqrc
  3. $HOME/.csvq/csvqrc
  4. CURRENT_DIRECTORY/csvqrc

cf. https://mithrandie.github.io/csvq/reference/command.html#configurations

ondohotola commented 2 years ago

Perfect!

Thank you

el

On 01/03/2022 13:35, Yuki wrote:

|touch $HOME/.csvqrc echo 'SET @@FORMAT TO BOX' > $HOME/.csvqrc|

-- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist @.** / | 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