def showTablePage(request, fullPath, path, downloadURL):
'''
Warning: This function won't check whether the user have the authority to access the path, won't escape the path, and won't check whether the file exists.
Display a table for a request.
fullPath: The path in the server's file system to be shown.
path: The path to be shown.
Return a httpRespond.
'''
# Decide whether the user can view the file
initPara = {'itemPerPage': 50, 'haveHeading': False, 'page': 1}
cd = initPara
# Get parameters from query string
if request.method == 'GET' and 'submit' in request.GET:
form = tablePageSettingsForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
else:
cd = initPara
else:
form = tablePageSettingsForm(initPara)
cd = initPara
try:
cd['page'] = int(request.GET.get('page', '1'))
except ValueError:
cd['page'] = 1
# Fetch the file
csvfile = file(fullPath, 'rb')
reader = csv.reader(csvfile)
lines = list(reader)
# Paging
if cd['haveHeading']:
paginator = Paginator(lines[1:], cd['itemPerPage'])
else:
paginator = Paginator(lines, cd['itemPerPage'])
try:
content = paginator.page(cd['page'])
except PageNotAnInteger:
content = paginator.page(1)
except EmptyPage:
content = paginator.page(paginator.num_pages)
# Rend
if cd['haveHeading']:
heading = list(lines[0])
else:
heading = []
respond = render(request, 'showdata/table.html',
{'path': path,
'filename': os.path.basename(fullPath),
'downloadURL': downloadURL,
'page_range': friendlyPageRange(paginator.page_range, content.number),
'paginator': paginator,
'content': content,
'table_headings': heading,
'form': form})
# Finishing
csvfile.close()
return respond
def showTablePage(request, path):
'''
Display a table for a request.
path: The path of csv file
Return a httpRespond.
'''
# Decide whether the user can view the file
if not request.user.is_authenticated():
return showMessagePage(request, '无法访问', '您没有登录，不能访问这个页面')
initPara = {'itemPerPage': 50, 'haveHeading': False, 'page': 1}
cd = initPara
# Get parameters from query string
if request.method == 'GET' and 'submit' in request.GET:
form = tablePageSettingsForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
else:
cd = initPara
else:
form = tablePageSettingsForm(initPara)
cd = initPara
try:
cd['page'] = int(request.GET.get('page', '1'))
except ValueError:
cd['page'] = 1
# Fetch the file
csvfile = file(path, 'rb')
reader = csv.reader(csvfile)
lines = list(reader)
# Paging
if cd['haveHeading']:
paginator = Paginator(lines[1:], cd['itemPerPage'])
else:
paginator = Paginator(lines, cd['itemPerPage'])
try:
content = paginator.page(cd['page'])
except PageNotAnInteger:
content = paginator.page(1)
except EmptyPage:
content = paginator.page(paginator.num_pages)
# Rend
if cd['haveHeading']:
heading = list(lines[0])
else:
heading = []
respond = render(request, 'showdata/table.html',
{'title': '表格 ' + path,
'path': path,
'page_range': friendlyPageRange(paginator.page_range, content.number),
'paginator': paginator,
'content': content,
'table_headings': heading,
'form': form})
# Finishing
csvfile.close()
return respond
