#strart_main.py
from fastapi import FastAPI, Depends,Request,WebSocket
from fastapi.staticfiles import StaticFiles
from fastapi.templating import Jinja2Templates
from fastapi.responses import HTMLResponse
#from fastapi.requests import Request
from fastapi import HTTPException, Query
from sqlmodel import Session, select
from database import create_db_and_tables, get_session
from models import Book,BookCreate
from models import*import emoji
import time
import uvicorn
def i():
num =1while True:
yield num
num +=1
y=i()
hd=('name','age','years')
#t= time.strftime("%Y/%m/%d %r",time.localtime())
s= emoji.emojize('Python is :thumbs_up:')
app =FastAPI()
templates =Jinja2Templates('/data/data/com.termux/files/home/testpy/templates')
def configure():create_db_and_tables()
app.mount('/static',StaticFiles(directory='/data/data/com.termux/files/home/testpy/static'), name='static')@app.get("/")
def home_page(*, session: Session =Depends(get_session), request: Request):
books = session.exec(select(Book)).all()
data_all={"request":request,"hd":hd,"s":s,"books":books
}return templates.TemplateResponse("index.html",data_all)@app.post("/book")
def add_book(*, session: Session =Depends(get_session), request: Request, book: BookCreate)-> BookRead:
db_book = Book.from_orm(book)
data=session.add(db_book)
session.commit()
session.refresh(db_book)return db_book
#return templates.TemplateResponse("index.html",{'request':request,'data':data})@app.websocket("/ws")
async def websocket_endpoint(websocket:WebSocket):try:
#等待socket连接并建立连接
await websocket.accept()while True:
#获取客服端传回的数据
data = await websocket.receive_text()
await websocket.send_text(f"主动发消息给客户端:{data}")if data=='1':
g='2'
#if判断客服端发来的数据并处理客户端发来的数据data后重新发送给客户端发
await websocket.send_text(f"Message text was:data: {data} g: {g}")else:
await websocket.send_text(f"不匹配")
except:
#客户端连接情况反馈信息
print('断开连接')print('当前连接次数: '+str(next(y)))
u=time.time()
d=time.strftime("此连接断开时间 :%Y-%m-%d %H:%M:%S",time.localtime(u))print(d)if __name__=="__main__":configure()
uvicorn.run(app, host="127.0.0.1", port=9999)else:configure()<!--index.html--><!DOCTYPE html><html lang="en-us"><head
<meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1.0"><meta name="description" content="A website showcasing fastapi and sqlmodel"><meta name="author" content="idjotherwise"><title>Fastapi+Fastsqlmodel+jinja2+socketserver</title><link href="{{ url_for('static', path='css/styles.css') }}" rel="stylesheet"></head><body style="text-align: center"><h1> A super stylish home page </h1><p>
Really interesting content, full of buzzwords like AI and MACHINE LEARNING!</p>{%if books %}<ul>{%for book in books %}<li key="{{book.id}}">Title:{{book.title}}, Author:{{book.author}}</li>{% endfor %}</ul>{% endif %}<h1>哈哈</h1><!--apache2服务器-->{% set url ="http://127.0.0.1:8000"%}<a href={{url}}>ggg</a><a href={{url_for('static', path='html/h.html')}}>ddddd</a><img src="{{ url_for('static', path='images/1.png') }}" alt="" width="30" height="24">{%for x in hd %}<p>{{x}}</p>{% endfor %}<p>{{s}}</p>{% set urls ="http://www.baidu.com"%}<a href={{urls}}>guuug</a><form action="" onsubmit="sendMessage(event)"><input type="text" id="messageText" autocomplete="off"/><button>Send</button></form><ul id='messages'></ul><script>
var ws =newWebSocket("ws://localhost:9999/ws");
ws.onmessage =function(event){
var messages = document.getElementById('messages')
var message = document.createElement('li')
var content = document.createTextNode(event.data)
message.appendChild(content)
messages.appendChild(message)};
function sendMessage(event){
var input = document.getElementById("messageText")
ws.send(input.value)
input.value =''
event.preventDefault()}</script><!--向数据库发送数据js代码--><input type="text" id="name" placeholder="Your name"><input type="email" id="email" placeholder="Email"><!-- Button to send data --><button onclick="sendJSON()">Send JSON</button><script>
function sendJSON(){
let result = document.querySelector('.result');
let name = document.querySelector('#name');
let email = document.querySelector('#email');// Creating a XHR object
let xhr =newXMLHttpRequest();
let url ="/book/";// open a connection
xhr.open("POST", url,true);// Set the request header i.e. which type of content you are sending
xhr.setRequestHeader("Content-Type","application/json");// Create a state change callback
xhr.onreadystatechange = function (){if(xhr.readyState ===4&& xhr.status ===200){// Print received data from server
result.innerHTML =this.responseText;}};// Converting JSON data to string
document.getElementById('name')
document.getElementById('email')
var data = JSON.stringify({"title": name.value ,"author": email.value });// Sending data with the request
xhr.send(data);}</script></p><!--本页面扩展base.html(父文件)的所有(标签，js,cs等所有)，可以继承和覆盖父文件属性-->{%extends"/base.html"%}<!--本页面包含-->{% include "/user.html"%}</body></html>
734
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
