消息推送系统

import sqlite3

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS bids (

id INTEGER PRIMARY KEY AUTOINCREMENT,

title TEXT,

content TEXT,

category TEXT,

timestamp DATETIME DEFAULT CURRENT_TIMESTAMP

)

''')

conn.commit()

conn.close()

]]>

import requests

from bs4 import BeautifulSoup

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

response = requests.get(url)

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

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

title = tender.find('h3').text

content = tender.find('p').text

cursor.execute("INSERT INTO bids (title, content, category) VALUES (?, ?, ?)",

(title, content, 'Public Tender'))

conn.commit()

conn.close()

]]>