func BenchmarkFormatQueryWithStructMethods(b *testing.B) { rec := &Record{ Num1: 1, Num2: 2, Num3: 3, Str1: randSeq(100), Str2: randSeq(200), Str3: randSeq(300), } for i := 0; i < b.N; i++ { _, err := pg.FormatQuery(` SELECT ?GetNum1, ?GetNum2, ?GetNum3, ?GetStr1, ?GetStr2, ?GetStr3 WHERE 1=1 AND 2=2 `, rec) if err != nil { b.Fatal(err) } } }
func BenchmarkFormatQueryWithArgs(b *testing.B) { rec := &Record{ Num1: 1, Num2: 2, Num3: 3, Str1: randSeq(100), Str2: randSeq(200), Str3: randSeq(300), } for i := 0; i < b.N; i++ { _, err := pg.FormatQuery(` SELECT ?, ?, ?, ?, ?, ? WHERE 1=1 AND 2=2 `, rec.Num1, rec.Num2, rec.Num3, rec.Str1, rec.Str2, rec.Str3) if err != nil { b.Fatal(err) } } }
func BenchmarkFormatQueryWithoutArgs(b *testing.B) { rec := &Record{ Num1: 1, Num2: 2, Num3: 3, Str1: randSeq(100), Str2: randSeq(200), Str3: randSeq(300), } q := fmt.Sprintf(` SELECT %d, %d, %d, '%s', '%s', '%s' WHERE 1=1 AND 2=2 `, rec.Num1, rec.Num2, rec.Num3, rec.Str1, rec.Str2, rec.Str3) for i := 0; i < b.N; i++ { _, err := pg.FormatQuery(q) if err != nil { b.Fatal(err) } } }
func ExampleInts_in() { ids := pg.Ints{1, 2, 3} q, err := pg.FormatQuery(`SELECT * FROM table WHERE id IN (?)`, ids) fmt.Println(q, err) // Output: SELECT * FROM table WHERE id IN (1,2,3) <nil> }