Beispiel #1
0
def getRepairs(busname):
	connexion_vsr, cursor_vsr = Util.connectDB(DB_PATH+"_vsr.db")
	if busname == '369': busname = '396'
	repair_dates_str = cursor_vsr.execute( "SELECT DISTINCT Visits.Date FROM Visits,Operations WHERE Visits.VisitID = Operations.Visit AND Visits.Bus LIKE '%"+busname+"%'" )
	repair_dates = [ Util.str2date(date_str, format = "%Y-%m-%d") for date_str in repair_dates_str ]
	repair_dates_str = [ Util.date2str(dt, format = "%Y-%m-%d") for dt in repair_dates ]
	return repair_dates_str
Beispiel #2
0
			# ------
			
			pvalue1, score1 = como_anomaly.normalityProba_V1( "online", flat_fleet_test_, his_test, all_buses, id_bus, i, h )
			# pvalue1, score1 = como_anomaly.normalityProba_V1( "KNN", flat_fleet_test_, his_test, all_buses, id_bus, i ); dir_imgs = "cosmo_KNN/"
			# pvalue2, score2 = como_anomaly.normalityProba_V2( "RNN", own_test_, his_test, all_buses, id_bus, i ); dir_imgs = "cosmo_RNN/"
			# pvalue1, score1 = 0.5, 0.5
			pvalue2, score2 = pvalue1, score1
			
			h.train( [ bus[0] for bus in fleet_test_ ] )# ; print "nb_nodes", h.nb_nodes
			
			
			Z1.append( pvalue1 ); Z2.append( pvalue2 )
			S1.append( score1 ); S2.append( score2 )
		
		#--------------------------
		connexion_sig, cursor_sig = Util.connectDB(DB_PATH+filename)
		connexion_sig, cursor_sig_mil = Util.connectDB(DB_PATH+busname+"_16644.db")
		connexion_vsr, cursor_vsr = Util.connectDB(DB_PATH+"_vsr.db")
		if busname == '369': busname = '396'
		
		#--------------------------
		image = como_ploting.Ploting( busname, dates )
		
		Z1_means, Dev1 = como_anomaly.getZvalues( Z1 )
		Z2_means, Dev2 = como_anomaly.getZvalues( Z2 )
		image.plotScores(S1, S2); image.plotPValues(Z1, Z2, Z1_means, Z2_means); image.plotDeviations(Dev1, Dev2)
		
		#----------
		repair_dates_str = cursor_vsr.execute( "SELECT DISTINCT Visits.Date FROM Visits,Operations WHERE Visits.VisitID = Operations.Visit AND Visits.Bus LIKE '%"+busname+"%'" )
		repair_dates = [ Util.str2date(date_str, format = "%Y-%m-%d") for date_str in repair_dates_str ]