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))
Exemple #2
0
    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 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)))
Exemple #4
0
    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)))