args.go

package mysqlcommon

import (
	"strconv"

	"github.com/nixrajput/siphon/internal/driver"
)

// BuildDumpArgs assembles the mysqldump argument vector for a backup. The
// binary name itself is supplied by the caller (mysqldump vs mariadb-dump).
func BuildDumpArgs(p driver.Profile, opt driver.BackupOpts) []string {
	args := []string{
		"-h", p.Host,
		"-P", strconv.Itoa(p.Port),
		"-u", p.User,
		"--single-transaction",
		"--routines",
		"--triggers",
		"--events",
		"--no-tablespaces",
		"--skip-comments",
		p.Database,
	}
	if opt.SchemaOnly {
		args = append(args, "--no-data")
	}
	if opt.DataOnly {
		args = append(args, "--no-create-info")
	}
	args = append(args, opt.IncludeTables...)
	for _, t := range opt.ExcludeTables {
		args = append(args, "--ignore-table="+p.Database+"."+t)
	}
	return args
}

// BuildRestoreArgs assembles the mysql client argument vector for a restore.
// The dump file is authoritative for shape; the restore client just pipes it
// in. Clean is a no-op here because mysqldump output already emits
// DROP TABLE IF EXISTS / CREATE TABLE, making the restore idempotent.
func BuildRestoreArgs(p driver.Profile, _ driver.RestoreOpts) []string {
	return []string{
		"-h", p.Host,
		"-P", strconv.Itoa(p.Port),
		"-u", p.User,
		"--default-character-set=utf8mb4",
		p.Database,
	}
}

// NOTE: Profile.SSLMode is honored by the connect DSN (see dsn.go) but is NOT
// yet propagated to the dump/restore CLI tools. The flag differs across forks —
// MySQL's mysqldump uses --ssl-mode=<DISABLED|REQUIRED|VERIFY_CA|VERIFY_IDENTITY>
// while MariaDB's mariadb-dump uses --ssl / --skip-ssl — so it needs per-fork
// handling (and the dump tools' stderr surfaced so a rejected flag isn't opaque).
// Tracked as a follow-up; see the PR #4 discussion.