Python實(shí)現(xiàn),從txt取出號(hào)碼,在數(shù)據(jù)庫(kù)里查詢此號(hào)碼是否存在
貼代碼:
import os
import os.path
import json
import logger
import time
gar = []
file = u"E:/ybl_TestDepartment/interface_test/config/1.txt"
class TXT():
log = logger.Log()
def __init__(self):
if not os.path.exists(file):
self.log.info("錯(cuò)誤信息:文件不存在")
self.file = open(file,"r+")
def Read(self):
gar = []
filen=self.file.readlines()
for i in filen:
gar.append(i.strip())
if (0<len(gar)<5):
self.log.info("##警告: phone_data即將為空,目前為%s##"%len(gar))
if(len(gar) ==0):
self.log.info("##警告: phone_data文件為空,請(qǐng)輸入phone")
return gar[0]
def Del(self):
gar = []
filen=self.file.readlines()
for i in filen:
gar.append(i)
self.file.seek(0)
self.file.truncate()
self.file.close()
gar.pop(0)
#gar.append(" ")
self.file = open(file,"r+")
#self.file.truncate()
time.sleep(1)
for i in gar:
self.file.write(i+"\n")
self.file.close()
此代碼在:common/Txt.py
class register():
log = logger.Log()
s =requests.session()
def __init__(self):
mysql = MysqlUtil()
A = TXT()
phone = A.Read()
while True:
#驗(yàn)證取得的電話號(hào)碼是否已經(jīng)注冊(cè)過(guò)
sql = "SELECT DISTINCT(phone) FROM table WHERE phone = '"+phone+"';"
#if (sql == "null"):
#print (sql)
result = mysql.mysql_getrows(sql)
result1 = json.dumps(result)
if (result1 == '[]'):
self.phone =phone
print (self.phone)
break
else:
A = TXT()
A.Del()
phone = A.Read()
self.log.info("####號(hào)碼重復(fù),重取####")
不喜勿噴,第一次在園里貼自己寫的代碼,
開始想在excel表里實(shí)現(xiàn),但發(fā)現(xiàn)xlrt庫(kù)寫入和刪除沒(méi)有找到方法,算了,還是txt吧,反正功能能實(shí)現(xiàn),就是打開txt丑點(diǎn),哈哈哈哈哈哈哈哈哈哈哈哈
不讓發(fā)布到博客園首頁(yè),那我再寫幾個(gè)字,
posted on 2019-04-19 14:30 一只貓咪· 閱讀(557) 評(píng)論(0) 收藏 舉報(bào)
浙公網(wǎng)安備 33010602011771號(hào)