从Django下载sqlite文件

Question

我有使用sqlite作为数据库的Django应用。我不会制作能够下载该sqlite文件的视图。到目前为止，这是我得到的：def backup(request):    """Return Sqlite3 db file, if Sqlite3 db is used."""    import settings    db_engine = settings.DATABASES['default']['ENGINE']    #db_engine = 'JUST_FOR_TESTING'    if db_engine == 'django.db.backends.sqlite3':        db_path = settings.DATABASES['default']['NAME']        response = HttpResponse(mimetype='application/x-sqlite3')        response['Content-Disposition'] = 'attachment; filename=%s' % db_path        response.write(db_path)        return HttpResponse(response)    else:        return HttpResponse("settings.DATABASES['default']['ENGINE'] is %s,<br />\                             only for 'django.db.backends.sqlite3' online backup is posible." % (db_engine))我所缺少的是如何将文件添加为附件。还可以通过某种方式仅下载特定表吗？

Answer 1

您只是试图将文件路径作为附件发送。

相关代码是

from django.conf import settings

from django.core.files import File

db_path = settings.DATABASES['default']['NAME']

dbfile = File(open(db_path, "rb"))

response = HttpResponse(dbfile, mimetype='application/x-sqlite3')

response['Content-Disposition'] = 'attachment; filename=%s' % db_path

response['Content-Length'] = dbfile.size

return response