Autonomous AI sales agent powered by Claude Code or Codex. Finds prospects, writes cold emails, sends campaigns, handles replies, books meetings. No API keys needed — runs on your Claude or Codex subscriptions.
"""Tests for state management (SQLite operations)."""
import asyncio
import tempfile
import os
import pytest
import pytest_asyncio
from harvey.state import StateManager
from harvey.models.prospect import Prospect
from harvey.models.company import Company
@pytest_asyncio.fixture
async def state():
"""Create a StateManager with a temp database."""
with tempfile.TemporaryDirectory() as tmpdir:
db_path = os.path.join(tmpdir, "test.db")
sm = StateManager(db_path)
await sm.init_db()
yield sm
@pytest.mark.asyncio
async def test_add_and_get_company(state):
company = Company(name="Acme", domain="acme.com", industry="SaaS")
company_id = await state.add_company(company)
assert company_id
fetched = await state.get_company_by_domain("acme.com")
assert fetched is not None
assert fetched.name == "Acme"
@pytest.mark.asyncio
async def test_company_exists(state):
company = Company(name="Acme", domain="acme.com")
await state.add_company(company)
assert await state.company_exists("acme.com")
assert not await state.company_exists("notreal.com")
@pytest.mark.asyncio
async def test_add_and_get_prospect(state):
p = Prospect(
first_name="Jane", last_name="Doe", email="[email protected]",
title="VP Sales", status="new",
)
prospect_id = await state.add_prospect(p)
assert prospect_id
assert await state.prospect_exists(email="[email protected]")
assert not await state.prospect_exists(email="[email protected]")
@pytest.mark.asyncio
async def test_get_prospect_by_email(state):
p = Prospect(
first_name="Jane", last_name="Doe", email="[email protected]",
title="VP Sales",
)
await state.add_prospect(p)
found = await state.get_prospect_by_email("[email protected]")
assert found is not None
assert found.first_name == "Jane"
not_found = await state.get_prospect_by_email("[email protected]")
assert not_found is None
@pytest.mark.asyncio
async def test_prospect_status_update(state):
p = Prospect(first_name="Jane", last_name="Doe", email="[email protected]", title="VP")
pid = await state.add_prospect(p)
await state.update_prospect_status(pid, "contacted")
prospects = await state.get_prospects_by_status("contacted")
assert len(prospects) == 1
assert prospects[0].status == "contacted"
@pytest.mark.asyncio
async def test_usage_tracking(state):
"""Usage increment should use UPSERT, not insert duplicate rows."""
await state.increment_usage()
await state.increment_usage()
await state.increment_usage()
count = await state.get_usage_today()
assert count == 3
@pytest.mark.asyncio
async def test_reply_deduplication(state):
assert not await state.is_reply_processed("reply-123")
await state.mark_reply_processed("reply-123")
assert await state.is_reply_processed("reply-123")
# Marking again should not error
await state.mark_reply_processed("reply-123")
@pytest.mark.asyncio
async def test_contacts_for_company(state):
company = Company(name="Acme", domain="acme.com")
cid = await state.add_company(company)
p1 = Prospect(first_name="Jane", last_name="Doe", email="[email protected]", title="VP", company_id=cid)
p2 = Prospect(first_name="John", last_name="Doe", email="[email protected]", title="Dir", company_id=cid)
await state.add_prospect(p1)
await state.add_prospect(p2)
contacts = await state.get_contacts_for_company(cid)
assert len(contacts) == 2