integration_tests/

Integration Tests

This directory contains integration tests for the neat ORM.

Setup

Integration tests require actual database connections to be set up. The tests can be run against:

• MySQL
• PostgreSQL
• SQLite
• Turso

Environment Variables

Before running integration tests, set up the following environment variables:

# MySQL
MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_DATABASE=test
MYSQL_USER=root
MYSQL_PASS=root

# PostgreSQL
POSTGRES_HOST=127.0.0.1
POSTGRES_PORT=5432
POSTGRES_DATABASE=test
POSTGRES_USER=test
POSTGRES_PASS=test
POSTGRES_SSLMODE=disable

# Turso (optional - if not set, tests use local SQLite)
TURSO_URL=your-database-url.turso.io
TURSO_AUTH_TOKEN=your-auth-token

Running Tests

To run integration tests with the integration build tag:

# Run all integration tests
go test -tags=integration ./integration_tests/...

# Run MySQL integration tests
go test -tags=integration ./integration_tests/mysql/...

# Run PostgreSQL integration tests
go test -tags=integration ./integration_tests/postgres/...

# Run SQLite integration tests
go test -tags=integration ./integration_tests/sqlite/...

# Run Turso integration tests
go test -tags=integration ./integration_tests/turso/...

# Run common integration tests
go test -tags=integration ./integration_tests/common/...

Turso Integration Tests

Turso integration tests can run in two modes:

1. Remote Turso Database: Set TURSO_URL and TURSO_AUTH_TOKEN environment variables to test against a real Turso database
2. Local SQLite: If Turso environment variables are not set, tests will use a local SQLite database (since Turso is SQLite-based)

CI/CD

Integration tests are automatically run in GitHub Actions using the integration-tests.yml workflow. This workflow sets up MySQL, PostgreSQL, and SQLite services and runs the tests with the integration build tag.