from pymongo import MongoClient
from pymongo import InsertOne
import random
import datetime
from dateutil import parser
from urllib import parse
import pymysql
# 转义用户名和密码
def insert():
conn = pymysql.connect(host='0.0.14.53',
user='GdkySjpt',
password='CebAna@2021',
database='c_heatin',
port=3389,
charset='utf8',
autocommit=1)
print("连接成功")
host = '0.0.14.20'
username = parse.quote_plus("netmongo")
password = parse.quote_plus("netmongo")
port = '27010'
db = 'GD_BD'
mongo_url = 'mongodb://{0}:{1}@{2}:{3}/?authSource={4}&authMechanism=SCRAM-SHA-1' \
.format(username, password, host, port, db)
client = MongoClient(mongo_url)
my_db = client['GDKY_BD_GRB_HECM_TEMP']
my_collection1 = my_db['DAT_ROOMTEMP_HISTORY_H']
my_collection2 = my_db['DAT_ROOMTEMP_HISTORY_M']
my_collection3 = my_db['DAT_ROOMTEMP_ORIGINAL_HISTORY_H']
my_collection4 = my_db['DAT_ROOMTEMP_ORIGINAL_HISTORY_M']
time = datetime.datetime.now()
gettime = str(time + datetime.timedelta(hours=-8))
with open('D:/leidian/室温点id.txt', 'r') as f:
content = f.readlines()
for line in content:
ROOMTEMP = round(random.uniform(15, 30), 2)
data1 = []
data1.append(InsertOne({"ROOMTEMPPOINTID": str(line.strip("\n")),
"ROOMTEM": str(ROOMTEMP),
"ORIGINALTEP": str(ROOMTEMP),
"REVISEFAG": str(1),
"GETTIE": parser.parse(gettime),
"ADDTME": parser.parse(gettime)}))
data2 = []
data2.append(InsertOne({"RMTEMPPOINTID": str(line.strip("\n")),
"ORIGINALTEMP": str(ROOMTEMP),
"GETTE": parser.parse(gettime),
"ATIME": parser.parse(gettime)}))
data3 = []
data3.append((ROOMTEMP, ROOMTEMP, time, time, line.strip("\n")))
my_collection1.bulk_write(data1)
my_collection2.bulk_write(data1)
my_collection3.bulk_write(data2)
my_collection4.bulk_write(data2)
cursor = conn.cursor()
sql = "UPDATE `dt_romtemp` SET `roomemp`=%s,`originltmp`=%s,`gettme` = %s,`addme` = %s where `ROOMTEPOINTID`=%s"
cursor.executeany(sql, data3)
conn.comit()
cursor.close()
conn.close()
if __name__ == '__main__':
insert()
python简单代码段
最新推荐文章于 2024-03-12 05:42:40 发布