def get_wiki_data(): with open('data.pickle', 'rb') as f: wiki_collected = pickle.load(f) print(wiki_collected[12]) for i in range(len(wiki_collected)): #for i in range(20): print(i) try: new_point = Point() new_point.point_name = wiki_collected[i]['name'] new_point.point_lat = wiki_collected[i]['latWeb'] new_point.point_lon = wiki_collected[i]['lonWeb'] if 'image_link' in wiki_collected[i]: new_point.point_image = wiki_collected[i]['image_link'] else: new_point.point_name = '* '+new_point.point_name if 'link' in wiki_collected[i]: new_point.point_link = wiki_collected[i]['link'] else: new_point.point_name = '* '+new_point.point_name new_point.save() except KeyError: print(i,'KeyError') return 'Collected {} row'.format(len(wiki_collected))
def insertNewPoints(third_party_sh_name, third_userid, request_mode, userid, account_name, add_amount, transaction_type, linked_trans_id, token): expiration_time = datetime.datetime.now() + datetime.timedelta(30) add_point = Point(third_party_sh_name=third_party_sh_name, third_userid=third_userid, request_mode=request_mode, userid=userid, account_name=account_name, balance=add_amount, transaction_type=transaction_type, linked_trans_id=linked_trans_id, expiration_time=expiration_time, token=token) add_point.save()
def save(self, force_insert=False, force_update=False): #print "HOAISJDOIJEOIENF" #print self.id self.updated_at = datetime.now() super(Post, self).save(force_insert, force_update) from points.models import Point from django.contrib.contenttypes.models import ContentType if not Point.objects.filter( content_type=ContentType.objects.get_for_model(self), object_id = self.id, ) and self.point: p=Point(zoom=self.zoom, point=self.point, owner=self.author, object_id=self.id, content_type=ContentType.objects.get_for_model(self), ) p.save()
def saveScrapResultstoPoints(store_data): points = Point(third_party_sh_name=str(store_data['third_party_sh_name']), request_mode=str(store_data['request_mode']), third_userid=str(store_data['third_userid']), userid=str(store_data['userid']), account_name=str(store_data['account_name']), balance=str(store_data['balance']), transaction_type=str(store_data['transaction_type']), linked_trans_id=str(store_data['linked_trans_id']), expiration_time=str(store_data['expiration_time']), points_accumulate_so_far=str(store_data['points_accumulate_so_far']), member_ship_no=str(store_data['member_ship_no']), token=str(store_data['token']), reward_point=str(store_data['reward_point']), member_id=str(store_data['member_id']), expiration_date=str(store_data['expiration_date']), remaining_balance=str(store_data['remaining_balance']), points_to_be_expire_by_monthend=str(store_data['points_to_be_expire_by_monthend']), stays_balance=str(store_data['stays_balance']), nights_balance=str(store_data['nights_balance']), points_balance=str(store_data['points_balance']), point_accumulated=str(store_data['point_accumulated']), nights_accumulated=str(store_data['nights_accumulated']), member_name=str(store_data['member_name']), updated_at=datetime.datetime.now()) points.save()
def saveRoute(request): points = [] if request.POST.has_key("points"): points = request.POST.getlist("points") routeName = request.POST.get("routeName") route = Route(name=routeName) route.save() for point in points: print "KURWA TU" print point address = getAddress(point).split(" ")[1:] saveAddress = Address( street=getStreet(address), number=getNumber(address), postCode=getCode(address), city=getCity(address) ) saveAddress.save() savePoint = Point( route=route, address=saveAddress, longitude=getLongitude(point), latitude=getLatitude(point) ) savePoint.save() return HttpResponse("Trasa zapisana") return HttpResponse("Wybierz conajmniej jeden punkt")
def setup(request): if not request.facebook.uid: return HttpResponseRedirect(reverse('auth_login')+"?next="+request.GET.get('next','')) if request.method == "POST": if request.POST.get('next',False) and request.POST['next']: next = request.POST['next'] else: next = getattr(settings,'LOGIN_REDIRECT_URL','/') profile = FacebookProfile(facebook_id=request.facebook.uid) if request.POST.get('facebook_only',False): if not User.objects.filter(username=profile.first_name): user = User( username=profile.first_name, password=sha.new(str(random.random())).hexdigest()[:8] ) user.save() else: user = User( username = str(request.facebook.uid), password = sha.new( str(random.random())).hexdigest()[:8] ) user.save() if request.POST['map']: point = Point(point=request.POST['map'], owner=user, content_type = ContentType.objects.get_for_model(user), object_id=user.id) point.save() profile.user = user profile.save() logging.info("FBC: Added user and profile for %s!" % request.facebook.uid) user = authenticate(request=request) login(request, user) return HttpResponseRedirect(next) form = AuthenticationForm(data=request.POST) if form.is_valid(): user = form.get_user() logging.debug("FBC: Trying to setup FB: %s, %s" % (user,profile)) if user is not None and user.is_active: if request.POST['map']: point = Point(point=request.POST['map'], owner=user, content_type = ContentType.objects.get_for_model(user), object_id=user.id) point.save() profile.user = user profile.save() logging.info("FBC: Attached facebook profile %s to user %s!" % (profile.facebook_id,user)) login(request, user) return HttpResponseRedirect(next) else: user = User() user.facebook_profile = profile elif request.user.is_authenticated(): profile = FacebookProfile(facebook_id=request.facebook.uid) profile.user = request.user profile.save() logging.info("FBC: Attached facebook profile %s to user %s!" % (profile.facebook_id,profile.user.id)) return HttpResponseRedirect('/') else: user = User() user.facebook_profile = FacebookProfile(facebook_id=request.facebook.uid) next = request.GET.get('next','') form = AuthenticationForm(request) return render_to_response( 'facebook/setup.html', {"user":user, "form":form, "next":next}, context_instance=RequestContext(request))
def save(self,*args,**kwargs): self.upl_iter = 0 stack=[] prepared=[] deflang = Language.objects.get(deflang = True) super(Loader,self).save(*args,**kwargs) path = self.upl_file.path self.parsefile(path,stack) self.prepare_lines(stack,prepared) for line in prepared: ############################################ country_count = Country.objects.filter(mnemo=line['country_mnemo']).count() if country_count == 0: cntr = Country( nazva_inner=line['country_mnemo'], mnemo = line['country_mnemo'], ) cntr.save() cntrN = CountryName( nazva=line['country_mnemo'], lang=deflang, country=cntr ) cntrN.save() else: cntr = Country.objects.get(mnemo=line['country_mnemo']) ############################################ ############################################ city_count=City.objects.filter(nazva_inner=line['city']).count() if city_count == 0: city = City( nazva_inner=line['city'], mnemo = line['city'], country = cntr ) city.save() cityN = CityName( nazva=line['city'], lang=deflang, city=city ) cityN.save() else: city = City.objects.get(nazva_inner=line['city']) ############################################ pnt_count = Point.objects.filter(Q(code=line['code'])|Q(nazva_inner=line['provider'])).count() if pnt_count == 0: pnt = Point( nazva_inner=line['provider'], code=line['code'], teln=line['telns'], city = city, in_use=False ) pnt.save() if self.tsystem: pnt.tsystems.add(self.tsystem) pnt.save() prv = ProviderName( nazva = line['provider'], lang = deflang, point = pnt ) prv.save() adr = AddressName( nazva = line['address'], lang = deflang, point = pnt ) adr.save() wkt = WorkTime( nazva = line['works'], lang = deflang, point=pnt ) wkt.save() self.upl_iter = self.upl_iter + 1 else: continue super(Loader,self).save(*args,**kwargs)
def do_insert(self,deflang): self.ins_iter = 0 #deflang = Language.objects.get(deflang = True) for line in self.for_insert: try: ############################################ country_count = Country.objects.filter(mnemo=line['country_mnemo']).count() if country_count == 0: cntr = Country( nazva_inner=line['country_mnemo'], mnemo = line['country_mnemo'], ) cntr.save() cntrN = CountryName( nazva=line['country_mnemo'], lang=deflang, country=cntr ) cntrN.save() else: cntr = Country.objects.get(mnemo=line['country_mnemo']) ############################################ ############################################ city_count=City.objects.filter(nazva_inner=line['city']).count() if city_count == 0: city = City( nazva_inner=line['city'], mnemo = line['city'], country = cntr ) city.save() cityN = CityName( nazva=line['city'], lang=deflang, city=city ) cityN.save() else: city = City.objects.get(nazva_inner=line['city']) ############################################ pnt_count = Point.objects.filter(Q(code=line['code'])|Q(nazva_inner=line['provider'])).count() if pnt_count == 0: pnt = Point( nazva_inner=line['provider'], code=line['code'], teln=line['telns'], city = city, in_use=False ) pnt.save() prv = ProviderName( nazva = line['provider'], lang = deflang, point = pnt ) prv.save() adr = AddressName( nazva = line['address'], lang = deflang, point = pnt ) adr.save() wkt = WorkTime( nazva = line['works'], lang = deflang, point=pnt ) wkt.save() self.ins_iter = self.ins_iter + 1 except: continue