Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from cassandra.cluster import Cluster
- cluster = Cluster()
- session = cluster.connect()
- session.execute('USE proyecto1')
- def ExtractInfo():
- Usuarios = session.execute('SELECT * FROM usuario')
- exist = 0
- Usuario = 'totoaspri11a'
- Mes = '2019-03-30'
- for User in Usuarios:
- ConsuVoz = 0
- ConsuDatos = 0
- if(User.nameusuario == Usuario):
- Tel = session.execute("SELECT telefono FROM telefonos WHERE username=%s",[Usuario])
- ConVoz = session.execute("SELECT consumovoz FROM Voz WHERE telefono=%s AND fecha <%s",[Tel],[Mes])
- ConDatos = session.execute("SELECT consumodatos FROM Datos WHERE telefono=%s AND fecha <%s",[Tel],[Mes])
- ConsuVoz+= ConVoz
- ConsuDatos += ConDatos
- print ("Usuario: ",Usuario,"\nMes: ",Mes, "\nConsumo en Voz: ",ConsuVoz,"\nConsumo en Datos: ",ConsuDatos)
- ExtractInfo()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement