Skip to content

README.md

Latest commit

 

History

History
34 lines (23 loc) · 928 Bytes

README.md

File metadata and controls

34 lines (23 loc) · 928 Bytes

Birko.Workflow.SQL

SQL-based workflow instance persistence for the Birko Workflow engine. Works with any SQL connector (PostgreSQL, MSSql, MySQL, SQLite).

Features

  • Persists workflow instances to __WorkflowInstances table
  • Generic over SQL connector type (DB : AbstractConnector)
  • Save (upsert), Load, Delete, FindByState/Status/WorkflowName
  • Schema management utilities (EnsureCreated/Drop)

Usage

using Birko.Workflow.SQL;
using Birko.Data.SQL.PostgreSQL.Connectors;

// Create store
var store = new SqlWorkflowInstanceStore<PostgreSqlConnector, OrderData>(settings);

// Save instance
await store.SaveAsync("OrderProcessing", instance);

// Load instance
var loaded = await store.LoadAsync(instanceId);

// Query
var active = await store.FindByStatusAsync(WorkflowStatus.Active);
var pending = await store.FindByStateAsync("Pending");

License

MIT License - see License.md