| 446 | } |
| 447 | |
| 448 | func (s *StmtSuite) TestUpdateWithOrderBy(c *gc.C) { |
| 449 | stmt := table1.Update().Set(table1Col1, Literal(1)) |
| 450 | stmt.Where(EqL(table1Col2, 2)) |
| 451 | stmt.OrderBy(table1Col2) |
| 452 | sql, err := stmt.String("db") |
| 453 | c.Assert(err, gc.IsNil) |
| 454 | |
| 455 | c.Assert( |
| 456 | sql, |
| 457 | gc.Equals, |
| 458 | "UPDATE `db`.`table1` "+ |
| 459 | "SET `table1`.`col1`=1 "+ |
| 460 | "WHERE `table1`.`col2`=2 "+ |
| 461 | "ORDER BY `table1`.`col2`") |
| 462 | } |
| 463 | |
| 464 | func (s *StmtSuite) TestUpdateWithLimit(c *gc.C) { |
| 465 | stmt := table1.Update().Set(table1Col1, Literal(1)) |