Skip to content

Add CI pipelines for build, SQL, and DuckDB validation#75

Merged
erikdarlingdata merged 2 commits intodevfrom
feature/ci-pipelines
Feb 16, 2026
Merged

Add CI pipelines for build, SQL, and DuckDB validation#75
erikdarlingdata merged 2 commits intodevfrom
feature/ci-pipelines

Conversation

@erikdarlingdata
Copy link
Owner

@erikdarlingdata erikdarlingdata commented Feb 16, 2026

Summary

  • ci.yml: Builds all 5 projects (Dashboard, Lite, Installer, InstallerGui, Lite.Tests) and runs DuckDB schema tests on every PR/push to dev
  • sql-validation.yml: Installs all 51 SQL scripts on a matrix of SQL Server 2017/2019/2022/2025, validates all 93 objects exist (path-filtered to install/**)
  • Lite.Tests: 6 xUnit tests covering DuckDB schema initialization, version correctness, idempotency, archive directory creation, table count, and index creation

What this catches

  • .NET build breaks across all projects
  • SQL install script syntax errors or version incompatibilities
  • DuckDB schema drift (missing tables, wrong version, broken migrations)
  • Regressions on older SQL Server versions (2017/2019)

Closes #77

Test plan

  • All 6 DuckDB tests pass locally (dotnet test Lite.Tests/ -c Release)
  • SQL validation script verified against sql2022 (93 objects found)
  • CI workflow passes on GitHub Actions

🤖 Generated with Claude Code

erikdarlingdata and others added 2 commits February 16, 2026 15:45
…B schema tests

- ci.yml: Build all 5 projects + run Lite.Tests on PR/push to dev
- sql-validation.yml: Install all SQL scripts on 2017/2019/2022/2025 matrix, validate 93 objects exist
- ci_validate_installation.sql: OBJECT_ID checks for all schemas, tables, procedures, views
- Lite.Tests: 6 xUnit tests for DuckDB schema init, version, idempotency, indexes

All tests verified locally against sql2022 and DuckDB.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
…igured Microsoft apt repo

- Health check: grep errorlog instead of sqlcmd (works across all container versions)
- Install sqlcmd: skip repo setup if Microsoft repo already configured (Ubuntu 24.04)
- Increase health retries from 10 to 15 for slower container starts

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 09b2d84 into dev Feb 16, 2026
3 checks passed
@erikdarlingdata erikdarlingdata deleted the feature/ci-pipelines branch February 16, 2026 21:31
@erikdarlingdata erikdarlingdata mentioned this pull request Feb 18, 2026
3 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant