attempt to fix windows build

.github/workflows/artcraft-windows-publish.yml

@@ -26,14 +26,23 @@ jobs:
     steps:
       - uses: actions/checkout@v4
 
+      - name: install Rust stable
+        uses: dtolnay/rust-toolchain@stable
+
+      - name: install wreq dependencies
+        run: |
+          choco install cmake -y
+          choco install strawberryperl -y
+          choco install pkgconfiglite -y
+          choco install llvm -y
+          choco install nasm -y
+        shell: cmd
+
       - name: setup node
         uses: actions/setup-node@v4
         with:
           node-version: lts/*
 
-      - name: install Rust stable
-        uses: dtolnay/rust-toolchain@stable
-
       - name: install frontend dependencies
         run: |
           # Navigate to the frontend directory to install dependencies
@@ -83,6 +92,8 @@ jobs:
       - name: build and publish
         uses: tauri-apps/tauri-action@v0
         env:
+          # NB(bt): This is needed by wreq. Hopefully it doesn't kill Tauri
+          RUSTFLAGS: "-C target-feature=+crt-static"
           GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
           # Use the SQLx query cache for SQLite
           SQLX_OFFLINE: true

crates/api_clients/midjourney_client/Cargo.toml

@@ -33,7 +33,15 @@ serde_json.workspace = true
 url.workspace = true
 
 # NB: wreq gets past fingerprinting, but we have to deal with platform-specific build issues.
-# Mac: brew install --formula cmake pkg-config llvm
+#
+# Mac:
+#   brew install --formula cmake pkg-config llvm
+# Windows:
+#   choco install cmake -y
+#   choco install strawberryperl -y
+#   choco install pkgconfiglite -y
+#   choco install llvm -y
+#   choco install nasm -y
 wreq = { version = "5", features = ["json"] }
 wreq-util = "2"
 tokio = { version = "1", features = ["full"] }

script/rust/windows_sqlite_migrate.ps1

@@ -0,0 +1,13 @@
+# This script is a little rough
+
+# Step 1
+cargo sqlx migrate run \
+  --database-url "sqlite:C:\Users\Bombay\AppData\Local\Temp\tasks.sqlite" \
+  --source "C:\Users\Bombay\Documents\GitHub\storyteller-rust\_sql\artcraft_migrations"
+
+# Step 2
+Push-Location -Path ".\crates\schema\database\sqlite_tasks"
+cargo sqlx prepare \
+  --database-url "sqlite:C:\Users\Bombay\AppData\Local\Temp\tasks.sqlite"
+Pop-Location
+