def send_message(destination):
email = credentials.username()
pssword = credentials.password()
server = sign_in(email, pssword)
num_messages = 10
for i in range(num_messages):
# time.sleep(0.5) # Uncomment to ensure chronological order
server.sendmail(email, destination, "Hello " + str(i))
def sendEmail(to, content):
import credentials
server = smtplib.SMTP('smtp.gmail.com', 587)
server.ehlo()
server.starttls()
# Enable low security in gmail
server.login(credentials.email(), credentials.password())
server.sendmail(credentials.email(), to, content)
server.close()
# XXX: The Database URI should be in the format of:
#
# postgresql://USER:PASSWORD@<IP_OF_POSTGRE_SQL_SERVER>/<DB_NAME>
#
# For example, if you had username ewu2493, password foobar, then the following line would be:
#
# DATABASEURI = "postgresql://*****:*****@<IP_OF_POSTGRE_SQL_SERVER>/postgres"
#
# For your convenience, we already set it to the class database
# Use the DB credentials you received by e-mail
# DB_USER = "******"
# DB_PASSWORD = "******"
DB_USER = credentials.username()
DB_PASSWORD = credentials.password()
# DB_SERVER = "w4111.cisxo09blonu.us-east-1.rds.amazonaws.com"
DB_SERVER = "mydbinstance.cmgiyjltohsu.us-east-1.rds.amazonaws.com"
# DATABASEURI = "postgresql://"+DB_USER+":"+DB_PASSWORD+"@"+DB_SERVER+"/w4111"
DATABASEURI = "postgresql://"+DB_USER+":"+DB_PASSWORD+"@"+DB_SERVER+"/FakeTasticdb"
#
# This line creates a database engine that knows how to connect to the URI above
#
engine = create_engine(DATABASEURI)
# Here we create a test table and insert some values in it
engine.execute("""DROP TABLE IF EXISTS test;""")
## Psycopg2 remote setup
try:
remoteDB = psycopg2.connect(database=rc.database(), host=rc.hostname(), port=rc.port(),
user=rc.username(), password=rc.password())
remoteCUR = remoteDB.cursor()
except:
print "Unable to connect to remote database"
print sys.exc_info()[1]
sys.exit()
## Psycopg2 local setup
try:
DB = psycopg2.connect(database=c.database(), host=c.hostname(), user=c.username(),
password=c.password())
CUR = DB.cursor()
except:
print "Unable to connect to local database"
print sys.exc_info()[1]
sys.exit()
## Desc - Gets the remote comments such that start <= x < end, where x is the comments.
## In - (chunkSize) integer of the number of comments to pull from remote database
## Out - list of comment objects
## Mod - Nothing
## ToDo - Return status code?
## - Add try except block for connection issues?
def getRemoteComments(chunkSize=25):
comments = []
rem_in_percents, wake_in_percents, phase_duration_average_in_hours,
phase_duration_average_in_percents, deviation_in_hours,
deviation_in_percents, all_count, deep_count, light_count,
rem_count, wake_count, deep_count_per_hour, light_count_per_hour,
rem_count_per_hour, wake_count_per_hour, one, two, three,
one_per_hour, two_per_hour, three_per_hour
]
if __name__ == '__main__':
locale.setlocale(locale.LC_ALL, 'czech')
try:
cnx = mysql.connector.connect(user=cr.user(),
database=cr.database(),
host=cr.host(),
password=cr.password())
cursor = cnx.cursor()
parsing = Parsing()
chart_class = Chart()
csv_save = CSVSave()
database = DatabaseWorks()
data_processing = DataProcessing()
print(
"\n##################################################################################\n"
)
database.print_last_sync_info(cursor, parsing)
print(
"\n##################################################################################\n"
)
database.print_fitbit_sync_info(cursor, parsing)
'''
import imaplib
import credentials
import re
import numpy as np
import pandas as pd
import os
import glob
## ---- preamble [some info to edit] ---- ##
imap_ssl_host = 'imap.gmail.com'
imap_ssl_port = 993
username = credentials.username()
password = credentials.password()
mission_id = 'M333'
paths = [
'/home/cyrf0006/data/gliders_data/SEA003/M333/Nav',
'/home/cyrf0006/data/gliders_data/SEA003/M333/science'
]
## ---- PART 1 - get time from gmail ---- ##
print('PART 1 - get time from gmail')
# initialize fields to fill
lat_dec = []
lat_min = []
lon_dec = []
lon_min = []
time_str = []
cycle_no = []
## Globals
WAIT_INTERVAL = 1
MAX_WAIT_TIME = 60
WAIT_TIME = 30
MIN_WAIT_TIME = 2 ## Minimum time between requests (according to reddit API)
ROWS = 0
## Praw setup
USER_AGENT = ("F1Bot 0.1")
REDDIT = praw.Reddit(USER_AGENT)
SUBREDDIT = REDDIT.get_subreddit("formula1")
## Psycopg2 setup
try:
DB = psycopg2.connect(database=c.database(), host=c.hostname(),
user=c.username(), password=c.password())
CUR = DB.cursor()
except:
print "Unable to connect to database"
print sys.exc_info()[1]
sys.exit()
## Desc - Counts the number of rows in the database
## In - Nothing (cursor defined globally)
## Out - long int rows
## Mod - Nothing
## ToDo - Nothing
def countRows():
CUR.execute("SELECT COUNT(*) FROM f1_bot;")
return CUR.fetchone()[0]
def main():
""" Пример получения последнего сообщения со стены """
login, password = credentials.login(), credentials.password()
vk_session = vk_api.VkApi(login, password)
try:
vk_session.auth(token_only=True)
except vk_api.AuthError as error_msg:
print(error_msg)
return
vk = vk_session.get_api()
""" VkApi.method позволяет выполнять запросы к API. В этом примере
используется метод wall.get (https://vk.com/dev/wall.get) с параметром
count = 1, т.е. мы получаем один последний пост со стены текущего
пользователя.
"""
items = set()
with open(f'events_{location_name}.txt', 'r') as fp:
num_lines = sum(1 for ln in fp)
events_count = 0
fp.seek(0)
for event in fp:
events_count += 1
print(f'{events_count}/{num_lines}')
print(f'Event {event}')
offset = 0
while True:
try:
q = vk.groups.getMembers(group_id=event, offset=offset)
items.update(q['items'])
if len(q['items']) < 1000:
break
offset += 1000
except vk_api.exceptions.ApiError as e:
print(e)
break
except:
break
offset = 0
while True:
try:
q = vk.groups.getMembers(group_id=event,
offset=offset,
filter='unsure')
items.update(q['items'])
if len(q['items']) < 1000:
break
offset += 1000
except vk_api.exceptions.ApiError as e:
print(e)
break
except:
break
print(len(items))
pass
with open(f'events_members_{location_name}.txt', 'w') as f:
for item in items:
f.write("%s\n" % item)