def checkEmailPhoneExists()

in src/tobedeleted.py [0:0]

• 19 lines of code
• 5 McCabe index (conditional complexity)

def checkEmailPhoneExists(tmp_email_phone):
    groups = ["Doctor", "Patient", "Operationaladmin", "Systemadmin", "Superadmin", "Hospitaladmin", "Labadmin",
              "Diagnosticadmin"]
    admins = ["Operationaladmin", "Systemadmin", "Superadmin", "Hospitaladmin", "Labadmin", "Diagnosticadmin"]
    tmp_user = {}
    for group in groups:
        sql = MyHelper.querySelect(MyHelper.getTableFromGroup(group), tmp_email_phone)
        with conn.cursor(pymysql.cursors.DictCursor) as cur:
            cur.execute(sql)
            for rows in cur:
                tmp_user.update({'aws_cognito_username': rows['aws_cognito_username']})
                if group in admins:
                    tmp_user.update({'user_group': rows['user_group']})
                else:
                    tmp_user.update({'user_group': group})
            conn.commit()
        if len(tmp_user) > 0:
            break
    return tmp_user