| 167 | |
| 168 | |
| 169 | def test_count(sql_context): |
| 170 | db, dialect, is_psycopg = sql_context |
| 171 | sql = IntFields.all().filter(intnum=1).count().sql() |
| 172 | if dialect == "mysql": |
| 173 | expected = "SELECT COUNT(*) FROM `intfields` WHERE `intnum`=%s" |
| 174 | elif dialect == "postgres": |
| 175 | if is_psycopg: |
| 176 | expected = 'SELECT COUNT(*) FROM "intfields" WHERE "intnum"=%s' |
| 177 | else: |
| 178 | expected = 'SELECT COUNT(*) FROM "intfields" WHERE "intnum"=$1' |
| 179 | else: |
| 180 | expected = 'SELECT COUNT(*) FROM "intfields" WHERE "intnum"=?' |
| 181 | assert sql == expected |
| 182 | |
| 183 | |
| 184 | def test_update(sql_context): |