Alex-School0-0x / Next-Project

0 stars 0 forks source link

Håndter escape sequences i log display på dashboardet #3

Closed LobaDK closed 3 weeks ago

LobaDK commented 3 weeks ago

Log beskeder kan ofte være ekstra formateret når de ligger i filen, for at gøre det nemmere at læse dem. Når backenden læser og returnere dem, inkludere den formateringen som escape sequences (\r, \n, \t).

Hvis muligt, ville det være rart hvis dashboardet kunne korrekt konvertere dem tilbage til deres respektive format, hvorved det ville blive nemmere at læse de stører log beskeder.

\r = Carriage return \t = Tab (2 eller 4 mellemrum?) \n = Newline (enter)

Nuværende

sql.log

[2024-10-01 10:19:06] [INFO    ] sqlalchemy.engine.Engine: 
CREATE TABLE question_templates (
    id INTEGER NOT NULL, 
    template_id VARCHAR NOT NULL, 
    title VARCHAR NOT NULL, 
    description VARCHAR NOT NULL, 
    created_at DATETIME NOT NULL, 
    PRIMARY KEY (id)
)

Dashboard

[2024-10-01 10:19:06] [INFO ] sqlalchemy.engine.Engine: CREATE TABLE question_templates ( id INTEGER NOT NULL, template_id VARCHAR NOT NULL, title VARCHAR NOT NULL, description VARCHAR NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) ) [2024-10-01 10:19:06] [INFO ] sqlalchemy.engine.Engine: CREATE TABLE questions ( id INTEGER NOT NULL, template_reference_id VARCHAR NOT NULL, title VARCHAR NOT NULL, selected_option INTEGER, custom_answer VARCHAR, PRIMARY KEY (id), FOREIGN KEY(template_reference_id) REFERENCES question_templates (template_id) ) [2024-10-01 10:19:06] [INFO ] sqlalchemy.engine.Engine: CREATE TABLE options ( id INTEGER NOT NULL, question_id INTEGER NOT NULL, value INTEGER NOT NULL, label VARCHAR NOT NULL, is_custom BOOLEAN NOT NULL, PRIMARY KEY (id), FOREIGN KEY(question_id) REFERENCES questions (id) )

Ønsket

sql.log

[2024-10-01 10:19:06] [INFO    ] sqlalchemy.engine.Engine: 
CREATE TABLE question_templates (
    id INTEGER NOT NULL, 
    template_id VARCHAR NOT NULL, 
    title VARCHAR NOT NULL, 
    description VARCHAR NOT NULL, 
    created_at DATETIME NOT NULL, 
    PRIMARY KEY (id)
)

Dashboard

[2024-10-01 10:19:06] [INFO    ] sqlalchemy.engine.Engine: 
CREATE TABLE question_templates (
    id INTEGER NOT NULL, 
    template_id VARCHAR NOT NULL, 
    title VARCHAR NOT NULL, 
    description VARCHAR NOT NULL, 
    created_at DATETIME NOT NULL, 
    PRIMARY KEY (id)
)