import mssql_python

mssql_python.setup_logging()
cnxn = mssql_python.connect(
    "SERVER=192.168.0.199;"
    "DATABASE=master;"
    "UID=scott;PWD=tiger^5HHH;"
    "TrustServerCertificate=yes;"
)
cnxn.setautocommit(True)
crsr = cnxn.cursor()
for db_name in ["test", "test2", "test3"]:
    if not crsr.execute("select name from sys.databases where name = ?", db_name).fetchval():
        sql = f"CREATE DATABASE {db_name}"
        print(sql)
        crsr.execute(sql)
crsr.execute(
    "ALTER SERVER CONFIGURATION SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON;"
)
crsr.execute(
    "BACKUP SERVER TO DISK = '/var/opt/mssql/backup/metadata/backup_1.bkm' WITH METADATA_ONLY, FORMAT;"
)