forked from Hatcat123/XianyuSdd
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdb.py
138 lines (96 loc) · 3.74 KB
/
db.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
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
__author__ = 'AJay'
__mtime__ = '2019/4/25 0025'
"""
from pymongo import MongoClient, ASCENDING
# mongod.exe --logpath D:\mongodb\xianyudb\mongodb.log --logappend --dbpath D:\mongodb\xianyudb --directoryperdb --serviceName mongodbxy --install
ip = '127.0.0.1'
port = 27017
class MongoTime():
def __init__(self, ip=ip, port=port):
conn = MongoClient(ip, port)
self.db = conn.xianyu
self.collection = self.db.time
self.collection.create_index([('nid', ASCENDING)])
def insert(self, item_dict):
self.collection.insert_one(item_dict)
def select_one(self, dict):
return self.collection.find_one(dict)
def delete(self, query_dict):
self.collection.delete_one(query_dict)
def delete_all(self, dict):
self.collection.delete_many(dict)
def update_time(self, key):
self.collection.update({'flag': 1}, {'$set': {"time": key}})
def update_type(self, key):
self.collection.update({'flag': 1}, {'$set': {"type": key}})
def count(self):
self.collection.count_documents({})
class MongoKeyword():
def __init__(self, ip=ip, port=port):
conn = MongoClient(ip, port)
self.db = conn.xianyu
self.collection = self.db.keyword1
self.collection.create_index([('nid', ASCENDING)])
def insert(self, item_dict):
self.collection.insert_one(item_dict)
def select_all(self, dict):
return self.collection.find(dict)
def select_one(self, dict):
return self.collection.find_one(dict)
def delete(self, query_dict):
self.collection.delete_one(query_dict)
def delete_all(self, dict):
self.collection.delete_many(dict)
def update_start(self, key):
self.collection.update({'keyword': key}, {'$set': {"start": 1}})
def update_stop(self, key):
self.collection.update({'keyword': key}, {'$set': {"start": 0}})
def update(self, dic):
self.collection.update(dic)
def count(self):
self.collection.count_documents({})
class MongoProduct():
def __init__(self, ip=ip, port=port):
conn = MongoClient(ip, port)
self.db = conn.xianyu
self.collection = self.db.product
self.collection.create_index([('nid', ASCENDING)])
def insert(self, item_dict):
self.collection.insert_one(item_dict)
def select(self, dict):
return self.collection.find_one(dict)
def delete(self, query_dict):
self.collection.delete_one(query_dict)
def delete_all(self, dict):
self.collection.delete_many(dict)
def update_start(self, key):
self.collection.update({'keyword': key}, {'$set': {"start": 1}})
def update_stop(self, key):
self.collection.update({'keyword': key}, {'$set': {"start": 0}})
def count(self):
self.collection.count_documents({})
class MongoConfig():
def __init__(self, ip=ip, port=port):
conn = MongoClient(ip, port)
self.db = conn.xianyu
self.collection = self.db.config
self.collection.create_index([('nid', ASCENDING)])
def insert(self, item_dict):
self.collection.insert_one(item_dict)
def select_one(self, dic):
return self.collection.find_one(dic)
def select_all(self):
return self.collection.find()
def delete(self, query_dict):
self.collection.delete_one(query_dict)
def delete_all(self, dict):
self.collection.delete_many(dict)
def update_start(self, key):
self.collection.update({'keyword': key}, {'$set': {"start": 1}})
def update_stop(self, key):
self.collection.update({'keyword': key}, {'$set': {"start": 0}})
def count(self):
return self.collection.count_documents({})