Feature: Database-Agnostic SQL Helpers for Time-Based Metrics

[pawelmarkowski]

Overview

Currently, CasWAF metrics and reporting features rely on specific SQL syntax for timestamp manipulation, which varies significantly between database providers (MySQL, PostgreSQL, MSSQL, and SQLite).

When a user visits the URL: http://localhost:17000/dashboard of the CasWAF instance running on a PostgreSQL database - will see errors:

pq: function unix_timestamp(character varying) does not exist
pq: function unix_timestamp(character varying) does not exist
pq: function date_format(character varying, unknown) does not exist
pq: function unix_timestamp(character varying) does not exist

[hsluoyz]

@pawelmarkowski I didn't get the issue. First this is CasWAF's repo, not Casdoor. I don't know why you are keeping mentioning Casdoor, did you get to the wrong repo?

Second. can you just describe the issue you encountered (AS a user)? like an error message, or a crash backend/frontend. you don't need to explain the code logic at this stage. we (and the AI) knows the code.

Third, stop using ChatGPT to generate your issue. We strongly don't recommend external users to use ChatGPT to generate issues because this will usually end up with a mess.

[pawelmarkowski]

@hsluoyz I have included an error message from the user's perspective, who is attempting to run CasWAF on a PostgreSQL database and open casWAF dashboard. The previous description was a summary of the corrected code. CasDoor* was a misstatement on my part, as the CasWAF application's interface resembles that of the CasDoor dashboard.