def ag_update_kit_password(self, kit_id, password):
        """updates ag_kit table with password

        kit_id is supplied_kit_id in the ag_kit table
        password is the new password
        """
        with TRN:
            password = password.encode('utf-8')
            password = bcrypt.hashpw(password, bcrypt.gensalt())
            sql = """UPDATE AG_KIT
                     SET kit_password = %s, pass_reset_code = NULL
                     WHERE supplied_kit_id = %s"""
            TRN.add(sql, [password, kit_id])