def check(self, tipo=None, nro_control=None, titulo=None, id_msj=None):
		with _db_session:
			if nro_control:
				return _select(msg for msg in _Mensaje if int(nro_control)==msg.nro_control and int(tipo)==msg.tipo and msg.activo==True).exists()
			else:
				if id_msj:
					tmp = _Mensaje.select(lambda msg: id_msj!=msg.id_msj and msg.titulo==titulo and msg.activo==True).count()
					return False if tmp==0 else True
				else:
					return _select(msg for msg in _Mensaje if titulo==msg.titulo and int(tipo)==msg.tipo and msg.activo==True).exists()
Beispiel #2
0
	def v_ci(self, ci):
		try:
			with _db_session:
				return _select(pr for pr in _Persona if pr.ci==ci).exists()
		except Exception, e:
			#raise e
			return False
Beispiel #3
0
	def v_telf(self, telf):
		try:
			with _db_session:
				return _select(pr for pr in _Persona if pr.telf==telf).exists()
		except Exception, e:
			#raise e
			return False
Beispiel #4
0
	def v_login(self, login):
		try:
			with _db_session:
				return _select(us for us in _Usuario if us.login==login).exists()
		except Exception, e:
			print e
			return False
Beispiel #5
0
 def v_login(self, login):
     try:
         with _db_session:
             return _select(us for us in _Usuario
                            if us.login == login).exists()
     except Exception, e:
         print e
         return False
	def get_All(cls):
		return _select(tn for tn in _Comunidad)
	def getbyChild(cls, id_rcn):
		return _select(ct for ct in _Control if ct.recien_nacido.id_rcn==id_rcn).order_by(lambda ct: (ct.nro_con, ct.fecha_con))
	def getbyPregnancy(cls, id_emb):
		return _select(ct for ct in _Control if ct.embarazo.id_emb==id_emb).order_by(lambda ct: (ct.nro_con, ct.fecha_con))
Beispiel #9
0
	def get_All(self, status=True):
		return _select(pr for pr in _Persona if pr.activo==status and not pr.defuncion).order_by(lambda pr: (pr.nombres, pr.apellidos))
	def get_All(self):
		return _select(cm for cm in _Comunidad).order_by(lambda cm: (cm.municipio, cm.nombre))
Beispiel #11
0
 def get_All(self):
     return _select(cm for cm in _Comunidad).order_by(
         lambda cm: (cm.municipio, cm.nombre))
	def get_all(self, id_per):
		return _select(em for em in _Embarazo if em.embarazada.id_per==id_per).order_by(lambda em: (_desc(em.parto_prob),))
Beispiel #13
0
	def get_All(cls):
		# return _select(tn for tn in _Comunidad)
		return _select(tn for tn in _Municipio).order_by(lambda tn: (tn.dpto, tn.nombre))
Beispiel #14
0
	def prenants_by_community(self, id_com):
		return _select(pr for pr in _Per if pr.sexo=='f' and pr.comunidad.id_com==id_com)
Beispiel #15
0
 def get_All(cls):
     return _select(nt
                    for nt in _Red_Salud).order_by(lambda nt: (nt.nombre, ))
	def get_All(cls):
		return _select(nt for nt in _Red_Salud).order_by(lambda nt: (nt.nombre,))