def prepop_businesses(user): if user == None: user = get_default_user() reader = csv.reader(open(settings.BASE_DIR+'/prepop/businesses.csv', 'U'), delimiter=',', quotechar='"') i = 0 for row in reader: i+=1 if i == 1: continue name = row[0] addr = row[1] city = row[2] state = row[3] phurl = row[4] print('name: '+str(name)) print('addr: '+str(addr)) print('city: '+str(city)) print('state: '+str(state)) bset = Business.objects.filter(name=name,address=addr,state=state,city=city) if bset.count() == 0: b = Business(name=name.encode("utf8"), city=city.encode("utf8"), state=state, address=addr.encode("utf8"), lat=0, lon=0) b.save() elif bset.count() > 1: Business.objects.filter(name=name.encode("utf8"), city=city.encode("utf8"), state=state, address=addr.encode("utf8")).delete() b = Business(name=name.encode("utf8"), city=city.encode("utf8"), state=state, address=addr.encode("utf8"), lat=0, lon=0) b.save() else: b = bset[0] setBusLatLng(b) add_tag_to_bus(b, get_master_summary_tag(), get_default_user()) add_photo_by_url(phurl,b,user,default=True)
def create_business(name, address, state, city, lat, lon): bset = Business.objects.filter(name=name,address=address,state=state,city=city) if bset.count() > 0: return b = Business(name=name.encode("utf8"), city=city.encode("utf8"), state=state, address=address.encode("utf8"), lat=lat, lon=lon) b.save() setBusLatLng(b) add_tag_to_bus(b,get_master_summary_tag()) return b
def get_default_bus_context(b,user): comments = get_business_comments(b) bus_tags = get_tags_business(b,user=user,q="") user_tags = get_tags_user(user,"") top_tags = get_top_tags(10) hard_tags = get_hard_tags(b) value_tags = get_value_tags(b) pages = get_pages(b,bus_tags,user) b = get_single_bus_data(b,user) context = {} context.update({ 'business' : b, 'comments': comments, 'lat':b.lat, 'lng':b.lon, 'bus_tags':bus_tags, 'pages': pages, 'master_summary': get_master_summary_tag(), 'tags': Tag.objects.all().order_by('-descr').reverse(), 'user_sorts':user_tags, 'top_sorts':top_tags, 'all_sorts':get_all_sorts(4), 'hard_tags':hard_tags, 'value_tags':value_tags, 'location_term':get_community(user) , 'communities': Community.objects.all(), 'following_business': is_user_subscribed(b,user), 'feed' : get_bus_recent_activity(b), 'bus_photos': get_all_bus_photos(b) }) return context