爬取机票价格相关信息

import datetime
import pymysql
import requests
import re
import time
import csv
import json
import random
import citys


def mysql(sql):
    # 链接数据库
    db = pymysql.connect(host='localhost', user="root", port=3306, password="123456", database="asd")
    cursor = db.cursor()
    cursor.execute(sql)
    db.commit()
    cursor.close()
    db.close()


def get_headers(header_raw):
    return dict(line.split(": ", 1) for line in header_raw.split("\n"))


# 获取网页源码的文本文件
def get_html(url):
    response = requests.get(url, headers=get_headers(headers))
    response.close()
    return response


def post_html(url, data):
    res = requests.post(url, headers=get_headers(headers), json=data)
    time.sleep(1)
    return res


def save_data(demcity, arrcity, demTime, arrTime, Airline, flightNo, lowPrice):
    with open("data.csv", "a", encoding="