id          = "mariadb-10-11"
name        = "MariaDB 10.11"
homepage    = "https://mariadb.org/"
description = "Drop-in replacement for MySQL"
executables      = ["mariadb"]

[dotfiles]

# MariaDB's official option-file documentation identifies ~/.my.cnf as the
# user-scoped option file on Unix-like systems. The versioned server formula
# also reads this shared client/server option file.
# https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files
paths = ["~/.my.cnf"]
secret = []

[[dotfiles.secret_paths]]
file   = "~/.my.cnf"
match  = { prefix = ["password"] }

[[dotfiles.machine_lines]]
file   = "~/.my.cnf"
match  = { prefix = ["socket"] }
scope  = "platform"

[commands]
format = 1
label = "mariadb"
description = "Connect with the MariaDB command-line client, optionally running one statement. Password options are left out; use an option file or the prompt."
quality = "ai-draft"
parser = { end_of_options = "--", interleave = "permute", long_equals = true, short_attached = true, short_bundles = false }

[[commands.source]]
id = "docs"
kind = "manual"
url = "https://mariadb.com/docs/server/clients-and-utilities/mariadb-client/mariadb-command-line-client"
evidence = """-D, --database= name
-e, --execute= name
-h, --host= host
-P, --port= num
-t, --table
-u , --user=
-E, --vertical
-s, --silent
-N, --skip-column-names"""

[[commands.field]]
id = "host"
label = "Host"
type = "string"
option = ["--host", "-h"]
sources = ["docs"]

[[commands.field]]
id = "port"
label = "Port"
type = "integer"
option = ["--port", "-P"]
sources = ["docs"]

[[commands.field]]
id = "user"
label = "User"
type = "string"
option = ["--user", "-u"]
sources = ["docs"]

[[commands.field]]
id = "database"
label = "Database"
type = "string"
option = ["--database", "-D"]
sources = ["docs"]

[[commands.field]]
id = "execute"
label = "Statement"
description = "Run this statement and exit."
type = "string"
option = ["--execute", "-e"]
effect = "exec"
sources = ["docs"]

[[commands.field]]
id = "table"
label = "Table output"
type = "boolean"
option = ["--table", "-t"]
sources = ["docs"]

[[commands.field]]
id = "vertical"
label = "Vertical output"
type = "boolean"
option = ["--vertical", "-E"]
sources = ["docs"]

[[commands.field]]
id = "silent"
label = "Silent"
type = "boolean"
option = ["--silent", "-s"]
sources = ["docs"]

[[commands.field]]
id = "skip_column_names"
label = "Skip column names"
type = "boolean"
option = ["--skip-column-names", "-N"]
sources = ["docs"]

[[commands.task]]
id = "connect"
label = "Connect"
fields = ["host", "port", "user", "database"]
required = []

[[commands.task]]
id = "query"
label = "Run one statement"
fields = ["host", "port", "user", "database", "execute", "table", "vertical", "skip_column_names"]
required = ["execute"]

[[commands.group]]
id = "basic"
label = "Basic"
fields = ["host", "port", "user", "database", "execute"]

[[commands.group]]
id = "advanced"
label = "Advanced"
fields = ["table", "vertical", "silent", "skip_column_names"]