(c *gc.C)
| 167 | } |
| 168 | |
| 169 | func (s *StmtSuite) TestSelectOrderByDesc(c *gc.C) { |
| 170 | q := table1.Select(table1Col1, table1Col2).OrderBy(Desc(table1Col2)) |
| 171 | sql, err := q.String("db") |
| 172 | |
| 173 | c.Assert(err, gc.IsNil) |
| 174 | c.Assert( |
| 175 | sql, |
| 176 | gc.Equals, |
| 177 | "SELECT `table1`.`col1`,`table1`.`col2` "+ |
| 178 | "FROM `db`.`table1` ORDER BY `table1`.`col2` DESC") |
| 179 | } |
| 180 | |
| 181 | func (s *StmtSuite) TestSelectMultiOrderBy(c *gc.C) { |
| 182 | q := table1.Select(table1Col1, table1Col2) |