Acornfile

name:        "MariaDB Acorn"
description: "Acorn providing MariaDB"
readme:      "./README.md"
icon:        "./mariadb.svg"

info: localData.info

args: {
	// Name of the database to create. Defaults to "instance"
	// Changing this value will have no effect on an existing instance
	dbName: "instance"
	// Name of the user to create. If a username is not set, one is randomly generated
	// Changing this value will have no effect on an existing instance
	username: ""
}

services: db: {
	default:   true
	container: "mariadb"
	secrets: ["admin", "user"]
	ports: "3306"
	data: dbName: args.dbName
}

containers: mariadb: {
	name:        "MariaDB"
	description: "Containerized MariaDB database server"
	image:       "mariadb:10.11.6" // Current LTS Version
	ports:       "3306/tcp"
	env: {
		MARIADB_ROOT_PASSWORD: "@{secrets.admin.password}"
		MARIADB_USER:          "@{secrets.user.username}"
		MARIADB_PASSWORD:      "@{secrets.user.password}"
		MARIADB_DATABASE:      args.dbName
	}
	dirs: "/var/lib/mysql": "volume://db-data?subPath=data"
	probes: [
		{
			type:                "liveness"
			initialDelaySeconds: 10
			exec: command: localData.probeExecCommand
		},
		{
			type:                "readiness"
			initialDelaySeconds: 5
			exec: command: localData.probeExecCommand
		},
	]
}

secrets: admin: {
	name:        "Admin user credentials"
	description: "Credentials for the admin user with full control over the database server"
	type:        "basic"
	params: {
		usernameLength:     11
		usernameCharacters: "a-z"
		passwordCharacters: "A-Za-z0-9^_-"
	}
	data: username: "root"
}

secrets: user: {
	name:        "DB User Credentials"
	description: "Credentials for the user with full access to the created database instance"
	type:        "basic"
	params: {
		usernameLength:     11
		usernameCharacters: "a-z"
		passwordCharacters: "A-Za-z0-9^_-"
	}
	data: username: args.username
}

localData: probeExecCommand: [
	"bash",
	"-ec",
	"exec",
	"mysqladmin",
	"status",
	"-uroot",
	"-p\"${MARIADB_ROOT_PASSWORD}\"",
]

localData: info: """
## Usage

```aml
services: db: {
	external: "@{acorn.name}"
}

containers: app: {
	image:    "app-image"
	consumes: ["db"]
	env: {
		DB_HOST:       "@{@{service.}db.address}"
		DB_PORT:       "@{@{service.}db.port.3306}"
		DB_NAME:       "@{@{service.}db.data.dbName}"
		DB_ADMIN_USER: "@{@{service.}db.secrets.admin.username}"
		DB_ADMIN_PASS: "@{@{service.}db.secrets.admin.password}"
		DB_USER:       "@{@{service.}db.secrets.user.username}"
		DB_PASS:       "@{@{service.}db.secrets.user.password}"
	}
}
```
"""