More efficient programming of the unlang language

[Matthew Newton]

On Mon, 2018-04-23 at 15:56 +0200, Marijn van Gool wrote:
> 
> if ("%{sql:SELECT username FROM radcheck WHERE username LIKE
> '%{string:&ADSL-Agent-Remote-Id}@%%' LIMIT 1}" != "") {
> 	update request {
>         	User-Name := "%{sql:SELECT username FROM radcheck
> WHERE username LIKE '%{string:&ADSL-Agent-Remote-Id}@%%' LIMIT 1}"
> 	}        
> }
> 
> Basically what I’m trying to do is to check if the query in question
> returns the username and to use this username in a self created
> variable later on.
> Something like this:
> 
> username-var = SELECT query;
> 
> if (username-var != “”) {
> 	update-request {
> 		User-Name := username-var
> 	}
> }
> 
> How would I achieve this? What is the syntax that can be used here?

Pretty much what you've written? This is all in the unlang man page.

Use a temporary attribute, something like

update control {
	&Tmp-String-1 := "%{sql:SELECT username .....}"
}        

if (&control:Tmp-String-1) {
	update request {
        	&User-Name := &control:Tmp-String-1
	}        
}

I'd update the things that use the User-Name attribute, though, rather
than changing the attribute itself.

-- 
Matthew