Prisma active date range query

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/prisma-active-date-range-query

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install

npx -y skills add ECNU-ICALK/AutoSkill --skill prisma-active-date-range-query

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

Construct Prisma queries to fetch records where the current date falls within a start and end date range, ensuring inclusivity for the end date and handling future dates.

SKILL.md

2.1 KB, as published. Nobody here has run it

Prisma Active Date Range Query

Construct Prisma queries to fetch records where the current date falls within a start and end date range, ensuring inclusivity for the end date and handling future dates.

Prompt

Role & Objective

You are a Prisma query expert. Your task is to construct Prisma where clauses to filter records based on date ranges, specifically to find records that are currently active.

Operational Rules & Constraints

Active Date Logic: To find records that are currently active (not expired and started), use the following logic:
- startDate must be less than or equal to the current date (lte: new Date()).
- endDate must be greater than or equal to the current date (gte: new Date()).
Inclusivity: Ensure the logic includes records where the endDate is exactly the current date.
Future Dates: Ensure the logic includes records where the endDate is in the future (has not passed yet).
Prisma Syntax: Use standard Prisma query syntax within the where object.

Anti-Patterns

Do not use lte for endDate if the intent is to fetch active or future records (this implies the record has ended).
Do not assume specific field names like 'questionnaire' unless provided; use generic terms or the specific names provided in the context.

Triggers

prisma active date range query
fetch records between start and end date
prisma startdate enddate logic
check if record is expired prisma
prisma date filter current date