sAwybX5J

1import sqlite3 as sql
2import vk_api
3from vk_api.utils import get_random_id
4from vk_api.bot_longpoll import *
5from random import randint
6
7VKA = vk_api.VkApi(token='8916d58678d4079c0b5f8ee8fc444a566732d45ff6afa39c81a036382a9cc6b0ecc58cb913d83e9f33cc3')
8longpoll = VkBotLongPoll(VKA, 190602169)
9api = VKA.get_api()
10sql = sql.connect('db.db')
11cur = sql.cursor()
12try: 
13	sql.execute(""" 
14		CREATE TABLE texts(
15		id INT primary key,
16		phrase text,
17		author int
18		)
19		""")
20except:
21   pass
22
23
24def main():
25	for event in longpoll.listen():
26
27		if event.type == VkBotEventType.MESSAGE_NEW:
28			r=cur.lastrowid or 0
29			print(event.obj.text, event.obj.peer_id)
30			sql.execute("INSERT INTO texts(phrase) VALUES (?)", (event.obj.text,))
31			sql.commit()
32			sql.execute("SELECT * from texts")
33			print(cur.fetchall())
34			if randint(0, r) > 50 :
35				sql.execute('SELECT phrase FROM texts')
36				all = cur.fetchall()
37				result=[]
38				for i in all:
39					for z in event.obj.text.split():
40						if z in i:
41							result.append(i)
42							break
43				result1=''
44				for i in result:
45					for z in i:
46						if randint(0,99) > 50:
47							result1+=z+', '
48				api.messages.send(
49					peer_id=event.obj.peer_id,
50					chat_id=event.chat_id,
51					random_id=get_random_id,
52					message=result1
53					)
54
55
56if __name__ == '__main__':
57	main()
58	try:
59		main()
60	except:
61		sql.close()