def take_data_from_db(chat_id, message):
row = ['', '', '', '', '', '', '']
conn = MySQLdb.connect(host='sql139.main-hosting.eu',
port=3306,
user='******',
passwd='rootroot1',
db='u356390377_vibor')
cursor = conn.cursor()
conn.set_character_set('utf8')
cursor.execute('SET NAMES utf8;')
cursor.execute('SET CHARACTER SET utf8;')
cursor.execute('SET character_set_connection=utf8;')
main.login = False
login = message
if (login[:-10] == '+7'):
login = '******' + login[2:]
print(login)
cursor.execute(
'SELECT * FROM u356390377_vibor.usersdb WHERE Number = \'{}\''.format(
login))
row = cursor.fetchone()
if row == None:
print("In except")
main.send_message(chat_id, "Неправильный логин!")
main.open_sing_in_payers(chat_id)
else:
print(row)
list_of_pays = [('50-50', row[3]), ('Aktay', row[3]),
('Atyray', row[3]), ('Semya', row[3])]
for i in list_of_pays:
cursor.execute("SELECT * FROM `{}` WHERE Name = '{}';".format(
i[0], i[1]))
data = cursor.fetchone()
if data is None:
continue
print(data)
cursor.execute("SELECT COUNT(Name) FROM {}".format(i[0]))
count = cursor.fetchall()
count_of_payers = str(count[0][0])
send = "Здравствуйте, {}! Сейчас пайщиков в кооперативе: {}. ".format(
data[0], count_of_payers)
#print(data)
if data[3] == -1:
send += "Вы получили недвижимость на сумму {} тенге. " \
"Ваш ежемесячный паевый взнос состовляет {} тенге. "\
.format(data[1], data[2])
else:
send += "Ваша запрашиваемая сумма недвижимости состовляет {} тенге. " \
"Ваш паевый взнос состовляет {} тенге." \
"Ваше место в очереди: {}".format(data[1], data[2], data[3])
main.send_message(chat_id, send)
break
conn.close()
def post(self):
import key
import person
from main import send_message
body = jsonUtil.json_loads_byteified(self.request.body)
logging.debug("body: {}".format(body))
people_count = body['present']
setPiCounterValue(people_count)
#katja = person.getPersonById(key.KATJA_T_ID)
#send_message(katja, "People count: {} ".format(people_count))
people_in_stats = Person.query(Person.state == 5).fetch()
for p in people_in_stats:
send_message(p, "Posti occupati: {} ".format(people_count))
sleep(0.1)
remember_device = True
return key, remember_device
vk_session = vk_api.VkApi(login, password, auth_handler=auth_handler)
try:
vk_session.auth()
except vk_api.AuthError as error_msg:
print(error_msg)'''
================================================="РЕгистрация для группы"==========================================
vk_session = vk_api.VkApi(token=token)
session_api = vk_session.get_api()
longpool = VkLongPoll(vk_session)
while True:
for event in longpool.listen():
if event.type == VkEventType.MESSAGE_NEW:
print(f'Message time is {datetime.strftime(datetime.now(), "%H:%M:%S")}')
print(f'Message text : {event.text}')
response = event.text.lower()
if event.from_user and not event.from_me:
response_for_user = main.send_message(event.text)
vk_session.method('messages.send', {
'user_id': event.user_id,
'message': response_for_user,
'random_id': random.randint(0, 2000000)
})
from main import send_message
import time
if __name__ == '__main__':
print("Clock server is running")
parser = argparse.ArgumentParser(description="Create a new Clock")
parser.add_argument('--port', type=int, help='Port of the node')
parser.add_argument('--start', type=str, help='The time on port')
args = parser.parse_args()
port = args.port
start = args.start
with socket.socket(socket.AF_INET, socket.SOCK_STREAM) as _socket:
_socket.bind(("127.0.0.1", 9997))
_socket.listen()
print(f'Clock server is running on PORT 9999')
while True:
time.sleep(60)
hour = int(start.split(":")[0])
minute = int(start.split(":")[1])
minute += 1
if minute > 60:
minute == 0
hour += 1
if hour > 24:
hour = 0
minute = 0
start = f"{str(hour).zfill(2)}:{str(minute).zfill(2)}"
send_message("Clock-" + start, port)
print(start)
def playall():
send_message(playall='playall')
return redirect(url_for('index'))
def play(filename):
print("route play filename :", filename)
fname = filename
send_message(play_file=fname)
return redirect(url_for('index'))
from time import sleep
from datetime import datetime as dt
from main import Post, send_message
while True:
for post in Post.query.filter_by(date=dt.now()).all():
send_message(post)
sleep(60)