"""
@author: luojunhui
"""
import pymysql


class AdMySQL(object):
    """
    PQ Mysql
    """
    connection = pymysql.connect(
        host='rm-bp12k5fuh5zyx31d28o.mysql.rds.aliyuncs.com',
        port=3306,
        user='wx2023_ad',
        password='wx2023_adP@assword1234',
        db='adplatform',
        charset='utf8mb4'
    )

    # @classmethod
    # def update(cls, sql, params):
    #     """
    #     更新
    #     :return:
    #     """
    #     cursor = cls.connection.cursor()
    #     cursor.execute(sql, params)
    #     cls.connection.commit()

    @classmethod
    def select(cls, sql):
        """
        查询
        :param sql:
        :return:
        """
        cursor = cls.connection.cursor()
        cursor.execute(sql)
        result = cursor.fetchall()
        return result