python 读写yaml文件 写Excel文件 连接MySql

python 读写yaml文件

import yaml
from yaml import SafeLoader

if __name__ == '__main__':

    # read a yaml file
    # open方法打开直接读出来
    f = open("read_yaml.yaml", 'r', encoding='utf-8')
    file_data = f.read()
    f.close()

    my_data = yaml.load(file_data, Loader=SafeLoader)  # 用load方法转字典
    print(my_data)
    print(my_data['spec']['selector']['matchLabels']['<key>'])

    my_data['spec']['selector']['matchLabels']['<key>'] = 10

    # write a yaml file
    f = open("read_yaml.yaml", 'w', encoding='utf-8')
    f.write(yaml.dump(my_data, allow_unicode=True))
    f.close()

python写Excel文件

import xlsxwriter

if __name__ == '__main__':

    workbook = xlsxwriter.Workbook('write_Excel.xlsx')
    worksheet1 = workbook.add_worksheet("sheet1")  # 创建子表
    worksheet1.activate()  # 激活表

    bold = workbook.add_format({
        'bold': True,  # 字体加粗
        'border': 1,  # 单元格边框宽度
        'align': 'left',  # 水平对齐方式
        'valign': 'vcenter',  # 垂直对齐方式
        'fg_color': '#FFFFFF',  # 单元格背景颜色
        'text_wrap': True,  # 是否自动换行
    })

    title = ['迭代次数', 'split', 'edgeRunTime', 'Loss', 'acc']  # 设置表头
    worksheet1.write_row('A1', title, bold)  # 从A1单元格开始写入表头
    i = 2  # 从第二行开始写入数据
    for j in range(5):
        insertData = [j, '5', '5s', 0.01, '5%']
        row = 'A' + str(i)
        worksheet1.write_row(row, insertData, bold)
        i += 1
    workbook.close()  # 关闭表

python连接MySql

def init():
    MyComputerNodeList = []
    MyDataListList = []
    MyStoreNodeList = []
    MyNetList = []

    # 连接数据库
    conn = pymysql.connect(host='127.0.0.1'  # 连接名称，默认127.0.0.1
                           , user='root'  # 用户名
                           , passwd='123456'  # 密码
                           , port=3306  # 端口，默认为3306
                           , db='nodes'  # 数据库名称
                           , charset='utf8'  # 字符编码
                           )

    cur = conn.cursor()  # 生成游标对象

    sql = "select * from `MyComputerNode`"  # SQL语句
    cur.execute(sql)  # 执行SQL语句
    data = cur.fetchall()  # 通过fetchall方法获得数据
    for i in data:
        MyComputerNodeList.append(MyComputerNode(i[0], i[1], i[2], i[3], i[4], i[5], i[6], i[7], i[8], i[9], i[10], i[11]))
    print("ComputerNodeList:")
    for i in MyComputerNodeList:
        print(i.__dict__)
    print()

    sql = "select * from `MyDataList`"  # SQL语句
    cur.execute(sql)  # 执行SQL语句
    data = cur.fetchall()  # 通过fetchall方法获得数据
    for i in data:
        MyDataListList.append(MyDataList(i[0], i[1], i[2], i[3], i[4], i[5]))
    print("DataListList:")
    for i in MyDataListList:
        print(i.__dict__)
    print()

    sql = "select * from `MyStoreNode`"  # SQL语句
    cur.execute(sql)  # 执行SQL语句
    data = cur.fetchall()  # 通过fetchall方法获得数据
    for i in data:
        MyStoreNodeList.append(MyStoreNode(i[0], i[1], i[2], i[3]))
    print("StoreNodeList")
    for i in MyStoreNodeList:
        print(i.__dict__)
    print()

    sql = "select * from `MyNet`"  # SQL语句
    cur.execute(sql)  # 执行SQL语句
    data = cur.fetchall()  # 通过fetchall方法获得数据
    for i in data:
        MyNetList.append(MyNet(i[0], i[1], i[2], i[3]))
    print("NetList")
    for i in MyNetList:
        print(i.__dict__)
    print()

    cur.close()  # 关闭游标
    conn.close()  # 关闭连接

    return MyComputerNodeList, MyDataListList, MyStoreNodeList, MyNetList