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 VSIXLibraries 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.
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.
| API | Use |
|---|---|
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.
