笑々笑的博客

import pymysql import decimal import datetime import json class DecimalEncoder(json.JSONEncoder): def default(self,obj): if isinstance(obj,decimal.Decimal):#decimal类型转换，使其可以转换为json格式数据 ...

#coding:utf-8 # a={} # b=['11','101'] # c=['10','9'] # a=dict(zip(b,c)) # for key in a: # print(key) # print(a[key]) import requests import re import unittest # headers={ # 'Accept': '...

import pymysql import decimal import datetime import json import os __description__='Testting order_delivery and t_wms2tms_order' class DecimalEncoder(json.JSONEncoder): def default(self,obj): ...

import pymysql import decimal import datetime import json import LogPackage import logging import os logs=LogPackage.Logger(filename='log.txt',path=1,driver_path=os.getcwd()) logs.Log() logger=loggin...

import pymysql import decimal import datetime import json __description__='Finding the data in the same database' class DecimalEncoder(json.JSONEncoder): def default(self,obj): if isinst...

__description__='Finding data in different servers' import pymysql import json import decimal import datetime db1=pymysql.connect(host="服务器地址",port=3306,user='用户名',password='密码',db='数据库名称',charset='...

import redis pool=redis.ConnectionPool(host='127.0.0.1',port=6379,decode_responses=True) r=redis.Redis(connection_pool=pool) # set测试 # r.sadd('test_set',10,20,30) print(r.scard('test_set')) print(r...

import pymysql import datetime import json import decimal import requests import warnings import time """ 超市供应链数据测试：1、product表和supplier表拆分重组与supply_introduce表对比 2、接口返回数据和supply_int...

本文转载地址：https://www.cnblogs.com/dinglinyong/p/6656315.html 建表 在这里呢我们先来建立两张有外键关联的张表。 CREATE DATABASE db0206; USE db0206; CREATE TABLE `db0206`.`tbl_dept`( `id` INT(11) NOT NULL AUTO_INCREMENT, ...