import requests
import json
import re
import pymysql
from tool.Mysql_connect import Mysql_operation
from tool.get_token import Crm_token

class test_demo(object):
  def __init__(self):
    self.op_mysql=Mysql_operation()
    self.token=Crm_token()
  def create_yixiang(self):
    url='http://xxx/customerAdjunctAdd'
    token=self.token.get_token()
    headers={"Content-Type":'application/x-www-form-urlencoded',
    "token":token}
    try:
      tel_num=self.op_mysql.sql_select('''select max(tel) from nc_customer_adjunct''')[0]['max(tel)'] #結(jié)果為str
    except Exception as error:
      print(error)
    a=1
    while a<3:
      tel_num=int(tel_num)+1
      a+=1
      data='customer_type=1&source=1&course_name_id=41&tel=%d&customer_name=測試3.1&sex=0&school=測試1&intro_id=0'%(tel_num)
      try:
        request1=requests.request("POST",url=url,headers=headers,data=data.encode()) #encode對請求編碼處理：不處理接口會返回數(shù)據(jù)解析錯誤
        # print(data)
        response1=request1.json()
        print(headers)
        print(response1)
      except Exception as error:
        print(error)
if __name__=="__main__":
  Tm=test_demo()
  Tm.create_yixiang()