# Path: recruit_app/user/models.py
# class EveCharacter(Model, TimeMixin):
#     __tablename__ = 'characters'
# 
#     character_id = Column(db.String(254), primary_key=True)
#     character_name = Column(db.String(254))
#     corporation_id = ReferenceCol('corporations', pk_name='corporation_id', nullable=True)
#     corporation = relationship('EveCorporationInfo', backref='characters', foreign_keys=[corporation_id])
# 
#     api_id = ReferenceCol('api_key_pairs', pk_name='api_id', nullable=True)
#     api = relationship('EveApiKeyPair', backref='characters', foreign_keys=[api_id])
# 
#     user_id = ReferenceCol('users', nullable=True)
#     user = relationship('User', backref='characters', foreign_keys=[user_id])
# 
#     skillpoints = Column(db.Integer, nullable=True)
#     previous_users = db.relationship('User', secondary=previous_chars, backref=db.backref('previous_chars', lazy='dynamic'), lazy='dynamic')
# 
#     def __str__(self):
#         return self.character_name
# 
# Path: recruit_app/extensions.py



from recruit_app.user.models import EveCharacter
from recruit_app.extensions import cache_extension
from flask import current_app
from bs4 import BeautifulSoup
import requests
        r = s.get(url, verify=True)

        soup = BeautifulSoup(r.text, 'html.parser')
        token = soup.find('input', {'name':'auth_key'})['value']

        payload = {
            'ips_username' : current_app.config['GSF_USERNAME'],
            'ips_password' : current_app.config['GSF_PASSWORD'],
            'auth_key' : token,
            'referer' : 'https://goonfleet.com/',
            'rememberMe' : 1,
        }

        url = 'https://goonfleet.com/index.php?app=core&module=global&section=login&do=process'
        r = s.post(url, data=payload, verify=True)

        url = 'https://goonfleet.com/corps/checkMembers.php'
        r = s.get(url, verify=True)

        payload = {
            'corpID' : str(corp_id)
        }
        r = s.post(url, data=payload, verify=True)

        soup = BeautifulSoup(r.text, 'html.parser')

        output = "<table id='compliance' class='table tablesorter'><thead><th>Character Name</th><th>Forum Name/Main</th><th>Primary Group</th><th>Status</th></thead><tbody>\n"

        for row in soup.findAll('tr'):
            alert = None

# Path: recruit_app/user/models.py
# class EveCharacter(Model, TimeMixin):
#     __tablename__ = 'characters'
# 
#     character_id = Column(db.String(254), primary_key=True)
#     character_name = Column(db.String(254))
#     corporation_id = ReferenceCol('corporations', pk_name='corporation_id', nullable=True)
#     corporation = relationship('EveCorporationInfo', backref='characters', foreign_keys=[corporation_id])
# 
#     api_id = ReferenceCol('api_key_pairs', pk_name='api_id', nullable=True)
#     api = relationship('EveApiKeyPair', backref='characters', foreign_keys=[api_id])
# 
#     user_id = ReferenceCol('users', nullable=True)
#     user = relationship('User', backref='characters', foreign_keys=[user_id])
# 
#     skillpoints = Column(db.Integer, nullable=True)
#     previous_users = db.relationship('User', secondary=previous_chars, backref=db.backref('previous_chars', lazy='dynamic'), lazy='dynamic')
# 
#     def __str__(self):
#         return self.character_name
# 
# Path: recruit_app/extensions.py



# Path: recruit_app/hr/managers.py
from recruit_app.user.models import EveCharacter
from recruit_app.extensions import cache_extension
from flask import current_app
from bs4 import BeautifulSoup
import requests

        r = s.get(url, verify=True)

        soup = BeautifulSoup(r.text, 'html.parser')
        token = soup.find('input', {'name':'auth_key'})['value']

        payload = {
            'ips_username' : current_app.config['GSF_USERNAME'],
            'ips_password' : current_app.config['GSF_PASSWORD'],
            'auth_key' : token,
            'referer' : 'https://goonfleet.com/',
            'rememberMe' : 1,
        }

        url = 'https://goonfleet.com/index.php?app=core&module=global&section=login&do=process'
        r = s.post(url, data=payload, verify=True)

        url = 'https://goonfleet.com/corps/checkMembers.php'
        r = s.get(url, verify=True)

        payload = {
            'corpID' : str(corp_id)
        }
        r = s.post(url, data=payload, verify=True)

        soup = BeautifulSoup(r.text, 'html.parser')

        output = "<table id='compliance' class='table tablesorter'><thead><th>Character Name</th><th>Forum Name/Main</th><th>Primary Group</th><th>Status</th></thead><tbody>\n"

        for row in soup.findAll('tr'):
            alert = None

            if row.get('class'):