//go:build ignore

package main

import (
	"fmt"
	"log"

	"doormile/config"
	"doormile/db"

	"github.com/joho/godotenv"
)

func main() {
	_ = godotenv.Load()
	cfg := config.Load()
	db.Connect(cfg)
	if db.DB == nil {
		log.Fatal("no DB")
	}
	var avail string
	db.DB.Raw(`SELECT availabilitystatus FROM milerprofiles WHERE userid = 23`).Scan(&avail)
	fmt.Printf("miler 23 availability: %s\n", avail)

	var open int64
	db.DB.Raw(`SELECT count(*) FROM bookingassignments ba
	  JOIN pickupbookings b ON b.bookingid = ba.bookingid
	  WHERE ba.mileruserid = 23 AND ba.assignmentstatus IN ('Assigned','Accepted')`).Scan(&open)
	fmt.Printf("miler 23 open assignments: %d\n", open)

	var onCancelled int64
	db.DB.Raw(`SELECT count(*) FROM bookingassignments ba
	  JOIN pickupbookings b ON b.bookingid = ba.bookingid
	  WHERE ba.assignmentstatus IN ('Assigned','Accepted') AND b.status = 'Cancelled'`).Scan(&onCancelled)
	fmt.Printf("\nACROSS ALL RIDERS — open assignments on a CANCELLED booking: %d\n", onCancelled)
}