Regex query with variables using Go client QueryWithVars

[mbudge]

Is it possible to use variables with regex search in Go?

We could built the query with SprintF but that would be insecure.

q :=query Search($searchterm: string) {
subdomains(func: regexp(name, /^.*$searchterm/)) {
uid:uid
name:name
}
}

[pawanrawal]

You might want to have a look at https://discuss.dgraph.io/t/variables-in-regex-is-this-an-acceptable-use-for-dgraph/2193.

[mbudge]

Hi thanks but I already saw that article and it didn't help. It's for the javascript library and I'm using the Go client.

The following query does not return any results, even tho they exist.

q := `query Search($searchterm: string) {
			subdomains(func: regexp(name, /$searchterm/)) {
				uid:uid
				name:name
			}
		}`

Or this

q := `query Search($searchterm: string) {
			subdomains(func: regexp(name, /.*$searchterm.*/)) {
				uid:uid
				name:name
			}
		}`

Please could someone update the Go documentation to show how to use regex with variables?

[mbudge]

Still can't get this to work when I call QueryWithVars using the Go client.

searchterm := vars["searchterm"]

variableMap := map[string]string{"$searchterm": searchterm}

txn.QueryWithVars(ctx, q, variableMap)

[alexthomas93]

Hi @pawanrawal I'm also having trouble with this issue. Any advice you have would be much appreciated.

[zboralski]

@mbudge have you tried subdomains(func: regexp(name, $searchterm)) and set searchterm to /REGEXP/.

[mbudge]

It didn't work as regex requires /regex/ in the func

variableMap := map[string]string{"$domain": fmt.Sprintf("/%s/", domain)}

q := `query Subdomains($domain: string) {
     subdomains(func: regexp(name, $domain)) {
          uid:uid
          name:name
     }
}`

resp, err := txn.QueryWithVars(ctx, q, variableMap)

Error code

rpc error: code = Unknown desc = : Function 'regexp' requires 2 arguments, but got 1 ([//domain.co.uk//])

@pawanrawal Could this be a bug in the dgraph Go client?

[pawanrawal]

Looks like GraphQL variables aren't supported in arguments for regex function. I am working on a fix.