views代码:
关键代码:
info = SqlOrder.objects.raw(''' select 1 from dual;''')
完整代码(待部分分页功能):
try: page = request.GET.get('page') username = request.GET.get('username') except KeyError as e: CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}') return HttpResponse(status=500) else: try: un_init = util.init_conf() custom_com = ast.literal_eval(un_init['other']) page_number = SqlOrder.objects.filter(assigned=username).count() start = (int(page) - 1) * 20 end = int(page) * 20 info = SqlOrder.objects.raw( ''' select core_sqlorder.*,core_databaselist.connection_name, \ core_databaselist.computer_room from core_sqlorder \ INNER JOIN core_databaselist on \ core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.assigned = '%s'\ ORDER BY core_sqlorder.id desc ''' % username )[start:end] data = util.ser(info) info = Account.objects.filter(group='perform').all() ser = serializers.UserINFO(info, many=True) return Response( {'page': page_number, 'data': data, 'multi': custom_com['multi'], 'multi_list': ser.data}) except Exception as e: CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}') return HttpResponse(status=500)