Python获取单个业务数据量的SQL语句拼接方法
single.get("tablelist")
上述获取的是一个列表list
一种比较恶心的办法,将list以字符串的形式拼接在SQL语句中
if "共享平台" in single.get("key"): sql = "select " \ "table_schema, " \ "table_name, " \ "table_comment, " \ "round(data_length/1024/1024, 2) as 'datasizeM', " \ "round(index_length/1024/1024, 2) as 'indexsizeM', " \ "table_rows as 'rows' " \ "from information_schema.tables " \ "where table_name in ("+str(single.get("tablelist")).split('[')[1].split(']')[0]+")" else:
如各位大侠有更好的办法,还请不吝赐教!