I have an SQL text with arguments in the form ":argument_1" How do I get a list of the used arguments used in this SQL using parse?
Endo
Something like this? >> digit: charset [#"0" - #"9"] >> alpha: charset [#"a" - #"z" #"A" - #"Z"] >> alphanum: union alpha digit >> validchars: union alphanum charser [#"_"] ;put any other valid chars here >> sql: {select * from table where a = :param1 and b=:param2 or x=3} >> parse/all sql [some [thru ":" copy p some avlidchars (print p) | skip]] param1 param2
You may need to cleanup comments, You can use something like:
remove-sql-comments: has [m n] [ parse/all read clipboard:// [ some [ m: "--" to newline n: (remove/part m n) :m | m: "/*" thru "*/" n: (remove/part m n) :m | skip ] ] ]
Arnold
Thank you Endo. This is very useful.
Endo
It is not complete, it doesn't care about comments in strings, but you got the idea.
szeng
Can anybody help me to replace all of "on-init" in the parttern of "space on-init non-word" with "abcd" in a string?
I've tried
space: charset [#" " #"^-"] word: charset [#"a" - #"z" #"A" - #"Z" #"-"] non-word: complement word on-init-rule: [ space mark: "on-init" non-word ( remove/part mark 7 ;remove on-init insert mark "abcd" ) ]
parse/all inp: {abcasdfasdf on-init a on-init b } [ any [ thru on-init-rule ] ]
it failed with:
** Script error: PARSE - invalid rule or usage of rule: make bitset! #{0040000080} ** Where: parse do either either either -apply- ** Near: parse/all inp: {abcasdfasdf on-init a on-init b } [ any ...
>> q
DocKimbel
Here is a working version:
space: charset [#" " #"^-"] word: charset [#"a" - #"z" #"A" - #"Z" #"-"] non-word: complement word on-init-rule: [ space mark: "on-init" non-word ( remove/part mark 7 ;remove on-init mark: insert mark "abcd" ) :mark ]
parse/all inp: {abcasdfasdf on-init a on-init b } [some [on-init-rule | skip]]
szeng
Thanks Doc, I'''' give it a try
Yes, it works. Thanks!
DocKimbel
You're welcome.
Endo
parse/all #{010203} [thru #{03} (print ".")] ;works on R3 and Red but fails on R2, any workaround for this?
Arnold
There is no refinement all. Leave that out and the output is like the output for R3 with all refinement.
So is the only workaround parsing binary! is converting to string!? Although this one works, it looks parsing with binary! works but TO / THRU doesn't.
R2> parse/all #{010203} [#{010203}] == true
Arnold
Sorry I only use a Red version from before the libRed changes. that is why I got the message red>> parse/all #{010203} [thru #{03} (print ".")] *** Script Error: parse has no refinement called all *** Where: parse
Endo
Sure, there is no /all in Red, it is default. I meant the difference of TO with binary!.