消息推送系统

import requests

from bs4 import BeautifulSoup

import sqlite3

url = 'https://example.com/tender'

response = requests.get(url)

soup = BeautifulSoup(response.text, 'html.parser')

conn = sqlite3.connect('tenders.db')

c = conn.cursor()

c.execute('''CREATE TABLE IF NOT EXISTS tenders (id INTEGER PRIMARY KEY, title TEXT, date TEXT)''')

for item in soup.find_all('div', class_='tender-item'):

title = item.find('h2').text

date = item.find('span', class_='date').text

c.execute("INSERT INTO tenders (title, date) VALUES (?, ?)", (title, date))

conn.commit()

conn.close()