Python临时文件tempfile.TemporaryFile的简单应用

参考小例：

# -*- coding: utf-8 -*-

import tempfile
import pymysql


def writeFile_01(sql):
    # 创建临时文件
    fp = tempfile.TemporaryFile()
    fp.write(sql.encode('utf-8'))
    # 将文件指针移到开始处，准备读取文件
    fp.seek(0)
    print(fp.read().decode('utf-8'))  # 输出刚才写入的内容
    # 关闭文件，该文件将会被自动删除
    fp.close()


def writeFile_02(sql):
    conn = pymysql.connect('127.0.0.1', 'root', 'dong', charset='utf8')
    cursor = conn.cursor()
    with tempfile.TemporaryFile() as fp:
        sql = sql.encode('utf-8')
        fp.write(sql)
        # 将文件指针移到开始处，准备读取文件
        fp.seek(0)
        for line in fp.readlines():
            sqlCmd = line.decode('utf-8').strip()
            cursor.execute(sqlCmd)
        ret = cursor.fetchall()
        print(ret)


if __name__ == '__main__':
    sql = "use girls;\n" \
          "select * from admin;\n"
    # writeFile_01(sql)
    writeFile_02(sql)