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)
