we-analysis/test.py

"""
测试代码
"""

from feishu.feishu import Feishu
from applications.mysql import Mysql


F = Feishu()
M = Mysql()

sql = "SELECT * FROM we_analysis_results where mini_program = '票圈视频+' and date = \'2024-01-15\';"

if __name__ == '__main__':
    data_lines = M.select(sql)
    for line in data_lines[:1]:
        for info in line:
            print(info)

    # print(data)
# value = [
#     [1, 2, 3],
#     [4, 5, 6],
#     [7, 8, 9],
#     [10, 11, 12],
#     [13, 14, 15],
#     [16, 17, 18]
# ]
# F.insert_value(
#     sheet_id="gwzBOM",
#     values=value,
#     ranges="A2:C7"
# )