package db

import (
	"errors"
	"fmt"
	"os/exec"
	"syscall"

	"git.faercol.me/faercol/polyculeconnect/polyculeconnect/cmd/utils"
	"git.faercol.me/faercol/polyculeconnect/polyculeconnect/config"
	"github.com/spf13/cobra"
)

// connectCmd represents the db connect command
var connectCmd = &cobra.Command{
	Use:   "connect",
	Short: "Connect to the database",
	Long:  `Connect to the database.`,
	Run: func(cmd *cobra.Command, args []string) {
		conf := utils.InitConfig("")
		if err := connectToDB(conf); err != nil {
			utils.Failf("Failed to connect to DB: %s", err.Error())
		}
	},
}

func connectSQLite(conf *config.StorageConfig) error {
	path, err := exec.LookPath("sqlite3")
	if err != nil {
		if errors.Is(err, exec.ErrNotFound) {
			return errors.New("sqlite3 not installed")
		}
		return fmt.Errorf("failed to find sqlite3 executable: %w", err)
	}

	if err := syscall.Exec(path, []string{path, conf.File}, nil); err != nil {
		return fmt.Errorf("failed to run sqlite3 command: %w", err)
	}
	return nil
}

func connectToDB(conf *config.AppConfig) error {
	switch conf.StorageType {
	case string(config.Memory):
		return errors.New("no DB associated with memory storage")
	case string(config.SQLite):
		return connectSQLite(conf.StorageConfig)
	default:
		return fmt.Errorf("unsupported storage type %q", conf.StorageType)
	}
}

func init() {
	dbCmd.AddCommand(connectCmd)

	// Here you will define your flags and configuration settings.

	// Cobra supports Persistent Flags which will work for this command
	// and all subcommands, e.g.:
	// dbCmd.PersistentFlags().String("foo", "", "A help for foo")

	// Cobra supports local flags which will only run when this command
	// is called directly, e.g.:
	// dbCmd.Flags().BoolP("toggle", "t", false, "Help message for toggle")
}