import pytest
from crud_operations import CRUDOperations


@pytest.fixture
def crud_operations():
    return CRUDOperations("sample.db")


def test_create(crud_operations):
    crud_operations.create("users", ["id", "name", "age"], [1, "Alice", 25])
    assert crud_operations.read("users", ["id", "name", "age"]) == [(1, "Alice", 25)]


def test_read(crud_operations):
    crud_operations.create("users", ["id", "name", "age"], [1, "Alice", 25])
    assert crud_operations.read("users", ["id", "name", "age"]) == [(1, "Alice", 25)]


def test_update(crud_operations):
    crud_operations.create("users", ["id", "name", "age"], [1, "Alice", 25])
    crud_operations.update("users", {"name": "Bob"}, "id = 1")
    assert crud_operations.read("users", ["id", "name", "age"]) == [(1, "Bob", 25)]


def test_delete(crud_operations):
    crud_operations.create("users", ["id", "name", "age"], [1, "Alice", 25])
    crud_operations.delete("users", "id = 1")
    assert crud_operations.read("users", ["id", "name", "age"]) == []