# -*- coding = utf-8 -*-
# @Time : 2021/4/22 19:45
# @Author : Zyh
# @File : tets.py
# @Software : PyCharm

import pymysql

conn = pymysql.connect(host='localhost',
                       user='zyh',
                       passwd='mysql123',
                       db='dota2bigdata',
                       cursorclass=pymysql.cursors.DictCursor)
cur = conn.cursor()
sql = '''
                SELECT g.region_name,r.rC from game_region as g LEFT JOIN region as r ON g.region_id = r.r WHERE g.id != '22' ORDER BY g.id DESC   
                  '''
cur.execute(sql)
data = cur.fetchall()
r_name_list = []
rc_list = []
for item in data:
    r_name_list.append(item['region_name'])
    if item['rC']:
        rc_list.append(item['rC'])
    else:
        rc_list.append(0)

print(r_name_list)
print(rc_list)