INNER CODE UNIT · Python

get_dept

infobyte/emploleaks · emploleaks.py:729

        def get_dept(emp):
            return emp['department'] or ''

        emp_data = []
        all_breaches = []
        all_email_creds = []
        all_secrets = []

        for emp in employees:
            eid = emp['employee_id']
            name = emp['name'] or ''
            title = emp['title'] or ''
            photo = emp['profile_photo_url'] or ''
            dept = get_dept(emp)

            cur.execute("SELECT email FROM emails WHERE employee_id = ?", (eid,))
            confirmed = [r['email'] for r in cur.fetchall()]
            cur.execute("SELECT email FROM potential_emails WHERE employee_id = ?", (eid,))

View source record →