(t *testing.T)
| 9 | ) |
| 10 | |
| 11 | func TestTemplateSelect(t *testing.T) { |
| 12 | |
| 13 | b := sqlbuilder.WithTemplate(template) |
| 14 | assert := assert.New(t) |
| 15 | |
| 16 | assert.Equal( |
| 17 | `SELECT * FROM "artist"`, |
| 18 | b.SelectFrom("artist").String(), |
| 19 | ) |
| 20 | |
| 21 | assert.Equal( |
| 22 | `SELECT * FROM "artist"`, |
| 23 | b.Select().From("artist").String(), |
| 24 | ) |
| 25 | |
| 26 | assert.Equal( |
| 27 | `SELECT * FROM "artist" ORDER BY "name" DESC`, |
| 28 | b.Select().From("artist").OrderBy("name DESC").String(), |
| 29 | ) |
| 30 | |
| 31 | assert.Equal( |
| 32 | `SELECT * FROM "artist" ORDER BY "name" DESC`, |
| 33 | b.Select().From("artist").OrderBy("-name").String(), |
| 34 | ) |
| 35 | |
| 36 | assert.Equal( |
| 37 | `SELECT * FROM "artist" ORDER BY "name" ASC`, |
| 38 | b.Select().From("artist").OrderBy("name").String(), |
| 39 | ) |
| 40 | |
| 41 | assert.Equal( |
| 42 | `SELECT * FROM "artist" ORDER BY "name" ASC`, |
| 43 | b.Select().From("artist").OrderBy("name ASC").String(), |
| 44 | ) |
| 45 | |
| 46 | assert.Equal( |
| 47 | `SELECT * FROM "artist" LIMIT 1 OFFSET 5`, |
| 48 | b.Select().From("artist").Limit(1).Offset(5).String(), |
| 49 | ) |
| 50 | |
| 51 | assert.Equal( |
| 52 | `SELECT * FROM "artist" LIMIT 1 OFFSET 5`, |
| 53 | b.Select().From("artist").Offset(5).Limit(1).String(), |
| 54 | ) |
| 55 | |
| 56 | assert.Equal( |
| 57 | `SELECT * FROM "artist" OFFSET 5`, |
| 58 | b.Select().From("artist").Limit(-1).Offset(5).String(), |
| 59 | ) |
| 60 | |
| 61 | assert.Equal( |
| 62 | `SELECT * FROM "artist" OFFSET 5`, |
| 63 | b.Select().From("artist").Offset(5).String(), |
| 64 | ) |
| 65 | |
| 66 | assert.Equal( |
| 67 | `SELECT "id" FROM "artist"`, |
| 68 | b.Select("id").From("artist").String(), |
nothing calls this directly
no test coverage detected