Add support for UPDATE / DELETE operations

[zhcy]

Would you mind add update support to this tool.
eg.update dest = 'xxxx' to copy select result file to dest folder.
or delete from where XXX
I just want this tool long ago. Thanks in advance.

[kashav]

Hey @zhcy, thanks for the request! I'll definitely consider implementing something like this. It might require a large refactor though, so I can't guarantee anything. You should know that you can use common unix tools to accomplish some of these things, take a look at xargs.

For example, to copy all files with the name foo to ~/Desktop/bar:

$ mkdir -p ~/Desktop/bar
$ fsql "SELECT FULLPATH(name) FROM . WHERE name = foo" | xargs -I {} cp {} ~/Desktop/bar

Although I do agree that something like the following is a lot nicer to use.

$ fsql "COPY TO ~/Desktop/bar FROM . WHERE name = foo"

[zhcy]

@kshvmdn
Thanks for your reply. My main working environment is windows os (I think many people the same).
I do like unix tools,but sometimes I can't use it.
And I prefer "sql" this style
update dest = '~/Desktop/bar' FROM . WHERE name = foo
OR delete FROM . WHERE name = foo
Anyway,Thanks for your work.