python简单代码段

最新推荐文章于 2024-03-12 05:42:40 发布

weiguochuli

最新推荐文章于 2024-03-12 05:42:40 发布

阅读量171

点赞数

分类专栏：学习笔记文章标签：数据库 java 服务器

本文链接：https://blog.csdn.net/weiguochuli/article/details/128648440

版权

学习笔记专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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()