from model.DateUtils import DateUtils 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__())