forked from zhaozhengcoder/Algorithm
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest_mysql.cpp
More file actions
211 lines (167 loc) · 4.76 KB
/
Copy pathtest_mysql.cpp
File metadata and controls
211 lines (167 loc) · 4.76 KB
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
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
#include <iostream>
#include <string>
#include <vector>
#include <random>
#include <set>
#include <functional>
#include <time.h>
#include <Windows.h>
using namespace std;
string GetRandomString(const int len) {
string str2(len+1,'\0');
int i;
for (i = 0; i<len; ++i)
str2[i] = 'A' + rand() % 26;
str2[++i] = '\0';
return str2;
}
class Weibo {
public:
int id;
int uid;
string text;
int status;
Weibo() {
id = -1;
uid = -1;
text = "";
status = -1;
}
static Weibo create(int _uid,string _text,int _status=0) {
static int Self_growth_id = 0;
Weibo w;
w.id = Self_growth_id++;
w.uid = _uid;
w.text = _text;
w.status = _status;
return w;
}
};
class Index_uid {
public:
int HashID;
int uid;
set<Weibo *> set_pw;
Index_uid() { HashID = -1; uid = -1; }
};
Index_uid empty_uid;
class Mysql_Weibo{
private:
vector<Weibo> vw;
vector<Index_uid> index_uid;
bool index_uid_enable;
hash<int> hash_int;
int Maxuser;
public:
Mysql_Weibo():vw(15000),index_uid(2000, empty_uid) {
index_uid_enable = false;
Maxuser = 2000;
}
//发布weibo
void PostWeibo(int _uid,string _text) {
Weibo w=Weibo::create(_uid, _text);
vw.push_back(w);
}
//获得某个用户最近发布的十条weibo
vector<Weibo> getTimeline(int user_id) {
// Write your code here
vector<Weibo> tl;
int number = 10;
for (auto it = vw.rbegin(); it != vw.rend() && number >= 0; it++) {
if (it->uid == user_id) {
number--;
tl.push_back(*it);
}
}
return tl;
}
//给uid上创建hash索引
void CreateHashIndex_InUid(){
index_uid.reserve(Maxuser);
for (auto it = vw.begin(); it != vw.end(); it++) {
int temp_uid = it->uid;
int hash_uid=hash_int(temp_uid) %Maxuser;
index_uid[hash_uid].uid = temp_uid;
index_uid[hash_uid].HashID = hash_uid;
index_uid[hash_uid].set_pw.insert(&(*it));
}
this->index_uid_enable = true;
}
//使用索引来查询uid的weibo
vector<Weibo*> UseIndexQuery_inUid(int user_id) {
vector<Weibo *> query_res;
int hashid = hash_int(user_id)%Maxuser;
auto it_begin = this->index_uid[hashid].set_pw.begin();
auto it_end = this->index_uid[hashid].set_pw.end();
for (auto it = this->index_uid[hashid].set_pw.begin(); it != this->index_uid[hashid].set_pw.end(); it++) {
if ((*it)->uid == user_id) {
query_res.push_back((*it));
}
}
return query_res;
}
};
void Print_Weibo(vector<Weibo> w) {
cout << " >>> " << endl;
for (auto it = w.begin(); it != w.end(); it++) {
cout << "id : " << it-> id << " userid : " << it->uid << " text : " << it->text << " status : " << it->status << endl;
}
}
void Print_Weibo(vector<Weibo*> w) {
cout << " >>> " << endl;
for (auto it = w.begin(); it != w.end(); it++) {
cout << "id : " << (*it)->id << " userid : " << (*it)->uid << " text : " << (*it)->text << " status : " << (*it)->status << endl;
}
}
void GetLocalTime() {
SYSTEMTIME sys;
GetLocalTime(&sys);
cout << "Hour : " << sys.wHour << " , Minute : " << sys.wMinute << " ,second :" << sys.wSecond << " , millseconds :" << sys.wMilliseconds << endl;
}
int main() {
Mysql_Weibo mysql_weibo;
random_device rd;
uniform_int_distribution<int> dist1(0, 500);
uniform_int_distribution<int> dist2(1, 20);
//假设有1w条weibo 和 500位用户
for (int i = 0; i < 10000; i++) {
int uid = dist1(rd);
int str_len = dist2(rd);
string text = GetRandomString(str_len);
cout << text << endl;
mysql_weibo.PostWeibo(uid,text);
}
int query_uid1 = 100;
int query_uid2 = 120;
int query_uid3 = 150;
int query_uid4 = 200;
int query_uid5 = 250;
vector<Weibo> ret_wb1=mysql_weibo.getTimeline(query_uid1);
vector<Weibo> ret_wb2 = mysql_weibo.getTimeline(query_uid2);
vector<Weibo> ret_wb3 = mysql_weibo.getTimeline(query_uid3);
vector<Weibo> ret_wb4 = mysql_weibo.getTimeline(query_uid4);
vector<Weibo> ret_wb5= mysql_weibo.getTimeline(query_uid5);
Print_Weibo(ret_wb1);
//Print_Weibo(ret_wb2);
//Print_Weibo(ret_wb3);
//Print_Weibo(ret_wb4);
//Print_Weibo(ret_wb5);
mysql_weibo.CreateHashIndex_InUid();
//mysql_weibo.UseIndexQuery_inUid(query_uid1);
//mysql_weibo.UseIndexQuery_inUid(query_uid2);
//mysql_weibo.UseIndexQuery_inUid(query_uid3);
//mysql_weibo.UseIndexQuery_inUid(query_uid4);
//mysql_weibo.UseIndexQuery_inUid(query_uid5);
vector<Weibo*> ret_index_wb1=mysql_weibo.UseIndexQuery_inUid(query_uid1);
vector<Weibo*> ret_index_wb2=mysql_weibo.UseIndexQuery_inUid(query_uid2);
vector<Weibo*> ret_index_wb3=mysql_weibo.UseIndexQuery_inUid(query_uid3);
vector<Weibo*> ret_index_wb4 = mysql_weibo.UseIndexQuery_inUid(query_uid4);
vector<Weibo*> ret_index_wb5 = mysql_weibo.UseIndexQuery_inUid(query_uid5);
Print_Weibo(ret_index_wb1);
//Print_Weibo(ret_index_wb2);
//Print_Weibo(ret_index_wb3);
//Print_Weibo(ret_index_wb4);
//Print_Weibo(ret_index_wb5);
system("pause");
return 0;
}