def __init__(self, id): db = MySQLdb.connect(host="localhost", user="******", passwd="ringil-87", db="parafarmacie") crs = db.cursor() crs.execute("select * from pv where pv_id={0}".format(id)) item = crs.fetchone() # ui = Ui_MainWindow(id) # print ui #ui.text_fax.insert("test anagrafica") ui.checkBox_cliente.setCheckState(int(item[6])) ui.text_codice_mmas.setText(str(item[3])) ui.text_ragione_sociale.setText(str(item[8])) ui.text_titolare.setText(str(item[9])) ui.text_indirizzo.setText(str(item[11])) ui.lineEdit_10.setText(str(item[12])) ui.text_comune.setText(str(item[13])) ui.text_provincia.setText(str(item[14])) ui.text_telefono.setText(str(item[15])) ui.text_mail.setText(str(item[21])) ui.text_sito.setText(str(item[20])) ui.text_fax.setText(str(item[19])) tables = [] tables.append(ui.table_parametri_mmas) tables.append(ui.table_marchi_mmas) tables.append(ui.table_potenziali_mmas) db.close() util = utility(795, tables) util.populateTables(795) ui.show()
def __init__(self, id): db = MySQLdb.connect(host="localhost", user="******", passwd="ringil-87",db="parafarmacie") crs=db.cursor() crs.execute("select * from pv where pv_id={0}".format(id)) item= crs.fetchone() # ui = Ui_MainWindow(id) # print ui #ui.text_fax.insert("test anagrafica") ui.checkBox_cliente.setCheckState(int(item[6])) ui.text_codice_mmas.setText(str(item[3])) ui.text_ragione_sociale.setText(str(item[8])) ui.text_titolare.setText(str(item[9])) ui.text_indirizzo.setText(str(item[11])) ui.lineEdit_10.setText(str(item[12])) ui.text_comune.setText(str(item[13])) ui.text_provincia.setText(str(item[14])) ui.text_telefono.setText(str(item[15])) ui.text_mail.setText(str(item[21])) ui.text_sito.setText(str(item[20])) ui.text_fax.setText(str(item[19])) tables=[] tables.append(ui.table_parametri_mmas) tables.append(ui.table_marchi_mmas) tables.append(ui.table_potenziali_mmas) db.close() util=utility(795, tables) util.populateTables(795) ui.show()
def analyze(self, user): print "***selezioni su finestra " + str(self.ui_tree.getList()) self.selectionList = Lista(user, user.getActiveDb()) self.util = utility( [], 0, user, user.getActiveDb()) #non potra' popolare' le tabelle # create and show the dialog curLayer = self.iface.mapCanvas().currentLayer() #elenco tutti gli elementi del layer corrente featids = range(curLayer.featureCount()) #creo la lista della selezioni self.makeList() print("SSScomuni selezionati mmasgis.py 430", self.selectionList.getList()) self.dlg = testDialog(self.selectionList.getList(), user, user.getActiveDb()) NomeDb = user.getActiveDb().getNameDb() self.dlg.setWindowTitle("Elenco Anagrafiche " + NomeDb.capitalize()) # show the dialog self.dlg.show() #app=QtGui.QApplication(["show",""],True) #resetto la lista self.selectionList.resetList() #sys.exit(app.exec_()) result = 1 #dlg.traccheggio() # See if OK was pressed if result == 1: # do something useful (delete the line containing pass and # substitute with your code pass
def mmasgis(self, user): self.util = utility( [], 0, user, user.getActiveDb()) #non potra' popolare' le tabelle self.selectionList = Lista(user, user.getActiveDb()) # create and show the dialog #####settrace() curLayer = self.iface.mapCanvas().currentLayer() #elenco tutti gli elementi del layer corrente featids = range(curLayer.featureCount()) #creo la lista della selezioni self.makeList() self.log("comuni selezionati mmasgis.py 297", self.selectionList.getList()) self.log( "lista inviata a testDialog {0} ".format( self.selectionList.getList()), "test.py 212") self.dlg = testDialog(self.selectionList.getList(), user, user.getActiveDb()) # show the dialog self.dlg.show() #app=QtGui.QApplication(["show",""],True) #resetto la lista self.selectionList.resetList() #sys.exit(app.exec_()) result = 1 #dlg.traccheggio() # See if OK was pressed if result == 1: # do something useful (delete the line containing pass and # substitute with your code pass
def mmasgis(self,user): self.util=utility([],0,user,user.getActiveDb())#non potra' popolare' le tabelle self.selectionList=Lista(user,user.getActiveDb()) # create and show the dialog #####settrace() curLayer = self.iface.mapCanvas().currentLayer() #elenco tutti gli elementi del layer corrente featids = range(curLayer.featureCount()) #creo la lista della selezioni self.makeList() self.log("comuni selezionati mmasgis.py 297",self.selectionList.getList()) self.log("lista inviata a testDialog {0} ".format(self.selectionList.getList()),"test.py 212") self.dlg = testDialog(self.selectionList.getList(),user,user.getActiveDb()) # show the dialog self.dlg.show() #app=QtGui.QApplication(["show",""],True) #resetto la lista self.selectionList.resetList() #sys.exit(app.exec_()) result=1 #dlg.traccheggio() # See if OK was pressed if result == 1: # do something useful (delete the line containing pass and # substitute with your code pass
class Sqrt: x = utility() number = int(input("enter the number\n")) x.sqrtFunction(number)
class Anagram: obj = utility() st1 = raw_input("enter first string\n") st2 = raw_input("enter second string\n") obj.isAnagram(st1, st2)
def analyze(self,user): print "***selezioni su finestra "+str(self.ui_tree.getList()) self.selectionList=Lista(user,user.getActiveDb()) self.util=utility([],0,user,user.getActiveDb())#non potra' popolare' le tabelle # create and show the dialog curLayer = self.iface.mapCanvas().currentLayer() #elenco tutti gli elementi del layer corrente featids = range(curLayer.featureCount()) #creo la lista della selezioni self.makeList() print("SSScomuni selezionati mmasgis.py 430",self.selectionList.getList()) self.dlg = testDialog(self.selectionList.getList(),user,user.getActiveDb()) NomeDb=user.getActiveDb().getNameDb() self.dlg.setWindowTitle("Elenco Anagrafiche "+NomeDb.capitalize()) # show the dialog self.dlg.show() #app=QtGui.QApplication(["show",""],True) #resetto la lista self.selectionList.resetList() #sys.exit(app.exec_()) result=1 #dlg.traccheggio() # See if OK was pressed if result == 1: # do something useful (delete the line containing pass and # substitute with your code pass
class insertion: x = utility() array = ['a', 'k', 'n', 'b', 'f', 'c'] print "unsorted list is" print array x.insertionsort(array)
class Find_Number: x = utility() number = int(input("enter the number\n")) power = 2**number print power x.findPower(0, power)
def populateAnagrafica(self, id): self.tables = [] self.id = id self.tables.append(self.table_parametri_mmas) self.tables.append(self.table_marchi_mmas) self.tables.append(self.table_potenziali_mmas) self.util = utility(self.id, self.tables) self.util.populateTables(self.id) self.util.populateFields(self, self.id)
def populateAnagrafica(self, id): self.tables=[] self.id=id self.tables.append(self.table_parametri_mmas) self.tables.append(self.table_marchi_mmas) self.tables.append(self.table_potenziali_mmas) self.util=utility(self.id, self.tables) self.util.populateTables(self.id) self.util.populateFields(self, self.id)
class bubbleSort: x = utility() numList = [10, 15, 14, 13, 19, 8, 4, 33] print "list before sort" print numList, "\n" print "list after sort" print(x.bubbleSort(numList))
def instantiateUtil(self): """ instanzia la classe util @param None: @return: None """ #svuoto la lista delle tabelle self.tables={} self.tables['parametro']=self.table_parametri_mmas self.tables['marca']=self.table_marchi_classe self.tables['potenziale']=self.table_potenziali_mmas self.util=utility(self.id, self.tables,self.user,self.activeDb,True)
class Binary: x = utility() number = input("enter the number\n") result1 = x.toBinary(number) print result1,"\n" result2 = x.swap(result1) print " after swapning a digits \n",result2 result3 = x.convertToDecimal(result2) print "after converting a binary to decimal \n",result3
def __init__(self, user, db): self.user = user self.db = db self.lista = [] self.cons = cons() self.util = utility([], 0, user, db) self.utbClasses = {} self.utbClasses['mysql'] = [Regione, Provincia, Comune, CAP] self.utbClasses['postgresql'] = [RegionePg, ProvinciaPg, ComunePg, CAP] self.utbFactory = {} self.utbFactory['reg'] = self.utbClasses[db.getRDBMS()][0] #Regione self.utbFactory['pro'] = self.utbClasses[db.getRDBMS()][1] #Provincia self.utbFactory['com'] = self.utbClasses[db.getRDBMS()][2] #Comune self.utbFactory['cap'] = self.utbClasses[db.getRDBMS()][3] #CAP
class Range_Prime: x = utility() number = int(raw_input("enter the range between 1 to 1000\n")) print "\palindrome number is\n" i = 2 while i < number: result = x.prime(i) if result == True: print i, " is prime number" else: pass i += 1
def doit(self, pv_id): #self.w = Ui_MainWindowAnagrafica(QtGui.QMainWindow) # mainWindowAnagrafica necessita del riferimento a chi la invoca per poter scorrere la lista self.w = MainWindowAnagrafica(pv_id, self, self.user, self.activeDb) #self.w.setGeometry(QtCore.QRect(100, 100, 400, 200)) tables = {} tables['parametro'] = self.w.table_parametri_mmas tables['marca'] = self.w.table_marchi_classe tables['potenziale'] = self.w.table_potenziali_mmas #print "doit activedb",self.activeDb util = utility(pv_id, tables, self.user, self.activeDb, census=True) #util.populateTables(pv_id) util.populateFields(self.w, int(str(pv_id))) screen = QtGui.QDesktopWidget().screenGeometry() size = self.w.geometry() self.w.move((screen.width() / 2) - size.width() / 2, (screen.height() / 2) - size.height() / 2) self.w.setWindowTitle("Scheda Anagrafica " + self.nomeDb.capitalize()) self.w.show()
V2 = Vol(h2, 1) V2.price = 700 flights = [V1, V2] T = Client(0) B = Client(1) C = B for f in flights: print("Vol") print(">>> Time utility = {}".format(time_utility(C, f))) print(">>> Price utility = {}".format(price_utility(C, f))) print(">>> Utility = {}".format(utility(C, f))) print(">>> Utility / temp = {}".format(utility(C, f) / C.temp)) print("Overall") print(">>> Choix : {}".format(choice(C, flights, 1))) f = Fareclass("Leisure", 1, 2, 3, 0.5) fares = [f] list = demand_NHPP(10, fares) def fn(p, client): hor = lambda h: math.exp(-1 / 12 * (h - 9)**2) + math.exp(-1 / 12 * (h - 19)**2) uh = hor(14)
class AnaAndPalin: x = utility() number = int(raw_input("enter the number between 1 to 1000\n")) print "\n Palindrom Number is :" x.palPrime(number)
class MenuDriven: x = utility() choice = 0 while 1: print "Menu : " print "1. binarySearch method for integer" print "2. binarySearch method for String" print "3. insertionSort method for integer" print "4. insertionSort method for String" print "5. bubbleSort method for integer" print "6. bubbleSort method for String" print "7.Exit" choice = int(input("\nenter your choice\n")) if choice == 1: numList = [1, 3, 6, 9, 11, 32, 54, 59, 61] print numList ele = input("enter the element to search") pos = x.binarySearchInteger(ele, numList) if (pos != -1): print ele, " is found at ", (pos + 1), " position" else: print("element not found") elif choice == 2: numList = ['a', 'b', 'c', 'd', 'e', 'f', 'g'] print numList ele = raw_input("enter the element to search") pos = x.binarySearchString(ele, numList) if (pos != -1): print ele, " is found at ", (pos + 1), " position" else: print("element not found") elif choice == 3: numList = [10, 15, 14, 13, 19, 8, 4, 33] print numList array1 = x.insertionSortInteger(numList) print "Sorted Insertion Sort Array : ", array1 elif choice == 4: array = ["nikhil", "kunal", "zeeshan", "amar"] print array array1 = x.insertionSortString(array) print "Sorted Insertion Sort Array : ", array1 elif choice == 5: numList = [10, 15, 14, 13, 19, 8, 4, 33] print "list before sort" print numList, "\n" print "list after sort" print(x.bubbleSort(numList)) elif choice == 6: array = ["nikhil", "kunal", "zeeshan", "amar"] print("Sorted Bubble Sort Array : ") print array print("Sorted Bubble Sort Array : ") x.bubbleSortString(array) else: exit(0)
class ToBinary: x = utility() number = input("enter the Nuber\n") result = x.toBinary(number) print result
class Vending_Machin: x = utility() i = 0 notes = [1000, 500, 100, 50, 20, 10, 5, 2, 1] amount = int(input("enter the amount\n")) x.vendingMachin(notes, amount, i)
from utility import * util=utility([],0) dicto=open("dict.py",'a') dicto.write("regione={") def writeList(regione,t): l= "'{0}':{1},".format(regione,str(t)) dicto.write(l) #print util.getRegioneId_sql("SICILIA") lista= util.getRegioni() for i in lista: provincie=util.regionExpander(i) writeList(i,provincie)
from utility import * util = utility([], 0) dicto = open("dict.py", 'a') dicto.write("regione={") def writeList(regione, t): l = "'{0}':{1},".format(regione, str(t)) dicto.write(l) #print util.getRegioneId_sql("SICILIA") lista = util.getRegioni() for i in lista: provincie = util.regionExpander(i) writeList(i, provincie)
def profit(flights, prices, list_of_clients, pricing_policy): #Si on a trop de clients, la politique de prix est invalide ==> ERREUR N = len(list_of_clients) #Sinon c'est OK et on prend les clients par ordre d'arrivée #Remarque : si on a pas assez de clients, la politique de prix sera certainement sous-optimale #Initialisation step = 0 #Liste des états states = States(flights) #Etat initial (0,0,....,0) state_index = 0 dic_sales = {} count = 0 for client in list_of_clients: count += 1 state = states[state_index] print("Arrivée du client n°{} sur {}".format(step + 1, N)) if seat_available(flights) == False: print("Plus de siège disponible, plus d'achat.") break else: available = [f.remaining for f in flights] print("Sièges disponibles : {}".format(available)) #S'il reste des sièges on cherche le pricing correspondant [p1,...,pn] pricing = pricing_policy[step][state_index] print(">>>Pricing proposé :{}".format(pricing)) #On doit mettre à jour le prix proposé de chaque vol for i in range(len(flights)): flights[i].price = pricing[i] #Le client prend une décision #flight_choice = -1 si pas d'achat, i si achat vol i #Choix seulement s'il reste de la place ! flight_choice = choice(client, flights, verbose=1) #Si achat if flight_choice != -1: flight = flights[flight_choice] #print(">>>Le client choisit le vol {} d'utilité {}".format(flight_choice,math.exp(utility(client,flights[flight_choice])))) u = utility(client, flight) print( ">>>Le client choisit le vol {} pour un prix de {} et une utilité de {}" .format(flight_choice, flight.price, u)) dic_sales[count] = [ flight.price, flight.departure_time.hours, flight.remaining ] #On modifie l'objet Vol pour flight.sell() #On récupère l'index du nouvel état new_state = state.copy() new_state[flight] = flight.seats - flight.remaining state_index = states.index(new_state) else: print( ">>>Le client choisit de ne pas acheter pour une utilité de {}" .format(client.v0)) #si pas d'achat rien ne change step += 1 #Quand on a fini de parcourir la file de clients, on calcule le gain total return sum([f.gain() for f in flights]), dic_sales