()
| 428 | } |
| 429 | |
| 430 | func ExampleSelectBuilder_ToSql() { |
| 431 | |
| 432 | var db *sql.DB |
| 433 | |
| 434 | query := Select("id", "created", "first_name").From("users") |
| 435 | |
| 436 | sql, args, err := query.ToSql() |
| 437 | if err != nil { |
| 438 | log.Println(err) |
| 439 | return |
| 440 | } |
| 441 | |
| 442 | rows, err := db.Query(sql, args...) |
| 443 | if err != nil { |
| 444 | log.Println(err) |
| 445 | return |
| 446 | } |
| 447 | |
| 448 | defer rows.Close() |
| 449 | |
| 450 | for rows.Next() { |
| 451 | // scan... |
| 452 | } |
| 453 | } |
| 454 | |
| 455 | func TestRemoveColumns(t *testing.T) { |
| 456 | query := Select("id"). |