| 123456789101112131415161718192021222324252627282930313233 |
- from app.api_data.cost_util import *
- from model.DateUtils import DateUtils
- from model.DataBaseUtils import MysqlUtils
- du = DateUtils()
- # def get_accounts(filter=None):
- # db = MysqlUtils()
- # if filter:
- # if filter=='MP':
- # return db.quchen_text.getData("select account_id,access_token,name channel from advertiser_vxwhere (name !='' or name is not null)")
- #
- # else:
- # return db.quchen_text.getData("select account_id,access_token,name channel"
- # " from advertiser_qq where (name !='' or name is not null)")
- #
- # return db.quchen_text.getData("select account_id,access_token,name channel,'MP' flag "
- # "from advertiser_vx where (name !='' or name is not null) union "
- # "select account_id,access_token,name channel,'GDT' flag"
- # " from advertiser_qq where (name !='' or name is not null)")
- if __name__ == '__main__':
- account_id = "19521440"
- token = "5ea8737494daecf9e954df56b250826e"
- st = "2021-05-01"
- et = '2021-05-20'
- print(mp_campaign_daily_report(account_id,token,st,et).__len__())
|
