/ - Diff - Automatická detekce a dokumentace připojených USB zařízení (ZF) - Bug Thugs - Redmine

server/requirements.txt
5	5	psycopg2-binary==2.8.6
6	6	jinja2==3.1.1
7	7	python-multipart==0.0.5
8		fastapi-jwt-auth=0.5.0
	8	fastapi-jwt-auth==0.5.0

     from fastapi import Depends, APIRouter, Form
     from fastapi import Request
     from fastapi.responses import HTMLResponse
     from fastapi.templating import Jinja2Templates
     from fastapi.responses import HTMLResponse
     from fastapi_jwt_auth import AuthJWT
     from pydantic import BaseModel
     # Path to html templates used in this file
     templates = Jinja2Templates(directory="templates/auth")
     # prefix used for all endpoints in this file
     auth = APIRouter(prefix="")
     class Settings(BaseModel):
         authjwt_secret_key: str = "secret"
         # Configure application to store and get JWT from cookies
         authjwt_token_location: set = {"cookies"}
         # Disable CSRF Protection for this example. default is True
         authjwt_cookie_csrf_protect: bool = False
     @AuthJWT.load_config
     def get_config():
         return Settings()
     fake_users_db = {
         "admin": {
             "username": "admin",
             "password": "admin"
+        }
+    }
     @auth.get("/login", response_class=HTMLResponse)
     async def login_get(request: Request):
         return templates.TemplateResponse("login.html", {"request": request})
     @auth.post("/login", response_class=HTMLResponse)
     async def login(username: str = Form(...), password: str = Form(...), Authorize: AuthJWT = Depends()):
         user_dict = fake_users_db.get(username)
         if user_dict != None:
             if user_dict["username"] == username and user_dict["password"] == password:
                 access_token = Authorize.create_access_token(subject="admin", expires_time=False)
                 refresh_token = Authorize.create_refresh_token(subject="admin", expires_time=False)
             else:
                 access_token = Authorize.create_access_token(subject="host", expires_time=False)
                 refresh_token = Authorize.create_refresh_token(subject="host", expires_time=False)
         else:
             access_token = Authorize.create_access_token(subject="host", expires_time=False)
             refresh_token = Authorize.create_refresh_token(subject="host", expires_time=False)
         # Set the JWT cookies in the response
         Authorize.set_access_cookies(access_token)
         Authorize.set_refresh_cookies(refresh_token)
         return """
         <html>
             <head>
                 <title>Login</title>
             </head>
             <body>
                 <h1>Logged in</h1>
                 <form action="/logs-web" method="get">
                     <input type="submit" value="Back" />
                 </form>
             </body>
         </html>
         """
     @auth.post('/refresh')
     def refresh(Authorize: AuthJWT = Depends()):
         Authorize.jwt_refresh_token_required()
         current_user = Authorize.get_jwt_subject()
         new_access_token = Authorize.create_access_token(subject=current_user)
         # Set the JWT cookies in the response
         Authorize.set_access_cookies(new_access_token)
         return {"msg": "The token has been refresh"}
     @auth.get('/logout', response_class=HTMLResponse)
     def logout(Authorize: AuthJWT = Depends()):
         """
         Because the JWT are stored in an httponly cookie now, we cannot
         log the user out by simply deleting the cookies in the frontend.
         We need the backend to send us a response to delete the cookies.
         """
         Authorize.jwt_optional()
         Authorize.unset_jwt_cookies()
         return """
             <html>
                 <head>
                     <title>Logout</title>
                 </head>
                 <body>
                     <h1>Logged Out</h1>
                     <form action="/logs-web" method="get">
                         <input type="submit" value="Back" />
                     </form>
                 </body>
             </html>
             """

     from fastapi import Depends, APIRouter, Form
     from fastapi import Request
     from fastapi.responses import HTMLResponse
     from fastapi.responses import HTMLResponse, RedirectResponse
     from fastapi.templating import Jinja2Templates
     from fastapi_jwt_auth import AuthJWT
     from pydantic import BaseModel
     from sqlalchemy.orm import Session
     from sql_app.api.auth import fake_users_db
     from sql_app import crud, models
     from ..database import SessionLocal, engine
-...
     device_web = APIRouter(prefix="")
     class Settings(BaseModel):
         authjwt_secret_key: str = "secret"
         # Configure application to store and get JWT from cookies
         authjwt_token_location: set = {"cookies"}
         # Disable CSRF Protection for this example. default is True
         authjwt_cookie_csrf_protect: bool = False
     @AuthJWT.load_config
     def get_config():
         return Settings()
     fake_users_db = {
         "admin": {
             "username": "admin",
             "password": "admin"
         },
         "editor": {
             "username": "editor",
             "password": "editor"
         },
+    }
     # Dependency
     def get_db():
         db = SessionLocal()
-...
             db.close()
     @device_web.get("/token", response_class=HTMLResponse)
     async def login_get(request: Request):
         return templates.TemplateResponse("login.html", {"request": request})
     @device_web.post("/token", response_class=HTMLResponse)
     async def login(username: str = Form(...), password: str = Form(...), Authorize: AuthJWT = Depends()):
         user_dict = fake_users_db.get(username)
         access_token = Authorize.create_access_token(subject=username, expires_time=False)
         refresh_token = Authorize.create_refresh_token(subject=username, expires_time=False)
         # Set the JWT cookies in the response
         Authorize.set_access_cookies(access_token)
         Authorize.set_refresh_cookies(refresh_token)
         return """
         <html>
             <head>
                 <title>Some HTML in here</title>
             </head>
             <body>
                 <h1>Look ma! HTML!</h1>
                 <form action="/devices-web" method="get">
                     <input type="submit" value="Login" />
                 </form>
             </body>
         </html>
         """
     @device_web.post('/refresh')
     def refresh(Authorize: AuthJWT = Depends()):
         Authorize.jwt_refresh_token_required()
         current_user = Authorize.get_jwt_subject()
         new_access_token = Authorize.create_access_token(subject=current_user)
         # Set the JWT cookies in the response
         Authorize.set_access_cookies(new_access_token)
         return {"msg": "The token has been refresh"}
     @device_web.get('/logout', response_class=HTMLResponse)
     def logout(Authorize: AuthJWT = Depends()):
         """
         Because the JWT are stored in an httponly cookie now, we cannot
         log the user out by simply deleting the cookies in the frontend.
         We need the backend to send us a response to delete the cookies.
         """
         Authorize.jwt_required()
         Authorize.unset_jwt_cookies()
         return """
             <html>
                 <head>
                     <title>Some HTML in here</title>
                 </head>
                 <body>
                     <h1>Look ma! HTML!</h1>
                     <form action="/devices-web" method="get">
                         <input type="submit" value="Login" />
                     </form>
                 </body>
             </html>
             """
     @device_web.get("/devices-web", response_class=HTMLResponse)
     async def read_devices(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db),
                            Authorize: AuthJWT = Depends()):
-...
         for i in range(0, len(devices)):
             statuses.append(devices[i].logs[len(devices[i].logs) - 1].status)
         licenses = crud.get_licenses(db, skip=skip, limit=limit)
         return templates.TemplateResponse("devices.html", {"request": request, "devs": len(devices), "devices": devices,
                                                            "statuses": statuses, "licenses": licenses})
         if current_user == "admin":
             return templates.TemplateResponse("devices.html", {"request": request, "devs": len(devices), "devices": devices,
                                                                "statuses": statuses, "licenses": licenses})
         else:
             return templates.TemplateResponse("devices_normal.html", {"request": request, "devs": len(devices), "devices": devices,
                                                                "statuses": statuses, "licenses": licenses})
     @device_web.post("/devices-web", response_class=HTMLResponse)
-...
     @device_web.post("/devices-web/{device_id}", response_class=HTMLResponse)
     async def connect_post(request: Request, device_id: int, lic: str = Form(...), skip: int = 0, limit: int = 100,
                            db: Session = Depends(get_db)):
     async def connect_post(device_id: int, lic: str = Form(...), db: Session = Depends(get_db)):
         """
         Endpoint called from template for connecting device with license. Adds entry to devices_licenses
         table and returns template with all devices in database
         """
         crud.create_device_license(db, device_id, int(lic), datetime.now())
         devices = crud.get_devices(db, skip=skip, limit=limit)
         statuses = []
         # adding state for each device in list
         for i in range(0, len(devices)):
             statuses.append(devices[i].logs[len(devices[i].logs) - 1].status)
         licenses = crud.get_licenses(db, skip=skip, limit=limit)
         return templates.TemplateResponse("devices.html", {"request": request, "devs": len(devices), "devices": devices,
                                                            "statuses": statuses, "licenses": licenses})
         return RedirectResponse("/devices-web")

     from sql_app import crud, models, schemas
     from ..database import SessionLocal, engine
     from fastapi import FastAPI, Request
     from fastapi.responses import HTMLResponse
     from fastapi.responses import HTMLResponse, RedirectResponse
     from fastapi.staticfiles import StaticFiles
     from fastapi.templating import Jinja2Templates
-...
     @licenses_web.post("/licenses-web", response_class=HTMLResponse)
     def create_license(request: Request, name: str = Form(...), expdate: date = Form(...), skip: int = 0, limit: int = 100,
                        db: Session = Depends(get_db)):
     def create_license(name: str = Form(...), expdate: date = Form(...), db: Session = Depends(get_db)):
         """
         Endpoint called from create license form. Creates new license and returns template with all licenses in database
         """
         db_license = crud.create_license(db, name, expdate)
         if db_license is None:
             print("something went wrong")
         devices = crud.get_devices(db, skip=skip, limit=limit)
         statuses = []
         for i in range(0, len(devices)):
             statuses.append(devices[i].logs[len(devices[i].logs) - 1].status)
         licenses = crud.get_licenses(db, skip=skip, limit=limit)
         return device_templates.TemplateResponse("devices.html", {"request": request, "devs": len(devices), "devices": devices,
                                                            "statuses": statuses, "licenses": licenses})
         return RedirectResponse("/devices-web")

     from sql_app import crud, models, schemas
     from ..database import SessionLocal, engine
     from fastapi import FastAPI, Request
     from fastapi.responses import HTMLResponse
     from fastapi.responses import HTMLResponse, RedirectResponse
     from fastapi_jwt_auth import AuthJWT
     from fastapi.staticfiles import StaticFiles
     from fastapi.templating import Jinja2Templates
-...
     @pcs_web.get("/pcs-web", response_class=HTMLResponse)
     async def read_pcs(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
     async def read_pcs(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db),
                        Authorize: AuthJWT = Depends()):
         """
         Returns template with all pcs currently saved in database
         """
         Authorize.jwt_optional()
         current_user = Authorize.get_jwt_subject()
         pcs = crud.get_pcs(db, skip=skip, limit=limit)
         return templates.TemplateResponse("pcs.html", {"request": request, "pcs": pcs})
         if current_user == "admin":
             return templates.TemplateResponse("pcs.html", {"request": request, "pcs": pcs})
         else:
             return templates.TemplateResponse("pcs_normal.html", {"request": request, "pcs": pcs})
     @pcs_web.get("/pc-team/{pc_id}", response_class=HTMLResponse)
-...
     @pcs_web.post("/pcs-web/{pc_id}", response_class=HTMLResponse)
     async def connect_post(request: Request, pc_id: int, team: str = Form(...), skip: int = 0, limit: int = 100,
                            db: Session = Depends(get_db)):
     async def connect_post(pc_id: int, team: str = Form(...), db: Session = Depends(get_db)):
         """
         Endpoint called from within form for connecting pc with team. Updates certain pc with new team.
         """
         old_pc = crud.update_pc(db, pc_id, team)
         pcs = crud.get_pcs(db, skip=skip, limit=limit)
         return templates.TemplateResponse("pcs.html", {"request": request, "pcs": pcs})
         RedirectResponse("/pcs-web")

     from sql_app import crud, models, schemas
     from ..database import SessionLocal, engine
     from fastapi import FastAPI, Request
     from fastapi.responses import HTMLResponse
     from fastapi.responses import HTMLResponse, RedirectResponse
     from fastapi_jwt_auth import AuthJWT
     from fastapi.staticfiles import StaticFiles
     from fastapi.templating import Jinja2Templates
-...
     @teams_web.get("/teams-web", response_class=HTMLResponse)
     async def read_devices(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
     async def read_devices(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db),
                            Authorize: AuthJWT = Depends()):
         """
         Returns template with all teams currently saved in database
         """
         Authorize.jwt_optional()
         current_user = Authorize.get_jwt_subject()
         teams = crud.get_teams(db, skip=skip, limit=limit)
         return templates.TemplateResponse("teams.html", {"request": request, "teams": teams})
         if current_user == "admin":
             return templates.TemplateResponse("teams.html", {"request": request, "teams": teams})
         else:
             return templates.TemplateResponse("teams_normal.html", {"request": request, "teams": teams})
     @teams_web.get("/team-create", response_class=HTMLResponse)
-...
     @teams_web.post("/teams-web", response_class=HTMLResponse)
     def create_team(request: Request, name: str = Form(...), skip: int = 0, limit: int = 100,
                        db: Session = Depends(get_db)):
     def create_team(name: str = Form(...), db: Session = Depends(get_db)):
         """
         Endpoint called from within form for creating new team. Creates new team and returns all teams in database
         """
         team = crud.create_team(db, name)
         if team is None:
             print("something went wrong")
         teams = crud.get_teams(db, skip=skip, limit=limit)
         return templates.TemplateResponse("teams.html", {"request": request, "teams": teams})
         RedirectResponse("/teams-web")

     from sql_app.api.usb_logs_web import usblogs_web
     from sql_app.api.teams import teams
     from sql_app.api.teams_web import teams_web
     from sql_app.api.auth import auth
     from fastapi import FastAPI
-...
     app.include_router(pcs_web)
     app.include_router(teams_web)
     app.include_router(usblogs_web)
     app.include_router(auth)
     '''
     if __name__ == "__main__":

     <!DOCTYPE html>
     <html lang="en">
     <head>
         <meta charset="UTF-8">
         <title>Login</title>
     </head>
     <body>
     <form action="/login" method="post">
       <label for="username">Username:</label><br>
       <input type="text" id="username" name="username"><br><br>
         <label for="password">Expiration Date</label>
       <input type="text" id="password" name="password">
       <input type="submit" value="Submit">
     </form>
     </body>
     </html>

         <title>Devices Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
-...
       </select>
       <input type="submit" value="OK">
     </form>
     <form action="/token" method="get">
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <form action="/devices-web" method="post">
         <label for="lic">License:</label>
         <input id="lic" name="lic" type="text" list="licenses" value="" placeholder="all">

     <html>
     <head>
         <title>Devices Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
           <option value=""></option>
           <option value="/logs-web">Logs</option>
           <option value="/devices-web">Devices</option>
           <option value="/teams-web">Teams</option>
           <option value="/pcs-web">PCs</option>
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <form action="/devices-web" method="post">
         <label for="lic">License:</label>
         <input id="lic" name="lic" type="text" list="licenses" value="" placeholder="all">
         <datalist id="licenses">
             {% for license in licenses %}
             <option value="{{license.name}}"></option>
             {% endfor %}
         </datalist>
       <input type="submit" value="Filter">
     </form>
     <table>
         <TR>
             <TH>ID</TH>
             <TH>Vendor ID</TH>
             <TH>Product ID</TH>
             <TH>Serial Number</TH>
             <TH>Licenses</TH>
             <TH>Status</TH>
         </TR>
         {% for i in range(devs) %}
         <TR>
             <TD class="ID">{{devices[i].id}}</TD>
             <TD class="Vendor ID">{{devices[i].vendor_id}}</TD>
             <TD class="Product ID">{{devices[i].product_id}}</TD>
             <TD class="Serial Number">{{devices[i].serial_number}}</TD>
             <TD class="License">
                 {% for lic in devices[i].licenses %}
                     {{lic.licenses.name}}<BR>
                 {% endfor %}
             </TD>
             <TD class="Status">{{statuses[i]}}</TD>
         </TR>
         {% endfor %}
     </table>
     </body>
     </html>

     <!DOCTYPE html>
     <html lang="en">
     <head>
         <meta charset="UTF-8">
         <title>Login</title>
     </head>
     <body>
     <form action="/token" method="post">
       <label for="username">Username:</label><br>
       <input type="text" id="username" name="username"><br><br>
         <label for="password">Expiration Date</label>
       <input type="text" id="password" name="password">
       <input type="submit" value="Submit">
     </form>
     </body>
     </html>

         <title>Licenses Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
-...
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <table>
         <TR>
             <TH>ID</TH>

         <title>Pcs Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
-...
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <table>
         <TR>
             <TH>ID</TH>

     <html>
     <head>
         <title>Pcs Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
           <option value=""></option>
           <option value="/logs-web">Logs</option>
           <option value="/devices-web">Devices</option>
           <option value="/teams-web">Teams</option>
           <option value="/pcs-web">PCs</option>
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <table>
         <TR>
             <TH>ID</TH>
             <TH>Username</TH>
             <TH>Hostname</TH>
             <TH>Team</TH>
         </TR>
         {% for pc in pcs %}
         <TR>
             <TD class="ID">{{pc.id}}</TD>
             <TD class="Vendor ID">{{pc.username}}</TD>
             <TD class="Product ID">{{pc.hostname}}</TD>
             {% if pc.team == None %}
                 <TD class="Team">NONE</TD>
             {% else %}
                 <TD class="Team">{{pc.team.name}}</TD>
             {% endif %}
         </TR>
         {% endfor %}
     </table>
     </body>
     </html>

         <title>Teams Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
-...
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <table>
         <TR>
             <TH>ID</TH>

     <html>
     <head>
         <title>Teams Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
           <option value=""></option>
           <option value="/logs-web">Logs</option>
           <option value="/devices-web">Devices</option>
           <option value="/teams-web">Teams</option>
           <option value="/pcs-web">PCs</option>
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <table>
         <TR>
             <TH>ID</TH>
             <TH>Name</TH>
         </TR>
         {% for team in teams %}
         <TR>
             <TD class="ID">{{team.id}}</TD>
             <TD class="Vendor ID">{{team.name}}</TD>
         </TR>
         {% endfor %}
     </table>
     </body>
     </html>

         <title>Logs Details</title>
     </head>
     <body>
     <div style='float:left'>
     <form action="" method="get">
       <label for="view">Choose view:</label>
       <select id="view" name="view" onchange="this.form.action=this.value;">
-...
       </select>
       <input type="submit" value="OK">
     </form>
     </div>
     <div style='float:left'>
     <form action="/login" method="get">
         <input type="submit" value="Login" />
     </form>
     </div>
     <form action="/logout" method="get">
         <input type="submit" value="Logout" />
     </form>
     <form action="/logs-web" method="post">
       <label for="pc">PC:</label>
       <input id="pc" name="pc" type="text" list="pcs" value="" placeholder="all">

Projekt

Obecné

Profil

ASWI - Pokročilé softwarové inženýrství » ASWI 2022 » Automatická detekce a dokumentace připojených USB zařízení (ZF) - Bug Thugs

Revize 2fe004b1

Přidáno uživatelem Matěj Zeman před více než 2 roky(ů)

Projekt

Obecné

Profil

ASWI - Pokročilé softwarové inženýrství » ASWI 2022 » Automatická detekce a dokumentace připojených USB zařízení (ZF) - Bug Thugs

Revize 2fe004b1

Přidáno uživatelem Matěj Zeman před více než 2 roky(ů)

Související úkoly