Function test_delete

tests/test_sql.py:199–211

(sql_context)

def test_delete(sql_context):
    db, dialect, is_psycopg = sql_context
    sql = IntFields.filter(intnum=2).delete().sql()
    if dialect == "mysql":
        expected = "DELETE FROM `intfields` WHERE `intnum`=%s"
    elif dialect == "postgres":
        if is_psycopg:
            expected = 'DELETE FROM "intfields" WHERE "intnum"=%s'
        else:
            expected = 'DELETE FROM "intfields" WHERE "intnum"=$1'
    else:
        expected = 'DELETE FROM "intfields" WHERE "intnum"=?'
    assert sql == expected


@pytest.mark.asyncio