(sql_context)
| 53 | |
| 54 | |
| 55 | def test_group_by(sql_context): |
| 56 | db, dialect, is_psycopg = sql_context |
| 57 | sql = IntFields.all().group_by("intnum").values("intnum").sql() |
| 58 | if dialect == "mysql": |
| 59 | expected = "SELECT `intnum` `intnum` FROM `intfields` GROUP BY `intnum`" |
| 60 | else: |
| 61 | expected = 'SELECT "intnum" "intnum" FROM "intfields" GROUP BY "intnum"' |
| 62 | assert sql == expected |
| 63 | |
| 64 | |
| 65 | def test_annotate(sql_context): |