Django 文件下载功能

def file_download(request):
    con= MySQLdb.connect(host='192.168.xxx.xxx',user='root',passwd='xxxx',db='test')
    cursor = con.cursor()
    query = "SELECT * FROM xxxx" 
    cursor.execute(query)
    with open('xxxx.csv','w') as f:
        writer = csv.writer(f)
        for row in cursor.fetchall():
            writer.writerow(row)
    with open('xxxx.csv') as f:
        c = f.read()
    response = HttpResponse(c) 
    response['Content-Type'] = 'application/octet-stream'
    response['Content-Disposition'] = 'attachment;filename="{0}"'.format('xxxx.csv')
    return response

 

上述代码是django下载文件的功能。

因为我使用的是MYSQL 数据库，先连接数据库，打开并导出文件writer, 然后使用open,read，读出文件，后HTTPRESPONE将文件下载导出。