Skip to content

Commit f384039

Browse files
DIYgodDIYgod
committed
Complete 0002
1 parent e7cefa8 commit f384039

File tree

2 files changed

+234
-0
lines changed

2 files changed

+234
-0
lines changed

‎DIYgod/0002/Activation_code.txt

Lines changed: 200 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,200 @@
1+
xsdPh4f
2+
8qoW07j
3+
Tnj1HmB
4+
zIT8qAB
5+
FnDnNi0
6+
3QpZj1O
7+
KlkwRfE
8+
wsdy8NQ
9+
pvXSdlY
10+
pp9LWSn
11+
dS6zQnC
12+
WbCHjJH
13+
jAjJtli
14+
38ykU8k
15+
wMNCQ1m
16+
X245rLW
17+
UWizZgo
18+
YkLduIF
19+
v1GJSdz
20+
BNMZuX5
21+
yIjRDQu
22+
GNvXIIF
23+
DbWEtTD
24+
F1W2jtg
25+
54bWrUb
26+
b2IEbzZ
27+
xcaOsuG
28+
uXOhegJ
29+
TvKkKSN
30+
KgSCoEJ
31+
elrc80r
32+
DOXohsE
33+
KjdnEGw
34+
ffqwUwX
35+
xdRhBkT
36+
ruceTaI
37+
RZZTs0h
38+
K5EKaNj
39+
VqW5vfD
40+
ownScnm
41+
7rGnRPw
42+
TiaUfFy
43+
7YSMWr0
44+
C9YkCdo
45+
6ikBwSy
46+
qiETLg6
47+
aKDPWxE
48+
b3cCXhY
49+
MKA2OKu
50+
9EdcKmD
51+
0qeKaui
52+
ejpFFlC
53+
SmC9Nor
54+
mCPyWEv
55+
kStIHKd
56+
9DkalxT
57+
jWColwT
58+
GcTkSXk
59+
V5UrDSg
60+
ekrLbCf
61+
cQXARzF
62+
UP7ksMd
63+
MGVEVVH
64+
tKlLsKA
65+
bz978B2
66+
3d6BchN
67+
FQaaOIJ
68+
CVOzpVy
69+
5S41CmW
70+
BrEcQpZ
71+
RgpvtTu
72+
eNIFEtp
73+
IYA1GXy
74+
aVofZsk
75+
RtR05Dr
76+
RtKSB4v
77+
ylWhH4I
78+
E1rTSQQ
79+
km1GyrM
80+
1YhC46I
81+
Yth5Mop
82+
h1rq8Zt
83+
1N33N7j
84+
k5BXCmg
85+
E1wPDwt
86+
uvWFfTk
87+
QaExb9R
88+
xmbbV3I
89+
Jiqxv4q
90+
t86xdCq
91+
hjnITkf
92+
X7QfU9R
93+
BNrvD6R
94+
TrD8RKS
95+
j4Hb5m0
96+
Ej01pN1
97+
DjBieTP
98+
TF1Yhw3
99+
P8Hvl0h
100+
iuQIBSZ
101+
7hYH1nu
102+
Keddid3
103+
UMhZAlX
104+
yEBxCNV
105+
h9eUhig
106+
Uf2FGRg
107+
D6mGp0Y
108+
slkzCJF
109+
d2MtwFg
110+
H4P7dA5
111+
dh3uvgk
112+
hV67DzW
113+
kS6veXF
114+
QWs0IBe
115+
mUTAsKo
116+
bA3ZmDA
117+
bdzo5aa
118+
ssP0Ioy
119+
bSzxPwX
120+
Yvx2TwW
121+
B8RHjhI
122+
f1k9PHy
123+
JT6UjuI
124+
UrUzUMT
125+
gatlmvG
126+
Z0IcjOW
127+
WSeJD71
128+
xn2TEqq
129+
l6XMop0
130+
cebTTJx
131+
JAFSQP7
132+
hP86mW8
133+
uTbUfPI
134+
uInfJSv
135+
PkWbVsD
136+
Soc04tS
137+
Trv2Tli
138+
p9OQOR6
139+
2E63ef8
140+
mOIm6vn
141+
pvY48CT
142+
18u0DeJ
143+
G65JpBW
144+
fXAyrcL
145+
nujVYv3
146+
Zmcu79i
147+
NPtWjMc
148+
Xhsc44i
149+
cpVKhfM
150+
QiwFFGB
151+
YbBpW33
152+
ShzJeoe
153+
rRVzaA2
154+
9P9TjOA
155+
9DCcFW6
156+
eV9kso8
157+
ylNtW8l
158+
cg4NDrW
159+
z9jG8LY
160+
p8DRxic
161+
v60BL2p
162+
7gXCYhl
163+
bRFKTnV
164+
9hAeREO
165+
UF8Ushb
166+
zHnAsxJ
167+
qIEgxWg
168+
B2gMwr8
169+
fyTx67J
170+
14iRytg
171+
hLludCg
172+
jMVkbU1
173+
lFQQ1YX
174+
stOGahb
175+
cgB8aJC
176+
eVyrvc7
177+
eftb4Ge
178+
MFyiWOO
179+
hAf6Hha
180+
b884B8F
181+
qXaVpDs
182+
z1PYqm3
183+
YXZz3YI
184+
LZgQpdZ
185+
HpYkmdw
186+
uhR1wth
187+
mwfz0kk
188+
9AlVldl
189+
pQ8xzhi
190+
5tPou1g
191+
ahNqlgN
192+
euCV2IH
193+
tg9b7s8
194+
Z4r2aA6
195+
JYUijB2
196+
k6tMe54
197+
LJuhb7x
198+
Z6VPjwe
199+
U3qgd0G
200+
a9RH5fF

‎DIYgod/0002/store_mysql.py

Lines changed: 34 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,34 @@
1+
# -*- coding: utf-8 -*-
2+
3+
import mysql.connector
4+
5+
def store_mysql(filepath):
6+
conn = mysql.connector.connect(user = 'root', password = '1207', database = 'ShowMeTheCode')
7+
cursor = conn.cursor()
8+
9+
# 判断表是否已经存在
10+
cursor.execute('show tables in ShowMeTheCode;')
11+
tables = cursor.fetchall()
12+
findtables = False
13+
for table in tables:
14+
if 'code' in table:
15+
findtables = True
16+
if not findtables:
17+
cursor.execute('''
18+
CREATE TABLE `ShowMeTheCode`.`code` (
19+
`id` INT NOT NULL AUTO_INCREMENT,
20+
`code` VARCHAR(10) NOT NULL,
21+
PRIMARY KEY (`id`));
22+
''')
23+
24+
f = open(filepath, 'rb')
25+
for line in f.readlines():
26+
code = line.strip()
27+
cursor.execute("insert into ShowMeTheCode.code (code) values(%s);", [code])
28+
29+
conn.commit()
30+
cursor.close()
31+
conn.close()
32+
33+
if __name__ == '__main__':
34+
store_mysql('Activation_code.txt')

0 commit comments

Comments
 (0)