Regexp in Golang not matching

Question

I'm currently writing tests for SQL using the package sqlmock, however, I've been unable to find a regular expression that seems to match what I would have thought was a relatively simple expression.

I've included a play url with the code below. However, I'm unsure as to why these strings don't match?

http://play.golang.org/p/I6QZkjkLmj

package main

import (
    "fmt"
    "regexp"
)

var myExp = regexp.MustCompile(`SELECT count(\*) FROM video_resource WHERE key = $1`)

func main() {
    fmt.Println(myExp)
    fmt.Println("SELECT count(\\*) FROM video_resource WHERE key = $1")
    matched := myExp.MatchString("SELECT count(\\*) FROM video_resource WHERE key = $1")
    fmt.Println(matched)
    fmt.Printf("%+v", myExp.MatchString("SELECT count(*) FROM video_resource WHERE key = $1"))
}

For others, I was trying to match the entire string. It's part of the sqlmock library as a method to do mock integrations for the database/sql library in golang. — Jamie
– Jamie, Commented Oct 24, 2014 at 18:22

hwnd · Accepted Answer · 2014-10-24 18:16:38Z

3

Your regular expression contains metacharacters that need to be escaped.

regexp.MustCompile(`SELECT count\(\*\) FROM video_resource WHERE key = \$1`)

Play

edited Oct 24, 2014 at 18:16

answered Oct 24, 2014 at 18:07

hwnd

70.9k4 gold badges100 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jamie Over a year ago

Thank you, for some reason I was intensely focused on the *, and totally oblivious to the other problems.

laher · Accepted Answer · 2014-10-24 18:07:44Z

0

Brackets and dollar signs are significant in regular expressions and should be escaped.

This would make your first boolean evaluate to true:

`SELECT count\(\\\*\) FROM video_resource WHERE key = \$1`

or this for the second:

`SELECT count\(\*\) FROM video_resource WHERE key = \$1`

See here: http://play.golang.org/p/apkker73wr

answered Oct 24, 2014 at 18:07

laher

9,1783 gold badges31 silver badges39 bronze badges

Collectives™ on Stack Overflow

Regexp in Golang not matching

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related