import MySQLdb

# db = MySQLdb.Connection("localhost", "root", "root", "users")
# cursor = db.cursor()
# cursor.execute("SELECT id, login, user_first_name, second_name FROM user")
# data = cursor.fetchall()

# for i in data:
#     print "ID: %s; Login: %s; First name: %s; Last name: %s; " % i


# db.close()


class User:
    login = ''
    password = ''
    first_name = ''
    last_name = ''
    is_active = False

    def signin(self, e_login, e_password):
        if len(e_login) >= 6 and len(e_password) >= 6:
            # self.login = e_login
            # self.password = e_password
            db = MySQLdb.Connection("localhost", "root", "root", "users")
            cursor = db.cursor()
            INSERT_QUERY = """
                INSERT INTO `users`.`user` (
                    `login`, `parol`, `user_first_name`, `second_name`,
                    `is_active`, `joined_at`, `last_joined`
                ) VALUES (
                    '{login}', '{password}', '', '', 1, NOW(), NOW()
                );
            """.format(login=e_login, password=e_password)

            cursor.execute(INSERT_QUERY)
            db.commit()
            db.close()
            return 'Success'
        elif len(e_login) < 6:
            return 'LoginError'
        elif len(e_password) < 6:
            return 'ErrorPassword'

    # def signin_first(self, e_login, e_password):
    #     if len(e_login) > 6:
    #         self.login = e_login
    #     else:
    #         return 'ErrorPassword'

    #     if len(e_password) > 6:
    #         self.password = e_password
    #     # elif e_password is None:
    #     #     return 'ErrorPassword'
    #     else:
    #         return 'ErrorPassword'

    #     self.is_active = True

    #     return (self.login, self.password, self.is_active)

    def reset_password(self, e_login, e_password):
        if len(e_password) > 6:
            db = MySQLdb.Connection("localhost", "root", "root", "users")
            cursor = db.cursor()
            INSERT_QUERY = """
                UPDATE `users`.`user` SET parol='{password}' WHERE login='{login}';
            """.format(password=e_password, login=e_login)
            cursor.execute(INSERT_QUERY)
            db.commit()
            db.close()
        else:
            return 'ErrorPassword'

    def is_active(self, e_login):
        # db = MySQLdb.Connection("localhost", "root", "root", "users")
        # cursor = db.cursor()
        # INSERT_QUERY = """
        #     SELECT is_active FROM `users`.`user` WHERE login='{login}';
        # """.format(login=e_login)
        # cursor.execute(INSERT_QUERY)
        # db.commit()
        # db.close()
        return self.is_active

    def change_profile_detail(self, e_login, e_first_name, e_last_name):
        if len(e_first_name) > 2:
            db = MySQLdb.Connection("localhost", "root", "root", "users")
            cursor = db.cursor()
            INSERT_QUERY = """
                UPDATE `users`.`user` SET user_first_name='{first_name}' WHERE login='{login}';
            """.format(first_name=e_first_name, login=e_login)
            cursor.execute(INSERT_QUERY)
            db.commit()
            db.close()
        else:
            return 'ShortFirstName'

        if len(e_last_name) > 2:
            db = MySQLdb.Connection("localhost", "root", "root", "users")
            cursor = db.cursor()
            INSERT_QUERY = """
                UPDATE `users`.`user` SET second_name='{second_name}' WHERE login='{login}';
            """.format(second_name=e_last_name, login=e_login)
            cursor.execute(INSERT_QUERY)
            db.commit()
            db.close()
        else:
            return 'ShortLastName'

    def check_password(self, e_password):
        return self.password == e_password

    def send_confirmation_password(self, letter):
        return letter


def trys():
    rikitiki = User()
    rikitiki.signin('rikitiki', 'parol')
    # rikitiki.reset_password('subaru', 'newparol')
    # rikitiki.change_profile_detail('subaru', 'Subaru', 'Shyuuhei')


if __name__ == '__main__':
    trys()