from ipaddress import IPv4Address  # for your IP address
from pyairmore.request import AirmoreSession  # to create an AirmoreSession
from pyairmore.services.messaging import MessagingService  # to send messages
#import psycopg2

# Medium article https://medium.com/@erayerdin/send-sms-with-python-eab7a5854d3a

ip = IPv4Address("10.50.0.146")  # let's create an IP address object
# now create a session
session = AirmoreSession(ip)
# if your port is not 2333
# session = AirmoreSession(ip, 2334)  # assuming it is 2334

print(session.is_server_running)  # True if Airmore is running

was_accepted = session.request_authorization()
print(was_accepted)  # True if accepted
#session.close()

service = MessagingService(session)

service.send_message('+584120290136', 'prueba msj33  telefono 2')
service.send_message('+584123791856', 'prueba msj33  telefono 2')
service.send_message('+584129131987', 'prueba msj33  telefono 2')

'''
service = MessagingService(session)
connection = psycopg2.connect(database='survey',host='192.168.1.109',user='django',password='Berlin2024',port='5432')
cursor = connection.cursor()
cursor.execute("SELECT * FROM send")
everything = cursor.fetchall()


for i in range(len(everything)):
    print(everything[i][1], everything[i][2] + everything[i][3])
    service.send_message(everything[i][1], everything[i][2] + everything[i][3])
    
'''