1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 |
- import requests
- from utils.UrlConfig import *
- import json
- import pandas as pd
- from utils.DataBaseConfig import *
- def get_lower_case_name(name):
- lst = []
- for index, char in enumerate(name):
- if char.isupper() and index != 0:
- lst.append("_")
- lst.append(char)
- return "".join(lst).lower()
- def get_video_info(account_id, url):
- request_data = {"accountId": account_id}
- request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data))
- if request['code'] != 0:
- return None
- return request['data']
- def get_video_info(account_id, cnt, url):
- request_data = {"accountId": account_id, "videoCnt": cnt}
- request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data))
- if request['code'] != 0:
- return None
- return request['data']
- def get_video_info(account_id, cnt, url):
- request_data = {"accountId": account_id, "videoCnt": cnt}
- request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data))
- if request['code'] != 0:
- return None
- return request['data']
- def get_video_info(account_id, cnt, start_time, end_time, url):
- request_data = {"accountId": account_id, "num": cnt, "startTime": start_time, "endTime": end_time}
- request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data))
- if request['code'] != 0:
- return None
- return request['data']
- def get_campaign_and_group_name_rule(account_id):
- sql = """select campaign_name, unit_name
- from ctop_ai_kuaishou_advertiser_strategy
- where account_id = %s
- and status = 1
- limit 1
- """ % account_id
- df = pd.read_sql(sql, engine)
- if df.empty:
- return None, None
- campaign_name = df['campaign_name'].values[0]
- group_name = df['unit_name'].values[0]
- return campaign_name, group_name
|