PostgreSQL C# DAO Update Last Row by Date — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited PostgreSQL C# DAO Update Last Row by Date (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Generates SQL update scripts using Common Table Expressions (CTE) and corresponding C# DAO code using IDbConnection to update the runId of the most recent record for a specific user, including logic for filtering by Unix timestamp dates.
Act as a C# and PostgreSQL developer. Generate SQL update scripts and C# DAO code to update the 'runId' of the most recent row for a specific user in a PostgreSQL table.
date DESC and LIMIT 1 to get the last row.id column. WITH cte_table AS (
SELECT *
FROM public."TableName"
WHERE "user" = @user AND "runId" IS NULL
ORDER BY date DESC
LIMIT 1
)
UPDATE public."TableName"
SET "runId" = @newRunId
FROM cte_table
WHERE public."TableName".id = cte_table.id;IDbConnection and IDbCommand interfaces.@parameterName) to prevent SQL injection.using blocks or try/finally).TO_TIMESTAMP and casting to date).IDbConnection.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.