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 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 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()
