import mysql.connector
from mysql.connector import Error

host = "localhost"
port = "3307"
user = "root"
pwd = ""
db = "tg_maintain_db"

def create_server_connection():
    connection = None
    try:
        connection = mysql.connector.connect(
            host=host,
            port=port,
            user=user,
            passwd=pwd
        )
        print("資料庫連接成功")
    except Error as e:
        print(f"資料庫連接失敗{e}")
    return connection

def create_db_connection():
    connection = None
    try:
        connection = mysql.connector.connect(
            host=host,
            port=port,
            user=user,
            passwd=pwd,
            database=db
        )
        print("資料庫連接成功")
    except Error as e:
        print(f"資料庫連接失敗{e}")
    return connection