读取文件，多个参数，循环查询，返回结果，记录文件

import pymssql

'''
链接数据库，查询每天每个客服接待机器的数量，汇总成集合，统计数量。
写入txt文件

'''


def linkdb(name,date):
    # 数据库远程连接
    conn = pymssql.connect(host="127.0.0.1", user="sa",password="password", database="test_02", charset="utf8")

    # 使用cursor()方法获取操作游标
    cursor = conn.cursor()
    # 查询语句
    sql = """
    SELECT distinct [RobotCode]
    FROM [test_02].[dbo].[wangbao_recode] WITH (NOLOCK)
     where
     Recode_name = %s
     and 
  filename like %s
    """
    try:
        cursor.execute(sql,(name,date))  # 游标
        result = cursor.fetchall()  # 查询
        # print (result)
    except:

        print("连接数据库报错了！")
    # 关闭数据库连接
    conn.close()
    return result

if __name__ == '__main__':
    # result = linkdb('ceshi001','20200803%')
    # print (result)
    sn_as=[]

    with open('22.txt','r') as f:
        for line in f:
            sn_as.append(line.strip('\n').split(',')[0])

    yue_8 = []
    for i in range(22):
        a = str(20200801 + i)
        b = a + '{}'
        c = b.format('%')
        yue_8.append(c)
    list1 = []
    for i in yue_8:
        print (i)
        sn_as_set = set()
        for sn in sn_as:
            print (sn)
            result = linkdb(sn,i)
            print (result)
            if result != None:
                for x in result:
                    print (x[0])
                    sn_as_set.add(x[0])
            print (sn_as_set)
        list1.append(len(sn_as_set))


    print (list1)
    with open('44.txt', 'w', encoding='utf-8') as f:
        for c in list1:
            f.write(str(c) + '\n')