def setUpClass(cls):
global mysql
mysql = MysqlUtil()
sql_1 = "select * from message.message_circle_link_account where circle_uuid = '555c54bb67a546569969e8c5d8d0c538' and join_type = 0 and `status` = 1;" #第四个圈子关联账号
sql_2 = "select * from message.message_circle_link_account where circle_uuid = 'd41b03780174469ba858a3db5ae0f05d' and join_type = 0 and `status` = 1;" #第三个圈子关联账号
global four_max, three_max # 声明全局变量
four_max = mysql.fetch_all(sql_1) # 查询出第四个圈子，下属短账号，返回的是list
three_max = mysql.fetch_all(sql_2)
def setUp(self):
global mysql
mysql = MysqlUtil()
global max_counts
max_counts = mysql.fetch_all(
"select * from message.message_circle_field where id != '' order by id desc "
) # 事先查出所有的领域
def setUp(self):
global mysql
mysql = MysqlUtil()
global max_circle
# 事先从数据库中查出，可以加入领域的 圈子
max_circle = mysql.fetch_all(
"select m.title,m.uuid from message.message_circle m where m.`status`=1 and m.uuid not in (select circle_uuid from message.message_circle_field_link where `status`=2)"
)
def setUpClass(cls):
global mysql
mysql = MysqlUtil()
sql = "select * from message.message_circle_link where circle_uuid = 'd41b03780174469ba858a3db5ae0f05d' and type = 1 and `status` != 0;"
global spam_type
spam_type = mysql.fetch_all(sql) #事先从数据库查出，第三个圈子，下属所有刷屏
def setUp(self):
global mysql
mysql = MysqlUtil()
sql = "select * from message.message_circle_vote_questions where circle_uuid = '555c54bb67a546569969e8c5d8d0c538';"
global vote_max
vote_max = mysql.fetch_all(sql) # 事先从数据库中查出来，第四个圈子下的投票（存在一个圈子下，多个投票的情况，所以返回list）