8.2、config、dbmysql、rip_tool

publicParameters.ini

#得助统一接口地址
[ApiAddressConfig]
rip_addr=http://rip-stage-test3.msxfcloud.test
login_data={"userName":"admin","password":"ZqONDX8Dd3iEjTRKG4HDeg==","secFactorCode":"1"}
login_header={"Content-Type":"application/json"}

#数据库连接配置
[DBConnectConfig]
#得助数据接入配置
db_rip={"host":"10.193.244.170","port":3306,"user":"root","password":"123456","database":"datasource_test3"}

db.py

import pymysql

class DbHandle():
    def __init__(self, host, port, user, passwd, db):
        self.cursor = self.getConnect(host, port, user, passwd, db)

    def getConnect(self, host, port, user, passwd, db):
        conn = pymysql.connect(
            host=host,
            port=port,
            user=user,
            passwd=passwd,
            db=db,
            charset='utf8'
        )
        return conn

    #查询按插入时间倒叙排列,最近一条数据的id
    def ripdata(self):
        cursor = self.cursor.cursor()
        sql = "SELECT id FROM  `service_base` ORDER BY create_time DESC LIMIT 1;"
        cursor.execute(sql)
        results = cursor.fetchall() #获取所有记录列表
        return results[0][0]  #返回service_code

    # 返回接入类型是hbase的统计数量
    def ripdata_count(self):
        cursor = self.cursor.cursor()
        sql = "SELECT COUNT(*) FROM `service_base` WHERE access_type = '3'"
        cursor.execute(sql)
        results = cursor.fetchall() #获取所有记录列表
        return results[0][0]  #返回接入类型是hbase的统计数量


if __name__ == '__main__':
    aa = DbHandle("10.193.244.170",3306,"root","123456","datasource_test3")
    b = aa.ripdata_count()
    print(b)
    print(type(b))


    # conn = pymysql.connect(host="10.193.244.170",
    #                        port=3306,
    #                        user="root",
    #                        password="123456",
    #                        database="datasource_test3",
    #                        charset="utf8")

zhaoshuju_tool.py

from faker import Faker
import json,datetime

class ZSJ():
    def zhaoshuju(self):
        fake = Faker(locale='zh_CN')
        a = fake.profile(fields=None, sex=None)
        a['birthdate'] = str((datetime.datetime.now()))
        a['current_location'] = '空' #将current_location的值替换成空
        a['居住地'] = a.pop('residence') # 将key进行替换：居住地代替residence
        a['网站'] = a.pop('website')
        a.pop('网站') #删除key :key名‘网站’
        a['idCard'] = a.pop('ssn')
        a['phone']= a.pop('blood_group')
        a['phone']= fake.phone_number()
        # 只是在控制台中显示成json输出格式，前端页面不这么显示
        b = json.dumps(a, ensure_ascii=False,sort_keys=True, indent=2)
        return b
if __name__ == '__main__':
    aa = ZSJ()
    bb = aa.zhaoshuju()
    print(bb)