def db_rebuild(self):
""" Tears down and rebuilds db. """
db_delete()
db_build()
deleteprojects()
loadprojects()
return "REBUILDING DB..."
def delete(request):
# if this is a POST request we need to process the form data
if request.method == 'POST':
# create a form instance and populate it with data from the request:
form = deleteCompanyData(request.POST)
# check whether it's valid:
if form.is_valid():
# process the data in form.cleaned_data as required
# ...
# redirect to a new URL:
# return HttpResponseRedirect('/index/')
company = form.cleaned_data['company']
date = form.cleaned_data['date']
data = []
table = 'invest_sharePrice'
path = '/home/website/website/mysite/db.sqlite3'
db_delete(path, table, company, date)
company_list = sharePrice.objects.all()
# time.strftime('%Y-%m-%d', time.strptime("30 Nov 17", "%d %b %y"))
data = serializers.serialize("json", company_list)
companylist = db_query('/home/website/website/mysite/db.sqlite3', 'invest_sharePrice', "*")
context = {
#'company_list': json.dumps(company_list),
'company_list': data,
'companylist': companylist,
}
return render(request, 'invest/index.html', context)
# if a GET (or any other method) we'll create a blank form
else:
form = deleteCompanyData()
return render(request, 'invest/index.html', {'form': form})
def delete(id):
# check auth
db_delete(id)
return redirect('/')
def delete():
username = input('请输入需要删除的用户名：')
db_delete(username)
