mirror of
https://github.com/kevinveenbirkenbach/computer-playbook.git
synced 2026-11-06 10:59:59 +00:00
kevinveenbirkenbachandClaude Fable 5
40e553069d
Move files that share a delimiter-bounded name prefix within a folder (threshold 2) into a subfolder named after the prefix, dropping the prefix from the filename. Covers plugins/filter (docker, generate, has, merge, get/all), env handler subpackages, utils/roles/entity, utils/tests/swarm/write, role SQL/scripts/templates, keycloak/mailu task-includes, shared tasks/utils/load, and CI scripts. Update every import, query_file/script/include_tasks/src/lookup target, compose bind mount, and python -m path to the new locations. Extend the prefix-grouped-files lint to threshold 2 with dir-level .nocheck and file-head nocheck opt-outs, and skip groups whose shortest member's stem equals the shared prefix. Keep flat only where a loader forbids nesting: WordPress mu-plugins and the docs/requirements namespace. Ansible filter discovery is recursive, so nested filters stay Jinja-resolvable. Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
23 lines
513 B
SQL
23 lines
513 B
SQL
SET @sql_create := CONCAT(
|
|
"CREATE USER IF NOT EXISTS '", @db_user, "'@'%';"
|
|
);
|
|
PREPARE stmt FROM @sql_create;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
SET @sql_alter := CONCAT(
|
|
"ALTER USER '", @db_user, "'@'%' IDENTIFIED BY ", QUOTE(@db_pwd), ";"
|
|
);
|
|
PREPARE stmt FROM @sql_alter;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
SET @sql_grant := CONCAT(
|
|
"GRANT ALL PRIVILEGES ON `", @db_name, "`.* TO '", @db_user, "'@'%';"
|
|
);
|
|
PREPARE stmt FROM @sql_grant;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
FLUSH PRIVILEGES;
|