import mysql.connector

# SO_db configure
class SO:
    
    def config():
        conn = mysql.connector.connect(
            host = '133.42.145.219',
            port = 4309,
            user = 'sotorrent',
            password = 't0tt0Pa-ku',
            db = 'sotorrent18_12',
        )
        return conn
    
    def ssh_config():
        conn = mysql.connector.connect(
            host = '127.0.0.1',
            port = 3306, 　　　　　　#ポートフォワーディングのローカルバインドポート（変更可）
            user = 'sotorrent',
            password = 't0tt0Pa-ku',
            db = 'sotorrent18_12',
        )
        return conn
    

# GH_db configure
class GH:
    def config():
        conn = mysql.connector.connect(
            host = 'HOST ID',
            port = 'PORT NUM',
            user = 'USER NAME',
            password = 'PASSWORD',
            db = 'GH DATABASE',
        )
        return conn