import wmill
from typing import List
# Auto-generated UI form generated from types!
def main(table_name: str, min_score: int = 75) -> dict:
    """Fetch high-priority customer records and sync to CRM."""
    db = wmill.get_resource("u/admin/postgres_db")
    results = db.query(
        f"SELECT id, email, score FROM {table_name} WHERE score >= %s",
        [min_score]
    )
    return {
        "processed": len(results),
        "accounts": results
    }

import * as wmill from "npm:windmill-client";
export async function main(
  customerEmail: string,
  refundAmount: number
) {
  // Access centrally managed secrets securely
  const stripeKey = await wmill.getVariable("STRIPE_SECRET_KEY");
  console.log(`Processing refund of $${refundAmount} for ${customerEmail}`);
  
  return {
    status: "approved",
    timestamp: new Date().toISOString()
  };
}

-- Direct database querying with typed parameters
SELECT 
    users.id,
    users.email,
    count(orders.id) as total_orders,
    sum(orders.total) as lifetime_value
FROM users
JOIN orders ON orders.user_id = users.id
WHERE orders.created_at >= :start_date
GROUP BY users.id, users.email
HAVING sum(orders.total) > :min_spend;

#!/usr/bin/env bash
# Inputs are automatically injected as environment variables!
echo "Running system backup for workspace: $WORKSPACE_NAME"
pg_dump -h $PG_HOST -U $PG_USER $PG_DATABASE > /tmp/backup.sql
aws s3 cp /tmp/backup.sql s3://$S3_BUCKET/backups/$(date +%Y-%m-%d).sql
echo "Backup successfully uploaded to S3!"

package main
import (
    "fmt"
    "github.com/windmill-labs/windmill-go-client"
)
type Input struct {
    ClusterID string `json:"cluster_id"`
}
func Main(args Input) (map[string]interface{}, error) {
    fmt.Printf("Deploying update to cluster: %s\n", args.ClusterID)
    return map[string]interface{}{
        "status": "synchronized",
        "cluster": args.ClusterID,
    }, nil
}