def index(request): params = function.json_decode(request.body) data = {} if not params.get('name'): return function.ehcoJson({ 'code': 400, 'msg': function.ReturnCode[400] }) data['name'] = params.get('name') if not params.get('city'): return function.ehcoJson({ 'code': 400, 'msg': function.ReturnCode[400] }) data['city'] = params.get('city') if not params.get('email'): return function.ehcoJson({ 'code': 400, 'msg': function.ReturnCode[400] }) data['email'] = params.get('email') data['is_valid'] = 1 publish = Publish(**data) publish.save() if publish: print(publish) return function.ehcoJson({ 'code': 200, 'msg': function.ReturnCode[200] }) return function.ehcoJson({'code': 500, 'msg': function.ReturnCode[500]})
def index(request): params = function.json_decode(request.body) page = params.get('page') if params.get('page') else 1 limit = params.get('limit') if params.get('limit') else 10 offset1 = (page - 1) * limit offset2 = page * limit if params.get('is_valid') == 1 or params.get('is_valid') == 0: where_dict = {'is_valid': params.get('is_valid')} else: where_dict = {} if params.get('name'): where_dict['name__icontains'] = params.get('name') if params.get('phone') and params.get('phone').isdigit(): where_dict['author_detail__phone'] = int(params.get('phone')) #基于双下划线的关联查询 res = Author.objects.filter(**where_dict).values( 'id', 'name', 'age', 'is_valid', 'author_detail__phone', 'author_detail__birthday', 'author_detail__addr').order_by('-id')[offset1:offset2] data = [] for i in res: i['phone'] = i['author_detail__phone'] i['birthday'] = i['author_detail__birthday'] i['addr'] = i['author_detail__addr'] data.append(i) return function.ehcoJson({ 'code': 200, 'msg': function.ReturnCode[200], 'data': data, 'totalpage': len(data) })
def index(request): params = function.json_decode(request.body) data = {} data2 = {} if not params.get('name') or not params.get('price') or not params.get( 'publish_date') or not params.get('publish__id') or not params.get( 'authors'): return function.ehcoJson({ 'code': 400, 'msg': function.ReturnCode[400] }) data['name'] = params.get('name') data['price'] = params.get('price') data['publish_date'] = params.get('publish_date') data['publish_id'] = params.get('publish__id') data['is_valid'] = 1 data2['authors'] = params.get('authors') #data2=Author.objects.filter(id__in=params.get('authors')) book = Book.objects.create(**data) book.authors.add(*data2['authors']) if book: return function.ehcoJson({ 'code': 200, 'msg': function.ReturnCode[200] }) return function.ehcoJson({'code': 500, 'msg': function.ReturnCode[500]})
def index(request): params = function.json_decode(request.body) if params.get('id') and params.get('name') and params.get('price') and \ params.get('publish_date') and params.get('publish__id') and params.get('authors') : if params.get('is_valid') == 1 or params.get('is_valid') == 0: where_dict = {'is_valid': params.get('is_valid')} where_dict['name'] = params.get('name') where_dict['price'] = params.get('price') where_dict['publish_date'] = params.get('publish_date') where_dict['publish'] = params.get('publish__id') #where_dict['authors']=params.get('authors') res = Book.objects.filter(id=params.get('id')).update(**where_dict) book = Book.objects.filter(id=params.get('id')).first() book.authors.set(params.get('authors')) if res and book: return function.ehcoJson({ 'code': 200, 'msg': function.ReturnCode[200] }) else: return function.ehcoJson({ 'code': 500, 'msg': function.ReturnCode[500] }) return function.ehcoJson({'code': 400, 'msg': function.ReturnCode[400]})
def index(request): params = function.json_decode(request.body) page = params.get('page') if params.get('page') else 1 limit = params.get('limit') if params.get('limit') else 10 offset1 = (page - 1) * limit offset2 = page * limit if params.get('is_valid') == 1 or params.get('is_valid') == 0: where_dict = {'is_valid': params.get('is_valid')} else: where_dict = {} if params.get('name'): where_dict['name__icontains'] = params.get('name') res = Publish.objects.filter(**where_dict).order_by('-id')[offset1:offset2] data = [] i = 0 for li in res: data.append({ 'id': li.id, 'name': li.name, 'email': li.email, 'city': li.city, 'is_valid': li.is_valid }) i += 1 return function.ehcoJson({ 'code': 200, 'msg': function.ReturnCode[200], 'data': data, 'totalpage': i })
def index(request): params = function.json_decode(request.body) if params.get('id') and params.get('name') and params.get('email') and params.get('city'): if params.get('is_valid') == 1 or params.get('is_valid') == 0: where_dict = {'is_valid': params.get('is_valid')} where_dict['name']=params.get('name') where_dict['email']=params.get('email') where_dict['city']=params.get('city') res=Publish.objects.filter(id=params.get('id')).update(**where_dict) if res : return function.ehcoJson({'code':200,'msg':function.ReturnCode[200]}) else: return function.ehcoJson({'code': 500, 'msg': function.ReturnCode[500]}) return function.ehcoJson({'code': 400, 'msg': function.ReturnCode[400]})
def index(request): params = function.json_decode(request.body) page = params.get('page') if params.get('page') else 1 limit = params.get('limit') if params.get('limit') else 10 offset1 = (page - 1) * limit offset2 = page * limit if params.get('is_valid') == 1 or params.get('is_valid') == 0: where_dict = {'is_valid': params.get('is_valid')} else: where_dict = {} if params.get('book_name'): where_dict['name__icontains'] = params.get('book_name') if params.get('author_name'): where_dict['authors__name__icontains'] = params.get('author_name') if params.get('publish_name'): where_dict['publish__name__icontains'] = params.get('publish_name') #基于双下划线的关联查询 res = Book.objects.filter(**where_dict).values( 'id', 'name', 'price', 'publish_date', 'is_valid', 'authors__id', 'authors__name', 'publish__id', 'publish__name').order_by('-id')[offset1:offset2] data = {} for i in list(res): i['authors'] = data[i['id']]['authors'] if data.get(i['id']) else [] i['authors'].append(i['authors__id']) i['author_arr_name'] = data[i['id']]['author_arr_name'] if data.get( i['id']) else [] i['author_arr_name'].append(i['authors__name']) i['authors__name_str'] = ','.join(i['author_arr_name']) data[i['id']] = i res_data = [] print(connection.queries) for index in data: res_data.append(data[index]) return function.ehcoJson({ 'code': 200, 'msg': function.ReturnCode[200], 'data': res_data, 'totalpage': len(res_data) })
def index(request): params =function.json_decode(request.body) data={} data2 = {} if not params.get('name') or not params.get('age') or not params.get('phone') or not params.get('birthday') or not params.get('addr'): return function.ehcoJson({'code':400,'msg':function.ReturnCode[400]}) data['name']=params.get('name') data['age'] = params.get('age') data['is_valid'] = 1 data2['phone'] = params.get('phone') data2['birthday'] = params.get('birthday') data2['addr'] = params.get('addr') authorDetail=AuthorDetail.objects.create(**data2) author=Author(**data,author_detail=authorDetail) author.save() if author: print(author) return function.ehcoJson({'code':200,'msg':function.ReturnCode[200]}) return function.ehcoJson({'code': 500, 'msg': function.ReturnCode[500]})