Blyx

Dunlin

Workflow framework · 0.1.0

Audit a table export for duplicate parents and orphaned child rows.

Audit a parent and child table before import

The parent export repeats ID 1. Two child rows reference the missing ID 2.

Run the native CLI

Extract the workflow collection for your platform. Run .\bin\dunlin.exe --help in PowerShell or ./bin/dunlin --help on Linux and macOS. Running the command with no arguments prints the worked example.

Build from source

With Blyx 0.2.1, Rust and a host linker installed, run these commands to edit and rebuild the example.

git clone --depth 1 --branch v0.1.0 https://github.com/Rahulchaube1/blyx-dunlin.git
cd blyx-dunlin
blyxc native-run project.blyx -- "1,1,3" "1,2,2"

Why this framework exists

A child reference can look valid while the parent key is duplicated. Check uniqueness and referential integrity before a bulk import. PostgreSQL, unique and foreign key constraints

Install Dunlin in your editor

Extension RahulChaube.blyx-dunlin · 0.1.0

The extension includes a runnable Blyx example, function completions and the framework source. For the modular project, extract the starter, open its folder and run blyxc native-run main.blyx with the native toolchain installed.

Create an empty .blyx file, type blyx-dunlin-demo and accept the completion. Choose Blyx: Run File to run the example.

For an offline installation, choose Extensions: Install from VSIX for Blyx Language first, then for Dunlin.

Download the companion Blyx Language VSIX

Libraries in this framework

Install with Conda

Create an environment containing Dunlin 0.1.0, its Blyx source and a runnable example. Run the second command with Blyx 0.2.1, Rust and a host linker installed.

conda create -y --prefix ./blyx-env --override-channels -c https://rahulchaube1.github.io/blyx-packages blyx-dunlin=0.1.0=0
blyxc native-run ./blyx-env/share/blyx/dunlin/main.blyx

To use this package in your application, copy share/blyx/dunlin/vendor/dunlin from the environment into your project's vendor directory.

Install the full collection with Homebrew or Scoop

Import into a Blyx project

Install Blyx 0.2.1, Rust 1.85 or newer and a host linker. From the directory containing your entry file, clone this tagged release.

git clone --depth 1 --branch v0.1.0 https://github.com/Rahulchaube1/blyx-dunlin.git vendor/dunlin

You can also download Dunlin as a ZIP. Extract its contents into vendor/dunlin.

Save this as main.blyx beside vendor and run blyxc native-run main.blyx.

use vendor::dunlin::dunlin;

fn main() {
    let parents = [1, 1, 3];
    let children = [1, 2, 2];
    let result = dunlin_check(parents, children);
    if len(result) == 0 { println!("invalid"); return; }
    let mut i = 0;
    while i < len(result) {
        println!(at(result, i));
        i += 1;
    }
}

Expected output

0
1
2
1

API and input requirements

Returns [load acceptable, duplicate parent rows, orphan child rows, first orphan row]. This local check complements database-enforced constraints. Invalid arguments and nonfinite results return an empty vector.

APIUse
dunlin_check(parents, children)Returns [load acceptable, duplicate parent rows, orphan child rows, first orphan row]. This local check complements database-enforced constraints.

Develop and contribute

Open the tagged source to read the implementation and examples. Include the smallest reproducible Blyx program, compiler version and expected result when reporting an issue.