FreedomBox/freedombox/db/mariadb.py
Sunil Mohan Adapa 23b6aff290
plinth/*: Rename plinth/ folder to freedombox/
Signed-off-by: Sunil Mohan Adapa <sunil@medhas.org>
Reviewed-by: James Valleroy <jvalleroy@mailbox.org>
2026-08-28 07:35:01 -04:00

20 lines
559 B
Python

# SPDX-License-Identifier: AGPL-3.0-or-later
"""Utilities to help with MariaDB/MySQL databases.
Uses utilities from 'mysql-client' package such as 'mysql' and 'mysqldump'.
"""
import subprocess
from .. import action_utils
def run_query(database_name: str, query: str) -> subprocess.CompletedProcess:
"""Run a database query using 'root' user.
Does not ensure that the database server is running.
"""
return action_utils.run(
['mysql', '--user=root', '--database', database_name],
input=query.encode('utf-8'), check=True)