-
Notifications
You must be signed in to change notification settings - Fork 9
/
db_actions.py
196 lines (170 loc) · 6.37 KB
/
db_actions.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
#encoding:utf-8
from datetime import datetime
from pprint import pprint
from pymongo import MongoClient
class PockebotDBSlave(object):
'''
docstring for PockebotDBSlave
'''
def __init__(self, config):
super(PockebotDBSlave, self).__init__()
self.chat_id = -1
if config['mongo']['use_auth']:
uri = 'mongodb://{user}:{password}@{host}:{port}/{db}'.format(
**config['mongo']
)
else:
uri = 'mongodb://{host}:{port}/{db}'.format(
**config['mongo']
)
self.client = MongoClient(uri)
self.db = self.client[config['mongo']['db']]
def get_pocket_key_v1(self):
config = self.db['config']
return config.find_one()['APP_KEY']
def get_pocket_key_v2(self):
config = self.db['config']
return config.find_one()['APP_KEY_v2']
def get_bot_token(self):
config = self.db['config']
return config.find_one()['BOT_TOKEN']
def get_access_key_v1(self):
access_keys = self.db['access_keys']
result = access_keys.find_one({'chat_id': self.chat_id})
if result is None:
return None
return result.get('access_token', None)
def get_access_key_v2(self):
access_keys = self.db['access_keys_v2']
result = access_keys.find_one({'chat_id': self.chat_id})
if result is None:
return None
return result.get('access_token', None)
def get_access_key(self):
is_old_user = False
if self.get_access_key_v1() is not None:
is_old_user = True
key_v2 = self.get_access_key_v2()
return key_v2, is_old_user
def save_unrecognized_messages(self, messages):
if len(messages) > 0:
doc = {
'chat_id': self.chat_id,
'ts': datetime.utcnow(),
'messages': messages
}
self._save_something('messages', doc)
def save_authorization_log(self, **kwargs):
info = {
'chat_id': self.chat_id,
'ts': datetime.utcnow()
}
info.update(kwargs)
self._save_something('request_keys_v2', info)
def get_request_key(self):
request_keys = self.db['request_keys_v2']
res = request_keys.find({'chat_id': self.chat_id})
request_tokens = {}
request_token = None
for item in res:
if 'request_token' in item:
request_tokens[item['ts']] = item['request_token']
if len(request_tokens) > 0:
# print(sorted(request_tokens.items(), reverse=True))
request_token = sorted(request_tokens.items(), reverse=True)[0]
return request_token
def _save_something(self, collection, data):
coll = self.db[collection]
coll.insert_one(data)
def save_access_token(self, token):
doc = {
'chat_id': self.chat_id,
'access_token': token,
'ts': datetime.utcnow()
}
self._save_something('access_keys_v2', doc)
def move_access_tocken(self, tocken):
access_keys = self.db['access_keys_v2']
data = access_keys.find_one({'chat_id': self.chat_id})
self._save_something('old_access_keys', data)
access_keys.delete_one({'chat_id': self.chat_id})
def save_url_response(self, **kwargs):
info = {
'chat_id': self.chat_id,
'ts': datetime.utcnow()
}
# response_to_save = dict()
# for i in kwargs.values():
# response_to_save[kwargs[]]
info.update(kwargs)
# pprint(info)
self._save_something('urls', info)
def save_feedback(self, **kwargs):
info = {
'chat_id': self.chat_id,
'ts': datetime.utcnow()
}
info.update(kwargs)
self._save_something('feedback', info)
def save_credentials(self, msg):
people_storage = self.db['people']
if people_storage.find_one({'id': msg['from']['id']}) is None:
people_storage.insert_one(msg['from'])
chats_storage = self.db['chats']
if chats_storage.find_one({'id': msg['chat']['id']}) is None:
chats_storage.insert_one(msg['chat'])
def update_tags_stat(self, tags):
tags_storage = self.db['tags']
res = tags_storage.find_one({'chat_id': self.chat_id})
stat = {}
if res is not None:
stat = res['stat']
for tag in tags:
stat[tag] = stat.get(tag, 0) + 1
if res is None:
tags_storage.insert_one({'chat_id': self.chat_id,
'stat': stat})
else:
tags_storage.update_one({'chat_id': self.chat_id},
{'$set': {'stat': stat}})
def get_last_items(self):
url_storage = self.db['urls']
urls = url_storage.find_one({'chat_id': self.chat_id}, sort=[('ts', -1)])
if urls is not None:
items = urls.get('saved_items', {}).keys()
return items
else:
return None
def get_last_entry(self):
url_storage = self.db['urls']
urls = url_storage.find_one({'chat_id': self.chat_id}, sort=[('ts', -1)])
if urls is not None:
items = urls.get('saved_items', {})
return items
else:
return None
def get_ordered_tags(self):
tags_storage = self.db['tags']
res = tags_storage.find_one({'chat_id': self.chat_id})
if res is None:
return None
tags = res['stat']
ordered_tags = sorted(tags.items(), key=lambda x: x[1], reverse=True)
# print(ordered_tags)
return [tag[0] for tag in ordered_tags]
def get_state(self):
state_storage = self.db['state']
res = state_storage.find_one({'chat_id': self.chat_id})
if res is None:
return dict()
return res.get('state', dict())
def save_state(self, state):
state['stat']['ts'] = datetime.utcnow()
state_storage = self.db['state']
res = state_storage.find_one({'chat_id': self.chat_id})
if res is None:
state_storage.insert_one({'chat_id': self.chat_id,
'state': state})
else:
state_storage.update_one({'chat_id': self.chat_id},
{'$set': {'state': state}})