Can I ask for a help on creating regex for templater ?

[eshepelyuk]

I need to support this style of placeholder

select bar
from bar
where id = :#${qwe}

I.e. the placeholder is :#${<param_name>} - specific Apache Camel syntax

The best regex I've been to come up with

param_regex = :#\$\{(?P<param_name>.+)}

But it still produces an error and considers : colon not a part of placeholder.

== [src/main/resources/sql/upsert-user-daily-balances.sql] FAIL
L:   3 | P:  13 | LT12 | Files must end with a single trailing newline.
                       | [layout.end_of_file]

sqruff fix converts my file into

select bar
from bar
where id = :
#${qwe}

[benfdking]

Hey,

I was looking into this, and I can't seem to get it behave as you describe. I am running this in the playground as it's just easier.

With the style

select bar
from bar
where id    = :#${qwe}

and config set to

[sqruff]
dialect = ansi
rules = core
templater = placeholder

[sqruff:templater:placeholder]
param_regex = :#\$\{(?P<param_name>.+)}

and it seems to work a treat with the output being

select bar
from bar
where id = :#${qwe}

[eshepelyuk]

Hello @benfdking

The dialect is the issue, if I change .sqruff to

[sqruff]
dialect = postgres
rules = core
templater = placeholder

[sqruff:templater:placeholder]
param_regex = :#\$\{(?P<param_name>.+)}

Then cat test.sql | sqruff fix - gives following error

cat test.sql | sqruff fix -
== [<string>] FAIL
L:   3 | P:  13 | LT12 | Files must end with a single trailing newline.
                       | [layout.end_of_file]
select bar
from bar
where id = :
#${qwe}

[benfdking]

So I debugged it with our new template tab in the playground

It turns out you're regex just simply isn't working. I wonder if something is being escaped in the parsing of the config file. That said I have just gone and implemented it.

New config once deployed would be

[sqruff]
dialect = postgres
rules = core
templater = placeholder

[sqruff:templater:placeholder]
param_style = apache_camel

and #1522 for keeping track.

[eshepelyuk]

Thank you !