osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Regex for changing :variable to ${variable} in sql query


Hi,

I have a sql query in which all variables declared as :variable should be changed to ${variable}. 

for example this sql:

select * 
from table 
where ":x" = "1" and :y=2
and   field in (:string)
and   time between :from and  :to


should be translated to:

select * 
from table 
where "${x}" = "1" and ${y} = 2
and   field in ( ${string} )
and   time between ${from} and ${to}

As far as I have come is to find the group as (:(.+?)\b)
and than replace it as ${$2} 

(it would be nice if before and after the ${variable} it is always one space)

For opposite change (from ${variable} notation to :variable) I am using:

sql.replace('${', ':').replace('}', '')

Can someone please help?

Regards.