mysql-dsn: Connect to a mysql database from the command line using a DSN as argument

mysql-dsn

#!/usr/bin/env python3
#
# mysql-dsn
# Takes a DSN as argument and tries to connect to the specified database using the "mysql"-command.
# Passwords must be quoted ("url-encoded").
#
# Example:
# $ mysql-dsn mysqli://me:top_secret@hostname:33006/db-name

import re
import subprocess
import sys
import urllib.parse

if len(sys.argv) < 2:
    print("Syntax: " + sys.argv[0] + " {DSN}")
    sys.exit(1)

dsn = sys.argv[1]
netloc_regex = re.compile(r"(?:([^:]+)(?::(.*))?@)?([^:]+)(?::([\d]+))?")

scheme, netloc, path, params, query, fragment = urllib.parse.urlparse(dsn)
username, password, host, port = netloc_regex.search(netloc).groups()

subprocess.run([
    "mysql", path.replace("/", ""),
    "--user", username,
    "--host", host,
    "--port", str(port),
    "-p"+urllib.parse.unquote(password)
])