Advertisement
Guest User

Funcion 3

a guest
Mar 20th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. from cassandra.cluster import Cluster
  2. cluster = Cluster()
  3. session = cluster.connect()
  4. session.execute('USE proyecto1')
  5.  
  6. def ExtractInfo():
  7. Usuarios = session.execute('SELECT * FROM usuario')
  8. exist = 0
  9.  
  10. Usuario = 'totoaspri11a'
  11. Mes = '2019-03-30'
  12.  
  13.  
  14. for User in Usuarios:
  15. ConsuVoz = 0
  16. ConsuDatos = 0
  17. if(User.nameusuario == Usuario):
  18. Tel = session.execute("SELECT telefono FROM telefonos WHERE username=%s",[Usuario])
  19. ConVoz = session.execute("SELECT consumovoz FROM Voz WHERE telefono=%s AND fecha <%s",[Tel],[Mes])
  20. ConDatos = session.execute("SELECT consumodatos FROM Datos WHERE telefono=%s AND fecha <%s",[Tel],[Mes])
  21. ConsuVoz+= ConVoz
  22. ConsuDatos += ConDatos
  23.  
  24. print ("Usuario: ",Usuario,"\nMes: ",Mes, "\nConsumo en Voz: ",ConsuVoz,"\nConsumo en Datos: ",ConsuDatos)
  25.  
  26. ExtractInfo()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement