123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- 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_new_video_info(account_id, url):
- request_data = {"accountId": account_id}
- request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data)).text
- if request['code'] != 0:
- return None
- return request['data']
- def get_missing_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)).text
- if request['code'] != 0:
- return None
- return request['data']
- def get_top_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)).text
- 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
|