Files

T

History

CartSnitch Engineer Bot 24f0dd0e67 fix: replace N+1 UPC query with SQL containment in normalization

- Add PostgreSQL JSONB containment (@>) query for match_by_upc
- Add SQLite LIKE fallback for test compatibility
- Update upc_variants column to JSONB with variant for cross-db support
- Add GIN index migration for upc_variants

Co-Authored-By: Paperclip <noreply@paperclip.ing>

2026-04-14 11:59:28 +00:00

.github/workflows

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

alembic

fix(api): escape percent signs in alembic database URL for configparser

2026-04-04 06:31:48 +00:00

scripts/stats

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

src/cartsnitch_common

fix: replace N+1 UPC query with SQL containment in normalization

2026-04-14 11:59:28 +00:00

tests

feat(common): sync email_inbound_token from standalone repo

2026-04-03 20:12:35 +00:00

.gitignore

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

alembic.ini

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

CLAUDE.md

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

Dockerfile

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

pyproject.toml

feat: add dedicated UAT seed user with known credentials

2026-03-29 21:20:31 +00:00

README.md

feat: add dedicated UAT seed user with known credentials

2026-03-29 21:20:31 +00:00

renovate.json

Merge commit '4cf6f91e954b770198578bcb8db5d98ac964bfed' as 'common'

2026-03-28 02:24:14 +00:00

README.md

CartSnitch Common

Shared models, schemas, and utilities for CartSnitch services.

Test Users

The following users are seeded by cartsnitch-seed and can be used for local development and UAT.

Email	Password	Display Name	Notes
`uat@cartsnitch.com`	`CartSnitch-UAT-2026!`	UAT Tester	Primary UAT account. Use for regression testing in the CartSnitch frontend. Created by the seed runner via Better-Auth's bcrypt path — credentials work against the live auth service. Idempotent; re-running the seed skips this user if it already exists.

Running the Seed

# Install with seed dependencies
pip install -e "cartsnitch-common[seed]"

# Run (requires CARTSNITCH_DATABASE_URL_SYNC)
CARTSNITCH_DATABASE_URL_SYNC=postgresql://user:pass@localhost:5432/cartsnitch \
  cartsnitch-seed

Architecture

Models live in src/cartsnitch_common/models/
Alembic migrations run via the api service (api/alembic/)
Seed runner runs via cartsnitch-seed (installed as a package entry point)