Python MOSES.getBigbrotherCredentials方法代碼示例

# 需要導入模塊: import MOSES [as 別名]
# 或者: from MOSES import getBigbrotherCredentials [as 別名]
def getQualityHistoricalDataMonth(query_date = None, months = None):
    import calendar
    if query_date is None:
        query_date = datetime.date.today()
    if months is None:
        months = 2
    months_list = [month for month in range(query_date.month+1)][1:][-months:]
    print months_list
    dates_lists = []
    end_dates = []
    cfm_average_list = []
    gseo_average_list = []
    user_id, password = MOSES.getBigbrotherCredentials()
    for month in months_list:
        year_ = query_date.year
        start_date = datetime.date(year_, month, 1)
        end_date = datetime.date(year_, month, calendar.monthrange(year_, month)[1])
        dates = MOSES.getWorkingDatesBetween(user_id, password, start_date, end_date, mode="All")
        dates.sort()
        start_date = min(dates)
        end_date = max(dates)
        cfm_average = 100.00*MOSES.getAverageTeamCFMBetween(start_date, end_date, True)
        gseo_average = 100.00*MOSES.getAverageTeamGSEOBetween(start_date, end_date, True)
        cfm_average_list.append(cfm_average)
        gseo_average_list.append(gseo_average)
        end_dates.append(end_date)
    return end_dates, cfm_average_list, gseo_average_list

# 需要導入模塊: import MOSES [as 別名]
# 或者: from MOSES import getBigbrotherCredentials [as 別名]
    def getEmployeeID(self, employee_name):
        return [employee["Employee ID"] for employee in self.employees_data if employee["Name"] == employee_name][0]

    def getDuration(self):
        self.start_time = self.event_start_time.dateTime().toPyDateTime()
        self.end_time = self.event_end_time.dateTime().toPyDateTime()
        duration_seconds = (self.end_time - self.start_time).total_seconds()
        return duration_seconds
    
    def getTotalDurationFor(self, employee_id):
        from random import randint
        total_duration = randint(0,3600)
        #print "Generated random duration of %d" %total_duration
        return total_duration

    def showDuration(self, duration_seconds):
        h, remainder = divmod(duration_seconds, 3600)
        m, s = divmod(remainder, 60)
        h = int(h)
        m = int(m)
        s = int(s)
        self.duration = datetime.time(h,m,s)
        self.calc_duration_datetimeedit.setTime(self.duration)

if __name__ == "__main__":
    app = QtGui.QApplication([])
    u, p = MOSES.getBigbrotherCredentials()
    events = EventManager(u,p)
    sys.exit(app.exec_())

    #select * from managermapping where `Employee ID` = '62487' AND `Revision Date` = (SELECT MAX(`Revision Date`) from managermapping where `Revision Date`<='2015-05-01');

# 需要導入模塊: import MOSES [as 別名]
# 或者: from MOSES import getBigbrotherCredentials [as 別名]
        #start plotting
        self.graphite_canvas.axes.set_xlabel("Writers")
        self.graphite_canvas.axes.set_ylabel("Efficiency")
        #print efficiency_writers_order, efficiency_list, efficiency_colors
        for counter in range(data_length):
            bar_set = self.graphite_canvas.axes.bar(positions[counter], efficiency_list[counter], width=efficiency_width, color = efficiency_colors[counter])
        self.graphite_canvas.axes.grid(True, lw=0.5, ls="--", c="0.05")
        self.graphite_canvas.axes.set_title("Efficiency Graph For %s" % query_date)
        ax = self.graphite_canvas.axes
        ax.xaxis.set_major_locator(ticker.FixedLocator(positions))
        ax.xaxis.set_major_formatter(ticker.FixedFormatter((efficiency_writers_order)))
        y_axis_tickers = np.arange(40)*2.5
        
        self.graphite_canvas.axes.set_yticks(np.arange(min(efficiency_list), max(efficiency_list)+1, max(efficiency_list)/20))
        labels = self.graphite_canvas.axes.get_xticklabels()
        #self.graphite_canvas.fig.setp(labels, rotation = 90.0)
        #self.graphite_canvas.axes.subplots_adjust(bottom=0.2)
        self.graphite_canvas.axes.set_ylim(min(efficiency_list))
        self.graphite_canvas.draw()

        #file_name = "Efficiency_Graph_%d%d%d.png" %(query_date.year,query_date.month, query_date.day)
        #self.graphite_canvas.axes.savefig(file_name, dpi=300, bbox_inches='tight')

if __name__ == "__main__":
    
    app = QtGui.QApplication([])
    user_id, password = MOSES.getBigbrotherCredentials()
    graphite = Graphite(user_id, password)
    sys.exit(app.exec_())