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 index(request):
begin_point = Point()
end_point = Point()
points = Point.objects.all()
if request.method != 'POST':
form = PointRadioForm({'radioFieldBegin': 'A', 'radioFieldEnd': 'A'})
else:
form = PointRadioForm(request.POST)
if form.is_valid():
begin_point = Point.objects.get(
name=form['radioFieldBegin'].value())
end_point = Point.objects.get(name=form['radioFieldEnd'].value())
context = {
'beginPoint': begin_point,
'endPoint': end_point,
'points': points,
'form': form,
}
return render(request, 'map/index.html', context)
def show(request, points_set_id):
points_set = PointsOfInterest.objects.get(id=points_set_id)
distance, path = prepare_shortest_path(points_set.points,
points_set.routes)
points_shortest_path = clear_table(
set_proper_order(points_set.points, path))
# print(path)
# print(distance)
# print(points_shortest_path)
points = []
for point in points_shortest_path:
p = Point()
p.name = points_shortest_path.index(point)
p.latitude = point[0]
p.longitude = point[1]
points.append(p)
context = {'points': points}
return render(request, 'trips/show.html', context)
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
