def check_users(self): start_time = time.time() emails = [] cursor = connection.cursor() cursor.execute("SELECT * FROM smf_members;") rows = cursor.fetchall() for row in rows: try: user = User.objects.get(username=row[1]) except User.DoesNotExist: try: print "User %s does not exist. Creating" % row[1] user = User.objects.create_user(row[1], row[12]) user.set_unusable_password() user.save() profile = Profile() profile.user = user profile.personal_text = row[13] profile.location = row[18] profile.old_user_id = row[0] profile.website = row[17] profile.title = row[32] profile.save() except Exception, e: print "Could not create user %s, %s" % (row[1], str(e))
def register(request): if request.method == "POST": try: user = User.objects.create_user( email=request.POST['email'], password=request.POST['password'], ) user.first_name = request.POST['first_name'] user.last_name = request.POST['last_name'] user.save() profile = Profile() profile.user = user profile.save() is_employer = (request.POST['is_employer'] == '0') if (is_employer): company = Company() company.user = user company.save() return render(request, 'registration/edit.html', {'is_company': is_employer}) except: return render(request, 'registration/edit.html', {'is_company': False}) else: return render(request, 'registration/registration.html')
def convert_users(self): start_time = time.time() emails = [] users = User.objects.values('email') for user in users: emails.append(user["email"]) print emails cursor = connection.cursor() cursor.execute("SELECT * FROM smf_members;") rows = cursor.fetchall() for row in rows: old_id = row[0] username = row[1] date_registered = row[2] post_count = row[3] last_login = row[6] email = row[12] personal_text = row[13] gender = row[14] website = row[17] location = row[18] if email in emails: user = User.objects.get(email=row[12]) profile, created = Profile.objects.get_or_create(user=user) if created: profile.save() else: try: user = User.objects.create_user(row[1], row[12]) user.set_unusable_password() user.save() profile = Profile() profile.user = user profile.personal_text = row[13] profile.location = row[18] profile.old_user_id = row[0] profile.website = row[17] profile.title = row[32] profile.save() except Exception, e: with open("conversion_errors.log", "a") as myfile: myfile.write("%s \r\n %s\r\n\r\n" % (row[1], str(e)))
def set_initial_user_names(request, user, sociallogin=None, **kwargs): """ sociallogin.account.provider # e.g. 'twitter' sociallogin.account.get_avatar_url() sociallogin.account.get_profile_url() sociallogin.account.extra_data['screen_name'] """ profile = Profile() if sociallogin: if sociallogin.account.provider == 'facebook': profile.gender_type = sociallogin.account.extra_data['gender'] #verified = sociallogin.account.extra_data['verified'] #I want to get country and city of user from ip address. from ipware import get_client_ip client_ip, is_routable = get_client_ip(request) if client_ip is None: pass # Unable to get the client's IP address else: # We got the client's IP address if is_routable: # The client's IP address is publicly routable on the Internet import requests r = requests.get('http://usercountry.com/v1.0/json/' + str(client_ip)) result = r.json() if result['status'] == "success": profile.country = result['country']['alpha-2'] profile.city = result['region']['city'] else: #result returns failure pass else: pass # The client's IP address is private profile.user = user profile.save()