def main(): # 1. 爬取数据 url = "http://scxk.nmpa.gov.cn:81/xk/itownet/portalAction.do?method=getXkzsList" data_list = spider.getDataFromUrl(url) # 2.创建数据库和表 dbpath = "cosmetics.db" # 数据库路径 dao.init_db(dbpath) # 3.往表里插入数据 dao.save2db(data_list, dbpath)
from flask import Flask from flask_restful import Resource from api import init_api import settings from dao import init_db app = Flask(__name__) #配置app app.config.from_object(settings.Config) #初始化API init_api(app) #初始化dao,或db init_db(app) if __name__ == '__main__': app.run()
import dao # TODO dao.init_db()
smt=smt, memory_speed=memory_speed, llc=llc, cores=cores, core_frequency=core_frequency, uncore_frequency=uncore_frequency) existing = Config.query.filter_by( workload=workload, sku=sku, smt=smt, memory_speed=memory_speed, llc=llc, cores=cores, core_frequency=core_frequency, uncore_frequency=uncore_frequency).first() if not existing: db_session.add(config) db_session.flush() #用于返回新增的id db_session.commit() #此时数据才插入到数据库中 else: config = existing emon.config_id = config.id db_session.commit() #再次commit,更新emon的config_id if __name__ == '__main__': init_db() test_result_rootdir = '../../../data/emon_result' load_data_from_rootdir(test_result_rootdir) update_tb_config()
def init_api(app): api.init_app(app) dao.init_db(app)
def init_db(): with dao.with_cursor(db_pool) as c: dao.init_db(c)