从数据库查询周刊内容统计数据 Returns: list: 包含期号和各类内容数量的元组列表
()
| 31 | } |
| 32 | |
| 33 | def query_data(): |
| 34 | """ |
| 35 | 从数据库查询周刊内容统计数据 |
| 36 | |
| 37 | Returns: |
| 38 | list: 包含期号和各类内容数量的元组列表 |
| 39 | """ |
| 40 | with sqlite3.connect(db_path) as conn: |
| 41 | cursor = conn.cursor() |
| 42 | query = """ |
| 43 | SELECT issue_no, article_count, project_count, audio_video_count, hot_topic_count, book_count |
| 44 | FROM weekly_summary |
| 45 | """ |
| 46 | cursor.execute(query) |
| 47 | data = cursor.fetchall() |
| 48 | return data |
| 49 | |
| 50 | def prepare_data(data, start, end): |
| 51 | """ |