def entry(self, username=None, password=None): """A new User with username and password try login Parameters: username: a not null email address or a possibly-null-not string uniquely identifying the specified user password: a not null key the specified user Return: True: wheather username exits and return a JSON Object with user map from database False: wheather username NOT exits and return None Object """ self.username= username #user name to entry self.password= password #password to entry if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "Query by user "+self.username+" with pass "+self.password+" " if username == "admin": self.response= _cnx.single_query("SELECT * FROM usuarios,roles where usuario='"+self.username+"' and contraseniausuario='"+self.password+"' and idrol=roldeusuario limit 1") else: self.response= _cnx.single_query("SELECT * FROM usuarios,roles,sucursal where usuario='"+self.username+"' and contraseniausuario='"+self.password+"' and idrol=roldeusuario and roles.codigosucursal = sucursal.codigosucursal limit 1") if (self.response is not None and len(self.response) > 0): if self.debug: print "User "+self.username+" FOUND" return True,self.response[0] #return pair True, JSON else: if self.debug: print "User "+self.username+" NO FOUND" return False,None #return Flase, None
def all_users(self,subsidiary=None): """ All user in database system Parameters: None Return: True: wheather exits users and return a JSON Object with user map from database False: wheather NOT exits user and return None Object """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all users" self.response= _cnx.single_query("SELECT * FROM usuarios where codigosucursal "+subsidiary+" ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"user found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found users" #return Flase, None return False,None
def seek_quotation(self,numerocotizacion=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query "+numerocotizacion+" quotations" self.response= _cnx.single_query("SELECT * FROM cotizacion where numerocotizacion = '"+numerocotizacion+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"quotation found" return True,self.response else: if self.debug: print "NOT found quotations" return False,None
def exist_offer(self,codigovehiculo=None,codigorepuesto=None,tipooferta=None,valoroferta=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "Buscando ofertas" self.response= _cnx.single_query("SELECT * FROM ofertas WHERE tipooferta='"+tipooferta+"' AND codigovehiculo='"+codigovehiculo+"' AND codigorepuesto ='"+codigorepuesto+"' AND valoroferta ='"+valoroferta+"'" ) if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"ofertas encontradas" return True else: if self.debug: print "No hay ofertas" return False
def all_offerspublic(self,subsidiary=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all offers" self.response= _cnx.single_query("SELECT * FROM ofertas WHERE estado ='PUBLICA' AND codigosucursal "+subsidiary+" ORDER BY codigooferta DESC") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"ofertas encontradas" return True,self.response else: if self.debug: print "No hay ofertas" return False,None
def exist_offerbyId(self,codigooferta): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all offers" self.response= _cnx.single_query("SELECT * FROM ofertas WHERE codigooferta='"+codigooferta+"'") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"ofertas encontradas" return True else: if self.debug: print "No hay ofertas" return False
def seek_offerbyuid(self,uuid=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query offer uuid= "+uuid+"" self.response= _cnx.single_query("SELECT * FROM ofertas WHERE uuid = '"+uuid+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"offers found --" return True,self.response else: if self.debug: print "No offers found" return False,None
def all_quotations(self,codigo_sucursal=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all articles" self.response = _cnx.single_query("SELECT * FROM cotizacion where codigosucursal "+codigo_sucursal+" ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"articles found" return True,self.response else: if self.debug: print "NOT found articles" #return Flase, None return False,None
def all_sales(self,codigo_sucursal=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all sales" self.response = _cnx.single_query("SELECT * FROM venta,cliente where venta.codigosucursal "+codigo_sucursal+" and venta.codigocliente = cliente.codigocliente") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"sales found" return True,self.response else: if self.debug: print "NOT found sales" #return Flase, None return False,None
def seek_inventory_byId(self,identifier=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query inventory with id = "+str(identifier)+" " self.response= _cnx.single_query("SELECT * FROM inventario where codigocarro = '"+str(identifier)+"' or codigorepuesto = '"+str(identifier)+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"inventory found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found inventory" #return Flase, None return False,None
def seek_inventory_bySubsidiary(self,codigo_sucursal=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query "+str(codigo_sucursal)+" inventory" self.response= _cnx.single_query("SELECT * FROM inventario where codigo_sucursal = '"+str(codigo_sucursal)+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"inventory found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found inventory" #return Flase, None return False,None
def exist_vehicle(self,marca = None,linea = None,modelo = None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "existe el vehiculo con marca <b>"+marca+"</b> linea"+linea+"<b> y modelo <b>"+modelo+"</b>" self.response= _cnx.single_query("SELECT * FROM vehiculo where marca = '"+marca+"' and modelo='"+modelo+"' and linea='"+linea+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"car found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True else: if self.debug: print "No hay vehiculo con marca <b>"+marca+"</b> linea"+linea+"<b> y modelo <b>"+modelo+"</b>" #return Flase, None return False
def seek_vehicle_byImportNumber(self,numero_importacion=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query "+numero_importacion+" car" self.response= _cnx.single_query("SELECT * FROM vehiculo where numero_importacion = '"+numero_importacion+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"car found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found cars" #return Flase, None return False,None
def seek_vehicle_byImagen(self,identifier=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query car with id = "+str(identifier)+" " self.response= _cnx.single_query("SELECT * FROM vehiculo where imagenes = '"+str(identifier)+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"car found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found cars" #return Flase, None return False,None
def seek_subsidiary_byId(self,identifier=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query subsidiary with id = "+str(identifier)+" " self.response= _cnx.single_query("SELECT * FROM sucursal where codigosucursal = '"+str(identifier)+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"subsidiary found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found subsidiaries" #return Flase, None return False,None
def seek_subsidiary_byName(self,nombre=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query "+nombre+" subsidiary" self.response= _cnx.single_query("SELECT * FROM sucursal where nombre = '"+nombre+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"subsidiary found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found subsidiaries" #return Flase, None return False,None
def all_subsidiaries(self): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all subsidiaries" self.response= _cnx.single_query("SELECT * FROM sucursal") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"subsidiary found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found subsidiaries" #return Flase, None return False,None
def all_articles(self,codigo_sucursal=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all articles" self.response = _cnx.single_query("SELECT * FROM vehiculo,inventario where inventario.codigocarro = vehiculo.codigovehiculo and codigosucursal "+codigo_sucursal+" order by codigovehiculo desc") # self.response += _cnx.single_query("SELECT * FROM repuesto,inventario where inventario.codigorepuesto = repuesto.codigo_repuesto and codigosucursal "+codigo_sucursal+" order by codigo_repuesto desc") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"articles found" return True,self.response else: if self.debug: print "NOT found articles" #return Flase, None return False,None
def seek_orderbyuid(self,numeroorden=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query "+numeroorden+" orders" self.response= _cnx.single_query("SELECT * FROM ordendetrabajo where numeroorden = '"+numeroorden+"' ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"order found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found orders" #return Flase, None return False,None
def get_grantees(self,idrol=None): """Get all the grantees that are directly granted this role. """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "get_grantees" self.response= _cnx.single_query("SELECT PROPIEDADESROL FROM ROLES WHERE IDROL='"+str(idrol)+"'"); if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"rol found " #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found rol" #return Flase, None return False,None
def all_inventoryparts(self,codigo_sucursal=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all inventory" print "codigo_sucursal"+str(codigo_sucursal) self.response = _cnx.single_query("SELECT * FROM inventario,repuesto WHERE inventario.codigorepuesto >0 and inventario.codigorepuesto = repuesto.codigo_repuesto AND codigosucursal "+codigo_sucursal+" ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"inventory found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found subsidiaries" #return Flase, None return False,None
def get_owner(self, idrol=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "get_owner" self.response= _cnx.single_query("SELECT PROPIETARIOROL FROM ROLES WHERE IDROL='"+str(idrol)+"'"); if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"rol found " #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found rol" #return Flase, None return False,None
def all_roles(self,subsidiary=None): """Gets a list of all the roles for the application. """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all users" self.response= _cnx.single_query("SELECT * FROM ROLES,SUCURSAL WHERE ROLES.codigosucursal "+subsidiary+" AND SUCURSAL.codigosucursal =ROLES.codigosucursal AND idrol<>1") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"user found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found users" #return Flase, None return False,None
def all_order(self): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all orders" self.response= _cnx.single_query("SELECT * FROM ordendetrabajo") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"Order found" # cambio las fechas a forma to iso #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found Orders" #return Flase, None return False,None
def get_messageidentifier(self,idusuario=None,identifier=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all messages" self.response= _cnx.single_query("SELECT nombrecompletousuario,apellidosusuario,mensaje,estado,fecha FROM mensajes,usuarios where mensajes.idreceptor = "+idusuario+" and mensajes.idemisor= usuarios.idusuario and idmensaje = "+identifier+" ") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"No messages" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found messages" #return Flase, None return False,None
def seek_role_byId(self,identifier=None): """Gets a value indicating whether the specified role name already exists in the role data source. """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query exists role" self.response= _cnx.single_query("SELECT * FROM ROLES,SUCURSAL WHERE IDROL='"+str(identifier)+"' AND SUCURSAL.codigosucursal =ROLES.codigosucursal") if (self.response is not None and len(self.response) > 0): if self.debug: print "role with id="+str(identifier)+" found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "role with id="+str(identifier)+" NOT found" return Flase, None
def all_vehicles(self,codigo_sucursal=None): """ """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all cars" self.response= _cnx.single_query("SELECT codigovehiculo,marca,linea, modelo, cilindraje, numero_importacion,clase_de_vehiculo, tipo_carroceria, combustible, color, capacidad,precio_base, estado, descripcion, imagenes FROM vehiculo,inventario where inventario.codigocarro = vehiculo.codigovehiculo and codigosucursal "+codigo_sucursal+" order by codigovehiculo desc") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"car found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found cars" #return Flase, None return False,None
def get_by_username(self,username): """Return a User Object by identifier Parameters: identifier - (int) identifier to seek Return : User - User Object None - None Object""" if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "Query by usuario= '"+username+"' " self.response= _cnx.single_query("SELECT * FROM usuarios where usuario = '"+username+"' limit 1") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"User with username="******" FOUND" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "User with username="******" NO FOUND" return False,None
def exists(self, rol_name=None,subsidiary=None): """Gets a value indicating whether the specified role name already exists in the role data source. """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query exists role" # print "########exist "+str("SELECT * FROM ROLES WHERE NOMBREROL='"+rol_name+"' AND CODIGOSUCURSAL=(select codigosucursal from sucursal where sucursal.nombre='"+subsidiary+"')") self.response= _cnx.single_query("SELECT * FROM ROLES WHERE NOMBREROL='"+rol_name+"' AND CODIGOSUCURSAL=(select codigosucursal from sucursal where sucursal.nombre='"+subsidiary+"')") if (self.response is not None and len(self.response) > 0): if self.debug: print rol_name+" role found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True else: if self.debug: print rol_name+" role NOT found" #return Flase, None return False
def all_users_by_role(self, role): """ All user in database system Parameters: None Return: True: wheather exits users and return a JSON Object with user map from database False: wheather NOT exits user and return None Object """ if self.debug: print "Connect to database" _cnx= Connection() if self.debug: print "query all by rol "+role+"" self.response= _cnx.single_query("SELECT * FROM roles,usuarios where descripcion= '"+role+"' AND idusuario=idrol") if (self.response is not None and len(self.response) > 0): if self.debug: print len(self.response),"user found" #Si no es nulo y la longitud de la consulta es mayor que 1 return True,self.response else: if self.debug: print "NOT found users" #return Flase, None return False,None