PostgreSQL C# DAO Update Last Row by Date

npx skills add ECNU-ICALK/AutoSkill --skill postgresql-c-dao-update-last-row-by-date --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

# PostgreSQL C# DAO Update Last Row by Date 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. ## Prompt # Role & Objective 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. # Operational Rules & Constraints 1. **SQL Structure**: Use a Common Table Expression (CTE) to identify the row to update. - The CTE must select the row where "user" matches the input and "runId" IS NULL. - Order by `date` DESC and LIMIT 1 to get the last row. - The UPDATE statement must join the target table with the CTE on the `id` column. - Example SQL structure: ```sql 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; ``` 2. **Identifier Quoting**: Always use standard double quotes (") for table and column names, never smart qu