def getSendSenPag(task_id,config_id,pagList):
# if len(notWhere) > 0:
# notWhere = 'id not in ({}) and'.format(notWhere[:-1])
sql = "select pag_id,content from {} where task_id = {} and config_id = {}".format(table, task_id, config_id)
print(sql)
cursor = config.config_online()
commit = config.config_Commit()
try:
# 先删
# data = ''
data = []
cursor.execute(sql)
i = 0
for info2 in pagList:
for info in cursor:
print(info)
if info2['id'] == info[0]:
pagList[i]['data'].append(info)
i += 1
return pagList
except Exception as e:
print(12313123)
print(e)
return ['error']
def delAlbumImgClear(type, admin_id, task_id, album_id, config_id):
cursor = config.config_online()
commit = config.config_Commit()
try:
sqlDel = "DELETE FROM {} WHERE type = '{}' and admin_id = '{}' and task_id = '{}' and album_id = '{}' and config_id = '{}'".format(
table_img, type, admin_id, task_id, album_id, config_id)
cursor.execute(sqlDel)
except Exception as e:
print(e)
def delAlbumImg(idList):
cursor = config.config_online()
commit = config.config_Commit()
try:
for id in idList:
sqlDel = "DELETE FROM {} WHERE id = '{}'".format(table_img, id)
cursor.execute(sqlDel)
except Exception as e:
print(e)
def deleteInfo(admin_id, name, task_id, config_id):
cursor = config.config_online()
commit = config.config_Commit()
try:
sqlDel = 'DELETE FROM {} WHERE admin_id = "{}" and name = "{}" and task_id = {} and config_id = {}'.format(
table, admin_id, name, task_id, config_id)
print(sqlDel)
cursor.execute(sqlDel)
except Exception as e:
print(e)
def deleteAll(admin_id, task_id, config_id):
sqlDel = "DELETE FROM {} WHERE admin_id = {} and task_id = {} and config_id = {}".format(
table, admin_id, task_id, config_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
cursor.execute(sqlDel)
commit.commit()
return cursor.fetchall()
except Exception as e:
print(e)
commit.rollback()
def randomImgData(admin_id, task_id, config_id):
sqlDel = "SELECT * FROM {} WHERE admin_id = {} and type = 2 and task_id = '{}' and config_id = '{}'".format(
table_img, admin_id, task_id, config_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
# 先删
data = []
cursor.execute(sqlDel)
for info in cursor:
data.append({"id": info[0], "url": info[1]})
return data
except Exception as e:
print(e)
def getInfoIdForId(id):
sql = "SELECT `id`,`name`,`is_send` FROM {} WHERE id = '{}'".format(
table, id)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
data = []
cursor.execute(sql)
for info in cursor:
if info is not None:
return {"id": info[0], "name": info[1], "is_send": info[2]}
except Exception as e:
print('此任务没有配置')
return []
def addConfig(task_id, config_id):
print()
insertAll = '("{}","{}"),'.format(task_id, config_id)
sql = "INSERT INTO {} ( `task_id`,`config_id`) VALUES {}".format(
table, insertAll)
print(sql)
cursor = config.config_online()
commit = config.config_Commit()
try:
cursor.execute(sql[:-1])
commit.commit()
return 1
except Exception as e:
print(e)
commit.rollback()
def addOtherContent(name, content, admin_id, task_id, config_id):
insertAll = '("{}","{}","{}","{}","{}"),'.format(
name, content.replace('"', '\\"'), admin_id, task_id, config_id)
sql = "INSERT INTO {} (`name`, `content`, `admin_id`,`task_id`,`config_id`) VALUES {}".format(
table, insertAll)
# print(sql)
cursor = config.config_online()
commit = config.config_Commit()
try:
# 先删
cursor.execute(sql[:-1])
commit.commit()
return 1
except Exception as e:
print(e)
commit.rollback()
def getInfo(task_id):
sql = "SELECT `id`,`name` FROM {} WHERE task_id = '{}' and status = 1".format(
table, task_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
data = []
cursor.execute(sql)
for info in cursor:
if info is not None:
data.append({"id": info[0], "name": info[1]})
return data
except Exception as e:
print('此任务没有配置')
return []
def addTask(name, type, admin_id):
# print(sql)
commit = config.config_Commit()
cursor = commit.cursor()
try:
insertAll = '("{}","{}","{}"),'.format(name, type, admin_id)
sql = "INSERT INTO {} (`name`, `type`, `admin_id`) VALUES {}".format(
table, insertAll)
print(sql[:-1])
cursor.execute(sql[:-1])
# id = getTaskId(admin_id,name)
# adminModel.addConfig(id,config_id)
commit.commit()
return 1
except Exception as e:
print(e)
commit.rollback()
def addAlbumImg(admin_id, url, task_id, album_id, config_id):
cursor = config.config_online()
commit = config.config_Commit()
try:
url = url.replace(apiAll.website, '')
# sqlDel = "DELETE FROM {} WHERE admin_id = '{}' and type = '{}' and task_id = '{}'".format(table_img,admin_id,type,task_id)
# cursor.execute(sqlDel)
sql = "INSERT INTO {} (url, type, admin_id,album_id,task_id,config_id) VALUES ( '{}', '{}','{}','{}','{}','{}')".format(
table_img, url.replace(apiAll.website + '/', ''), 3, admin_id,
album_id, task_id, config_id)
# 先删
print(sql)
cursor.execute(sql)
commit.commit()
except Exception as e:
print(e)
commit.rollback()
def add_DataDuan(sentenceList,admin_id,task_id,pag_id,config_id):
insertAll = ''
for info in sentenceList:
if len(info) > 0:
insertAll += '("{}",{},{},{},{}),'.format(info,admin_id,task_id,pag_id,config_id)
sql = "INSERT INTO {} (`content`, `admin_id`,`task_id`,`pag_id`,`config_id`) VALUES {}".format(table,insertAll)
# print(sql[:-1])
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
cursor.execute(sql[:-1])
commit.commit()
return 1
except Exception as e:
# print(e)
commit.rollback()
def getSendImg(admin_id, task_id, type, config_id, notWhere):
if len(notWhere) > 0:
notWhere = 'id not in ({}) and'.format(notWhere[:-1])
sql = "select id,url from {} where {} admin_id = {} and task_id = {} and type={} and config_id ={} order by rand() LIMIT 1".format(
table_img, notWhere, admin_id, task_id, type, config_id)
print(sql)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
# data = ''
cursor.execute(sql)
for info in cursor:
return info
else:
return ['error']
except Exception as e:
# print(e)
return ['error']
def addAlbumAll(admin_id, urlList, album_id, task_id, type, config_id):
cursor = config.config_online()
commit = config.config_Commit()
try:
sqlDel = "DELETE FROM {} WHERE admin_id = '{}' and type = '{}' and task_id = '{}' and album_id = '{}' and config_id = '{}'".format(
table_img, admin_id, type, task_id, album_id, config_id)
# print(sqlDel)
cursor.execute(sqlDel)
# print(urlList)
for url in urlList:
sql = "INSERT INTO {} (url, admin_id, type,task_id,album_id,config_id) VALUES ( '{}', '{}','{}','{}','{}','{}')".format(
table_img, url, admin_id, type, task_id, album_id, config_id)
# 先删
cursor.execute(sql)
result = cursor.fetchall()
commit.commit()
except Exception as e:
print(e)
commit.rollback()
def getDataList(admin_id, task_id, config_id):
sql = "SELECT * FROM {} WHERE admin_id = {} and task_id = '{}' and config_id = '{}'".format(
table, admin_id, task_id, config_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
data = []
cursor.execute(sql)
list = []
for info in cursor:
list.append(info)
print(list)
if len(list) > 0:
for info in list:
data.append({"id": info[0], "name": info[1]})
return data
except Exception as e:
print(e)
def getPagDataListSend(admin_id,task_id,config_id):
sql = "SELECT `id`,`name` FROM {} WHERE admin_id = {} and task_id = '{}' and config_id = '{}'".format(table_pag,admin_id,task_id,config_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
data = []
cursor.execute(sql)
list = []
for info in cursor:
list.append(info)
# print(result)
if len(list) > 0:
for info in list:
data.append({'id':info[0],'name':info[1],'data':[]})
return data
else:
return []
except Exception as e:
print(e)
def add_Data(keyword_list, admin_id, type, task_id, config_id):
insertAll = ''
for info in keyword_list:
if len(info) > 0:
insertAll += '("{}",{},{},{},{}),'.format(info, type, admin_id,
task_id, config_id)
sql = "INSERT INTO {} (`keyword`, `type`, `admin_id`,`task_id`,`config_id`) VALUES {}".format(
table, insertAll)
# print(sql[:-1])
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
cursor.execute(sql[:-1])
commit.commit()
return cursor.fetchall()
except Exception as e:
# print(e)
commit.rollback()
def addAlbum(admin_id, urlList, type, task_id, config_id):
cursor = config.config_online()
commit = config.config_Commit()
try:
for url in urlList:
sql_sel = "SELECT * FROM {} WHERE admin_id = {} and task_id = '{}' and url = '{}' and type = '{}' and config_id = '{}'".format(
table_img, admin_id, task_id, url, type, config_id)
cursor.execute(sql_sel)
data = []
for info in cursor:
data.append(info[0])
if len(data) == 0:
sql = "INSERT INTO {} (url, admin_id, type,task_id,config_id) VALUES ( '{}', '{}','{}','{}','{}')".format(
table_img, url, admin_id, type, task_id, config_id)
# 先删
cursor.execute(sql)
result = cursor.fetchall()
commit.commit()
except Exception as e:
print(e)
commit.rollback()
def getSendSen(admin_id,task_id,config_id):
sql = "select `content` from {} where pag_id = 0 and admin_id = {} and task_id = {} and config_id = {}".format(table,admin_id,task_id,config_id)
# # print(sql)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
# data = ''
cursor.execute(sql)
list = []
for info in cursor:
list.append(info[0])
print(2222222222211111111111)
print(list)
if len(list) > 0:
return list
else:
return []
except Exception as e:
print(e)
return ' '
def titleDataAdd(admin_id, titleList, task_id, config_id):
sqlDel = "DELETE FROM {} WHERE admin_id = {} and task_id = {} and config_id = {}".format(
table, admin_id, task_id, config_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
# #先删
# cursor.execute(sqlDel)
for info in titleList:
if len(info) > 0:
sql = 'INSERT INTO {} (title, admin_id,task_id,config_id) VALUES ("{}","{}","{}","{}")'.format(
table, info, admin_id, task_id, config_id)
# data = (info, admin_id,task_id)
cursor.execute(sql)
commit.commit()
return 1
except Exception as e:
print(e)
commit.rollback()
return 0
def getSendTitle(admin_id, task_id, config_id):
sql = "select `title` from {} where admin_id = {} and task_id = {} and config_id= {}".format(
table, admin_id, task_id, config_id)
# # print(sql)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
# data = ''
cursor.execute(sql)
list = []
for info in cursor:
list.append(info[0])
# print(result)
data = []
if len(list) > 0:
for info in list:
data.append(info[0])
return data
except Exception as e:
print(e)
def getDataOne(admin_id, task_id, name, config_id):
sqlDel = "SELECT * FROM {} WHERE admin_id = {} and task_id = '{}' and `name` = '{}' and `config_id` = '{}'".format(
table, admin_id, task_id, name, config_id)
# # print(sqlDel)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
data = []
cursor.execute(sqlDel)
list = []
for info in cursor:
list.append(info)
if len(list) > 0:
for info in list:
data = {"id": info[0], "name": info[1]}
return data
else:
return {"id": 0, "name": ''}
except Exception as e:
print(e)
def getInfo(task_id, config_id):
sql = "SELECT `username`,`password`,`token` FROM {} WHERE task_id = '{}' and config_id = '{}'".format(
table, task_id, config_id)
cursor = config.config_online()
commit = config.config_Commit()
try:
#先删
data = []
cursor.execute(sql)
for info in cursor:
if info is not None:
return {
"username": info[0],
"password": info[1],
"token": info[2]
}
print(2222222222)
return {"username": '', "password": '', "token": ''}
except Exception as e:
print('此任务没有配置')
return {"username": '', "password": '', "token": ''}
