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