Beispiel #1
0
 def goaltracker(self):
     mydb = mysql.connector.connect(host="localhost",
                                    user="******",
                                    password='******',
                                    database='flight_manager',
                                    auth_plugin='mysql_native_password')
     mycursor = mydb.cursor()
     query = """
         select flight_manager.air_crew.personal_number, flight_manager.auth_user.first_name, flight_manager.auth_user.last_name, 
         flight_manager.air_crew.goal, count(flight_manager.staffing.personal_num) As achieved
         from flight_manager.auth_user  join flight_manager.air_crew
         on flight_manager.auth_user.username = flight_manager.air_crew.personal_number
         left join flight_manager.staffing
         on flight_manager.air_crew.personal_number = flight_manager.staffing.personal_num
         group by air_crew.personal_number;
         
         """
     mycursor.execute(query)
     results = mycursor.fetchall()
     mydb.commit()
     air_goals = []
     for row in results:
         air_crew = AirCrew()
         air_crew.personal_num = str(row[0])
         air_crew.first_name = str(row[1]).capitalize()
         air_crew.last_name = str(row[2]).capitalize()
         air_crew.goal = str(row[3])
         air_crew.achieved = str(row[4])
         air_goals.append(air_crew)
     return air_goals
Beispiel #2
0
    def goaltracker(self):
        mydb = mysql.connector.connect(host="us-cdbr-iron-east-01.cleardb.net", user="******",
                                       password='******', database='heroku_947e29c06a5b4a3')

        mycursor = mydb.cursor()
        query = """
            select air_crew.personal_number, auth_user.first_name, auth_user.last_name, 
            air_crew.goal, count(staffing.personal_num) As achieved
            from auth_user  join air_crew
            on auth_user.username = air_crew.personal_number
            left join staffing
            on air_crew.personal_number = staffing.personal_num
            group by air_crew.personal_number;
            
            """
        mycursor.execute(query)
        results = mycursor.fetchall()
        mydb.commit()
        mycursor.close()
        air_goals = []
        for row in results:
            air_crew = AirCrew()
            air_crew.personal_num = str(row[0])
            air_crew.first_name = str(row[1]).capitalize()
            air_crew.last_name = str(row[2]).capitalize()
            air_crew.goal = str(row[3])
            air_crew.achieved = str(row[4])
            air_goals.append(air_crew)
        return air_goals