def create_server(): '''Создает сервер типа farhub ''' if (API_KEY != request.args.get('api')): return jsonify({'error': 'Wrong api key'}), 400 json_data = request.get_json(force=True) try: srv = Server.objects.get(hash_id=json_data['hash_id']) srv.delete() except Exception: pass finally: try: coun = Country.objects.get(name=json_data['location']) except: coun = Country(name=json_data['location']) coun.save() try: server_name = Type_Of_Server.objects.get( type_of_server='gtn_farhub') except: server_name = Type_Of_Server(type_of_server='gtn_farhub') server_name.save() server = Server(type_of_server=server_name, address=json_data['server_ip'], location=coun, api_key=json_data['api_key'], data=json_data['data'], description=json_data['description'], hash_id=json_data['hash_id']) server.save() Country.synhro() monitoring_service() return '200 OK'
def save_country_from_row(review_row): country = Country() country.country_name = review_row[0] country.country_code = review_row[1] country.iso_codes = review_row[2] country.population = review_row[3] country.area = review_row[4] country.gdp = review_row[5] country.save()
def backend(request): context = {} context['ajout'] = False if request.method == 'POST': pays = request.POST.get("pays", "") newPays = Country(name=pays, date=timezone.now()) newPays.save() context['ajout'] = True return render(request, 'backend.html', context)
def parse(self, **kwargs): worksheet = GoogleSheetsParser.get_worksheet(self, '1Mp9r7CNxVnKip-tLAFpbGp4K_MY2iUrbrBOQBcsKLVE') i = 2 while True: values_list = worksheet.row_values(i) i += 1 if not values_list[0]: break try: country = Country.objects.get( name=values_list[4] ) except ObjectDoesNotExist: country = Country( name=values_list[4] ) self.country_count += 1 country.save() try: region = Region.objects.get( name=values_list[1] ) except ObjectDoesNotExist: region = Region( name=values_list[1], country=country ) self.region_count += 1 region.save() try: city = City.objects.get( name=values_list[0] ) except ObjectDoesNotExist: city = City( name=values_list[0], lat=values_list[2], lon=values_list[3], region=region ) self.city_count += 1 city.save() return [ 'New Countries: ' + str(self.country_count), 'New Regions: ' + str(self.region_count), 'New Cities: ' + str(self.city_count), ]
def create_country(country_name): '''Создает страну''' if (API_KEY != request.args.get('api')): return jsonify({'error': 'Wrong api key'}), 400 if country_name is None or not country_name: return 'Incorrect Query' try: country = Country.objects.get(name=country_name) return 'Объект существует' except Exception: country = Country(name=country_name) country.save() return '200 OK'
def parse(self, **kwargs): worksheet = GoogleSheetsParser.get_worksheet(self, '15Q8sDyG_eBUHMcriIAHTmwDcdSdJSSLNAo34iBZKyJk') i = 2 while True: values_list = worksheet.row_values(i) i += 1 if not values_list[0]: break if values_list[5] == kwargs['options']['wave']: try: university = University.objects.get( name=values_list[0] ) except ObjectDoesNotExist: try: city = City.objects.get( name=values_list[3] ) except ObjectDoesNotExist: try: region = Region.objects.get( name='unknown' ) except ObjectDoesNotExist: try: country = Country.objects.get( name=values_list[2] ) except ObjectDoesNotExist: country = Country( name=values_list[2] ) country.save() region = Region( name='unknown', country=country, ) self.unknown_region = True region.save() city = City( name=values_list[3], region=region, lat=0, lon=0 ) self.city_count += 1 city.save() university = University( name=values_list[0], abbr=values_list[1], city=city, site=values_list[4] ) self.university_count += 1 university.save() result = [ 'Wave ' + str(kwargs['options']['wave']), 'New University: ' + str(self.university_count), ] if self.city_count > 0: result.append('------') result.append('Check this situation! It is not normal!') result.append('------') result.append('New City: ' + str(self.city_count)) if self.unknown_region: result.append('Added Region "unknown"') return result
def index(request): russia = Country(name="France", date=timezone.now()) russia.save() return HttpResponse("Hi, world. You're at the app index.")