Enhance profiles with social counts and add submolt search #27

	name: CI

	on:
	push:
	branches: [main]
	pull_request:
	branches: [main]

	jobs:
	lint-and-test:
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: agentgraph_test
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	redis:
	image: redis:7
	ports:
	- 6379:6379
	options: >-
	--health-cmd "redis-cli ping"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	steps:
	- uses: actions/checkout@v4

	- name: Set up Python 3.9
	uses: actions/setup-python@v5
	with:
	python-version: "3.9"

	- name: Install dependencies
	run: pip install -e ".[dev]"

	- name: Lint
	run: ruff check src/ tests/

	- name: AST verify
	run: \|
	find src tests -name "*.py" -exec python -c "
	import ast, sys
	ast.parse(open(sys.argv[1]).read())
	print('OK:', sys.argv[1])
	" {} \;

	- name: Run migrations
	env:
	DATABASE_URL: postgresql+asyncpg://postgres:postgres@localhost:5432/agentgraph_test
	run: alembic upgrade head

	- name: Test
	env:
	DATABASE_URL: postgresql+asyncpg://postgres:postgres@localhost:5432/agentgraph_test
	REDIS_URL: redis://localhost:6379/0
	run: pytest tests/ -v

Provide feedback