mysql数据库url获取库名

mysql://username:password@hostname:port/database_name

def get_database_name_from_url(url):
    # 去掉协议头
    if url.startswith("mysql://"):
        url = url[8:]
    
    # 分割用户名和密码部分
    if "@" in url:
        user_pass, rest = url.split("@", 1)
    else:
        user_pass, rest = "", url
    
    # 分割主机和端口部分
    if ":" in rest:
        host_port, database_name = rest.rsplit("/", 1)
        host, port = host_port.split(":")
    else:
        host_port, database_name = rest, ""
        host, port = host_port, None
    
    return database_name

# 示例URL
url = "mysql://user:pass@example.com:3306/mydatabase"
print(get_database_name_from_url(url))  # 输出: mydatabase

from urllib.parse import urlparse

def get_database_name_from_url(url):
    parsed_url = urlparse(url)
    path_parts = parsed_url.path.strip("/").split("/")
    return path_parts[-1] if path_parts else None

# 示例URL
url = "mysql://user:pass@example.com:3306/mydatabase"
print(get_database_name_from_url(url))  # 输出: mydatabase

import re

def is_valid_mysql_url(url):
    pattern = re.compile(r'^mysql://[a-zA-Z0-9_]+:[a-zA-Z0-9_]+@[a-zA-Z0-9.-]+(:\d+)?(/[a-zA-Z0-9_]+)?$')
    return bool(pattern.match(url))

# 使用前验证URL
if is_valid_mysql_url(url):
    print(get_database_name_from_url(url))
else:
    print("Invalid MySQL URL")