File tree Expand file tree Collapse file tree
Expand file tree Collapse file tree File renamed without changes.
File renamed without changes.
File renamed without changes.
Original file line number Diff line number Diff line change 1+ RXUadiI0zOKmg5Ww
2+ z4qo5vaXKGM8uFsB
3+ TU3PdPnSAKtUcXwl
4+ dy2nuUEjRczyXC0a
5+ Xn8MFsTBRCbcG45E
6+ 7DmryUic3pOs1DFu
7+ REINIyXEsovPrJ2G
8+ OKTYjXVpTljHanCO
9+ SzsuRGUmL6sEXBA1
10+ FrKGmMjKQGt0ImDV
11+ BLYXVaqENcuJXfUh
12+ ydsilfQorQtLKJs4
13+ abX1AUFy61k0gPZh
14+ xjEyzBwwu9AXrAaU
15+ wuJXMMscjhUpjOu1
16+ fbVRxeWbpilOQEQ2
17+ gKnLlSMvzFup2ubi
18+ mcU54YoHxGZ3gbRy
19+ izdNk0U2nlAqN5HT
20+ zGx1bP240lai9qMG
21+ 3Nqa5IB5dzuPWfBA
22+ jAtgS3XXojFlWI5j
23+ L8rb8ODGhGO03D7x
24+ 1SZ5ouRlwulVMcVd
25+ jGr71Sx2eU1BTzvq
26+ sB24ocOCXxuUwvJg
27+ RHesYESjimTftYZA
28+ gJvEvwB7nlRnsmcQ
29+ hVa1H4Ig9VfzBmRz
30+ bEGSjiMZMWpeRyhy
31+ 3mFUtX6T3q6qJmN1
32+ jfKbj7WEu7LuBjw8
33+ 07qBOuEyTvsoeC7o
34+ JCAGJusp8qdr7NzD
35+ 5vrE1vhHIJ4rqLcU
36+ PquV3EUuOWDTy4pX
37+ ZEEcNm4o7JXQuRZn
38+ xDGpAt5uUHbi3HLN
39+ 7KtkUMfREmSdTebQ
40+ 4CTfOxmFFT7VX6Ha
41+ hWFdJW034cEKX8nT
42+ vgaQuZgmOWeBdBHr
43+ iZsJpE4eSh7ZqgYq
44+ bX3Wf9ya2AYB0Ek5
45+ 7dAQNjyHPJ3BKTmt
46+ yCCVEeAAXwmPjj7x
47+ zt4Y1ptPZmFMEQ7Y
48+ TNXXk5PE2dKJTKwY
49+ qClONH4dhtpblVxO
50+ BcOxR9eik1YcKAIt
51+ IxVcoCfhx5U1KhJL
52+ e6LgwfakF5sIo3Wn
53+ rBz6ifzKMmLjRqnr
54+ 7sG7zoOEjwiPVwMN
55+ 2SpgY4eExdqyFma9
56+ seIIcsNT0deljKcF
57+ jUY48NLHJWn5mjSm
58+ epNdFfnUy3K9tddV
59+ FLKdZilBUpYloqLH
60+ b4flf5wi6a4joQwA
61+ 1hJ2tGTJwlvgjebQ
62+ KW0W8x23QRAQMC3K
63+ tvOBXdSFbujyiLnl
64+ 9SygR3CYo4ReQ1x4
65+ rTcggxAwbuu7waNy
66+ ql4gqiS3kJuNexrl
67+ ZpmKF1VYeIbvrAwE
68+ NhW0mMDUX9j1QkOR
69+ VHKBmzABwLwH1c8Y
70+ 238sBuP3YIJJIUn6
71+ EyLVxAOASe5PWDsi
72+ BDxWOvKpe3FRHfXZ
73+ qkqz0lD4ogDgG6HB
74+ I8M1aVJCRc2452OG
75+ JWl7JmPKK9sq8v2r
76+ bdXCjhrHUSNXsNPJ
77+ sEcmFMdcvz57wBkr
78+ OYouRL6AD21NncGn
79+ aNRk1zxXhrr30fAm
80+ g40yzH8LHOOymofr
81+ oPw8MO6iNamJ1bYK
82+ QfnffjYdbE8BKCqF
83+ mbEKxuHBNHHloDy0
84+ oeVHq1yblfNbDlm2
85+ S5O9WOvWHMUU0ymx
86+ eiwlpN9GuRGmpbn0
87+ TMGHVairDKmSGbCk
88+ kiOC0MLXtctQxLe5
89+ rfoaB5W9YxwMzNki
90+ FWIoPqzYBkxWUA5n
91+ HoCqNcTtQEtjAUMP
92+ Gy6nVQJmgsgv9hGc
93+ PBTm3QAQ6jNFkvUZ
94+ j3yRTRrcFGUgDwow
95+ bPF8g0RHaN47Q4dN
96+ NzM9WIrXiDbi5IXD
97+ w54j8L5ngiakgayX
98+ hkd4g0UkVhmNnyR6
99+ iEz5VpcVi1mpS1gq
100+ KWkIIA97y42V5cnx
101+ 5LZGIXk2odGvSTE1
102+ s1NdaGmS5YB8VJEL
103+ 272uuYgOloY7hJ8t
104+ oc0hco4FYw75n4US
105+ DzmWY32kG7JaFG3R
106+ UIaLpcjN9yA12Uo5
107+ 8RYmqxQ8IxUU0aGz
108+ D5Td2B7lEEUDYsUw
109+ vJ0rZHnIlI6sHDo5
110+ MYLBHHfax5MvUf96
111+ CQisO7bfEUwpr2Qy
112+ dyLBeumYaTAGHFyM
113+ wvFS79uJMwWSUgHv
114+ KkwuShhSHkzKy6op
115+ O72zwUdEuetJnnQ6
116+ Qj7r8dbBf1fKV55k
117+ T7K47FF9KcrEYcI7
118+ N79n066wlGUsxanD
119+ XPrc3XrLHA23mmmb
120+ sANdjXf4gD5tJvWF
121+ ARJPiZz9HmQbtqOW
122+ 7WAr9oIw9sebBNWj
123+ UmKbDJ9Z3XDB0uxa
124+ XbqEHERAPrrM42ud
125+ iRMKgFM0gqr9G8Rt
126+ WfdEyO5sGxXKiYND
127+ 3hPPrf7M3UPk3Pis
128+ PiL0B8e9ZtKPRsuj
129+ YuQXWQTw24RlfOUw
130+ nG8kOk3G6VWM3XcX
131+ 0XblQUEM8uCl8ljl
132+ VY2AKbDNFTXT2Vpj
133+ BZkiI7LxBsSPp9wI
134+ WuCVLSQqpj2jBA74
135+ I6ASBeIdmYPxg7Zx
136+ OIAeCY1FHbOdJHnk
137+ h3r45aQva46D0MkG
138+ BlHBdOq3KqcokYnp
139+ X4mFpYkR7LgyBdf9
140+ r04TZnPIpXlrYajl
141+ Zoa59BtKi0C7N3vQ
142+ PAUVrdCcV46DMcTa
143+ XzkP2UjLVPd6UdeH
144+ tFuOwhfZAminRknq
145+ LLRXDREtywZ9oL2l
146+ 1Bt1hjCu87iRvjVO
147+ 843udSQ5CYhxzpY3
148+ zm78Qr1fm6YbD5Pc
149+ nkKKOAThEvmvMDck
150+ daNI9lwDGwWPXgDh
151+ 3AD5vzwEgCh62OGG
152+ g0WACS40VWUhhO3n
153+ 8DSPNQnnPpExp5ae
154+ 1qDbOw7VXQu6sJyx
155+ IHeAepe22BqzyRYI
156+ Pyc8MoGTBonXrsig
157+ caIx6iJTzzrwRh76
158+ TuCiIBooXAtxGA1s
159+ d5vL89dwRziYYkOC
160+ Th7QNxgmuAHgdxjY
161+ Qde8adGqOCJLStgi
162+ X4YVCKnkpIglPXNH
163+ DJaSfz6ZZ5AexZrh
164+ p0suRQkjR2gPB50J
165+ Xu7zNDMf8LTXgUfP
166+ iO7lZE1d5u9C4agr
167+ ZScUrgefG4mhv7sn
168+ cxKn0LeiJmTmOncc
169+ MlHM9bSCqbLeYQyl
170+ hnNxbuM0iFXasDNU
171+ U9TDcgewoYmCuL8Z
172+ NiWuD6W6yo5naWVa
173+ 6xB2tyGaP9XD1Reu
174+ MyMQgM3LVp3OOZbH
175+ GNReq9Tsm9yEkjnH
176+ wv0m9rGnQlTzWBsz
177+ VXdYlEkAdRsw74Q6
178+ KYvyofRRw4HdHdGa
179+ feOc882CM6u3Vmb9
180+ bHfFtp2xlqR9ov7Z
181+ I9WJT51PDOho07f2
182+ mbfys9pZlaBa71fn
183+ Z7B8uUPNGUolHgve
184+ CyGhoq3E5eaLuYd8
185+ Sp4zPGY0Zb4ce2kX
186+ dawy36RyxYpGlDTG
187+ gJlcfSukZBZZbOji
188+ DM5lIjwwSR5Ixta0
189+ HQIN6iSuBBu95Cy1
190+ c3JKxSbY0vqx4SEC
191+ 9H4DXpc17vFjPCeE
192+ c48hIoAA5E5lVScv
193+ gadG0fAunAWg3C4I
194+ jr9kg1rr4rGPAT5i
195+ aLipX2YqYy8FyImJ
196+ GP87sr1igGhbAVnB
197+ Oghe3rzJSi4N9bCh
198+ j0pl6r1H8LD89zpg
199+ g9G0cNNlbgRRiuRM
200+ jqyltqFWJLEe0Gez
Original file line number Diff line number Diff line change 1+ # -*- coding: utf-8 -*-
2+
3+ #!/usr/bin/python
4+ # -*- coding: UTF-8 -*-
5+
6+ import pymysql
7+
8+
9+ # 打开数据库连接
10+ db = pymysql .connect ("localhost" , "root" , "" , "" )
11+
12+ # 使用cursor()方法获取操作游标
13+ cursor = db .cursor ()
14+
15+ # 使用execute方法执行SQL语句
16+ cursor .execute ("CREATE DATABASE IF NOT EXISTS pymysql;" )
17+ cursor .execute ("USE pymysql;" )
18+ cursor .execute (
19+ "CREATE TABLE IF NOT EXISTS active_code(code VARCHAR(255));" )
20+
21+ with open ("active_code.txt" , "r" ) as f :
22+ while True :
23+ s = f .readline ().strip ()
24+ # print(s)
25+ if s == "" :
26+ break
27+ cursor .execute ("INSERT INTO active_code (code) values(%s)" , [s ])
28+
29+ db .commit ()
30+ #cursor.execute("USE pymsql")
31+ cursor .execute ("SELECT * FROM active_code" )
32+
33+ # 使用 fetchone() 方法获取一条数据库。
34+ #data = cursor.fetchone()
35+
36+ #print("Database version : %s " % data)
37+
38+ # 关闭数据库连接
39+ db .close ()
You can’t perform that action at this time.
0 commit comments