搜索到
142
篇与
的结果
-
FastApi操作MySQL基本文件结构 首先是总的文件结构：.├── __pycache__│ └── main.cpython-38.pyc├── main.py└── sqlstu ├── __pycache__ │ ├── crud.cpython-38.pyc │ ├── database.cpython-38.pyc │ └── models.cpython-38.pyc ├── crud.py ├── database.py └── models.pymain.py就是FastAPI的启动文件了。 main.py:import uvicorn from pydantic import BaseModel from sqlstu import crud from sqlalchemy.orm import Session from fastapi import Response, Depends, FastAPI, HTTPException from sqlstu.database import SessionLocal, engine from sqlstu import models app = FastAPI() models.Base.metadata.create_all(bind=engine) # 数据库开关 def get_db(): db = SessionLocal() try: yield db finally: db.close() class Item(BaseModel): form: str form_name: str entry: dict @app.get('/') async def index(db: Session = Depends(get_db)): a = '111' b = '222' crud.add_record(db, a, b) return 1 if __name__ == '__main__': uvicorn.run(app='main:app', host='0.0.0.0', port=8000, reload=True, debug=False)crud.py进行数据库增删改查from sqlalchemy.orm import Session from .models import * def add_record(db: Session, source, result): if not db.query(PandaParse).filter(PandaParse.source == source).first(): added = PandaParse(source=source, result=result) db.add(added) db.commit() db.refresh(added) return 200database.py建立数据库链接from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker SQLALCHEMY_DATABASE_URL = "mysql+pymysql://username:password@localhost:port/database" engine = create_engine(SQLALCHEMY_DATABASE_URL, pool_pre_ping=True) SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) Base = declarative_base()models.py数据库表对应文件from sqlalchemy import Boolean, Column, Integer, String, Datetime from datetime import datetime from .database import Base class PandaParse(Base): __tablename__ = "LanAPI_Panda" id = Column(Integer, primary_key=True, index=True) source = Column(String) result = Column(String) -
-
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. 爬学校电费余额系统存到本地数据库时，开了多线程（车速过快），于是就报错了sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 12960 and this is thread id 13904.在链接sqlite的时候加上check_same_thread=False即可
-
-
-
一键去除“ - 快捷方式”python脚本 今天，一时兴起，重装了个系统，然后有些软件是不需要安装的，然后发送到桌面快捷方式之后都会带一个“ - 快捷方式”的后缀，于是顺手写了个小脚本，一键替换一下下，python大法好。# -*- coding: utf-8 -*- """ ------------------------------------------------- @ Author ：Lan @ Blog ：www.lanol.cn @ Date ： 2020/7/12 @ Description：I'm in charge of my Code ------------------------------------------------- """ import os sourcename = os.listdir('./') resultname = [i.replace(' - 快捷方式', '') for i in sourcename] for index, value in enumerate(sourcename): try: os.rename(value, resultname[index]) print(f'{value}成功') except: print(f'{value}失败') input('完成！')
-
Lan工具箱API之抖音短视频无水印解析 URL地址：http://tool.vast.codes/douyin/传递参数：URL请求方式：GET特别注意：传递的参数不一定非得是URL，可以直接传递分享的文字如：点击复制链接：当地时间10日0时40分左右，失联的韩国首尔市长朴元淳的遗体已被找到！ https://v.douyin.com/JNpy4kM/ 复制此链接，打开【抖音短视频】，直接观看视频！让直接传递给URL即可（不能以#开头）。http://tool.vast.codes/douyin/?url=当地时间10日0时40分左右，失联的韩国首尔市长朴元淳的遗体已被找到！%20https://v.douyin.com/JNpy4kM/%20复制此链接，打开【抖音短视频】，直接观看视频！如果是直接传递URL需传递完整URLhttp://tool.vast.codes/douyin/?url=https://v.douyin.com/JNpy4kM/
