func (t *DBTest) BenchmarkFormatWithArgs(c *C) {
for i := 0; i < c.N; i++ {
_, err := pg.FormatQ("SELECT ?, ? WHERE 1=1 AND 2=2", "hello", "world")
if err != nil {
panic(err)
}
}
}
func (t *DBTest) BenchmarkFormatWithoutArgs(c *C) {
for i := 0; i < c.N; i++ {
_, err := pg.FormatQ("SELECT 'hello', 'world' WHERE 1=1 AND 2=2")
if err != nil {
panic(err)
}
}
}
func (t *DBTest) TestFormatInts(c *C) {
q, err := pg.FormatQ("?", pg.Ints{1, 2, 3})
c.Assert(err, IsNil)
c.Assert(q, Equals, pg.Q("1,2,3"))
}
func (t *DBTest) TestFormatStrings(c *C) {
q, err := pg.FormatQ("?", pg.Strings{"hello", "world"})
c.Assert(err, IsNil)
c.Assert(q, Equals, pg.Q("'hello','world'"))
}
func (t *DBTest) TestFormatWithTooFewParams(c *C) {
q, err := pg.FormatQ("? ? ?", "foo", "bar")
c.Assert(err.Error(), Equals, "pg: expected at least 3 parameters but got 2")
c.Assert(string(q), Equals, "")
}